This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31112 | 31112 | 1916-04-08 | 3 | b-c | A letter of 1912 from Yuan Shikai to his Vice-President and local provincial governors. | China | http://trove.nla.gov.au/newspaper/page/24095219 | 24095219 | |
31118 | 31118 | 1916-04-08 | 6 | b-c | Feud and fighting of the Chinese communities in San Francisco, the casualties and the mediation effort. | America | http://trove.nla.gov.au/newspaper/page/24095224 | 24095224 | |
31121 | 31121 | 1916-04-08 | 7 | b-c | Short comments on the current situations in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095223 | 24095223 | |
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 |
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]);