This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9242 | 9242 | 1901-12-04 | 3 | a | French troops in China; French General in China; a big fire in London. | Other... | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9243 | 9243 | 1901-12-04 | 3 | a | An American doctor discovered a new kind of medicine. | America | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9244 | 9244 | 1901-12-04 | 3 | b | An elderly man in Bendigo, Victoria, passed away at 106. | Australia | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9245 | 9245 | 1901-12-04 | 3 | b | French general in Beijing blamed foreign women for looting. | China | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9246 | 9246 | 1901-12-04 | 3 | b-c | The first part of selections from British blue book about China affairs. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9247 | 9247 | 1901-12-04 | 3 | c | Recent relations between Russia and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9248 | 9248 | 1901-12-04 | 3 | c | Another newspaper has recently been published in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9249 | 9249 | 1901-12-04 | 3 | c-d | Report on a murder case in Adelaide, South Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9250 | 9250 | 1901-12-04 | 3 | d | The seventh part of the report on the lawsuit between Li Bu and Chen Shou, two Chinese businessmen in Sydney. Problems with Lin Yik Tong, Chinese Empire Reform Association and the Chinese community in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9251 | 9251 | 1901-12-04 | 3 | d | Dinner party of the Sydney Chinese Empire Reform Association. Attendants include Chen Xia, Zhou Jin, Ouyang Qing, Liu Ruxing, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 | |
9252 | 9252 | 1901-12-04 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100252 | 24100252 |
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]);