This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22129 | 22129 | 1909-12-18 | 2 | c-d | Beijing news. Japanese occupy Liugongdao island out of Shandong province. Germans in Shandong want to build the railway from Yantai to Weifang and their negotiation with Chinese side. Russian have completed their railway construction to Qiqihar. Statistics on foreign tourists to Heilongjiang province. Eunuchs to be dismissed. Conflict between Japanese and Chinese businessmen along the Fengtian-Andong railway. Russian treasurer visits Manchuria. Ban on opium smoking in Chinese officialdom and the progress. | China | http://trove.nla.gov.au/newspaper/page/26802432 | 26802432 | |
22141 | 22141 | 1909-12-18 | 3 | c-d | A public letter from Chinese businessman Yang Jingliu in Java to his Guangdong counterparts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 |
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]);