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 |
|---|---|---|---|---|---|---|---|---|---|
| 4325 | 4325 | 1899-12-30 | 2 | a-b | A brief biography, written by the editor Zheng Lu, of the Tsar of Russia. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4326 | 4326 | 1899-12-30 | 2 | b-c | A request has been put forward to the Empress Dowager asking her to retire and return power to the Emperor. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4327 | 4327 | 1899-12-30 | 2 | c-d | A letter from the Chinese Society for Federation Government to Hainan Society. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4328 | 4328 | 1899-12-30 | 2 | d-f | Boer war, South Africa. Reports about the war between Britain and Transvaal. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4329 | 4329 | 1899-12-30 | 2 | f | Drought damages crops in Queensland. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4330 | 4330 | 1899-12-30 | 2 | f | The price of silver in London. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4331 | 4331 | 1899-12-30 | 2 | f | The reasons behind riots in Samoa. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4332 | 4332 | 1899-12-30 | 2 | f | Tight security for Kang Youwei in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4333 | 4333 | 1899-12-30 | 2 | f | The capital of Russia introduces new regulations governing the sale of wine. | http://trove.nla.gov.au/newspaper/page/24102653 | 24102653 | ||
| 4334 | 4334 | 1899-12-30 | 3 | a | Recent developments in the situations in the Philippines. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4335 | 4335 | 1899-12-30 | 3 | a | Britain may boycott the international fair in Paris. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4336 | 4336 | 1899-12-30 | 3 | a | It is rumoured that Li Hongzhang will be the governor of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4337 | 4337 | 1899-12-30 | 3 | a | Heat wave sweeps across Victoria. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4338 | 4338 | 1899-12-30 | 3 | a | The custom of kidnapping brides in Hunan province. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4339 | 4339 | 1899-12-30 | 3 | a | A man in India was kicked and injured by a peacock. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4340 | 4340 | 1899-12-30 | 3 | b | Greetings from a reader to Kang Youwei. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4341 | 4341 | 1899-12-30 | 3 | b | Bandits in Panyu county, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4342 | 4342 | 1899-12-30 | 3 | b-d | South Africa, more reports on the war between Britain and Transvaal. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4343 | 4343 | 1899-12-30 | 3 | d | Four girls were drowned in Sydney during the Christmas holiday. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4344 | 4344 | 1899-12-30 | 3 | d | Counterfeit bank notes have been found in Sydney. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4345 | 4345 | 1899-12-30 | 3 | d | A magistrate in Zhejiang province was executed for embezzlement. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4346 | 4346 | 1899-12-30 | 3 | d | Mail from China awaits collection. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 |
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]);