This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1451 | 1451 | 1898-12-24 | 3 | b | Governor Qin of Guangdong is determined to suppress bandit activity and combat gangsters in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102244 | 24102244 | ||
1452 | 1452 | 1898-12-24 | 3 | b | Sydney boy seriously injured while playing with other children. | http://trove.nla.gov.au/newspaper/page/24102244 | 24102244 | ||
1463 | 1463 | 1898-12-24 | 2 | b | Female bandit in Yingde, Fogang area disguised as man. | http://trove.nla.gov.au/newspaper/page/24102243 | 24102243 | ||
1464 | 1464 | 1898-12-24 | 2 | b | Many cases of theft on temple fair; bandits still active. | http://trove.nla.gov.au/newspaper/page/24102243 | 24102243 | ||
1475 | 1475 | 1898-12-24 | 2 | b | No paper will be published on Christmas Day holiday. | http://trove.nla.gov.au/newspaper/page/24102243 | 24102243 | ||
1476 | 1476 | 1898-12-24 | 2 | b | Woman robbed on Sydney train. | http://trove.nla.gov.au/newspaper/page/24102243 | 24102243 |
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]);