This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9329 | 9329 | 1901-12-14 | 3 | a | A cargo train in Canada ran into a river after a bridge collapsed. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9330 | 9330 | 1901-12-14 | 3 | a | France considers how to spend the money it received as a result of the Boxer indemnity China paid. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9331 | 9331 | 1901-12-14 | 3 | a | A young man in Germany murdered dozens of people. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9332 | 9332 | 1901-12-14 | 3 | a | A thief was caught in a tailor shop on George Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9333 | 9333 | 1901-12-14 | 3 | a | A night watchman in Sydney injured others. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9334 | 9334 | 1901-12-14 | 3 | b | A woman in Guangzhou caught a thief. | China | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9335 | 9335 | 1901-12-14 | 3 | b | Imperial examination in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9336 | 9336 | 1901-12-14 | 3 | b | Prince Chun is now on his way to Shanghai. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9337 | 9337 | 1901-12-14 | 3 | b | Dong Fuxiang is powerful. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9338 | 9338 | 1901-12-14 | 3 | b-c | Second part of a report on the government officials in Zhejiang province who were punished for being involved in the Quzhou missionary incident. | China | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9339 | 9339 | 1901-12-14 | 3 | c | Indian and German soldiers clash in Tianjin. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9340 | 9340 | 1901-12-14 | 3 | c | Italy demands huge compensation from China for the missionary cases last year. | Britain | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9341 | 9341 | 1901-12-14 | 3 | c | Two Italian newspapers in San Francisco attack each other. | America | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9342 | 9342 | 1901-12-14 | 3 | d | Russia tries to kill rats in order to prevent the plague. | Russia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9343 | 9343 | 1901-12-14 | 3 | d | A carriage in Victoria was capsized, two passengers were injured. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9344 | 9344 | 1901-12-14 | 3 | d | Both Guangdong and Guangxi experienced serious drought this year. | China | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9345 | 9345 | 1901-12-14 | 3 | d | Hong Kong residents who originally came from Guangdong are allowed to return for their treatment. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9346 | 9346 | 1901-12-14 | 3 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
9347 | 9347 | 1901-12-14 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 |
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]);