This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18859 | 18859 | 1908-02-15 | 2 | a-b | Editorial/ Common aspiration of Chinese people in 1908. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801629 | 26801629 | |
18865 | 18865 | 1908-02-15 | 3 | a-b | Russia to build double-track for the Trans-Siberia Railroad. | Britain | http://trove.nla.gov.au/newspaper/page/26801628 | 26801628 | |
18896 | 18896 | 1908-02-15 | 8 | a-b | Railway news. Reports on disputes over the railway building in Jiangsu and Zhejiang province (attempt to borrow foreign loan, protest against foreign loans, and efforts of local authority to pacify the protest). | China | http://trove.nla.gov.au/newspaper/page/26801636 | 26801636 |
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]);