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 |
|---|---|---|---|---|---|---|---|---|---|
| 1869 | 1869 | 1899-03-01 | 3 | i | Man in Sydney in custody for robbery. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1870 | 1870 | 1899-03-01 | 3 | i | California in the US issues new regulations governing gold mining. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1912 | 1912 | 1899-03-08 | 2 | i | Restrictions placed on the exporting of daily necessities from China. | http://trove.nla.gov.au/newspaper/page/24102318 | 24102318 | ||
| 1923 | 1923 | 1899-03-08 | 3 | i | Missionaries in Zengcheng fail to mediate family disputes. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
| 1943 | 1943 | 1899-03-11 | 3 | i | Price of grain in Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102321 | 24102321 | ||
| 1944 | 1944 | 1899-03-11 | 3 | i | Twenty-one Chinese required to pay poll tax before landing in Tasmania. | http://trove.nla.gov.au/newspaper/page/24102321 | 24102321 | ||
| 1969 | 1969 | 1899-03-15 | 3 | i | Dockers in Fremantle strike, demand pay rise. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1983 | 1983 | 1899-03-18 | 2 | i | Britain has one of the strongest armies in the world. | http://trove.nla.gov.au/newspaper/page/24102330 | 24102330 | ||
| 2022 | 2022 | 1899-03-22 | 3 | i | Black American versus White American in martial arts contest in the USA. | http://trove.nla.gov.au/newspaper/page/24102333 | 24102333 | ||
| 2035 | 2035 | 1899-03-25 | 2 | i | Imperial edict for grain relief in the famine area of Hebei province. | http://trove.nla.gov.au/newspaper/page/24102338 | 24102338 | ||
| 2053 | 2053 | 1899-03-25 | 3 | i | The Lu family in Zengcheng and the Yuan family in Dongguan clash again. | http://trove.nla.gov.au/newspaper/page/24102337 | 24102337 | ||
| 2054 | 2054 | 1899-03-25 | 3 | i | The Queen of Luzon approves of the peace agreement with the US. | http://trove.nla.gov.au/newspaper/page/24102337 | 24102337 | ||
| 2055 | 2055 | 1899-03-25 | 3 | i | Spanish monks in the Philippines were murdered, some detained. | http://trove.nla.gov.au/newspaper/page/24102337 | 24102337 | ||
| 2065 | 2065 | 1899-03-29 | 2 | i | An earthquake in New South Wales. | http://trove.nla.gov.au/newspaper/page/24102342 | 24102342 | ||
| 2095 | 2095 | 1899-04-01 | 2 | i | Aboriginal man executed secretly by several White men. | http://trove.nla.gov.au/newspaper/page/24102346 | 24102346 | ||
| 2096 | 2096 | 1899-04-01 | 2 | i | Britain and Russia reconcile over their disputes in China. | http://trove.nla.gov.au/newspaper/page/24102346 | 24102346 | ||
| 2097 | 2097 | 1899-04-01 | 2 | i | A French man and a Russian man duelled over a minor dispute. | http://trove.nla.gov.au/newspaper/page/24102346 | 24102346 | ||
| 2099 | 2099 | 1899-04-01 | 2 | i | Several people die as cold weather strikes in London. | http://trove.nla.gov.au/newspaper/page/24102346 | 24102346 | ||
| 2114 | 2114 | 1899-04-01 | 3 | i | A snakes method of protecting its babies. | http://trove.nla.gov.au/newspaper/page/24102345 | 24102345 | ||
| 2115 | 2115 | 1899-04-01 | 3 | i | Storm and heavy rain in Adelaide, two men die in lightning strike. | http://trove.nla.gov.au/newspaper/page/24102345 | 24102345 | ||
| 2128 | 2128 | 1899-04-05 | 2 | i | New politics in Guangdong following the arrival of new governor, Lu Chuanlin, such as baojia system, census, bandit issue, etc. | http://trove.nla.gov.au/newspaper/page/24102350 | 24102350 | ||
| 2147 | 2147 | 1899-04-05 | 3 | i | A kind of fast sledge in north America. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2148 | 2148 | 1899-04-05 | 3 | i | A golf match in London. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2149 | 2149 | 1899-04-05 | 3 | i | British man pays huge tax bill. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2164 | 2164 | 1899-04-08 | 2 | i | Ship from London sinks, together with its 80 crew. | http://trove.nla.gov.au/newspaper/page/24102354 | 24102354 | ||
| 2181 | 2181 | 1899-04-08 | 3 | i | It is possible that an extra imperial examination will be held this year. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 | ||
| 2182 | 2182 | 1899-04-08 | 3 | i | Mr Macartney awarded for his contribution the Qing dynasty | 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]);