This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50745 | 50745 | 1931-09-26 | 8 | a | Japanese troops occupy Shenyang, Liaoning province, and Changchun, Jilin province, and miscellaneous report on this incident. | China | http://trove.nla.gov.au/newspaper/page/24090541 | 24090541 | |
50746 | 50746 | 1931-09-26 | 8 | c | Earthquake in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090541 | 24090541 | |
50747 | 50747 | 1931-09-26 | 8 | d | Russia dispatches troops to Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/24090541 | 24090541 | |
50748 | 50748 | 1931-09-26 | 8 | d | Australia news/ Another earthquake in New Zealand. Chinese Chamber of Commerce in Sydney sends telegram to Jiang Jieshi, Zhang Xueliang, Chen Jitang and other Chinese politicians which urges them to stop internal conflict and to fight Japanese invasion. Deadline of application for the Family Endowment Payment. Chinese man in New Zealand commits suicide because of mental problem. New Chinese Consul-General in Australia Chen Weipin arrives Sydney. A strange life case in Sydney. A letter from the Overseas Chinese Famine Relief Committee in Shanghai on the disasters in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090541 | 24090541 |
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]);