This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 47664 | 47664 | 1928-12-15 | 2 | b | Second and final part of comments by Tung Wah Times on the current situations in Manchuria and Mongolia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
| 47665 | 47665 | 1928-12-15 | 2 | c | Chinese Consul-General in Canada resign. | Canada | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
| 47666 | 47666 | 1928-12-15 | 2 | c | Japan and the issues of Manchuria and Mongolia. | Japan | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
| 47667 | 47667 | 1928-12-15 | 2 | d | Oppositions to Hu Hanmin in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
| 47668 | 47668 | 1928-12-15 | 2 | e | Ye Qi reports from Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
| 47669 | 47669 | 1928-12-15 | 2 | e | Conflicts within the Nationalist Party in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
| 47670 | 47670 | 1928-12-15 | 2 | f | Hebei province after the disasters of war. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
| 47671 | 47671 | 1928-12-15 | 3 | b | A conference of the national commercial chambers in Shanghai and its open telegrams. | China | http://trove.nla.gov.au/newspaper/page/24099049 | 24099049 | |
| 47672 | 47672 | 1928-12-15 | 3 | c | Efforts to suppress Zhu De, Mao Zedong and their communist forces in Jiangxi. | China | http://trove.nla.gov.au/newspaper/page/24099049 | 24099049 | |
| 47673 | 47673 | 1928-12-15 | 3 | e | Large amount of smuggled weapons arrive Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099049 | 24099049 | |
| 47674 | 47674 | 1928-12-15 | 3 | f | Japanese in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24099049 | 24099049 | |
| 47675 | 47675 | 1928-12-15 | 5 | c | Brief biography of Chen Huanzhang. | China | http://trove.nla.gov.au/newspaper/page/24099051 | 24099051 | |
| 47676 | 47676 | 1928-12-15 | 6-7 | a-d | Guangdong news/ The newspaper (xian xiang bao or Phenomenon Newspaper) closed in Guangzhou and arrest of its journalists. Restriction upon the residents in Guangzhou. Smuggled weapons seized in Guangzhou. Candidates for chairman of the provincial government. Peasants in Nanhai county appeal for help. Arrest in Guangzhou on illegal weapon smugglers. Endless trial on the clan feud and fighting in Gaoyao county. Police in Zengcheng county. Bandits in Zengcheng, Xinhui and Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24099054 | 24099054 | |
| 47677 | 47677 | 1928-12-15 | 8 | a | The Nanjing government engages American advisers for civil construction. | China | http://trove.nla.gov.au/newspaper/page/24099056 | 24099056 | |
| 47678 | 47678 | 1928-12-15 | 8 | a | Australia news/ White woman is arrested for theft. Chinese men detained for gambling. Sharks caught in Newcastle. Shops burgled on Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099056 | 24099056 | |
| 47679 | 47679 | 1928-12-15 | 8 | b-c | First part of a report on the celebrations organised by the Chinese communities in Auckland, New Zealand, on the National Day of October 10. | New Zealand | http://trove.nla.gov.au/newspaper/page/24099056 | 24099056 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] (
[date] TEXT,
[page] TEXT,
[column] TEXT,
[title] TEXT,
[description] TEXT,
[source] TEXT,
[page_url] TEXT,
[trove_id] TEXT
);
CREATE INDEX [idx_article_index_date]
ON [article_index] ([date]);