This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52768 | 52768 | 1933-04-15 | 6 | f | Australia news/ Federal government promotes trade with Asia. Chinese man in Sydney is on trial for fake legal documents. State election in Western and South Australia. Heavy rain in NSW. Passenger liner Taiping to leave Sydney soon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52769 | 52769 | 1933-04-15 | 6 | f | A meeting notice of the Chinese Chamber of Commerce in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 |
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]);