This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42287 | 42287 | 1924-11-08 | 3 | d | Jiangsu, Zhejiang, Anhui, Jiangxi and Fujian provinces support Wu Peifu in his fighting with Zhang Zuolin, claimed by Qi Xieyuan. | China | http://trove.nla.gov.au/newspaper/page/24100920 | 24100920 | |
42288 | 42288 | 1924-11-08 | 3 | d | The war between Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24100920 | 24100920 | |
42296 | 42296 | 1924-11-08 | 6 | d | Chinese Students Association in New South Wales is organised and their declaration, signed by Su Yiguang, Chen Qingyi, Zhong Ziyuan, Luo Fuquan, Su Guanqing, Li Huafu, Xiao Songfen, Zhong Zhensheng, Liu Xiliang, Li Weiman, Liu Zhenkai, Li Shekun, and Li Zhenxing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100925 | 24100925 |
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]);