This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32088 | 32088 | 1917-02-17 | 3 | a-b | A report by Yang Zengxin on disadvantages of direct election of provincial governor. | China | http://trove.nla.gov.au/newspaper/page/24095600 | 24095600 | |
32098 | 32098 | 1917-02-17 | 7 | a-b | Australia news/ Chinese Chamber of Commerce in New South Wales elects Ma Yingbiao candidate for the Chinese national senator, and other two candidates are Guo Le and Lu Yijun. Statistics of Australia's imports and exports in the last seven years (1910-1917). A Chinese man in injured in a tram accident in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095604 | 24095604 |
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]);