This data as json, CSV (advanced)
Suggested facets: date, column, title, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 10929 | 10929 | 1902-08-16 | 5 | b | Wollongong has a coal mine accident. | Australia | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
| 10946 | 10946 | 1902-08-23 | 5 | a | A Tasmania man died in a Sydney hospital after receiving too much anaesthesia. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10947 | 10947 | 1902-08-23 | 5 | b | Trams and passengers in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10948 | 10948 | 1902-08-23 | 5 | b | A rascal in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10949 | 10949 | 1902-08-23 | 5 | b | A Sydney businessman was punished for an inappropriate advertisement. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 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 | |
| 10992 | 10992 | 1902-09-06 | 5 | a | A woman of Dandenong, Melbourne, murdered her husband. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10993 | 10993 | 1902-09-06 | 5 | a | Drought in Gunnedah, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10995 | 10995 | 1902-09-06 | 5 | b | A house fire in Surry Hills, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10997 | 10997 | 1902-09-06 | 5 | b | A Wollongong man was awarded for his bravery. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 11015 | 11015 | 1902-09-20 | 5 | b | Shearers in New Zealand plan a strike. | Australia | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11016 | 11016 | 1902-09-20 | 5 | b | Somebody in Bendigo stole money from a woman's house. | Australia | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11017 | 11017 | 1902-09-20 | 5 | b | Forty-seven Western men from North Sydney were punished for gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11035 | 11035 | 1902-09-27 | 5 | a | Three foreign men in Ballarat have new way to defraud money from the bank. | Australia | http://trove.nla.gov.au/newspaper/page/24100500 | 24100500 | |
| 11036 | 11036 | 1902-09-27 | 5 | a | A successful man in Sydney committed suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100500 | 24100500 | |
| 11037 | 11037 | 1902-09-27 | 5 | b | An earthquake in Adelaide, South Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100500 | 24100500 | |
| 24248 | 24248 | 1911-02-04 | 5 | a-b | An editorial commentary on that China urgently needs a responsible cabinet | Based on the event of the Reform Movement of 1898 (Wu Xu Bian Fa), the commentary goes that China urgently needs a responsible cabinet. | Australia | http://trove.nla.gov.au/newspaper/page/24091624 | 24091624 |
| 24343 | 24343 | 1911-02-18 | 5 | a-b | A book advertisement | The newspaper issued a book advertisement about the new books it has in its office. | Australia | http://trove.nla.gov.au/newspaper/page/24091671 | 24091671 |
| 43029 | 43029 | 1925-04-18 | 5 | c | British and Dutch ships collide. | Australia | http://trove.nla.gov.au/newspaper/page/24101103 | 24101103 | |
| 43063 | 43063 | 1925-04-25 | 5 | b | Australian Oriental Navigation Company has built another big liner. | Australia | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
| 43146 | 43146 | 1925-05-09 | 5 | c | Police commissioner of New South Wales visits America. | Australia | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
| 43186 | 43186 | 1925-05-16 | 5 | c | American trade delegation postpones their visit to Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101135 | 24101135 | |
| 49224 | 49224 | 1930-06-07 | 5 | a | An anti-Chinese article published in a Sydney English newspaper on May 30, 1930. | Australia | http://trove.nla.gov.au/newspaper/page/24099660 | 24099660 | |
| 49291 | 49291 | 1930-07-05 | 5 | a | An English newspaper in Australia publishes an apology to the Chinese community. | Australia | http://trove.nla.gov.au/newspaper/page/24099692 | 24099692 | |
| 51158 | 51158 | 1932-02-06 | 5 | b | Proposal to move the Chinese national capital to Luoyang in order to resistance to Japanese invasion. | Australia | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 |
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]);