This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4901 | 4901 | 1900-04-07 | 2 | a-b | An essay discussing reform, arguing that it is for the good of the nation and the people. | China | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
4917 | 4917 | 1900-04-07 | 3 | a-b | Four executives of Chinese Empire Reform Association from Sydney, Liu Ruxing, Ouyang Wanqing, Miu Dianchen and Chen Shou, travel to New Castle to promote the Protect Emperor movement there. Su Jingling presided over the meeting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102758 | 24102758 |
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]);