This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19943 | 19943 | 1908-09-12 | 2 | a | A public notice from Sydney Chinese Society on the floods in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801875 | 26801875 | |
19960 | 19960 | 1908-09-12 | 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/26801879 | 26801879 | |
19964 | 19964 | 1908-09-12 | 7 | a | Tang Caizhi on the way back from Sydney and his meeting with Chinese community in Brisbane and Townsville, including Wang Zhanyuan, Wang Huilai and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801878 | 26801878 | |
19965 | 19965 | 1908-09-12 | 7 | a | Letter from Chinese businessman Liu Yongcai in Young, New South Wales, supports the navy levy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801878 | 26801878 | |
19970 | 19970 | 1908-09-12 | 8 | a | Typhoon and casualties in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801881 | 26801881 |
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]);