This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25074 | 25074 | 1911-09-30 | 7 | a | Notice for donations to floods in Anhui | A notice of Sydney Imperial Constitution Association asks for donations to floods in Anhui. | Other... | http://trove.nla.gov.au/newspaper/page/24091941 | 24091941 |
25075 | 25075 | 1911-09-30 | 7 | a-b | Australian news | Business comparison between New South Wales and Victoria. Mine workers in Tasmania are on strike. A proposal for Sydney to hold a world trade affair. The case of a Chinese's killing of a westerner in Hobart. Railway in Victoria made profits. Opium smugglers are caught in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24091941 | 24091941 |
25076 | 25076 | 1911-09-30 | 7 | b-c | Notice from China's Consulate to New Zealand | A notice from China's Consulate to New Zealand is about procedure for Chinese entry to Australia from New Zealand. | Other... | http://trove.nla.gov.au/newspaper/page/24091941 | 24091941 |
25077 | 25077 | 1911-09-30 | 7 | c | New Chinese consul to New Zealand | New Chinese consul to New Zealand is welcomed by several Chinese organisation in New Zealand. | Other... | http://trove.nla.gov.au/newspaper/page/24091941 | 24091941 |
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]);