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 |
|---|---|---|---|---|---|---|---|---|---|
| 2784 | 2784 | 1899-06-17 | 2 | f | Xiangshan experiences disease epidemic. | http://trove.nla.gov.au/newspaper/page/24102436 | 24102436 | ||
| 2785 | 2785 | 1899-06-17 | 2 | f | The price of grain in Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102436 | 24102436 | ||
| 2786 | 2786 | 1899-06-17 | 2 | f | Serious drought in Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102436 | 24102436 | ||
| 2787 | 2787 | 1899-06-17 | 2 | f | Strange salt found in Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102436 | 24102436 | ||
| 2788 | 2788 | 1899-06-17 | 2 | f | A woman and her niece in Walgett, New South Wales, die in a house fire. | http://trove.nla.gov.au/newspaper/page/24102436 | 24102436 | ||
| 2808 | 2808 | 1899-06-17 | 3 | f | Russia places more demands on China. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
| 2809 | 2809 | 1899-06-17 | 3 | f | Gold is found in abundance in Victoria. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 | ||
| 2810 | 2810 | 1899-06-17 | 3 | f | Fang Boyuan leaves Guangdong and gets promoted. | http://trove.nla.gov.au/newspaper/page/24102435 | 24102435 |
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]);