This data as json, CSV (advanced)
date (date) 7 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1942 | 1942 | 1899-03-11 | 3 | h-i | Civil corps have been well trained in Xiangshan to help maintain order. | http://trove.nla.gov.au/newspaper/page/24102321 | 24102321 | ||
1968 | 1968 | 1899-03-15 | 3 | h-i | Hundreds of people in danger due to strong winds near Brisbane. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
1982 | 1982 | 1899-03-18 | 2 | h-i | A report submitted by Governor of Guangdong and Guangxi regarding the promotion of Chen Liangjie. | http://trove.nla.gov.au/newspaper/page/24102330 | 24102330 | ||
2003 | 2003 | 1899-03-18 | 3 | h-i | Britain changes attitude towards Italy's demand for settlement in China; Italian ambassador to Beijing requests answer from Zongli Yamen; Italy recalls its ambassador from China, entrusting British ambassador to negotiate with Chinese government on their behalf; Italy moves ambassador from Japan to Beijing; Britain takes island near Shandong. | http://trove.nla.gov.au/newspaper/page/24102329 | 24102329 | ||
2034 | 2034 | 1899-03-25 | 2 | h-i | Imperial response to reports submitted by Qin Chunxuan, former Governor of Guangdong, and Huang Huaisen, a minister. | http://trove.nla.gov.au/newspaper/page/24102338 | 24102338 | ||
2064 | 2064 | 1899-03-29 | 2 | h-i | France seeks land allocations from China and other Asian countries. | http://trove.nla.gov.au/newspaper/page/24102342 | 24102342 | ||
2113 | 2113 | 1899-04-01 | 3 | h-i | Chinese society is to be established in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102345 | 24102345 | ||
2127 | 2127 | 1899-04-05 | 2 | h-i | Tsar of Russia suggested an international peace conference and got positive response from Britain. | http://trove.nla.gov.au/newspaper/page/24102350 | 24102350 |
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]);