This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32341 | 32341 | 1917-06-02 | 2 | a-c | Second and final part of the letter from Kang Youwei to Chinese President Li Yuanhong and Premier Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24095713 | 24095713 | |
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 |
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]);