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]);