This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27661 | 27661 | 1913-07-26 | 7 | a-b | Australia news/ The Chinese Chamber of Commerce in Sydney and the Chinese consul-general protest the immoral medical check on Chinese passengers. Two Chinese are murdered in Darwin and the trial on the suspects. A fire in Sydney destroys a shoe factory. Opium found in the captain's chamber on the St Albans. Some mad religious followers in Sydney. A Melbourne woman prays in naked. A man in North Sydney is charged with murder. | Australia | http://trove.nla.gov.au/newspaper/page/24092764 | 24092764 | |
27662 | 27662 | 1913-07-26 | 7 | b | Revenue of New Zealand in the first quarter of this year. Smallpox found in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092764 | 24092764 | |
27663 | 27663 | 1913-07-26 | 7 | b | Reports on the second revolution in China. | China | http://trove.nla.gov.au/newspaper/page/24092764 | 24092764 | |
27664 | 27664 | 1913-07-26 | 7 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092764 | 24092764 |
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]);