This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27044 | 27044 | 1913-02-22 | 7 | a-b | Report on inaugural meeting of Chinese Commercial Association. | Other... | http://trove.nla.gov.au/newspaper/page/24092588 | 24092588 | |
27045 | 27045 | 1913-02-22 | 7 | b | Australian news/ Australian new warship ready for service. Japanese warship arrives in Sydney. Variola found on Hong Kong ship arrived in Sydney. Extreme hot weather in Sydney. Chinese with mental problem arrested for shooting. Several Sydney Chinese arrested for gambling. | Other... | http://trove.nla.gov.au/newspaper/page/24092588 | 24092588 |
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]);