This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19736 | 19736 | 1908-07-25 | 6 | a | A notice from tong shan tang, association of Xiangshan people in Sydney, on the survey of the deceased fellows in New South Wales in order to transport their remains back to Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801823 | 26801823 | |
19737 | 19737 | 1908-07-25 | 6 | a-c | Report on floods in Huizhou, Zhaoqing, Qingyuan, Heshan, Gaoming, Nanhai, Sanshui, and other parts of Guangdong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801823 | 26801823 | |
19738 | 19738 | 1908-07-25 | 6 | c | Chinese community in Australia donates to the flood victims in Guangdong province. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801823 | 26801823 |
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]);