This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4290 | 4290 | 1899-12-20 | 3 | a | Germany will build more gunboats. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4291 | 4291 | 1899-12-20 | 3 | a | America has purchased a vast amount of land from Russia. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4292 | 4292 | 1899-12-20 | 3 | a | Germany removes all foreign ambassador's assistants. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4293 | 4293 | 1899-12-20 | 3 | a | A British minister said European countries have a plot against Britain. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4294 | 4294 | 1899-12-20 | 3 | a | Leader of the Democrats in America calls for an independent Philippines. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4295 | 4295 | 1899-12-20 | 3 | a | A shop on Gibbs St, Sydney, is a good place for shopping. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4296 | 4296 | 1899-12-20 | 3 | a | International relations and diplomacy, German Foreign Minister talks about their foreign relations. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4297 | 4297 | 1899-12-20 | 3 | a | American troops will release all prisoners they captured during the war. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4298 | 4298 | 1899-12-20 | 3 | a | Italy asks for Tangshan, Hebei province, from the Chinese government. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4299 | 4299 | 1899-12-20 | 3 | a | Yuan Shikai was summoned to the court and consulted. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4300 | 4300 | 1899-12-20 | 3 | b | Tap water will be available soon in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4301 | 4301 | 1899-12-20 | 3 | b-d | Boer war, South Africa, reports on the war between Britain and Transvaal. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4302 | 4302 | 1899-12-20 | 3 | d | Serious drought in Fuzhou, Fujian province. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4303 | 4303 | 1899-12-20 | 3 | d | Rain has fallen for many days in Shaoxing, Zhejiang province. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4304 | 4304 | 1899-12-20 | 3 | d | Empress Dowager tries to get information about Western learning. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 |
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]);