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 |
|---|---|---|---|---|---|---|---|---|---|
| 2956 | 2956 | 1899-07-05 | 2 | a | Imperial edicts on local affairs in Jiangxi, Hubei, Guangxi and Yunnan. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2957 | 2957 | 1899-07-05 | 2 | a-b | Imperial edicts. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2958 | 2958 | 1899-07-05 | 2 | b-c | A report submitted by Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2959 | 2959 | 1899-07-05 | 2 | c | Another report submitted by Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2960 | 2960 | 1899-07-05 | 2 | c-e | An essay written by Shoushan Jushi on the cultivation of moral character. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2961 | 2961 | 1899-07-05 | 2 | e | Gold miners in Yunnan cause social chaos. French consulate office harassed over behaviour of French in Yunnan. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2962 | 2962 | 1899-07-05 | 2 | e | The Philippines increased its tax rates after the war with America. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2963 | 2963 | 1899-07-05 | 2 | e | Riots and demonstrations in Brussels. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2964 | 2964 | 1899-07-05 | 2 | e | A liner of Gibbs Bright & Co. stranded near Adelaide. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2965 | 2965 | 1899-07-05 | 2 | e-f | Zhaoqing organises a ceremony to greet God and to exorcise demons. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2966 | 2966 | 1899-07-05 | 2 | f | Young men in Goulburn register their names for a possible journey to Transvaal. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2967 | 2967 | 1899-07-05 | 2 | f | Two traffic accidents in Sydney. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2968 | 2968 | 1899-07-05 | 2 | f | Soldiers from the USA infected with diseases while in the Philippines. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2969 | 2969 | 1899-07-05 | 2 | f | A man in London purchases a horse at a very high price. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2970 | 2970 | 1899-07-05 | 2 | f | British Prime Minister wants to fight Transvaal. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 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 | ||
| 2995 | 2995 | 1899-07-05 | 4 | a | Serious drought in the colonies of Australia. | http://trove.nla.gov.au/newspaper/page/24102458 | 24102458 |
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]);