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 |
|---|---|---|---|---|---|---|---|---|---|
| 1872 | 1872 | 1899-03-01 | 3 | j | Fire in Sydney possibly caused by a snake. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1873 | 1873 | 1899-03-01 | 3 | j | Trade in East Asia, especially the Philippines, will increase sharply in the near future due to its geographic position. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1874 | 1874 | 1899-03-01 | 3 | j | Wine school to be established in London. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1875 | 1875 | 1899-03-01 | 3 | j | New island has found in Indian Ocean. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1876 | 1876 | 1899-03-01 | 3 | j | Native tribes in Morocco slaughter each other. | http://trove.nla.gov.au/newspaper/page/24102309 | 24102309 | ||
| 1899 | 1899 | 1899-03-04 | 3 | j | Empress Dowager and local residents reject Russia's plans to collect was tax in Dalian, northeastern China. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1900 | 1900 | 1899-03-04 | 3 | j | China appoints government official to take charge of building of railway. Plans refused by Britain. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1901 | 1901 | 1899-03-04 | 3 | j | Rung Lu trains special army in south Beijing. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1924 | 1924 | 1899-03-08 | 3 | j | US soldiers and local residents in Luzon fight each other. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
| 1925 | 1925 | 1899-03-08 | 3 | j | Bandits capture Changle county in Jiangxi province. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
| 1945 | 1945 | 1899-03-11 | 3 | j | Fire in Guangzhou and Foshan. | http://trove.nla.gov.au/newspaper/page/24102321 | 24102321 | ||
| 1946 | 1946 | 1899-03-11 | 3 | j | Two people in Guangzhou arrested for consorting with Kang Youwei. | http://trove.nla.gov.au/newspaper/page/24102321 | 24102321 | ||
| 1971 | 1971 | 1899-03-15 | 3 | j | Thieves rob business in Xiangshan, take money meant to pay worker's salary. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1972 | 1972 | 1899-03-15 | 3 | j | A hen in Foshan changes into a cock. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 2023 | 2023 | 1899-03-22 | 3 | j | Britain and Germany forge closer ties. | http://trove.nla.gov.au/newspaper/page/24102333 | 24102333 | ||
| 2024 | 2024 | 1899-03-22 | 3 | j | Jiangsu province cancels traditional parade for candidates who passed imperial examinations. | http://trove.nla.gov.au/newspaper/page/24102333 | 24102333 | ||
| 2036 | 2036 | 1899-03-25 | 2 | j | Two trains collided in Victoria, one passenger dies in accident. | http://trove.nla.gov.au/newspaper/page/24102338 | 24102338 | ||
| 2056 | 2056 | 1899-03-25 | 3 | j | An American scientist has found that Saturn has nine moons. | http://trove.nla.gov.au/newspaper/page/24102337 | 24102337 | ||
| 2057 | 2057 | 1899-03-25 | 3 | j | Deputy commander of the Philippines army executed by the general commander. | http://trove.nla.gov.au/newspaper/page/24102337 | 24102337 | ||
| 2058 | 2058 | 1899-03-25 | 3 | j | Britain prepares to withdraw troops from Beijing; British ambassador advises Zongli Yamen to allocate land in Yangtze area to Belgium; Italian government demands an answer from Zongli Yamen about their request for land in Fujian; British Foreign Secretary advised his government to be careful when dealing with China; new Governor of NSW discusses plans; heavy snow in north Ireland; the new Governor of NSW is on the way. | http://trove.nla.gov.au/newspaper/page/24102337 | 24102337 | ||
| 2066 | 2066 | 1899-03-29 | 2 | j | Story of the new governor of New South Wales. | http://trove.nla.gov.au/newspaper/page/24102342 | 24102342 | ||
| 2079 | 2079 | 1899-03-29 | 3 | j | Casualties of epidemic in Britain. | http://trove.nla.gov.au/newspaper/page/24102341 | 24102341 | ||
| 2098 | 2098 | 1899-04-01 | 2 | j | Chinese man in NSW, Guang Chang, succesfully sues a White man, recieves compensation. | http://trove.nla.gov.au/newspaper/page/24102346 | 24102346 | ||
| 2116 | 2116 | 1899-04-01 | 3 | j | The new library in London. | http://trove.nla.gov.au/newspaper/page/24102345 | 24102345 | ||
| 2117 | 2117 | 1899-04-01 | 3 | j | Travellers in Zengcheng robbed by bandits. | http://trove.nla.gov.au/newspaper/page/24102345 | 24102345 | ||
| 2150 | 2150 | 1899-04-05 | 3 | j | Melbourne man killed in Nanyang. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2151 | 2151 | 1899-04-05 | 3 | j | A new style of bicycle in China. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2152 | 2152 | 1899-04-05 | 3 | j | Big celebration party in Sydney. | http://trove.nla.gov.au/newspaper/page/24102349 | 24102349 | ||
| 2166 | 2166 | 1899-04-08 | 2 | j | Man in Lismore, New South Wales, killed by his own carriage. | http://trove.nla.gov.au/newspaper/page/24102354 | 24102354 | ||
| 2167 | 2167 | 1899-04-08 | 2 | j | War news from Luzon, the Philippines. | http://trove.nla.gov.au/newspaper/page/24102354 | 24102354 | ||
| 2183 | 2183 | 1899-04-08 | 3 | j | Zhong Jingren, magistrate of Zhaoqing, Yanchun and Boluo, works hard for his people. | http://trove.nla.gov.au/newspaper/page/24102353 | 24102353 | ||
| 2184 | 2184 | 1899-04-08 | 3 | j | The Prime Minister of Spain boasts about Spain's military strength in Luzon. | 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]);