This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29103 | 29103 | 1914-07-25 | 6 | a-c | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093192 | 24093192 | |
29108 | 29108 | 1914-07-25 | 8 | a-c | A letter from Gao Junchen, Quan Xiyan and Pan Xifan of the Disaster Relief Committee, jointly set up by charity institutions in Guangzhou, Hong Kong and Macao, calls for donations to the flood victims in Guangdong. Chinese communities in Australia and New Zealand donate to the flooding stricken areas in Guangdong and their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093194 | 24093194 |
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]);