This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49297 | 49297 | 1930-07-05 | 8 | c | Even rats and rabbits are fleeing north China to escape the famine. White Russian rebellions besieged in Siberia. Han Fuqu retreats Jinan, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24099697 | 24099697 | |
49298 | 49298 | 1930-07-05 | 8 | c | Floods in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24099697 | 24099697 | |
49299 | 49299 | 1930-07-05 | 8 | c | Japanese gunboats arrest Russian people. | Japan | http://trove.nla.gov.au/newspaper/page/24099697 | 24099697 | |
49300 | 49300 | 1930-07-05 | 8 | d | Australia news/ Fire in Pitt Street, Sydney, and the casualties. A failed bank robbery in Sydney. Bank manager in Melbourne is charged with embezzlement. Financial status of South Australia. It is time to apply for the Family Endowment Tax. Four men are flying over the Atlantic Ocean. Increase of coal export from Australia. Chinese passenger may be poisoned to death in Melbourne. Church funeral service for Rev. Zhou Rongwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099697 | 24099697 |
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]);