This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10650 | 10650 | 1902-05-21 | 2 | d | Zeng Guangquan, Zeng Guofan's grandson and interpreter of the foreign affairs department, is seriously ill; foreign missionaries in Beijing are to build holiday houses in Beidaihe; boxes for suggestions in Tianjin government; number of Chinese police in Tianjin; French consulate in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10651 | 10651 | 1902-05-21 | 2 | d | Empress Dowager fawns over foreigners in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10652 | 10652 | 1902-05-21 | 2 | d | Three officials were removed for suggesting reforms, Pi Xirui, Xu Zhijing and Shen Peng. | China | http://trove.nla.gov.au/newspaper/page/24100432 | 24100432 | |
10679 | 10679 | 1902-05-21 | 3 | d | Bullfighting in the Philippines; one casualty. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100431 | 24100431 | |
10680 | 10680 | 1902-05-21 | 3 | d | A Chinese in Campbell Street, Sydney, died in an epidemic. | Australia | http://trove.nla.gov.au/newspaper/page/24100431 | 24100431 | |
10681 | 10681 | 1902-05-21 | 3 | d | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100431 | 24100431 | |
10682 | 10682 | 1902-05-21 | 3 | d | An effective prescription for epidemic disease. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100431 | 24100431 |
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]);