This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12014 | 12014 | 1903-07-18 | 2 | a | An article discusses China's weakness in relation to its fengshui properties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800257 | 26800257 | |
12045 | 12045 | 1903-07-18 | 3 | c | Chinese businessmen in Sydney Liu Ruxing, Xian Junhao, Tang Caizhi and Chen Xia visit Melbourne for share issue of the China commercial company. They are warmly welcomed by the Melbourne Chinese community. A dinner party was organised and hosted by Huang Shiyan and Tan Kailing, and attended by hundreds of people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12046 | 12046 | 1903-07-18 | 3 | c | Rev. Sun Zhiyu and Chinese Presbyterian church in New Castle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12050 | 12050 | 1903-07-18 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 |
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]);