This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9190 | 9190 | 1901-11-27 | 3 | a | Seismic sea waves in Wenzhou, Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9191 | 9191 | 1901-11-27 | 3 | a | Flooding in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9192 | 9192 | 1901-11-27 | 3 | a | New munitions factory in building in Fuzhou, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9193 | 9193 | 1901-11-27 | 3 | a | A foreigner plans to buy a mine in China. | China | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9194 | 9194 | 1901-11-27 | 3 | a | Report on the new policy initiated by the imperial court. | China | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9195 | 9195 | 1901-11-27 | 3 | b | Guangdong finds several stuntmen in the imperial examination this year. | China | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9196 | 9196 | 1901-11-27 | 3 | b-d | The fifth part of the report on the lawsuit between Li Bu and Chen Shou, two Chinese businessmen in Sydney. Problems with Lin Yik Tong, Chinese Empire Reform Association and the Chinese community in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9197 | 9197 | 1901-11-27 | 3 | e | Corrections from the newspaper. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9198 | 9198 | 1901-11-27 | 3 | e | Timetable of ocean liner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 |
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]);