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 |
---|---|---|---|---|---|---|---|---|---|
50733 | 50733 | 1931-09-26 | 2 | d | Shi Yousan purchases real properties in Dalian, Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24090535 | 24090535 | |
50734 | 50734 | 1931-09-26 | 2 | d | Yu Xuezhong talks about his battle with Shi Yousan. | China | http://trove.nla.gov.au/newspaper/page/24090535 | 24090535 | |
50743 | 50743 | 1931-09-26 | 5 | 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/24090536 | 24090536 | |
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]);