This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3397 | 3397 | 1899-08-26 | 2 | a | A report from Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3398 | 3398 | 1899-08-26 | 2 | a-c | A report from zongli yamen. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3399 | 3399 | 1899-08-26 | 2 | c-d | A speech from the former Japanese Prime Minister. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3400 | 3400 | 1899-08-26 | 2 | d | Gang Yi's comments during his inspection in Jiangsu. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3401 | 3401 | 1899-08-26 | 2 | d | Strange disease discovered in Egypt. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3402 | 3402 | 1899-08-26 | 2 | e | Disease spreads in Portugal. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3403 | 3403 | 1899-08-26 | 2 | e | Value of Adelaude's imports and exports. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3404 | 3404 | 1899-08-26 | 2 | e | Heavy rain and flooding in country New South Wales | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3405 | 3405 | 1899-08-26 | 2 | e | Monte Carlo is the biggest gambling venue in the world. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3406 | 3406 | 1899-08-26 | 2 | e | Magistrate of Hefei sacrifices himself for the people. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3407 | 3407 | 1899-08-26 | 2 | e | Bicycle champion in the USA. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3408 | 3408 | 1899-08-26 | 2 | f | A high-level official in Austria was arrested for selling information to other country. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3409 | 3409 | 1899-08-26 | 2 | f | A performer from Sydney travels to Britain to perform for the Queen. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3410 | 3410 | 1899-08-26 | 2 | f | Bandits in Nanhai county, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3411 | 3411 | 1899-08-26 | 2 | f | Casualties caused by foreign powder in a prayer ceremony in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3412 | 3412 | 1899-08-26 | 2 | f | Further investigations are needed on the death of a man in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 | ||
| 3413 | 3413 | 1899-08-26 | 2-3 | f | Gold found in Zengcheng; rich house robbed (belongs to Zhou family) ; Mr Gu Chaoqin, who married a white woman here, has returned to China; a poor lichee harvest is expected due to drought. | http://trove.nla.gov.au/newspaper/page/24102513 | 24102513 |
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]);