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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
50699 | 50699 | 1931-09-12 | 5 | d | Story of Scholar He. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 | |
50711 | 50711 | 1931-09-12 | 8 | d | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 |
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]);