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 |
---|---|---|---|---|---|---|---|---|---|
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 | ||
3429 | 3429 | 1899-08-26 | 3 | e | A temple in Zhaoqing damaged in fire. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3430 | 3430 | 1899-08-26 | 3 | e | New methods to cultivate pearls. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3431 | 3431 | 1899-08-26 | 3 | e | Kang Youwei has arrived in London. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3432 | 3432 | 1899-08-26 | 3 | e | Some bandits in Lufeng county are under custody. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3433 | 3433 | 1899-08-26 | 3 | e | Electric lights in Guangzhou are welcomed. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3434 | 3434 | 1899-08-26 | 3 | e | Britain demands compensation from Chinese government for the riots in Kowloon. | http://trove.nla.gov.au/newspaper/page/24102512 | 24102512 | ||
3435 | 3435 | 1899-08-26 | 3 | e | The inscriptions on a tablet found in Tianjin. | 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]);