This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3587 | 3587 | 1899-09-16 | 2 | f | War in Luzon. USA troops in the Philippines win a battle. | http://trove.nla.gov.au/newspaper/page/24102534 | 24102534 | ||
| 3588 | 3588 | 1899-09-16 | 2 | f | France postpones its scheduled military parade. | http://trove.nla.gov.au/newspaper/page/24102534 | 24102534 | ||
| 3589 | 3589 | 1899-09-16 | 2 | f | Transvaal government purchases weapons; war seems inevitable; residents of Pretoria want to fight; French newspapers accuse Transvaal. | http://trove.nla.gov.au/newspaper/page/24102534 | 24102534 | ||
| 3590 | 3590 | 1899-09-16 | 2 | f | Sailors from Norway eat their fellow countrymen in order to stay alive. | http://trove.nla.gov.au/newspaper/page/24102534 | 24102534 | ||
| 3591 | 3591 | 1899-09-16 | 2 | f | An armed robber in Western Australia. | http://trove.nla.gov.au/newspaper/page/24102534 | 24102534 | ||
| 3592 | 3592 | 1899-09-16 | 2 | f | Tingha is prosperous again following the discovery of tin. | http://trove.nla.gov.au/newspaper/page/24102534 | 24102534 | ||
| 3603 | 3603 | 1899-09-16 | 3 | f | A burglary case in Sydney. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 | ||
| 3604 | 3604 | 1899-09-16 | 3 | f | Prospect of agricultural production in New South Wales. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 | ||
| 3605 | 3605 | 1899-09-16 | 3 | f | Rapid weather changes in South Australia. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 | ||
| 3606 | 3606 | 1899-09-16 | 3 | f | A man in Perth dies in a mine explosion. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 | ||
| 3607 | 3607 | 1899-09-16 | 3 | f | Britain makes better torpedo boats. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 | ||
| 3608 | 3608 | 1899-09-16 | 3 | f | Tsar of Russia and his wife are visiting Denmark. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 | ||
| 3609 | 3609 | 1899-09-16 | 3 | f | Workers in the Netherlands are on strike, demanding higher pay. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 | ||
| 3610 | 3610 | 1899-09-16 | 3 | f | Price of grain in Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102533 | 24102533 |
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]);