This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6398 | 6398 | 1900-11-07 | 2 | b-c | The sixth and final part of the diary written by a Guangdong man who was working in Tianjin during the Boxer turmoil. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103008 | 24103008 | |
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 | |
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 |
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]);