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