This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29771 | 29771 | 1915-03-20 | 2 | b-c | President Yuan Shikai attends the ritual ceremony of worshipping the heaven. | China | http://trove.nla.gov.au/newspaper/page/24094777 | 24094777 | |
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 | |
29800 | 29800 | 1915-03-20 | 7 | b-c | British government forbids its ships entering Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24094780 | 24094780 |
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]);