This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35148 | 35148 | 1919-12-20 | 2 | a-b | Editorial by Tung Wah Times on the boycott to Japanese goods in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097976 | 24097976 | |
35154 | 35154 | 1919-12-20 | 3 | a-b | Anti-Chinese movement in Vietnam and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097975 | 24097975 | |
35167 | 35167 | 1919-12-20 | 7 | a-b | Australia news/ Liu Zhao'an writes to the Australian Chinese Association against Discrimination in Sydney. Li Ziyun and Zheng Shenghua argue for their Chinese fellows against discriminations and their letter to the Chinese Chamber of Commerce in Sydney. Opening ceremony of the Tianjin Cafe in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097979 | 24097979 |
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]);