This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19885 | 19885 | 1908-08-29 | 2 | b-c | Tung Wah column. Comments on the visit of American naval fleet to Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801859 | 26801859 | |
19905 | 19905 | 1908-08-29 | 6 | b-c | Jokes. Poems on opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801863 | 26801863 | |
19911 | 19911 | 1908-08-29 | 7 | b-c | Chinese Empire Reform Association in Sydney farewells Tang Caizhi, editor of the Tung Wah Times. Attendants includes Ye Bingnan, Xian Junhao, Zheng Fanchang, Luo Run, Cai Yinghui, Chen Qi, Chen Lianke, and Wu E'lou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801862 | 26801862 |
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]);