This data as json, CSV (advanced)
Suggested facets: 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 |
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]);