This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17485 | 17485 | 1907-05-25 | 2 | a | A notice from the Chinese Empire Reform Association says, although its Chinese name has been changed to diguo xianzheng hui (Chinese Empire Constitutional Reform Association), its English names will remain the same (Chinese Empire Reform Association). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801340 | 26801340 |
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]);