This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2283 | 2283 | 1899-04-22 | 2 | a | Report submitted by Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2284 | 2284 | 1899-04-22 | 2 | a-b | Report submitted by Hu Pin, governor of Shanxi. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2285 | 2285 | 1899-04-22 | 2 | b-c | Report submitted by Yu Chengge, imperial inspector of Shandong. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2286 | 2286 | 1899-04-22 | 2 | c-d | Ten proposals that Lu Chuanlin, governor of Guangdong, put forward to strengthen region. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2287 | 2287 | 1899-04-22 | 2 | d | Two girls robbed in Sydney. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2288 | 2288 | 1899-04-22 | 2 | d | Chinese envoy Xu Shoupeng, when meeting the King of Korea, found the traditional royal attire has been discarded in favour of new dress. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2289 | 2289 | 1899-04-22 | 2 | d-e | The story of a penniless family in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2290 | 2290 | 1899-04-22 | 2 | e-f | Chinese resist British occupation, attack British army; British military officer and his wife attacked by Chinese. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2291 | 2291 | 1899-04-22 | 2 | f | Two men travel from Albury to Melbourne by bicycle. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2292 | 2292 | 1899-04-22 | 2 | f | Germany has not appointed representative for Samoa; New Zealand has repeatedly requested to send troops; Germany considers agreement; US sends gunboat; German Foreign Minister discusees Samoa issue in Parliament; responses from USA. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2293 | 2293 | 1899-04-22 | 2 | f | The chief military officer of Hunan was attacked on the way to his office. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 | ||
| 2294 | 2294 | 1899-04-22 | 2 | f | The price Victorian wheat is selling for in London. | http://trove.nla.gov.au/newspaper/page/24102372 | 24102372 |
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]);