This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9053 | 9053 | 1901-11-09 | 3 | a | Chinese cabinet prepares for the return of the Emperor; Prince Qing is to welcome Emperor Guangxu; foreign doctors went to visit Li Hongzhang; somebody tried to assassinate Empress Dowager. | China | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9054 | 9054 | 1901-11-09 | 3 | a | Bandits in Jinzhou, Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9055 | 9055 | 1901-11-09 | 3 | a | Russia in Lushun (Port Arthur); Russians pay Chinese labourers little wages; Russian administration of Lushun; building of fortifications. | China | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9056 | 9056 | 1901-11-09 | 3 | b | List of families of imperial scholars. | China | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9057 | 9057 | 1901-11-09 | 3 | b | A touring boat in Queensland capsized. | Australia | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9058 | 9058 | 1901-11-09 | 3 | b | Report on imperial examination in Guangdong and Guangxi provinces. | China | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9059 | 9059 | 1901-11-09 | 3 | c | Qin Chunxuan wrote to Li Hongzhang and Prince Qing regarding precautions against missionary cases. | China | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9060 | 9060 | 1901-11-09 | 3 | c | A Filipino talks about his home country. | Japan | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9061 | 9061 | 1901-11-09 | 3 | d | Two stories of revenge from Taiwan. | China | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9062 | 9062 | 1901-11-09 | 3 | e | A driver of Sydney found gold left behind in his carriage. | Australia | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9063 | 9063 | 1901-11-09 | 3 | e | Rich people in America are more likely to have less children. | America | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 | |
9064 | 9064 | 1901-11-09 | 3 | f | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100224 | 24100224 |
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]);