This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6410 | 6410 | 1900-11-07 | 3 | a | American government follows the suggestions of Britain and France on China issues; France and Belgium signed an agreement on their cooperation in China; foreign gunboats in Guangdong; soldiers from Germany, France and Italy are looting in Baoding; Wang Wenshao was lashed on Beijing streets. | Other... | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6411 | 6411 | 1900-11-07 | 3 | a | A call from Shanghai charity organisation for donations to the disaster areas in north China. | China | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6412 | 6412 | 1900-11-07 | 3 | b | Japanese Consulate in Sydney holds a party to celebrate the birthday of Japanese Emperor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
6413 | 6413 | 1900-11-07 | 3 | b | British cabinet changed. | Britain | http://trove.nla.gov.au/newspaper/page/24103007 | 24103007 | |
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]);