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 |
---|---|---|---|---|---|---|---|---|---|
6273 | 6273 | 1900-10-13 | 2 | a-b | A letter from Sun Baoxiong, of Changzhou, to Zhang Zhidong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102983 | 24102983 | |
6274 | 6274 | 1900-10-13 | 2 | b | Monarchs of Western countries such as Queen of England, King of Denmark, are living long lives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102983 | 24102983 | |
6281 | 6281 | 1900-10-13 | 2 | d | Japanese administrators in Taiwan clash with local residents in Tainan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102983 | 24102983 | |
6282 | 6282 | 1900-10-13 | 2 | d | People in Chaozhou, Guangdong, harassed by hooligans. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102983 | 24102983 | |
6284 | 6284 | 1900-10-13 | 2 | e | A Guangdong businessman in Shanghai contends there is an urgent need to protect the Emperor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102983 | 24102983 | |
6288 | 6288 | 1900-10-13 | 2 | f | The story of a refugee from the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102983 | 24102983 | |
6289 | 6289 | 1900-10-13 | 3 | a | A cynical scholar in Panyu county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102982 | 24102982 | |
6290 | 6290 | 1900-10-13 | 3 | a | An argument from the Tung Wah News reporting on China affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102982 | 24102982 | |
6293 | 6293 | 1900-10-13 | 3 | c | A Chinese stabbed by a Portuguese in Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102982 | 24102982 | |
6294 | 6294 | 1900-10-13 | 3 | c | A correction from the newspaper office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102982 | 24102982 | |
6295 | 6295 | 1900-10-13 | 3 | c | Timetable of ocean liners travelling to and from Asian ports. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102982 | 24102982 |
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]);