This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5868 | 5868 | 1900-08-18 | 2 | d | A rapist in Melbourne was caught. | Australia | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5869 | 5869 | 1900-08-18 | 2 | d | The Sydney Chinese Empire Reform Association, after its establishment, has received donations from Chinese not only in Sydney but also from other towns, such as Huang Zhu, Liu Yanguang, Lin Dang, Chen Yanyao, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 |
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]);