This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46628 | 46628 | 1928-01-07 | 2 | a | Comments by Tung Wah Times on the occasion of New Year and the responsibilities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098656 | 24098656 | |
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]);