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 |
---|---|---|---|---|---|---|---|---|---|
2918 | 2918 | 1899-07-01 | 2 | e | A Sydney judge commits suicide. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2919 | 2919 | 1899-07-01 | 2 | e | Quantity and value of coal exported from colonies of Australia. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2920 | 2920 | 1899-07-01 | 2 | e | Situation in Luzon. Britain sends troops to the Philippines to recover two British men detained by the local forces. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2948 | 2948 | 1899-07-01 | 3 | e | Young man in Sydney faces penalities for fishing. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
2949 | 2949 | 1899-07-01 | 3 | e | A brave heroine in Dongguan. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
2950 | 2950 | 1899-07-01 | 3 | e | British government demands compensation from China for murdering of an Adelaide missionary in China. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
2951 | 2951 | 1899-07-01 | 3 | e | Fighting between family clans in Zengcheng; lawsuits pending. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 |
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]);