This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46650 | 46650 | 1928-01-07 | 7 | a | Australia news/ A white man is arrested in Sydney for illegally raising funds among the Chinese community. Fire on the eve of New Year in Victoria. Fire in Adelaide. Tariff income of the federal government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098659 | 24098659 | |
46651 | 46651 | 1928-01-07 | 7 | a | The biggest bus in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098659 | 24098659 |
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]);