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 |
---|---|---|---|---|---|---|---|---|---|
6469 | 6469 | 1900-11-21 | 2 | c | Li Hongzhang was called in to meet the Emperor. His Majesty was outraged. | China | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
6470 | 6470 | 1900-11-21 | 2 | c | A barefoot hero helped the Boxers to attack foreign missions in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
6487 | 6487 | 1900-11-21 | 3 | c | An opinion from the USA on negotiations for peace with China. | Japan | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6488 | 6488 | 1900-11-21 | 3 | c | A man in Carlton, Melbourne, was shot and killed by his wife. His property was left to his grandson and his wife. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6489 | 6489 | 1900-11-21 | 3 | c | Britain troops transport antiques from Beijing to their country; American troops burned the Temple of Heaven. | China | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6490 | 6490 | 1900-11-21 | 3 | c | A young man in Nanhai county, Guangdong, asked a question to the famous scholar He Danru. The question was too difficult for He Danru to answer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6491 | 6491 | 1900-11-21 | 3 | c | Timetable of ocean liner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6492 | 6492 | 1900-11-21 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 |
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]);