This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50692 | 50692 | 1931-09-12 | 2 | b | Second and final part of editorial on the negotiation between China and Japan over the atrocity of Japanese police in Jilin province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 | |
50693 | 50693 | 1931-09-12 | 2 | d | The anti-Chinese movement in Mexico and the tragedy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 | |
50694 | 50694 | 1931-09-12 | 2 | d | He Jian in Hunan resigns. Yan Xishan returns to Shanxi secretly. The Shanxi army that fight Jiang Jieshi. Shang Zhen resigns. Shi Yousan steps down. Talks between China and Japan over the Jilin incident and Japan's attitude. The Yangtze River is flooding again. Japan to promote its export to China by force. Chen Youren has left Japan. Sichuan situation is not optimistic. Japanese in Manchuria and Mongolia. The Dongling Cemetery will be turned into a forest. Nanjing government appoints directors of munitions factories. | China | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 |
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]);