This data as json, CSV (advanced)
date (date) 1 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2310 | 2310 | 1899-04-22 | 4 | a | A proposal to establish an association of the Chen family, Chen Yin Chuan Tang, in Sydney. Sponsors include Chen Liangxun, Chen Wendao, Chen Tianyou, Chen Tianhui, Chen Zunlu, Chen Jiazheng, Chen Yiyou, and Chen Xiluan. | http://trove.nla.gov.au/newspaper/page/24102374 | 24102374 |
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]);