This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31912 | 31912 | 1917-01-20 | 6 | a-b | Beijing news/ The last words of Cai E. China borrows more money from Britain. Li Liejun arrives in Shanghai. Japanese police occupy Hutou Mountain in Xiamen, of Fujian province. Army in Shaanxi province are against the local government. | China | http://trove.nla.gov.au/newspaper/page/24095559 | 24095559 |
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]);