This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20030 | 20030 | 1908-09-26 | 7 | b | Chinese Empire Reform Association in Sydney celebrates the birthday of Confucius and the speakers include Chen Lianke, Ye Bingnan, Xian Junhao, Zheng Fanchang, Mai Yaomei, Yu Bingyao, and Wu E'lou. Tong shan tang, association of Xiangshan people in Sydney, also celebrates the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801895 | 26801895 | |
20031 | 20031 | 1908-09-26 | 7 | b | Thirteen Chinese are detained in Pitt Street, Sydney, for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801895 | 26801895 |
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]);