This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
31289 | 31289 | 1916-06-03 | 7 | b-c | More news on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095287 | 24095287 |
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]);