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 |
|---|---|---|---|---|---|---|---|---|---|
| 539 | 539 | 1898-08-20 | 4 | a | Chinese man killed and white woman injured in stabbing incident in Sydney. | http://trove.nla.gov.au/newspaper/page/24102101 | 24102101 | ||
| 540 | 540 | 1898-08-20 | 4 | a | Quit Opium Smoking Association in London gathers, requests Britain ceases opium trade with China. | http://trove.nla.gov.au/newspaper/page/24102101 | 24102101 | ||
| 541 | 541 | 1898-08-20 | 4 | a-b | man steals shoes from shop. | http://trove.nla.gov.au/newspaper/page/24102101 | 24102101 | ||
| 542 | 542 | 1898-08-20 | 4 | b-c | Story of funny, incompetent doctor | http://trove.nla.gov.au/newspaper/page/24102101 | 24102101 | ||
| 543 | 543 | 1898-08-20 | 4 | c | Price list of products in Sydney market | http://trove.nla.gov.au/newspaper/page/24102101 | 24102101 | ||
| 544 | 544 | 1898-08-20 | 3 | a | War, Philippines, USA, aftermath of Luzon War. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 545 | 545 | 1898-08-20 | 3 | a | farmers in Queensland plan to start coffee plantation. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 546 | 546 | 1898-08-20 | 3 | a-b | Chinese man robbed on his way home by black woman. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 547 | 547 | 1898-08-20 | 3 | b | Man in New Zealand cooks enourmous curry. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 548 | 548 | 1898-08-20 | 3 | b | Crime, polygamy, minister in London charged for living with two wives. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 549 | 549 | 1898-08-20 | 3 | b-c | Huntsman in Britain seriously injurs man. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 550 | 550 | 1898-08-20 | 3 | c | Woman in New Zealand finds worm inside egg. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 551 | 551 | 1898-08-20 | 3 | c | Chinese man kills himself with shaver after quarrelling with White man. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 552 | 552 | 1898-08-20 | 3 | c | Building of railway from Shanghai to Wusong has been completed. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 553 | 553 | 1898-08-20 | 3 | c-d | Aboriginal man in Queensland catches crocodile while fishing. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 554 | 554 | 1898-08-20 | 3 | d | London woman dies during home abortion procedure. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 555 | 555 | 1898-08-20 | 3 | d | Britain completes building of new gunboat. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 556 | 556 | 1898-08-20 | 3 | d-e | Immigration. Chinese arrivals in Melbourne decrease. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 557 | 557 | 1898-08-20 | 3 | e | Two children die from extensive burns in house fire. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 558 | 558 | 1898-08-20 | 3 | e | Honolulu and Japan yet to achieve agreement on compensation to Japanese. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 559 | 559 | 1898-08-20 | 3 | e-f | English newspaper publishes article pointing out difficulties in carving up China. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 560 | 560 | 1898-08-20 | 3 | f | Crime, White man detained for illegal sale of wine. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 561 | 561 | 1898-08-20 | 3 | f | Bakery owners in Sydney punished for overcharging customers. | http://trove.nla.gov.au/newspaper/page/24102104 | 24102104 | ||
| 562 | 562 | 1898-08-20 | 2 | a | Philanthropy, rich man in London donates money to hospital before dieing. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 563 | 563 | 1898-08-20 | 2 | a | Baby abandoned near Sydney. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 564 | 564 | 1898-08-20 | 2 | a-b | Comments on likes and dislikes | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 565 | 565 | 1898-08-20 | 2 | b | Benefits of watching drama. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 566 | 566 | 1898-08-20 | 2 | b-c | War, Philippines. USA and Luzon agree on peace negotiations. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 567 | 567 | 1898-08-20 | 2 | c | People injured while gambling in USA. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 568 | 568 | 1898-08-20 | 2 | c | Immigration, one hundred Japanese arrive in Queensland. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 569 | 569 | 1898-08-20 | 2 | c-d | Motives behind Russia's attempts to carve up China. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 570 | 570 | 1898-08-20 | 2 | d | Man in Sydney forges certificate of Gibbs Steamship Co. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 571 | 571 | 1898-08-20 | 2 | d | Young girl dies in house fire in New Castle. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 572 | 572 | 1898-08-20 | 2 | d-e | Pick-pocket sentenced; man faces chrages for drunk and disorderly behaviour; penalty for illegally selling wine; etc. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 573 | 573 | 1898-08-20 | 2 | e | Six children left uncared for as father sent to madhouse. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 574 | 574 | 1898-08-20 | 2 | e | Man dies after jumping from high building. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 575 | 575 | 1898-08-20 | 2 | e-f | Five girls drown after falling into sea from ship. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 576 | 576 | 1898-08-20 | 2 | f | Jew in Sydney repeatedly prosecuted for gambling. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 577 | 577 | 1898-08-20 | 2 | f | Price of beef increases in Brisbane. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 | ||
| 578 | 578 | 1898-08-20 | 2 | f | Chinese man struggles to understand what judge says in court. | http://trove.nla.gov.au/newspaper/page/24102103 | 24102103 |
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]);