This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2423 | 2423 | 1899-05-10 | 2 | a-b | The third part of a report submitted by Yu Liansan, Governor of Hunan. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2424 | 2424 | 1899-05-10 | 2 | b-c | Lu Chuanlin, Governor of Guangdong, strengthens the bureaucracy of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2425 | 2425 | 1899-05-10 | 2 | c-d | The importance of talented people to the strength of a country. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2426 | 2426 | 1899-05-10 | 2 | d | Chinese in Sydney are to build a Guangong temple, the Council grants it tax-free status. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2427 | 2427 | 1899-05-10 | 2 | d | America and Germany are now connected by cables. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2428 | 2428 | 1899-05-10 | 2 | d | Ships from Britain and USA race against each other. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2429 | 2429 | 1899-05-10 | 2 | d-e | The first part of an article on the exploration of the Antarctic. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2430 | 2430 | 1899-05-10 | 2 | e | A gold mine accident in Russia; train accident in USA; coal miners on strike in the USA; America inflicts cruelest form of torture on blacks; Britain demands compensation for damages in Kowloon; a German newspaper says Britain should give central China to Germany; wool price is up in London; silver price is up in London. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2431 | 2431 | 1899-05-10 | 2 | e-f | Income tax rates in Victoria, Western Australia, New South Wales, South Australia, New Zealand; population in Western Australia; expenditure of Western Australia. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 | ||
| 2432 | 2432 | 1899-05-10 | 2-3 | f-a | Residents and customs in Taiwan, Malaysia, Singapore. | http://trove.nla.gov.au/newspaper/page/24102392 | 24102392 |
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]);