This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3111 | 3111 | 1899-07-19 | 3 | e | Foreign settlements in China, future development of the settlements. | http://trove.nla.gov.au/newspaper/page/24102471 | 24102471 | ||
| 3112 | 3112 | 1899-07-19 | 3 | e | Epidemic and casualties in Gaoyao county, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102471 | 24102471 | ||
| 3113 | 3113 | 1899-07-19 | 3 | e | A White girl was seriously injured by her Chinese boyfriend. | http://trove.nla.gov.au/newspaper/page/24102471 | 24102471 | ||
| 3114 | 3114 | 1899-07-19 | 3 | e | Top ten criminals in Xiangshan county, Guangdong: Li Mianqun, Zhao Chenlan, Mao Wangheng, Li Minglin, Zheng Dianhuang, Feng Mianying, Yang Jingyu, Lin Songling, He Jinji, and Liu Shiyu. | http://trove.nla.gov.au/newspaper/page/24102471 | 24102471 | ||
| 3115 | 3115 | 1899-07-19 | 3 | e | Epidemic disease in Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102471 | 24102471 |
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]);