This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17443 | 17443 | 1907-05-18 | 2 | a-c | Chinese businessmen in Sydney write to Wang Daxie, China's ambassador to London, and suggests promoting marine transportation in order to protect Chinese business. The appendix includes statistics of imports and export of the six Australian states in 1904. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801332 | 26801332 | |
17444 | 17444 | 1907-05-18 | 2 | c-d | Railway dispute. Deputy supervisor of the railway project from Hankou to Guangzhou elected illegally. Report on the company meeting on January 17 and February 20 and their resolutions. Beijing authority sends Wu Tingfang to inspect the railway project from Hankou to Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801332 | 26801332 |
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]);