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 |
---|---|---|---|---|---|---|---|---|---|
3875 | 3875 | 1899-10-21 | 2 | f | The deputy manager of a Melbourne bank was arrested for embezzlement. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
3876 | 3876 | 1899-10-21 | 2 | f | Parliament in Melbourne once again discusses proposals to ban entry of Chinese. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
3877 | 3877 | 1899-10-21 | 2 | f | Chinese Liu Wen finishes his lawsuit against a White man in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
3878 | 3878 | 1899-10-21 | 2 | f | The Chinese Anti-Opium Association in Christchurch, New Zealand, holds another meeting. Liu Si replaces Lin Leji as chairman. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
3879 | 3879 | 1899-10-21 | 2 | f | Royal family of Britain compensates French fisherman. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
3880 | 3880 | 1899-10-21 | 2 | f | Samoa requests compensation from Germany, Britain and the USA. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
3896 | 3896 | 1899-10-21 | 3 | f | Cremation in Denmark. | http://trove.nla.gov.au/newspaper/page/24102573 | 24102573 | ||
3897 | 3897 | 1899-10-21 | 3 | f | Man claims to make oil from water. | http://trove.nla.gov.au/newspaper/page/24102573 | 24102573 | ||
3898 | 3898 | 1899-10-21 | 3 | f | Gold price in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102573 | 24102573 |
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]);