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 |
---|---|---|---|---|---|---|---|---|---|
20739 | 20739 | 1909-03-06 | 6 | b | Chinese businessmen in Yokohama, Huang Qingzhi and Huang Liqing, are on the run after swindling some money out of their Japanese business partners. | Japan | http://trove.nla.gov.au/newspaper/page/26802104 | 26802104 | |
20748 | 20748 | 1909-03-06 | 7 | b | Chinese community in Sydney donates to the flood victims in Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802103 | 26802103 | |
20749 | 20749 | 1909-03-06 | 7 | b | Thirteen Chinese in Manly, Sydney, are punished or sentenced for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802103 | 26802103 | |
20750 | 20750 | 1909-03-06 | 7 | b | Chinese chef on German liner is detained in Sydney for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802103 | 26802103 | |
20751 | 20751 | 1909-03-06 | 7 | b | A white missionary in Sydney purchases 4,400 copies of Holy Bible for Chinese readers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802103 | 26802103 | |
20752 | 20752 | 1909-03-06 | 7 | b | Chinese magician Chen Liansu, of Guangdong province, is performing in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802103 | 26802103 | |
20753 | 20753 | 1909-03-06 | 7 | b | Advertisement for Paul's Tailor shop and Harrison & Attwood wine in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802103 | 26802103 |
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]);