This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29791 | 29791 | 1915-03-20 | 6 | a-b | Content of the speech made by Chen Qi at the International Sports Contest in Panama Canal Ceremony. | Other... | http://trove.nla.gov.au/newspaper/page/24094781 | 24094781 | |
29792 | 29792 | 1915-03-20 | 6 | b-c | Headline news miscellany/ 30 one-line news from China on government policies, official activities, promotions and dismissals and other important events. Yuan Shikai, Zhang zhenqiang, Zhang Raoqing, Tang Hualong, Jiang Zhuobin, Zhang Huizi, Liang Wenqi, Wu Tingfang, Liu Guangshun,and Zhang Zhenfang are included. | China | http://trove.nla.gov.au/newspaper/page/24094781 | 24094781 |
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]);