This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27291 | 27291 | 1913-04-19 | 2 | d | London newspaper Times' comments on China's foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24092649 | 24092649 | |
27292 | 27292 | 1913-04-19 | 2 | d | Reason for former Qing government not evacuate their palace. | China | http://trove.nla.gov.au/newspaper/page/24092649 | 24092649 | |
27293 | 27293 | 1913-04-19 | 2 | d | Shaanxi governor changes his party membership from Nationalist Party to United Party. | Other... | http://trove.nla.gov.au/newspaper/page/24092649 | 24092649 | |
27313 | 27313 | 1913-04-19 | 3 | d | Guangdong news/ Guangdong governor asks president to send ship to appreciate overseas Chinese in foreign nations. President asks to protect overseas Chinese's benefits. Dongguan mayor issues heavy punisment on opium smokers. Opium smoker asks people not to smoke opium on his way to detain centre. Governor Hu befriends with those advocating second revolution. Detective summoned to court for robbery. Foshan big businessmen threatened by gangsters. Funds for Gaoming road. | Other... | http://trove.nla.gov.au/newspaper/page/24092648 | 24092648 |
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]);