This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3629 | 3629 | 1899-09-20 | 3 | a | Empress Dowager issues new orders to regulate the bureaucracy. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3630 | 3630 | 1899-09-20 | 3 | a | A robbery during broad daylight in Xinning county. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3631 | 3631 | 1899-09-20 | 3 | b-d | Story of a local gentry scholar, Mr Zhan; baojia in local Zengcheng; feud between two families, Yu and Ye; local scholar Wen Xieyao has a concubine whose husband has died overseas; Zhang family in the county town has discovered their origins; a gambling house in Xintang village was robbed by bandits. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3632 | 3632 | 1899-09-20 | 3 | d | Many foxes have been found in Cowell, SA. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3633 | 3633 | 1899-09-20 | 3 | e | People in Warren, NSW, get clear water from underground. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3634 | 3634 | 1899-09-20 | 3 | e | A man in Bomera hunts more than 200 rabbits a day. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3635 | 3635 | 1899-09-20 | 3 | e | Earthquake in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3636 | 3636 | 1899-09-20 | 3 | e | Two men in Victoria die from poisonous gas. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3637 | 3637 | 1899-09-20 | 3 | e | Japan signs agreement with other countries to open China's ports. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3638 | 3638 | 1899-09-20 | 3 | e | Value and quantity of gold produced in Western Australia. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3639 | 3639 | 1899-09-20 | 3 | e | A Chinese in Sydney was penalised for horse abuse. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3640 | 3640 | 1899-09-20 | 3 | e | A boy in Sydney was shot dead by accident. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3641 | 3641 | 1899-09-20 | 3 | f | Bandits are very active in the rivers of Xiangshan; the bandits' leader is the nephew of a former local official; an escaped criminal is caught. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3642 | 3642 | 1899-09-20 | 3 | f | The bodies of two maidservants were found floating in a pond in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 |
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]);