This data as json, CSV (advanced)
Suggested facets: page, column, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35127 | 35127 | 1919-12-13 | 2 | a-b | Editorial by Tung Wah Times expresses pessimism on the current situations in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097968 | 24097968 | |
35128 | 35128 | 1919-12-13 | 2 | b-d | More debates with the Republic News (min guo bao). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097968 | 24097968 | |
35129 | 35129 | 1919-12-13 | 3 | a | Duan Qirui and Sun Yatsen may co-operate with each other. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097967 | 24097967 | |
35133 | 35133 | 1919-12-13 | 3 | d | Various mirrors produced in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097967 | 24097967 | |
35134 | 35134 | 1919-12-13 | 3 | d | Chinese communities in San Francisco, Singapore and other Nanyang areas promote Chinese products in order to save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097967 | 24097967 | |
35135 | 35135 | 1919-12-13 | 5 | a | Advertisement for Tientsin (Tianjin) Cafe recently opened in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097969 | 24097969 | |
35143 | 35143 | 1919-12-13 | 6 | b | Poems by Ruan Yongshang farewells friends in Australia, and reply by Zhong Jiayi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097972 | 24097972 | |
35144 | 35144 | 1919-12-13 | 6 | c | An article condemns Huang Yougong and the Republic News (min guo bao). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097972 | 24097972 | |
35145 | 35145 | 1919-12-13 | 7 | a | Advertisement for the Hanyang China Iron Tools Company Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097971 | 24097971 | |
35146 | 35146 | 1919-12-13 | 7 | b | Australia news/ A scholar speaks in the University of Sydney on the current situations in the East. A Chinese shop owner is injured in Sydney. Tung Wah Times warns Chen Dongru and Chen Renyi, both from Melbourne and support Huang Yougong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097971 | 24097971 | |
35147 | 35147 | 1919-12-13 | 8 | a-c | Articles debate with the Republic News (min guo bao). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097973 | 24097973 |
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]);