This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29168 | 29168 | 1914-08-15 | 7 | c | Chinese communities in Australia donate to the flood victims in Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 | |
29169 | 29169 | 1914-08-15 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 | |
29172 | 29172 | 1914-08-15 | 8 | c | Guangdong news/ The Disaster Relief Committee in Guangzhou calls for donations and more funds for the flooding areas. Miscellaneous report on the fundraising activities in Guangzhou and involvement of government officials such as Long Jiguang and the new General Inspector. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 |
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]);