This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33860 | 33860 | 1918-11-30 | 8 | a-b | Beijing news/ Yang Xingcheng is on the way to Beijing on the invitation from President Xu Shichang. Policies towards the nationals of enemy countries in Shanghai. Four local military governors appeal for peace talks. Qian Nengxun might be the next premier. Tang Hualong's coffin has arrived Tianjin from Canada. Storm in Zhenjiang, of Jiangsu province. Pirates near the Zhoushan islands. | China | http://trove.nla.gov.au/newspaper/page/24097524 | 24097524 |
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]);