This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33469 | 33469 | 1918-07-27 | 6 | a-b | Tung Wah (Dong Hua) Hospital in Hong Kong writes to the Chinese Chamber of commerce in Sydney and acknowledges receipts of their donations to the flooding area in Guangdong. Disaster Relief Office in Shantou, Guangdong, writes to the Chinese Chamber of Commerce in Sydney and asks for donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097374 | 24097374 | |
33470 | 33470 | 1918-07-27 | 6 | b-d | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24097374 | 24097374 |
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]);