This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31126 | 31126 | 1916-04-08 | 8 | a | Beijing news/ Financial chaos in Beijing. Government officials ask for leave. The case of murder in Xinhua Palace in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24095225 | 24095225 | |
31127 | 31127 | 1916-04-08 | 8 | b-c | Guangdong news/ Deadline for application for senior civil servant examination. Public properties owned by the Eight Banners should not be auctioned. Revolutionary Cai Rongji is executed in Zhaoqing. Bandits arrested in Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24095225 | 24095225 | |
31128 | 31128 | 1916-04-08 | 8 | c | Photograph of Yuan Chi wanted by Gibbs & Bright Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095225 | 24095225 | |
31129 | 31129 | 1916-04-08 | 8 | c-d | Advertisement for Hong Kong Wing On Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095225 | 24095225 |
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]);