This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29529 | 29529 | 1915-01-02 | 7 | a-c | Australia news/ Sydney China's School have made a great progress these years. Statistics of qualified soldiers in various states in Australia. Statistics show that Sydney business is declining due to the affects of European War. House of Yuan Mei, a Chinese in Sydney is stolen. Bat Hurst is flooding due to heavy rain there. | Australia | http://trove.nla.gov.au/newspaper/page/24094675 | 24094675 |
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]);