This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55196 | 55196 | 1935-06-15 | 2 | a | A Hong Kong businessman attends the Japanese consuls' meeting in Shanghai and comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096465 | 24096465 | |
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 |
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]);