This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27846 | 27846 | 1913-09-13 | 2 | a-b | Editorial advises Chinese people should retain the system of republic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 | |
27866 | 27866 | 1913-09-13 | 6 | a-b | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24092821 | 24092821 | |
27868 | 27868 | 1913-09-13 | 7 | a-b | Australia news/ Queensland authority issues new restriction on Chinese sugarcane growers. Sydney customs seize smuggled opium. Chinese opium smoker is penalised in Sydney. Local parliamentarian in New South Wales oppose to the bail out of a Chinese convict. Australia has new merchant ship. New South Wales authority inspects Chinese gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 |
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]);