This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7893 | 7893 | 1901-06-08 | 3 | a | Response of ordinary Chinese to the compensation demanded by foreign governments; German gunboat is on the way back from China; France wants to take over Hainan Island. | Other... | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7894 | 7894 | 1901-06-08 | 3 | a-b | Duan Wang is plotting a rebellion. | Singapore | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7895 | 7895 | 1901-06-08 | 3 | b | More than 190 passengers drowned when a liner capsized near Zhaoqing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7896 | 7896 | 1901-06-08 | 3 | b | A book written by Lin Hengfu on epidemic diseases. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7897 | 7897 | 1901-06-08 | 3 | b | Story of a folksong singer from Nanhai county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7898 | 7898 | 1901-06-08 | 3 | c | British and French soldiers clash in Tianjin; farewell to the commander of the international troops. | Other... | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7899 | 7899 | 1901-06-08 | 3 | c | Missionary cases in China, Korea and other east Asian regions. | Other... | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7900 | 7900 | 1901-06-08 | 3 | c | Tea production in Fujian province decreased. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7901 | 7901 | 1901-06-08 | 3 | c | Japan is seeking a new Prime Minister. | Japan | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
7902 | 7902 | 1901-06-08 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 |
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]);