This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 10589 | 10589 | 1902-05-14 | 2 | e | French man detained in Sydney for pilfering; two roommates in Sydney face court trial; a man in Alexandria, Sydney, punished for attacking girls; a traffic accident on George Street, Sydney, and casualties. | Australia | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
| 10590 | 10590 | 1902-05-14 | 2 | f | Four Chinese men died of epidemics in four days in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
| 10591 | 10591 | 1902-05-14 | 2 | f | Drought in Cobar, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
| 10593 | 10593 | 1902-05-14 | 2 | f | A Sydney baby was kicked by a Russian man and seriously injured. | Australia | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
| 10594 | 10594 | 1902-05-14 | 2 | f | An earthquake in south Europe. | Australia | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
| 10595 | 10595 | 1902-05-14 | 3 | a | Former governor of New South Wales is trying to have a portrait of the crowned King of England. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10596 | 10596 | 1902-05-14 | 3 | a | Dozens of train passengers in Belgium were injured in an accident. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10597 | 10597 | 1902-05-14 | 3 | a | The new alliance between Russia and France. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10603 | 10603 | 1902-05-14 | 3 | c | Turks prepare to defend their country from possible invasion of Italy. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10604 | 10604 | 1902-05-14 | 3 | c | Governor General Lord Hopetoun reviews Australian troops departing for the Boer War, Transvaal, South Africa. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10605 | 10605 | 1902-05-14 | 3 | c | A Chinese house in Alexandria, New South Wales, to be demolished because of suspected epidemic infection. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10606 | 10606 | 1902-05-14 | 3 | d | A bank manager in Coonamble, New South Wales, committed suicide by shooting himself. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10607 | 10607 | 1902-05-14 | 3 | d | A Chinese man, Zan Chang, died in a traffic accident on Goulburn Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
| 10608 | 10608 | 1902-05-14 | 3 | d | A restaurant on Castlereagh Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 |
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]);