This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32353 | 32353 | 1917-06-02 | 7 | a-c | Australia news/ Budget report delivered by the federal treasury. A man is arrested in Sydney for counterfeit bank notes. Sydney police raid an opium den. Zhou Fengzhen's speech at the annual conference of the Chinese Chamber of Commerce in Bendigo, Victoria. Number of casualties of Australian troops in the World War I. An Indian immigrant is killed in Lismore, New South Wales. Seven tons of mice caught in Mallee, Victoria. More opium addicts are detained in Sydney. Flood in New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
32354 | 32354 | 1917-06-02 | 7 | c | Li Jingyi is appointed Chinese Premier. | Canada | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
32355 | 32355 | 1917-06-02 | 7 | c | Famine in China. | Britain | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
32356 | 32356 | 1917-06-02 | 7 | c | Fire in Tokyo. | Canada | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
32357 | 32357 | 1917-06-02 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
32358 | 32358 | 1917-06-02 | 7 | c | Farewell words by Ma Zuxing who is going to work for the Wing On Company in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 |
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]);