This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 1851 | 1851 | 1899-03-01 | 2 | a-b-c-d | The ninth and final part of an essay on China's political reform. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1852 | 1852 | 1899-03-01 | 2 | d-e | Prostitute in Guangzhou is very considerate of the needs of her customers. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1853 | 1853 | 1899-03-01 | 2 | e | Guangdong under Qin Chunxuan stores grains to prevent famines. New governors should do the same. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1854 | 1854 | 1899-03-01 | 2 | e-f | Bandits in western Guangdong use guns purchased from overseas. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1855 | 1855 | 1899-03-01 | 2 | f | Price of silk higher than in past years. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1856 | 1856 | 1899-03-01 | 2 | f | Magistrate of Xinyi county, Guangdong province, prosecuted by Governor Qin Chunxuan. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1857 | 1857 | 1899-03-01 | 2 | f-g | Civil corps (tuan lian) organised in Guangdong. Necessary funding allocated. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1858 | 1858 | 1899-03-01 | 2 | g-h | Mr Zhao from Nanhai county punished for blocking Governor Qin Chunxuan's way. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1859 | 1859 | 1899-03-01 | 2 | h | Fighting between clans in Zengcheng claims a life. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1860 | 1860 | 1899-03-01 | 2 | h | Seven bandits caught pretending to be passengers in order to rob passenger ship. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1861 | 1861 | 1899-03-01 | 2 | h-i-j | Letter written by Qin Chunxuan, outgoing governor of Guangdong, to magistrates of counties and prefectures. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1862 | 1862 | 1899-03-01 | 2 | j-k | Britain and France disagree over a series of issues. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1863 | 1863 | 1899-03-01 | 2 | k-l | Wealthy man in Britain helps build a railway. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
| 1864 | 1864 | 1899-03-01 | 2 | l | The reasons for removing Zeng Guofan, Governor of Hubei. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 |
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]);