This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25489 | 25489 | 1911-12-30 | 2 | c-d | Current situation of Zi Zheng Yuan | Members are often absent for meetings in Zi Zheng Yuan and many return to their original places. | China | http://trove.nla.gov.au/newspaper/page/24092051 | 24092051 |
25503 | 25503 | 1911-12-30 | 3 | c-d | Guangdong news | Volunteers troop goes northward for expedition. Li Jun is to travel in Germany. Names of military counsels. Finance department in Guangdong praises Huang Qianghua supporting military govenment. Liu Yongfu visits Commander Long. Zhou Zhen resigns from Guangzhou city government. Officials are laid off in Military training school, Printing workers in Hong Kong strike on unreasonable arrest of workers by government. | http://trove.nla.gov.au/newspaper/page/24092050 | 24092050 | |
25517 | 25517 | 1911-12-30 | 8 | c-d | Thanks for donations | Thanks for donations for funeral arrangement of a friend and name of donators listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092057 | 24092057 |
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]);