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 |
|---|---|---|---|---|---|---|---|---|---|
| 4275 | 4275 | 1899-12-20 | 2 | a-b | An essay on the theory suggesting China ally with the rest of Asia in order to resist Europe. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4276 | 4276 | 1899-12-20 | 2 | b-c | Report about the transfer of Fuzhou concession into Japanese control. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4277 | 4277 | 1899-12-20 | 2 | c-d | Boer war, South Africa. Reports on the war between Britain and Transvaal. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4278 | 4278 | 1899-12-20 | 2 | d | An article commenting the current situation in east Asia. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4279 | 4279 | 1899-12-20 | 2 | d-e | An essay on the punishment and rewards. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4280 | 4280 | 1899-12-20 | 2 | e | Hu Ruan, a famous bandit in Shunde county, Guangdong, is now in custody. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4281 | 4281 | 1899-12-20 | 2 | e | The Emperor looks healthy and happy. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4282 | 4282 | 1899-12-20 | 2 | e | Chinese military commanders in Zhejiang take precautions against Italy. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4283 | 4283 | 1899-12-20 | 2 | e-f | A man in Melbourne makes waterproof clothes. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4284 | 4284 | 1899-12-20 | 2 | f | Bird fossils discovered in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4285 | 4285 | 1899-12-20 | 2 | f | The leap August on the lunar calendar will still be valid next year despite the bad omen it represents. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4286 | 4286 | 1899-12-20 | 2 | f | Rong Lu instructed Yuan Shikai to recruit more soldiers. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4287 | 4287 | 1899-12-20 | 2 | f | Four military commanders were summoned to Beijing. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4288 | 4288 | 1899-12-20 | 2 | f | The life of Huang Gongdu, former Chinese ambassador to Singapore and Japan, leads a casual life after being removed from the court. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4289 | 4289 | 1899-12-20 | 2 | f | New tax offices have been set up in Kowloon following the entry of British. | http://trove.nla.gov.au/newspaper/page/24102645 | 24102645 | ||
| 4290 | 4290 | 1899-12-20 | 3 | a | Germany will build more gunboats. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4291 | 4291 | 1899-12-20 | 3 | a | America has purchased a vast amount of land from Russia. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4292 | 4292 | 1899-12-20 | 3 | a | Germany removes all foreign ambassador's assistants. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4293 | 4293 | 1899-12-20 | 3 | a | A British minister said European countries have a plot against Britain. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4294 | 4294 | 1899-12-20 | 3 | a | Leader of the Democrats in America calls for an independent Philippines. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4295 | 4295 | 1899-12-20 | 3 | a | A shop on Gibbs St, Sydney, is a good place for shopping. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4296 | 4296 | 1899-12-20 | 3 | a | International relations and diplomacy, German Foreign Minister talks about their foreign relations. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4297 | 4297 | 1899-12-20 | 3 | a | American troops will release all prisoners they captured during the war. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4298 | 4298 | 1899-12-20 | 3 | a | Italy asks for Tangshan, Hebei province, from the Chinese government. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4299 | 4299 | 1899-12-20 | 3 | a | Yuan Shikai was summoned to the court and consulted. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4300 | 4300 | 1899-12-20 | 3 | b | Tap water will be available soon in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4301 | 4301 | 1899-12-20 | 3 | b-d | Boer war, South Africa, reports on the war between Britain and Transvaal. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4302 | 4302 | 1899-12-20 | 3 | d | Serious drought in Fuzhou, Fujian province. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4303 | 4303 | 1899-12-20 | 3 | d | Rain has fallen for many days in Shaoxing, Zhejiang province. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 | ||
| 4304 | 4304 | 1899-12-20 | 3 | d | Empress Dowager tries to get information about Western learning. | http://trove.nla.gov.au/newspaper/page/24102644 | 24102644 |
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]);