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 |
|---|---|---|---|---|---|---|---|---|---|
| 10960 | 10960 | 1902-08-30 | 3 | a | New South Wales has timely rain after a long drought. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
| 10961 | 10961 | 1902-08-30 | 3 | a | Epidemic has been eradicated in Fremantle, Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
| 10962 | 10962 | 1902-08-30 | 3 | a | An old Chinese man died on arrival in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
| 10963 | 10963 | 1902-08-30 | 3 | a | Best wishes to Mei Guangda from Ashfield council and some others. Mei Guangda is recovering from an injury. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
| 10964 | 10964 | 1902-08-30 | 3 | a | Baby found in Darling Harbour, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100480 | 24100480 | |
| 10968 | 10968 | 1902-08-30 | 5 | a | A young woman in North Carlton, Melbourne, burns her baby to death. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10969 | 10969 | 1902-08-30 | 5 | a | A family of five in Brisbane were murdered. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10970 | 10970 | 1902-08-30 | 5 | b | Donations from Sydney newspapers to victims of the coal mine accident in Wollongong, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10971 | 10971 | 1902-08-30 | 5 | b | A husband in Melbourne was murdered by his wife. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 |
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]);