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 |
|---|---|---|---|---|---|---|---|---|---|
| 392 | 392 | 1898-08-06 | 4 | a-b | Story of landlord in Nanhai, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102085 | 24102085 | ||
| 393 | 393 | 1898-08-06 | 4 | b | Sydney man arrested for smuggling cigars. | http://trove.nla.gov.au/newspaper/page/24102085 | 24102085 | ||
| 394 | 394 | 1898-08-06 | 4 | b | Multiple sightings of ghost in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102085 | 24102085 | ||
| 395 | 395 | 1898-08-06 | 4 | c-d | Guangdong Governor invites Liu Yongfu, leader of famous Black Flag rebellion in Guangxi, to discuss plans for dealing with foreigners (with photograph of Liu Yongfu). | http://trove.nla.gov.au/newspaper/page/24102085 | 24102085 | ||
| 396 | 396 | 1898-08-06 | 4 | d | War, Philippines. USA and Luzon negotiate for peace. | http://trove.nla.gov.au/newspaper/page/24102085 | 24102085 | ||
| 397 | 397 | 1898-08-06 | 4 | e | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102085 | 24102085 | ||
| 398 | 398 | 1898-08-06 | 3 | a | Magic powder discovered, may help win wars. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 399 | 399 | 1898-08-06 | 3 | a | Man in New Town, Tasmania, charged for throwing stone at shop. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 400 | 400 | 1898-08-06 | 3 | a-b | Escaped criminal caught again. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 401 | 401 | 1898-08-06 | 3 | b | Drama performed in Gibbs St, Sydney, July 12. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 402 | 402 | 1898-08-06 | 3 | b-c | Crime. Female thief caught in Heshan while trying to sell stolen goods. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 403 | 403 | 1898-08-06 | 3 | c | Victoria. Rich man donates most of his money to charity and employees before dying. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 404 | 404 | 1898-08-06 | 3 | c | Boy in Newtown, NSW, charged for throwing bag of flour at MP. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 405 | 405 | 1898-08-06 | 3 | c-d | Sydney, boy killed by carriage. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 406 | 406 | 1898-08-06 | 3 | d | Crime, three men in Launceston, Tasmania, charged with gambiling illegally. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 407 | 407 | 1898-08-06 | 3 | d-e | Illegal prostitute detained in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 408 | 408 | 1898-08-06 | 3 | e | Name list of people from east Guangdong who passed Imperial Examination. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 409 | 409 | 1898-08-06 | 3 | e-d | Woman arsonist, Adelaide. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 410 | 410 | 1898-08-06 | 3 | f | Woman seriously injured as carriage brake breaks. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 411 | 411 | 1898-08-06 | 3-2 | f-a | Statistics on Japan's geography, population, etc. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 412 | 412 | 1898-08-06 | 2 | a | Skiing competition held in NSW . | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 413 | 413 | 1898-08-06 | 2 | a-b | Rebels in Guangxi have occupied towns. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 414 | 414 | 1898-08-06 | 2 | b | Fortune-teller admits to tricking patrons. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 415 | 415 | 1898-08-06 | 2 | b-c | Thieves seek revenge in Foshan. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 416 | 416 | 1898-08-06 | 2 | c | Woman in Melbourne charged for blocking traffic. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 417 | 417 | 1898-08-06 | 2 | c | Some die and more than one hundred patients hospitalised due to disease epidemic. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 418 | 418 | 1898-08-06 | 2 | c | Some dies and over one hundred patients hospitablised due to disease epidemic. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 419 | 419 | 1898-08-06 | 2 | c-d | Man has dinner with ghost of dead friend. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 420 | 420 | 1898-08-06 | 2 | d | Japan compensated for Honolulu's former policy of refusing entry to Japanese citizens. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 421 | 421 | 1898-08-06 | 2 | d | Honolulu is now a part of USA; immigration regulations, government in Queensland notifies Japanese government of new regulations on entry of Japanese citizens. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 422 | 422 | 1898-08-06 | 2 | d-e | Slow-witted man from Guangning gets in trouble in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 423 | 423 | 1898-08-06 | 2 | e | Chinese man in Sydney fined 3 pounds for drunkeness. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 424 | 424 | 1898-08-06 | 2 | e-f | Times in London publishes articles on trade relations between China and Britain. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 | ||
| 425 | 425 | 1898-08-06 | 2 | f | Bismarck died last Saturday at 84 years of age. | http://trove.nla.gov.au/newspaper/page/24102087 | 24102087 |
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]);