This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10653 | 10653 | 1902-05-21 | 2 | e | Liu Kunyi has been urged to implement reform policies. | China | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10654 | 10654 | 1902-05-21 | 2 | e | Wu Zhihui and Niu Tiesheng, two teaching supervisors for the modern education schools Guangdong, have applied to resign. | China | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10655 | 10655 | 1902-05-21 | 2 | e | An American missionary and his son are seeking the contract to build the railway from Beijing to Zhangjiakou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10656 | 10656 | 1902-05-21 | 2 | e | Riots in Gansu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10657 | 10657 | 1902-05-21 | 2 | e | Zhang Zhidong employs a Japanese advisor for reform; a newspaper to be established in Hankou; government departments reduce staff numbers; governor's office burgled; security check at the city gates. | China | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10683 | 10683 | 1902-05-21 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100431 | 24100431 |
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]);