This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31830 | 31830 | 1916-12-23 | 3 | a-b | Memorial service for Tang Juedun, Wang Xieji and Tan Dianyu in Beijing and an open letter to Li Yuanhong from Tang Jiyao, Qin Chunxuan, Liang Qichao, Cai E, Lu Rongting, Chen Bingkun, Lu Gongwang, Li Liejun, Tan Yankai, Liu Xianshi, Luo Peijin, Zhu Qinglan and others/ | China | http://trove.nla.gov.au/newspaper/page/24095522 | 24095522 | |
31831 | 31831 | 1916-12-23 | 3 | c | Wu Tingfang is appointed Chinese foreign minister. | China | http://trove.nla.gov.au/newspaper/page/24095522 | 24095522 | |
31832 | 31832 | 1916-12-23 | 3 | c-d | Second and final part of the open letter from Zhang Xun for self-defence to President Li Yuanhong and the Chinese cabinet in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24095522 | 24095522 | |
31833 | 31833 | 1916-12-23 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095522 | 24095522 |
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]);