This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2971 | 2971 | 1899-07-05 | 3 | a | Chinese in Melbourne donate to local hospitals. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2972 | 2972 | 1899-07-05 | 3 | a | A Chinese grocery shop in Sydney was robbed. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2973 | 2973 | 1899-07-05 | 3 | a | A Chinese gardener robbed in Sydney. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2974 | 2974 | 1899-07-05 | 3 | a | Wong Tonghe never talks about politics after retirement. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2975 | 2975 | 1899-07-05 | 3 | a | Robbery in Taishan county, Guangdong province. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2976 | 2976 | 1899-07-05 | 3 | b | Missionary tragedy in Jianning county, Fujian province. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2977 | 2977 | 1899-07-05 | 3 | b | Hundreds of British people gather in Cape Town; Empress of Russia gives birth to a princess; Russia's opinion on the international peace conference; Russia purchases weapons and gunboats from USA; Britain sends troops to South Africa. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2978 | 2978 | 1899-07-05 | 3 | b | A furniture shop in Guangzhou sues brothers for refusing to return furniture they borrowed. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2979 | 2979 | 1899-07-05 | 3 | b | Two family clans, Chen and Jian, fight each other in Zengcheng. Clash was followed by a long lawsuit. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2980 | 2980 | 1899-07-05 | 3 | c | Britain is ready to fight in Transvaal. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2981 | 2981 | 1899-07-05 | 3 | c | A hot-air balloon in London | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2982 | 2982 | 1899-07-05 | 3 | c | Ms Liu Keqing, principal of a Shanghai church school, donates her paintings to famine area in Shandong. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2983 | 2983 | 1899-07-05 | 3 | d | A maidservant in Zengcheng falls pregnant. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2984 | 2984 | 1899-07-05 | 3 | d | Portuguese in Macao and the development. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2985 | 2985 | 1899-07-05 | 3 | d | A man in Warrnambool, Victoria, dies at the age of 101. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2986 | 2986 | 1899-07-05 | 3 | d | More than 50,000 workers lose their jobs as the factory closes down in St Petersburg. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2987 | 2987 | 1899-07-05 | 3 | d | Japan reforms its custom. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2988 | 2988 | 1899-07-05 | 3 | e | News from Hong Kong and its New Territory. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2989 | 2989 | 1899-07-05 | 3 | e | A bright road in France. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2990 | 2990 | 1899-07-05 | 3 | e | A skillfull doctor in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2991 | 2991 | 1899-07-05 | 3 | f | A study on human food, digestion, and breathing. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2992 | 2992 | 1899-07-05 | 3 | f | A private school in Foshan was struck by lightning in recent storm. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2993 | 2993 | 1899-07-05 | 3 | f | Tea business in Hunan this year is prosperous. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 | ||
| 2994 | 2994 | 1899-07-05 | 3 | f | A New Castle witness collapse in a faint while giving evidence in court. | http://trove.nla.gov.au/newspaper/page/24102455 | 24102455 |
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]);