This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | ||
3436 | 3436 | 1899-08-26 | 3 | f | Britain sends more troops to be stationed in Kowloon. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3437 | 3437 | 1899-08-26 | 3 | f | Beef as medicine to cure leprosy. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3438 | 3438 | 1899-08-26 | 3 | f | Women were smuggled into the USA for profit. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3439 | 3439 | 1899-08-26 | 3 | f | The wealth of citizens of the USA. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 |
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]);