This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54947 | 54947 | 1935-03-16 | 2 | c | China news/ Japanese commander in Tianjin narrowly escapes an assassination. Resistance in north China to Japanese invasion. West part of the Longhai railway to be built from Xi'an to Xianyang. Remains of the communist troops under Zhu De and Mao Zedong are fleeing west along the border of Yunnan and Sichuan. Central government in Nanjing to award Lu Diping. | China | http://trove.nla.gov.au/newspaper/page/24096359 | 24096359 | |
54952 | 54952 | 1935-03-16 | 3 | e | Wang Jingwei praises Lu Diping. | China | http://trove.nla.gov.au/newspaper/page/24096358 | 24096358 | |
54954 | 54954 | 1935-03-16 | 7-8 | a-f | Guangdong news/ Envoy of the Central Government Huang Musong on his visit to Tibet. Effort to secure cooperation between Guangzhou and Nanjing. Patriotism and national hero, an article selected from Chinese newspaper in Honolulu. Industrial development in Guangdong after the New Year. Yu Hanmou and Huang Linshu arrive Zhaoqing. More money remitted into Guangdong from the overseas si yi county fellows. Gold mining in Enping county. | China | http://trove.nla.gov.au/newspaper/page/24096362 | 24096362 | |
54958 | 54958 | 1935-03-16 | 6 | c | The Australian missionary kidnapped in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24096363 | 24096363 | |
54961 | 54961 | 1935-03-16 | 6 | d | Police in Beijing arrest students. | China | http://trove.nla.gov.au/newspaper/page/24096363 | 24096363 |
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]);