This data as json, CSV (advanced)
Suggested facets: page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9093 | 9093 | 1901-11-16 | 2 | b-c | The first part of a letter from Chinese Empire Reform Association in Canada to Tao Mo, governor of Guangdong and Guangxi provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100233 | 24100233 | |
9103 | 9103 | 1901-11-16 | 2 | e | The tallest man in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100233 | 24100233 | |
9115 | 9115 | 1901-11-16 | 3 | c-d | The second part of the report on the lawsuit between Li Bu and Chen Shou, two Chinese businessmen in Sydney. Problems with Lin Yik Tong, Chinese Empire Reform Association and the Chinese community in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100232 | 24100232 | |
9118 | 9118 | 1901-11-16 | 3 | e | Emperor Guangxu blessed a coffin cover for Li Hongzhang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100232 | 24100232 | |
9120 | 9120 | 1901-11-16 | 3 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100232 | 24100232 | |
9121 | 9121 | 1901-11-16 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100232 | 24100232 |
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]);