This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34231 | 34231 | 1919-03-08 | 2 | a-b | An article from Hong Kong on the provincial parliament in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097638 | 24097638 | |
34232 | 34232 | 1919-03-08 | 2 | c-d | Liang Qichao on China's declaration of war with Germany, the sixth and final part of the retrospect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097638 | 24097638 | |
34239 | 34239 | 1919-03-08 | 3 | c | Western newspaper says that Japan should give up the twenty-one demands to China, part II. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34254 | 34254 | 1919-03-08 | 7 | a-c | Australia news/ Election of the committee members of the New South Wales Chinese Chamber of Commerce (Guo Shun, Chen Zhuchen, Ye Bingnan and others). Chinese Chamber of Commerce in Sydney sends telegrams to Beijing and Nanjing on Japan's motives in China at the Paris conference. Immunisation in Sydney following the epidemic disease. Epidemic in Honolulu. Chinese vegetable pedlar in Sydney is robbed. Storm in Melbourne. Japan purchases horses in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097641 | 24097641 | |
34257 | 34257 | 1919-03-08 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097641 | 24097641 | |
34258 | 34258 | 1919-03-08 | 8 | a | Chinese in Tasmania donate to the Australian Chinese Association against Discrimination (hua qiao wei chi jin li hui). Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097644 | 24097644 |
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]);