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 |
---|---|---|---|---|---|---|---|---|---|
20075 | 20075 | 1908-10-10 | 2 | a | Chinese businessmen in Sydney call for donations to flood victims in Guangdong province. They are On Chong & Co. at 223 George Street, Sun Hing Jang & Co. at 429 Pitt Street, Kwong War Chong & Co. at 46 Campbell Street, Hang Hi Hop Kee & Co on Pitt Street, and many other Chinese shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801907 | 26801907 | |
20087 | 20087 | 1908-10-10 | 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/26801911 | 26801911 | |
20093 | 20093 | 1908-10-10 | 7 | a | Second part of the speech by missionary George Heralton on recent development in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801910 | 26801910 | |
20094 | 20094 | 1908-10-10 | 7 | a | Chinese consul-general Liang Lanxun might on the war to Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801910 | 26801910 | |
20095 | 20095 | 1908-10-10 | 7 | a | Revenue of the six Australian states in the third quarter of 1908 (July to September). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801910 | 26801910 | |
20096 | 20096 | 1908-10-10 | 7 | a | Forty-five Chinese are arrested for gambling in Redfern and Waterloo, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801910 | 26801910 | |
20097 | 20097 | 1908-10-10 | 7 | a | Chinese are suspected of dumping opium in Gunnedah, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801910 | 26801910 |
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]);