This data as json, CSV (advanced)
Suggested facets: date, page, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 1864 | 1864 | 1899-03-01 | 2 | l | The reasons for removing Zeng Guofan, Governor of Hubei. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1879 | 1879 | 1899-03-01 | 3 | l | Man in Canada finds new method to cut precious stone. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1905 | 1905 | 1899-03-04 | 3 | l | Volcano eruptes suddenly in Japan. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1928 | 1928 | 1899-03-08 | 3 | l | Man in Guangzhou married one woman while wooing another woman at the same time. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
| 1929 | 1929 | 1899-03-08 | 3 | l | Man in Guangzhou returns from overseas and manufactures paper from reed catkins. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
| 1930 | 1930 | 1899-03-08 | 3 | l | Wang Cunshan embezzled likin (opium tax) income of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
| 1931 | 1931 | 1899-03-08 | 3 | l | Zhang Yinyuan crosses the border, goes outside China. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
| 1949 | 1949 | 1899-03-11 | 3 | l | Nice weather in Guangzhou leads to predictions that province will experience bountiful harvest this year. | http://trove.nla.gov.au/newspaper/page/24102321 | 24102321 | ||
| 1956 | 1956 | 1899-03-15 | 2 | l | Crime, court case, man in Sydney penalised for horse abuse. | http://trove.nla.gov.au/newspaper/page/24102326 | 24102326 | ||
| 1975 | 1975 | 1899-03-15 | 3 | l | Bandits in Xinhui rob passenger boat. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1976 | 1976 | 1899-03-15 | 3 | l | Nanhai, Panyu and Shunde plan reforms to stop bad habits of locals. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1987 | 1987 | 1899-03-18 | 2 | l | Traffic accident in New Zealand claims five lives. | http://trove.nla.gov.au/newspaper/page/24102330 | 24102330 | ||
| 2013 | 2013 | 1899-03-22 | 2 | l | Fire in Xiangshan during the Spring Festival. | http://trove.nla.gov.au/newspaper/page/24102334 | 24102334 | ||
| 2028 | 2028 | 1899-03-22 | 3 | l | Switzerland has exculded Russia from the coming international peace conference. | http://trove.nla.gov.au/newspaper/page/24102333 | 24102333 | ||
| 2029 | 2029 | 1899-03-22 | 3 | l | Tan Zhonglin, the Governor of Guangdong, prays for rain. | http://trove.nla.gov.au/newspaper/page/24102333 | 24102333 | ||
| 2030 | 2030 | 1899-03-22 | 3 | l | The price of gold in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102333 | 24102333 | ||
| 2059 | 2059 | 1899-03-25 | 3 | l | Coal resources found in southern Sichuan. | http://trove.nla.gov.au/newspaper/page/24102337 | 24102337 | ||
| 2070 | 2070 | 1899-03-29 | 2 | l | US woman guilty of murder, soon to be executed in electric chair. | http://trove.nla.gov.au/newspaper/page/24102342 | 24102342 | ||
| 2085 | 2085 | 1899-03-29 | 3 | l | A famous missionary in Britain passed away. | http://trove.nla.gov.au/newspaper/page/24102341 | 24102341 | ||
| 2086 | 2086 | 1899-03-29 | 3 | l | Eighteen Chinese were required to pay tax before landing in Tasmania. | http://trove.nla.gov.au/newspaper/page/24102341 | 24102341 | ||
| 2087 | 2087 | 1899-03-29 | 3 | l | Price of silver in London. | http://trove.nla.gov.au/newspaper/page/24102341 | 24102341 | ||
| 2088 | 2088 | 1899-03-29 | 3 | l | The price of gold in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102341 | 24102341 | ||
| 2102 | 2102 | 1899-04-01 | 2 | l | Guangdong government attempts to stop likin (opium tax) evasion. | http://trove.nla.gov.au/newspaper/page/24102346 | 24102346 | ||
| 2120 | 2120 | 1899-04-01 | 3 | l | A Russian newspaper comments on it relations with and policy towards Britain | http://trove.nla.gov.au/newspaper/page/24102345 | 24102345 | ||
| 2154 | 2154 | 1899-04-05 | 3 | l | China stops negotiating with Italy on issue of Sanmen Bay, new ambassador yet to arrive in Beijing. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2155 | 2155 | 1899-04-05 | 3 | l | Man in Belgium detained in France for spying. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2156 | 2156 | 1899-04-05 | 3 | l | Casualties of war between US and Spain in Luzon. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2157 | 2157 | 1899-04-05 | 3 | l | A bridge under construction in Tasmania collapses. Four workers killed in accident. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2158 | 2158 | 1899-04-05 | 3 | l | Britain prepares new budget for this year. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2170 | 2170 | 1899-04-08 | 2 | l | Famine refugees from Xuzhou area, northern Jiangsu, had to sell their children. | http://trove.nla.gov.au/newspaper/page/24102354 | 24102354 | ||
| 2188 | 2188 | 1899-04-08 | 3 | l | The bank of Yellow River has been piled up. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 | ||
| 2189 | 2189 | 1899-04-08 | 3 | l | Casino in New South Wales has enough rain a few days ago. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 | ||
| 2190 | 2190 | 1899-04-08 | 3 | l | The smallest country in the world. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 | ||
| 2191 | 2191 | 1899-04-08 | 3 | l | Wellington of New Zealand refuses to take the fruits from Sydney. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 | ||
| 2192 | 2192 | 1899-04-08 | 3 | l | Russia manufactures advanced canons. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 | ||
| 2193 | 2193 | 1899-04-08 | 3 | l | Russia sends a minister to investigate the famine region. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 |
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]);