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]);