This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31285 | 31285 | 1916-06-03 | 6 | a-b | A telegram from Kang Youwei to army generals in Nanjing, Xuzhou, of Jiangsu province, Shandong, Zhejiang, Jiangxi, Hubei and Hunan. | China | http://trove.nla.gov.au/newspaper/page/24095288 | 24095288 | |
31286 | 31286 | 1916-06-03 | 6 | b-c | Beijing news/ Financial chaos under Yuan Shikai. Yuan Shikai's motives. Zhang Zuolin and Wang Zhanyuan. News policy of Yuan Shikai. Zhou Ziqi is ready to go. Ni Sichong arrives Beijing and his plan. | China | http://trove.nla.gov.au/newspaper/page/24095288 | 24095288 | |
31287 | 31287 | 1916-06-03 | 6 | c | Korean people under Japanese rule and their lessons, a care report. | America | http://trove.nla.gov.au/newspaper/page/24095288 | 24095288 |
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]);