This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6015 | 6015 | 1900-09-08 | 2 | c | A message from the newspaper on the upcoming Mid-Autumn Festival. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102939 | 24102939 | |
6018 | 6018 | 1900-09-08 | 2 | d | A young scholar in Guangzhou is trying hard to prepare for coming imperial examination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102939 | 24102939 | |
6020 | 6020 | 1900-09-08 | 2 | d | Two heads of the Boxer rebellions, Liu and Zhang, quarrel over the spoils. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102939 | 24102939 | |
6021 | 6021 | 1900-09-08 | 2 | d | Korean government worries about the changes in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102939 | 24102939 | |
6026 | 6026 | 1900-09-08 | 2 | e | Duan Wang and Dong Fuxiang decided to break the Great Canal and Yongding River near Beijing in order to prevent marching further of international troops into Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102939 | 24102939 | |
6040 | 6040 | 1900-09-08 | 3 | c | Zhang Zhuoxiong and Ouyang Qing sponsor three Chinese fellows from See Yip landing in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102938 | 24102938 | |
6041 | 6041 | 1900-09-08 | 3 | c | Timetable of ocean linears traveling to and from Asian ports. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102938 | 24102938 |
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]);