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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
47675 | 47675 | 1928-12-15 | 5 | c | Brief biography of Chen Huanzhang. | China | http://trove.nla.gov.au/newspaper/page/24099051 | 24099051 | |
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 | |
47673 | 47673 | 1928-12-15 | 3 | e | Large amount of smuggled weapons arrive Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099049 | 24099049 | |
47670 | 47670 | 1928-12-15 | 2 | f | Hebei province after the disasters of war. | China | http://trove.nla.gov.au/newspaper/page/24099050 | 24099050 | |
47674 | 47674 | 1928-12-15 | 3 | f | Japanese in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24099049 | 24099049 |
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]);