This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40572 | 40572 | 1923-10-20 | 7 | b | Queensland government issues new regulation on sugar sales. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40574 | 40574 | 1923-10-20 | 7 | b | Thief hurts a white man in Manly, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40575 | 40575 | 1923-10-20 | 7 | c | Smuggled weapons found in a Dutch ship while docking in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40576 | 40576 | 1923-10-20 | 7 | c | Workers of the gas factory are in strike in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40577 | 40577 | 1923-10-20 | 7 | c | A convict on the run is captured again in Geelong, Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
40578 | 40578 | 1923-10-20 | 7 | c | An American tourist reports to Sydney police that he was stolen by a woman. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 |
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]);