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 |
|---|---|---|---|---|---|---|---|---|---|
| 465 | 465 | 1898-08-13 | 4 | a | Chinese man dies while working in country Victoria. | http://trove.nla.gov.au/newspaper/page/24102093 | 24102093 | ||
| 466 | 466 | 1898-08-13 | 4 | a-b | Court cases in Sydney, including tobacco smuggling, burglary, etc. | http://trove.nla.gov.au/newspaper/page/24102093 | 24102093 | ||
| 467 | 467 | 1898-08-13 | 4 | b | Westerner in NSW hangs himself. | http://trove.nla.gov.au/newspaper/page/24102093 | 24102093 | ||
| 468 | 468 | 1898-08-13 | 4 | b-c | War, Philippines, USA, recent developments from war in Luzon | http://trove.nla.gov.au/newspaper/page/24102093 | 24102093 | ||
| 469 | 469 | 1898-08-13 | 4 | c | Thief steals from house of Chinese in Sydney. | http://trove.nla.gov.au/newspaper/page/24102093 | 24102093 | ||
| 470 | 470 | 1898-08-13 | 4 | d | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102093 | 24102093 | ||
| 471 | 471 | 1898-08-13 | 4 | d | Many people pay last respects to Bismarck at funeral. | http://trove.nla.gov.au/newspaper/page/24102093 | 24102093 | ||
| 472 | 472 | 1898-08-13 | 3 | a | Sugarcane growers in Queensland refuse to employ Chinese labourers except at busiest point of harvest. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 473 | 473 | 1898-08-13 | 3 | a | Young white boy caught stealing beans from Chinese garden. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 474 | 474 | 1898-08-13 | 3 | a-b | Woman in Victoria hangs herself at home. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 475 | 475 | 1898-08-13 | 3 | b-c | Stories of Mr Ghost. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 476 | 476 | 1898-08-13 | 3 | c-d | Crime, illegal gambling, Westerners found gambling on horse races. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 477 | 477 | 1898-08-13 | 3 | d | Eagle bites dog in Victoria | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 478 | 478 | 1898-08-13 | 3 | d-e | Crime, two children, aged 13 and 12, charged with burglary. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 479 | 479 | 1898-08-13 | 3 | e | Drunk man rests on streets and loses all things in his pockets. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 480 | 480 | 1898-08-13 | 3 | e | Baby boy abandoned in Waterloo. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 481 | 481 | 1898-08-13 | 3 | e-f | Court case, woman takes her former boyfriend to court. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 482 | 482 | 1898-08-13 | 3 | f | New Zealand is to place quality labels on all export meat products. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 483 | 483 | 1898-08-13 | 3-2 | f-a | Dog in Sydney. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 484 | 484 | 1898-08-13 | 2 | a | Russia prevents China from borrowing money to build railway in eastern China. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 485 | 485 | 1898-08-13 | 2 | a-b | Baby girl in Ballarat drowns in washing tub. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 486 | 486 | 1898-08-13 | 2 | b | Immigration regulations, Adelaide plans to ban entry of Japanese. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 487 | 487 | 1898-08-13 | 2 | b | Melbourne man hangs himself following death of wife. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 488 | 488 | 1898-08-13 | 2 | b | Old newspaper auctioned in Sydney. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 489 | 489 | 1898-08-13 | 2 | b-c | Seven customers poisoned by arsenic in Williamstown restaurant, Melbourne. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 490 | 490 | 1898-08-13 | 2 | c | Crime, four men face court on smuggling charges. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 491 | 491 | 1898-08-13 | 2 | c | Gunpowder magazine explodes in Victoria. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 492 | 492 | 1898-08-13 | 2 | c-d | Man in Sydney sentenced for forging bank notes. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 493 | 493 | 1898-08-13 | 2 | d | London, price of apples increases. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 494 | 494 | 1898-08-13 | 2 | d-e | Boy and girl have pointless quarrel in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 495 | 495 | 1898-08-13 | 2 | e | Chinese carpenters in Brisbane. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 496 | 496 | 1898-08-13 | 2 | e-f | New methods for taking baths. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 497 | 497 | 1898-08-13 | 2 | f | Famous official in New South Wales dies. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 498 | 498 | 1898-08-13 | 2 | f | Crime, robbery in New South Wales | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 | ||
| 499 | 499 | 1898-08-13 | 2 | f | Prisoner in Wollongong appeals results of case. | http://trove.nla.gov.au/newspaper/page/24102095 | 24102095 |
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]);