This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50074 | 50074 | 1931-03-07 | 8 | b | A Chinese ship runs on rocks in the Yangtze River and 30 people die. | China | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50075 | 50075 | 1931-03-07 | 8 | b | Flu in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50076 | 50076 | 1931-03-07 | 8 | b | Police in Japan and America arrest communists. | America | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50077 | 50077 | 1931-03-07 | 8 | b | Irish missionary is kidnapped in China and the negotiation. | China | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50078 | 50078 | 1931-03-07 | 8 | b | The Nationalist government dispatches more troops to suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50079 | 50079 | 1931-03-07 | 8 | b | Hu Hanmin resigns in protest against Jiang Jieshi. Hu Hanmin may be under house arrest. | China | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50080 | 50080 | 1931-03-07 | 8 | c | British ambassador arrives in Nanjing for a talk on the consular jurisdiction. | China | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50081 | 50081 | 1931-03-07 | 8 | c | Australia news/ A court hearing in Sydney on bank robbery. Arsenal explodes in Melbourne. A man murders his wife on the street. Car thief arrested in Sydney. Acting Chinese consul-general in Australia Li Mingyan is returning while Yu Enhe from New Zealand becomes deputy consul-general in Australia. Unprecedented storm in Fiji. Taxi driver in Sydney is imprisoned for helping robbers. Federal treasury to issue new bank notes. Man arrested for forging bank notes. Two men die in a test flight in Melbourne. Number of earthquake in New Zealand. Train on fire in New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 |
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]);