This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22125 | 22125 | 1909-12-18 | 2 | a-b | Editorial on geological research and its relation with national strength. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802432 | 26802432 | |
22126 | 22126 | 1909-12-18 | 2 | b-c | The motives behind cutring pigtails and changing the official uniform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802432 | 26802432 | |
22127 | 22127 | 1909-12-18 | 2 | c | Prince Regent prefers to pardon the party reformers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802432 | 26802432 | |
22128 | 22128 | 1909-12-18 | 2 | c | Navy news. Naval officer for sale. Naval rank and recruitment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802432 | 26802432 | |
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 |
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]);