This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49421 | 49421 | 1930-08-16 | 8 | c | Long drought in America. | America | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49422 | 49422 | 1930-08-16 | 8 | c | The Communist uprising in Changsha, Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49423 | 49423 | 1930-08-16 | 8 | c | Britain, America, Japan and France discuss to dispatch troops to China. | Britain | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49424 | 49424 | 1930-08-16 | 8 | c | Insect pest in Canada and the affect upon agricultural harvest. | Canada | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49425 | 49425 | 1930-08-16 | 8 | d | Guangdong authority arrests Communist members. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49426 | 49426 | 1930-08-16 | 8 | d | Foreign warships crowd the Yangtze River. | Britain | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49427 | 49427 | 1930-08-16 | 8 | d | Fierce battle to happen in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49428 | 49428 | 1930-08-16 | 8 | d | Troops from the north occupy the Longhai railway. | Australia | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49429 | 49429 | 1930-08-16 | 8 | d | Australia news/ Attention to mail senders. Tram operation in Sydney and the deficit last year. Australian government pays more attention to the trade with the East. Three men rob coach in NSW. Whale found near Sydney harbour. Life of the unemployed workers. Government hotels in Canberra have deficit. Churches help the unemployed in Sydney. Banks in Sydney change their savings policy. Discrimination against aboriginal people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 |
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]);