This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4171 | 4171 | 1899-12-02 | 3 | a | The wife of British Prime Minister passed away. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4172 | 4172 | 1899-12-02 | 3 | a | America recommends Britain increase the power of its navy by building more warships. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4173 | 4173 | 1899-12-02 | 3 | a | French media attacks Britain and the Queen. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4174 | 4174 | 1899-12-02 | 3 | a-b | A birthday present that Xu Yingkui, Governor of Zhejiang and Fujian provinces, received from his subordinate. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4175 | 4175 | 1899-12-02 | 3 | c | Li Hongzhang resumed his position in charge of foreign business; the railway project from Niuzhuang to Dalian has been completed. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4176 | 4176 | 1899-12-02 | 3 | c | A Tattslotto winner in Perth. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4177 | 4177 | 1899-12-02 | 3 | c-d | Liu Huangxue, a native of Xingning county, Guangdong province, is returning home. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4178 | 4178 | 1899-12-02 | 3 | d | A women's society in America with a purpose to subdue men. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4179 | 4179 | 1899-12-02 | 3 | e | Two bodies, one boy and one girl, were found in a river near Brisbane. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4180 | 4180 | 1899-12-02 | 3 | e | An earthquake in Victoria. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4181 | 4181 | 1899-12-02 | 3 | e | America to give hero's wlecome to General returning from the Philippines. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4182 | 4182 | 1899-12-02 | 3 | e | Russia considers building a city near Lushun in China. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 | ||
| 4183 | 4183 | 1899-12-02 | 3 | f | Chinese government awards compensation in the missionary case in Sichuan province. | http://trove.nla.gov.au/newspaper/page/24102623 | 24102623 |
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]);