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 |
|---|---|---|---|---|---|---|---|---|---|
| 2744 | 2744 | 1899-06-14 | 2 | e | Five Chinese in Melbourne fined for working on Sunday; an old man in Sydney was penalised for using fake bank notes; two women were penalised for quarrelling on the street; a Chinese man in Sydney was sentenced to five years' imprisonment for stabbing a White man. | http://trove.nla.gov.au/newspaper/page/24102432 | 24102432 | ||
| 2745 | 2745 | 1899-06-14 | 2 | e | War in Luzon, involvement of USA. Filipino soldiers defeat American troops. | http://trove.nla.gov.au/newspaper/page/24102432 | 24102432 | ||
| 2746 | 2746 | 1899-06-14 | 2 | e | A man in Tasmania was seriously injured. | http://trove.nla.gov.au/newspaper/page/24102432 | 24102432 | ||
| 2768 | 2768 | 1899-06-14 | 3 | e | Germany and Russia together forced China to accept their demands. | http://trove.nla.gov.au/newspaper/page/24102431 | 24102431 | ||
| 2769 | 2769 | 1899-06-14 | 3 | e | Xu Jihe talks about the Chinese economy. | http://trove.nla.gov.au/newspaper/page/24102431 | 24102431 | ||
| 2770 | 2770 | 1899-06-14 | 3 | e | Coal mining in Yichun, Jiangxi province. | http://trove.nla.gov.au/newspaper/page/24102431 | 24102431 | ||
| 2771 | 2771 | 1899-06-14 | 3 | e | Muslim riot in Gansu province. | http://trove.nla.gov.au/newspaper/page/24102431 | 24102431 | ||
| 2772 | 2772 | 1899-06-14 | 3 | e | An incidence of cheating in Shanghai. | http://trove.nla.gov.au/newspaper/page/24102431 | 24102431 |
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]);