This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50660 | 50660 | 1931-08-29 | 8 | b | American Red Cross donates to the flooding victims in Hankou, China. | America | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50661 | 50661 | 1931-08-29 | 8 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50662 | 50662 | 1931-08-29 | 8 | b | The flooding Yangtze River in China. | China | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50663 | 50663 | 1931-08-29 | 8 | c | Emperor of Japan donates to the relief work in China. | Japan | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50664 | 50664 | 1931-08-29 | 8 | c | Japan and Russia jointly threaten China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50665 | 50665 | 1931-08-29 | 8 | c | Chaos in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50666 | 50666 | 1931-08-29 | 8 | c | More disasters strike Hankou, China. | Canada | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50667 | 50667 | 1931-08-29 | 8 | d | Australia news/ Chinese consul-general Gui Zhi talks with various parties on the murder case involved Chinese. The Overseas Chinese Famine Relief Committee in Shanghai calls for donations to the flooding victims in China. The Nationalists and the Hua An Hui (Chinese Society) in Darwin fight each other for the remains of the deceased countrymen. Six Chinese are beheaded in New Zealand. Another bank is closed down in Sydney. Proposal to stop import of tomato. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50668 | 50668 | 1931-08-29 | 8 | e | 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/24090509 | 24090509 |
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]);