This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31423 | 31423 | 1916-07-22 | 6 | a-b | Miscellaneous report from China (situations in Guangdong and Guangxi, Li Yuanhong as new Chinese President, floods in Guangdong, Sun Baoqi as treasurer of Beijing government, Long Jiguang and Yuan Shikai). | China | http://trove.nla.gov.au/newspaper/page/24095343 | 24095343 | |
31428 | 31428 | 1916-07-22 | 7 | a-b | Sinn Fein in Ireland. | Britain | http://trove.nla.gov.au/newspaper/page/24095342 | 24095342 | |
31434 | 31434 | 1916-07-22 | 8 | a-b | Beijing news/ The political situations in Beijing after the death of Yuan Shikai. Some provinces cancel their independence. Nanjing Conference and the comments. Yuan Shikai's government and their rumours. The murder of Chen Qimei and Liang Shiyi. Liu Guanxiong and the Nanjing Conference. | China | http://trove.nla.gov.au/newspaper/page/24095345 | 24095345 |
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]);