This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49644 | 49644 | 1930-11-01 | 8 | b | Foreign missionaries kidnapped in China and the report. | China | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49645 | 49645 | 1930-11-01 | 8 | b | Exercise of Japanese navy and the injuries. | Japan | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49646 | 49646 | 1930-11-01 | 8 | b | British government subsidises aviation industry. | Britain | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49647 | 49647 | 1930-11-01 | 8 | c | American President Hoover bans weapon sales to rebellions in Brazil. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49648 | 49648 | 1930-11-01 | 8 | c | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49649 | 49649 | 1930-11-01 | 8 | c | Unemployed workers in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49650 | 49650 | 1930-11-01 | 8 | c | American government helps the unemployed. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49651 | 49651 | 1930-11-01 | 8 | c | German politicians cut their salary. | Germany | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49652 | 49652 | 1930-11-01 | 8 | c | Revolution in Brazil and the robberies during the revolution. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49653 | 49653 | 1930-11-01 | 8 | d | Floods in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49654 | 49654 | 1930-11-01 | 8 | d | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49655 | 49655 | 1930-11-01 | 8 | d | Australia news/ Police in Melbourne raid communist offices. Restaurant in King Street, Sydney, is sealed off. Gamblers arrested in Sydney. Earthquake in Sydney. Result of the state election in NSW. Coal miners celebrate the victory of Labour Party. Prices of long distance call between Australia and America. Article written by Ruan Yongchang advises Chinese to live a thrift life. Man on trial in Sydney for murder of his daughter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 |
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]);