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 |
---|---|---|---|---|---|---|---|---|---|
20023 | 20023 | 1908-09-26 | 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/26801894 | 26801894 | |
20027 | 20027 | 1908-09-26 | 7 | a | American naval fleet visits Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801895 | 26801895 | |
20028 | 20028 | 1908-09-26 | 7 | a | New South Wales educational authority to refurbish school buildings and the budget. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801895 | 26801895 | |
20029 | 20029 | 1908-09-26 | 7 | a | Wine consumption in New South Wales in the past ten years (1898-1907). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801895 | 26801895 |
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]);