This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19719 | 19719 | 1908-07-25 | 2 | b-c | Gathering of Sydney Chinese community in support of the navy levy. Speakers include envoy from Guangdong Lin Runzhao, Ye Bingnan, Wu Shihua, Li Chun, Huang Zaixing, Yu Derong, Yu Bingyao, Mai Yaomei, Zheng Fanchang, Cai Xing, Xian Junhao, Liang Chuang, and Tang Caizhi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801818 | 26801818 | |
19732 | 19732 | 1908-07-25 | 3 | b-c | A survey on opium consumption and number of addicts in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801817 | 26801817 |
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]);