This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55197 | 55197 | 1935-06-15 | 2 | b | Liu Zhennian is executed in Jiangxi province. Wu Zhihui on the infrastructure development of Yunnan and Guangxi province. Further report on the anti-Chinese movement in Thailand. Chinese newspaper director is assassinated in the Japanese settlement in Tianjin. The communist troops under Zhu De and Mao Zedong in north Yunnan province. Jiang Jieshi arrives Kunming. Japanese delegation meets Wang Jingwei in Nanjing. China decides to boycott Thailand rice because of the anti-Chinese movement. Jiang Jieshi reshuffles Guizhou provincial government. | China | http://trove.nla.gov.au/newspaper/page/24096465 | 24096465 | |
55200 | 55200 | 1935-06-15 | 3 | b | China's relations with Japan and Britain recently. | China | http://trove.nla.gov.au/newspaper/page/24096464 | 24096464 | |
55201 | 55201 | 1935-06-15 | 3 | b | Japanese protest against the Chinese government on the murder of a journalist in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096464 | 24096464 | |
55204 | 55204 | 1935-06-15 | 5 | b | Satirical introduction to the New Life Movement in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096466 | 24096466 |
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]);