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 |
|---|---|---|---|---|---|---|---|---|---|
| 500 | 500 | 1898-08-17 | 4 | a-b | Letter from reader Liu Yuanchun. | http://trove.nla.gov.au/newspaper/page/24102097 | 24102097 | ||
| 501 | 501 | 1898-08-17 | 4 | b | Crime, court case, Adelaide, murderer sentenced for burning woman. | http://trove.nla.gov.au/newspaper/page/24102097 | 24102097 | ||
| 502 | 502 | 1898-08-17 | 4 | b-c | New South Wales library has publications from around world, anyone can access. | http://trove.nla.gov.au/newspaper/page/24102097 | 24102097 | ||
| 503 | 503 | 1898-08-17 | 4 | c | Mail waiting to be collected. | http://trove.nla.gov.au/newspaper/page/24102097 | 24102097 | ||
| 504 | 504 | 1898-08-17 | 4 | c | Ocean liner timetable for arrivals and departures. | http://trove.nla.gov.au/newspaper/page/24102097 | 24102097 | ||
| 505 | 505 | 1898-08-17 | 4 | d | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102097 | 24102097 | ||
| 506 | 506 | 1898-08-17 | 4 | d | Price list of products in Melbourne market. | http://trove.nla.gov.au/newspaper/page/24102097 | 24102097 | ||
| 507 | 507 | 1898-08-17 | 3 | a | Man ordered to pay wife in divorce settlement. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 508 | 508 | 1898-08-17 | 3 | a | Iron and steel production in Russia. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 509 | 509 | 1898-08-17 | 3 | a-b | Man in Guangzhou cheated on in second marriage. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 510 | 510 | 1898-08-17 | 3 | b | Lamb princes increase in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 511 | 511 | 1898-08-17 | 3 | b | Country town in NSW holds charity party, all donations go to hospital. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 512 | 512 | 1898-08-17 | 3 | b-c | Crime, Westerner arrested for swindling Chinese shop. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 513 | 513 | 1898-08-17 | 3 | c | Britain spends much money on wine every year. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 514 | 514 | 1898-08-17 | 3 | c | Ceylon tea replaces Chinese tea in London market. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 515 | 515 | 1898-08-17 | 3 | c-d | Cat saves master in Hangzhou. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 516 | 516 | 1898-08-17 | 3 | d | International relations, disputes between Germany and Britain. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 517 | 517 | 1898-08-17 | 3 | d | Gold production in seven states of Australia. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 518 | 518 | 1898-08-17 | 3 | d-e-f | Animals and plants are very good weather forecasters. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 519 | 519 | 1898-08-17 | 3 | f | Boat hospital in London. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 520 | 520 | 1898-08-17 | 3 | f | Contributions of Chemistry. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 521 | 521 | 1898-08-17 | 3 | f | Bodies of three baby boys found in woman's backyard. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 522 | 522 | 1898-08-17 | 3-2 | f-a | Philanthropy, rich businessman in London helps build several charity foundations. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 523 | 523 | 1898-08-17 | 2 | a | Sydney man loses wine he purchased. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 524 | 524 | 1898-08-17 | 2 | a | Big mouse in Foshan avenges family that tried to kill him. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 525 | 525 | 1898-08-17 | 2 | a-b | Old man in Melbourne dies of gas poisoning. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 526 | 526 | 1898-08-17 | 2 | b | Chinese shop owner in Perth seriously injured after refusing to lend money to friends. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 527 | 527 | 1898-08-17 | 2 | b-c | Man from the north and working in Zengcheng tries to marry through deception. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 528 | 528 | 1898-08-17 | 2 | c | Old man in Maitland passes away leaving big family. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 529 | 529 | 1898-08-17 | 2 | c | International realtions and diplomacy: British trade representatives in China; Germany says Britain should not be allowed to build railway in Shandong; British Ambassador in discussion with Chinese government. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 530 | 530 | 1898-08-17 | 2 | c-d | Skilful doctor in Sydney, Tang Xijian, from Baishawan in Xiangshan, cures many patients. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 531 | 531 | 1898-08-17 | 2 | d | Crime, young man fined for picking woman's pocket. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 532 | 532 | 1898-08-17 | 2 | d | Man hurt after fall from bicycle. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 533 | 533 | 1898-08-17 | 2 | d-e | Crime, jewellery shop in Perth robbed. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 534 | 534 | 1898-08-17 | 2 | e | Woman in Zhangzhou, Fujian province, gives birth to teratism. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 535 | 535 | 1898-08-17 | 2 | e-f | Westerner lost after looking for job. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 536 | 536 | 1898-08-17 | 2 | f | Chinese man in Perth kills friend for money. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 537 | 537 | 1898-08-17 | 2 | f | Japan plans to build more technical schools. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 | ||
| 538 | 538 | 1898-08-17 | 2 | f | Population statistics from Europe. | http://trove.nla.gov.au/newspaper/page/24102099 | 24102099 |
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]);