This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50844 | 50844 | 1931-10-31 | 5 | d | Travel notes to Korea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090576 | 24090576 | |
50852 | 50852 | 1931-10-31 | 8 | d | Australia news/ Chinese communities in Melbourne and Darwin donate to the flooding victims in China. Chinese community in Auckland, New Zealand, organises an association to fight Japan and to save China. NSW state government issues new regulations for coach services. Wool prices going up sharply. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 |
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]);