This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49551 | 49551 | 1930-10-04 | 2 | d | Some silver mines closed in America. | America | http://trove.nla.gov.au/newspaper/page/24099798 | 24099798 | |
49559 | 49559 | 1930-10-04 | 3 | d | Agreement signed between China and Germany on air flight service. | China | http://trove.nla.gov.au/newspaper/page/24099797 | 24099797 | |
49570 | 49570 | 1930-10-04 | 8 | d | Australia news/ Murderer of the bank manger arrested in Melbourne. Proposal to reduce salary payment to government employees. New survey on the population of Australia. Motor factory on fire in Sydney. More robberies in Sydney. Dutch warships visit Australia. More report on the strike of the unemployed. Iron factory closed in Newcastle. Expenses for the election of the NSW state parliament. A man in NSW commits incest and the family tragedy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099803 | 24099803 |
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]);