This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8309 | 8309 | 1901-08-03 | 2 | f | Prince Duan on exile to Xinjiang; the Emperor argued with Empress Dowager on the relations with foreign countries and record of the arguments. | China | http://trove.nla.gov.au/newspaper/page/24100130 | 24100130 | |
8310 | 8310 | 1901-08-03 | 2 | f | The third and final part of couplets in remembrance of Yuan Chang, Xu Jingcheng and Xu Chengyu, respectively written by Tang Guangzhao, Chen Chongli, Huang Shaoji, Zhang Huanlun, Yang Wenying, Gao Er'xie, Tan Xian, Pu Zizhuang, Shi Yijue, Gu Yun, Yuan Chunxi, Ma Ruixi, Hu Jufen, and Sun Tingxian. | China | http://trove.nla.gov.au/newspaper/page/24100130 | 24100130 |
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]);