This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
34315 | 34315 | 1919-03-22 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | 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]);