This data as json, CSV (advanced)
Suggested facets: 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 |
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]);