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 |
---|---|---|---|---|---|---|---|---|---|
55460 | 55460 | 1935-09-28 | 2 | b | Chen Shuren resigns as director of the Overseas Chinese Commission of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55461 | 55461 | 1935-09-28 | 2 | b | Wang Jingwei resumes to work and Jiang Jieshi flies to Chengdu, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55462 | 55462 | 1935-09-28 | 2 | c | Li Zhenhua is arrested in Beijing for being involved in the case of Liu Zuozhou. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55463 | 55463 | 1935-09-28 | 2 | d | More than 300 villages are flooded in north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55466 | 55466 | 1935-09-28 | 3 | b | Radio communication connect China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55470 | 55470 | 1935-09-28 | 6-7 | a-f | Guangdong news/ Self-government movement in Guangdong will continue. Provincial government is preparing for its three-year development plan. Police in Guangzhou to stop women from wearing colourful clothes. Coal production in Guangdong. Chinese and foreign businessmen fight for the rice market in Shantou. Plan of military training for the army and government staff. Shantou authority tries to protect local railways. Sales of Chinese products domestically and on the international market. Business still dull in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24096591 | 24096591 | |
55471 | 55471 | 1935-09-28 | 8 | a | Meeting notice of the Chinese Chamber of Commerce in NSW. | China | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 |
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]);