This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8284 | 8284 | 1901-07-31 | 3 | a | Bandits and social security in Guangzhou; British foreign secretary on China issues; heat wave in America; hail in Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8285 | 8285 | 1901-07-31 | 3 | a | A love story in Gaoyao county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8286 | 8286 | 1901-07-31 | 3 | b | A Sydney man faces court hearing for theft. | Australia | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8287 | 8287 | 1901-07-31 | 3 | b | A carriage in Wagga Wagga was capsized and caused injuries. | Australia | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8288 | 8288 | 1901-07-31 | 3 | b | The English wife of a Chinese gardener in Towrang, NSW, committed suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8289 | 8289 | 1901-07-31 | 3 | b | Sydney Chinese Empire Reform Association had a farewell party to Huang Zaixing and Ou Bin, who are respectively going to China and Western Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8290 | 8290 | 1901-07-31 | 3 | c | Reply from the steamship company in regards to discount tickets provided to old and poor Chinese for their returning home. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8291 | 8291 | 1901-07-31 | 3 | c | A Shanghai newspaper says efforts should be made to restore the Emperor in power. | China | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8292 | 8292 | 1901-07-31 | 3 | c | A notice from The Tung Wah News for writing letter to the editor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8293 | 8293 | 1901-07-31 | 3 | c | A meeting of the Sydney Chinese Empire Reform Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8294 | 8294 | 1901-07-31 | 3 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
8295 | 8295 | 1901-07-31 | 3 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 |
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]);