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 |
|---|---|---|---|---|---|---|---|---|---|
| 320 | 320 | 1898-07-30 | 3 | a | Second part of article written by Zhang Zhidong to encourage learning. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 321 | 321 | 1898-07-30 | 3 | b | Famine in eastern Guangdong has followed by banditry; ocean liner arrived in Sydney from Hong Kong; poor harvest in Zengcheng; robbery in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 322 | 322 | 1898-07-30 | 3 | b-c | Two parting poems for Mr Bao Chi who is going to Perth, Western Australia. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 323 | 323 | 1898-07-30 | 3 | c | Russia change attitude, allows China to have British officers train Chinese navy. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 324 | 324 | 1898-07-30 | 3 | c | Woman in Guangzhou arrested for harbouring stolen goods. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 325 | 325 | 1898-07-30 | 3 | c-d | Comments of Gong Qinwang, brother of His Imperial Majesty, on government officials before passing away. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 326 | 326 | 1898-07-30 | 3 | d | Woman in Adelaide died at 102. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 327 | 327 | 1898-07-30 | 3 | d-e | MP candidate in NSW humiliated during election campaign. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 328 | 328 | 1898-07-30 | 3 | e | Man in Toowoomba lost all vision suddenly. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 329 | 329 | 1898-07-30 | 3 | e | Britain will build 40 more gunboats this year. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 330 | 330 | 1898-07-30 | 3 | e-f | Poor girl in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 331 | 331 | 1898-07-30 | 3 | f | London, Prince recovering from broken leg. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 332 | 332 | 1898-07-30 | 3 | f | Ship sailing for New Castle sighted big fish in sea. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 333 | 333 | 1898-07-30 | 3-2 | f-a | Businessman in Sydney penalised for employing child labour. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 334 | 334 | 1898-07-30 | 2 | a | Business penalised for selling milk diluted with water. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 335 | 335 | 1898-07-30 | 2 | a | Two convicts fight in Parrammata Prison. One of them is undergoing a sentence of life imprisonment. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 336 | 336 | 1898-07-30 | 2 | a | Residents in small NSW town enjoy snowball fight after heavy snowfall. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 337 | 337 | 1898-07-30 | 2 | a | Rich Chinese man dies without apparent cause in rural NSW. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 338 | 338 | 1898-07-30 | 2 | a-b | Woman dies while undergoin operation in Yalligup, Western Australia. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 339 | 339 | 1898-07-30 | 2 | b | Four treacherous officials who stand at front of hero Yue Fei's grave will stink for ever. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 340 | 340 | 1898-07-30 | 2 | b-c | Old woman in South Australia dies after accident with her own fireplace. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 341 | 341 | 1898-07-30 | 2 | c | First installment of article on various usages of salt. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 342 | 342 | 1898-07-30 | 2 | d | War, Philippines, USA. News from American army. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 343 | 343 | 1898-07-30 | 2 | d-e | Poems written by Xie Xiujie for departure of Mr Bao Chi for Perth. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 344 | 344 | 1898-07-30 | 2 | e | Immigration. Customs officers in Adelaide write to colleagues in Melbourne decalring that entry of Asians should be banned. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 345 | 345 | 1898-07-30 | 2 | e-f | Statistics of railway transportation in New South Wales. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 346 | 346 | 1898-07-30 | 2 | f | Red snow fell in North America. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 347 | 347 | 1898-07-30 | 2 | f | Gold discoveries and minning reaped harvest for Western Australia. | http://trove.nla.gov.au/newspaper/page/24102079 | 24102079 | ||
| 348 | 348 | 1898-07-30 | 4 | a | Crime, NSW. Traveller robbed on way home. | http://trove.nla.gov.au/newspaper/page/24102077 | 24102077 | ||
| 349 | 349 | 1898-07-30 | 4 | a-b | Politics. New South Wales elects new MPs. | http://trove.nla.gov.au/newspaper/page/24102077 | 24102077 | ||
| 350 | 350 | 1898-07-30 | 4 | b | Rebels Black Flag in Guangxi say they will kill all officials. Membership has reached 40,000. | http://trove.nla.gov.au/newspaper/page/24102077 | 24102077 | ||
| 351 | 351 | 1898-07-30 | 4 | b-c | Britain takes advantages of China in name of protecting unification of China. | http://trove.nla.gov.au/newspaper/page/24102077 | 24102077 | ||
| 352 | 352 | 1898-07-30 | 4 | c | Timetables of ocean liners' arrival in Asian ports. | http://trove.nla.gov.au/newspaper/page/24102077 | 24102077 | ||
| 353 | 353 | 1898-07-30 | 4 | d | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102077 | 24102077 | ||
| 354 | 354 | 1898-07-30 | 4 | b-c-d | New Queen Victoria Street, after renovation, opens for business (with street photo). | http://trove.nla.gov.au/newspaper/page/24102077 | 24102077 |
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]);