This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6414 | 6414 | 1900-11-07 | 3 | c | Clashes between Boxers and foreign troops in Baoding; magistrate of Baoding was detained by foreign troops; France and Germany sent soldiers to level all tombs of Ming dynasty; many courtmaids are now prisoners of foreign troops; quarrel of American officers and French soldiers. | China | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6415 | 6415 | 1900-11-07 | 3 | c | Queen's grandson will come to Australia. The trip is expected to be expensive. | Australia | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6416 | 6416 | 1900-11-07 | 3 | c | Sugar exports from Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6417 | 6417 | 1900-11-07 | 3 | c | A man in Brisbane was infected an infectious disease. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6418 | 6418 | 1900-11-07 | 3 | c | Statistics of robbery cases in the Prefecture of Guangzhou for the year of 1899. The counties include Nanhai, Panyu, Dongguan, Shunde, Xiangshan, Xinhui, Zengcheng, Sanshui, Xinning, Longmen, Conghua, Huaxian, Xin'an, Qingyuan. The number of cases and the number solved. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6419 | 6419 | 1900-11-07 | 3 | c | Chinese soldiers are very brave when fighting foreign troops. | China | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 |
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]);