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 |
---|---|---|---|---|---|---|---|---|---|
54795 | 54795 | 1935-01-19 | 2 | c | China news/ The communist troops and their atrocities in south China. Japanese still seek to occupy the whole north China. News on the Fifth Plenary Session in Nanjing. Remains of the communist troops flee Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24096295 | 24096295 | |
54796 | 54796 | 1935-01-19 | 3 | a | Jiang Jieshi on the suppression of the communist troops and meaning of the victory. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54797 | 54797 | 1935-01-19 | 3 | c | Japanese and the railways in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54798 | 54798 | 1935-01-19 | 3 | c | Puyi is preparing for a visit to Japan. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54800 | 54800 | 1935-01-19 | 3 | d | Huang Shaoxiong becomes governor of Zhejiang province and his team. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54803 | 54803 | 1935-01-19 | 7-8 | a-f | Guangdong news/ Hu Hanmin and others issue an open letter on the cooperation between Guangzhou and Nanjing. Guangxi dispatches more troops to suppress the communists. Shao Zeru dies in Guangzhou. Zou Lu and Tan Qixiu arrive Guangzhou. Promotion of Chinese products. Hong Kong banks transport silver to Britain and America. Villagers from Zengcheng present their petitions to the provincial government. | China | http://trove.nla.gov.au/newspaper/page/24096298 | 24096298 | |
54806 | 54806 | 1935-01-19 | 6 | b | Police in Shanghai raid drug smuggling chains. | China | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 |
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]);