This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29253 | 29253 | 1914-09-19 | 7 | a-b | Australia news/ Australian federal government stops food export. No German warships found in South Pacific. Chinese gardeners are advised to cooperate with patrol officers for night inspection. Liner of Gibbs Bright & Co delays its return to Australia due to the war in Europe. Australian navy takes New Caledonia from German troops. Returned fellows talk about Chinese residents in Noumea, New Caledonia, and their life there. Horse racing in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093255 | 24093255 | |
29254 | 29254 | 1914-09-19 | 7 | b-c | Miscellaneous report on the World War I (war in Europe, Australian envoy reports the frontline, German troops are defeated). | Other... | http://trove.nla.gov.au/newspaper/page/24093255 | 24093255 | |
29255 | 29255 | 1914-09-19 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093255 | 24093255 |
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]);