This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50023 | 50023 | 1931-02-21 | 8 | a | Unemployed people have demonstrations in America. | America | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50024 | 50024 | 1931-02-21 | 8 | b | Chinese foreign minister Wang Zhengting entertains foreign journalists. | China | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50025 | 50025 | 1931-02-21 | 8 | b | Mine owner in America commits suicide because of the economic recession. | America | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50026 | 50026 | 1931-02-21 | 8 | b | Britain to refund some Boxer Indemnity to China for railway construction. | Britain | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50027 | 50027 | 1931-02-21 | 8 | b | Coal mine explodes in Fushun, Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50028 | 50028 | 1931-02-21 | 8 | c | Japanese workers destroy a factory in Osaka. | Japan | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50029 | 50029 | 1931-02-21 | 8 | c | Russian authority organises army reserves in the school. | Britain | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50030 | 50030 | 1931-02-21 | 8 | c | Australia news/ Australia government extradites criminal suspect to South Africa. NSW state premier proposes a new way for the Federal government to repay foreign debts. Wool export from NSW and the statistics. More earthquakes in New Zealand. Tram association requests to restrict coach services. Smuggled opium seized from passenger liner Taiping. Coal export increases. More than 70,000 coal miners are unemployed suddenly. Chinese body found in Sydney harbour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 |
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]);