This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, 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 | |
| 55198 | 55198 | 1935-06-15 | 3 | a | Yin Tong visits Japan for possible cooperation between the two countries. | Japan | http://trove.nla.gov.au/newspaper/page/24096464 | 24096464 | |
| 55199 | 55199 | 1935-06-15 | 3 | a | Republican parliamentarians in American suggest to uphold American existence in the Philippines. | China | http://trove.nla.gov.au/newspaper/page/24096464 | 24096464 | |
| 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 | |
| 55202 | 55202 | 1935-06-15 | 3 | d | Air defence exercise in Paris. | France | http://trove.nla.gov.au/newspaper/page/24096464 | 24096464 | |
| 55203 | 55203 | 1935-06-15 | 3 | e | Chinese communities in Sumatra to build Chinese consulate office. | 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 | |
| 55205 | 55205 | 1935-06-15 | 5 | f | A gathering of the Zengcheng fellows in Wellington, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096466 | 24096466 | |
| 55206 | 55206 | 1935-06-15 | 6-7 | a-f | Guangdong news/ Conclusion to the case of Zhu Zhuowen. Underground political parties in Guangzhou. Chen Jitang sends Miu Peinan to inspect Chaozhou and Meixian counties. Wang Jialie is detained in Hankou. Overseas Chinese are now sending less money back to their hometown due to the low exchange rate. Celebrations in Hong Kong for the King of Britain and the expenditure. Statistics about Zengcheng county. | China | http://trove.nla.gov.au/newspaper/page/24096469 | 24096469 | |
| 55207 | 55207 | 1935-06-15 | 8 | a | British cabinet reshuffled. | Britain | http://trove.nla.gov.au/newspaper/page/24096471 | 24096471 | |
| 55208 | 55208 | 1935-06-15 | 8 | a | Current situation in north China and Japanese demands from the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24096471 | 24096471 | |
| 55209 | 55209 | 1935-06-15 | 8 | e | Australia news/ Court hearing on the murder of Chinese gardener in Sydney. Chinese herbalist in Melbourne dies and leaves huge amount of money. Chinese tobacconist in Sydney is penalised. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096471 | 24096471 |
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]);