This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34293 | 34293 | 1919-03-22 | 2 | a-c | Second part of the speech by Chinese President Xu Shichang to the industrial representatives. | China | http://trove.nla.gov.au/newspaper/page/24097654 | 24097654 | |
34311 | 34311 | 1919-03-22 | 6 | a-c | Duan Qirui's cabinet and its secret dealings with Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097658 | 24097658 | |
34314 | 34314 | 1919-03-22 | 7 | a-c | Australia news/ Chinese community in Melbourne writes to the Beijing government and its representative to the Paris Peace Conference, Lu Zhengxiang. Inaugural ceremony of the new committee of the Chinese Chamber of Commerce in New South Wales and speakers include Mai Yaomei, Ye Bingnan, Guo Shun, Wu Elou, Chen Zhuchen, and others. Restrictions lifted for some food prices in Sydney. A robbery in Sydney in daytime. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097657 | 24097657 |
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]);