This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49803 | 49803 | 1930-12-13 | 8 | b | British government sends advisers to help Chinese navy. | Britain | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49804 | 49804 | 1930-12-13 | 8 | b | Police in Washington fire tear bombs at the communist demonstrators. | America | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49805 | 49805 | 1930-12-13 | 8 | b | British ship rescues a stranded Swiss ship. | Britain | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49806 | 49806 | 1930-12-13 | 8 | b | Battle in Lima, capital of Peru. | Other... | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49807 | 49807 | 1930-12-13 | 8 | c | A ship sinks in the Yangtze River on its way from Shanghai to Changsha. | China | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49808 | 49808 | 1930-12-13 | 8 | c | Red rain in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49809 | 49809 | 1930-12-13 | 8 | c | Oil found in Taiwan. | Japan | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49810 | 49810 | 1930-12-13 | 8 | c | Japanese police raid smugglers of opium, cocaine and other drugs. | Japan | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49811 | 49811 | 1930-12-13 | 8 | c | Australia news/ Agricultural authority of NSW issues new regulations for tomato package and the Chinese translation. Australian government bars Italian immigrants from entry. Strike of the butchers in Sydney fails. The Communist organisations in New Zealand. Chinese who was robbed a few days ago dies of injury. Business depressed in Sydney and the hope of businessmen. Heavy rain burst the railway in Adelaide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 |
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]);