This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3299 | 3299 | 1899-08-12 | 3 | a | Story of a rich miser in Britain. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3300 | 3300 | 1899-08-12 | 3 | a | Chinese government issues new coins. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3301 | 3301 | 1899-08-12 | 3 | a | Disputes between the French consul and Chinese residents in Guangzhou; warnings from the local government instructing locals to remain polite to foreigners. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3302 | 3302 | 1899-08-12 | 3 | b | Security arrangement for the Empress Dowager. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3303 | 3303 | 1899-08-12 | 3 | b-c | Several people found buried landmines in Yuanming yuan. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3304 | 3304 | 1899-08-12 | 3 | c | The Empress Dowager is more careful now about her security. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3305 | 3305 | 1899-08-12 | 3 | c | Local customs and traditions in Thailand. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3306 | 3306 | 1899-08-12 | 3 | c | A big fire in Japan burns hundreds of houses. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3307 | 3307 | 1899-08-12 | 3 | d | Fund-raising fete for the hospitals in Sydney. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 | ||
| 3308 | 3308 | 1899-08-12 | 3 | d-f | List of Chinese who donate to Sydney hospitals. | http://trove.nla.gov.au/newspaper/page/24102496 | 24102496 |
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]);