This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2249 | 2249 | 1899-04-19 | 2 | a-b | A memorial report submitted by Liao Shoufeng, Governor of Zhejiang. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2250 | 2250 | 1899-04-19 | 2 | b | A memorial report submitted by Qin Chunxuan, former Governor of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2251 | 2251 | 1899-04-19 | 2 | c | Lu Chuanlin, new Governor of Guangdong, strengthens the bureaucracy, puts foward ten requirements. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2252 | 2252 | 1899-04-19 | 2 | c-d | Britain sends representative to Samoa; Germany refuses proposals put forward by USA and Britain; USA sends representative to Samoa; USA, Britain and Germany should work together to settle Samoa issues; new governor elected in Samoa; number of soldiers from USA, Germany and Britain; more negotiations between Germany and Britain on Samoa issues; New Zealand selects more volunteers for Samoa; New Zealand loffers to provide help on Samoa issues. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2253 | 2253 | 1899-04-19 | 2 | e | Cost of war; number of casualties; recent clashes between US troops and local forces. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2254 | 2254 | 1899-04-19 | 2 | e | German revenged in Shandong by using landmines; forced by Russia, China has changed its mind on the bidding of Hankou-Guangzhou railway; France and Belgium were given such a privilege due to their loans to China; Queen of Britain is back home after tour France. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2255 | 2255 | 1899-04-19 | 2 | f | Fruits from Hobart allowed to land in Sydney port. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2256 | 2256 | 1899-04-19 | 2 | f | The price of tin is going up in London. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2257 | 2257 | 1899-04-19 | 2 | f | An Italian scientist tries to promote radio in Africa. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
| 2258 | 2258 | 1899-04-19 | 2 | f | Magistrate of Panyu encourages cultivation of wasteland. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 |
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]);