This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 1888 | 1888 | 1899-03-04 | 3 | a-b-c | The first part of a public letter written by a group of gentry in Sichuan to government authorities concerning Yu Manzi and other bandits in Sichuan. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1889 | 1889 | 1899-03-04 | 3 | c-d | Court hearing in Melbourne on the death of a woman, possibly caused by a home-abortion operation. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1890 | 1890 | 1899-03-04 | 3 | d | US woman missionary opens two schools in Guangzhou to educate the blind. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1891 | 1891 | 1899-03-04 | 3 | d | Sydney, Chinese man, Ya Jian, dies in train while traveling to see a doctor. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1892 | 1892 | 1899-03-04 | 3 | e | The second son of the NSW governor died in Britain. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1893 | 1893 | 1899-03-04 | 3 | e-f | Representatives from Chinese community called at the Governor's house saying thanks and farewell. They are Mei Guangda, Liu Ruxing, Li Yihui, He Shuxian, Zhou Rongwei, Situ Qian, Sun Junchen, Jiang Rangnong, Sha San. A letter of thanks was also presented. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1894 | 1894 | 1899-03-04 | 3 | g | Outgoing Governor of NSW replies with a letter to the Chinese community. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1895 | 1895 | 1899-03-04 | 3 | g | Sydney General Post Office on fire last month. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1896 | 1896 | 1899-03-04 | 3 | g-h | Japanese government takes effective strategies to prevent natural disasters in the future. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1897 | 1897 | 1899-03-04 | 3 | h | Woman and two children die in Western Australia when burnt to death in fire. Police suspect fire lit deliberately. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1898 | 1898 | 1899-03-04 | 3 | h-i-j | His Imperial Majesty is recovering quickly after recent bout of ill-health. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1899 | 1899 | 1899-03-04 | 3 | j | Empress Dowager and local residents reject Russia's plans to collect was tax in Dalian, northeastern China. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1900 | 1900 | 1899-03-04 | 3 | j | China appoints government official to take charge of building of railway. Plans refused by Britain. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1901 | 1901 | 1899-03-04 | 3 | j | Rung Lu trains special army in south Beijing. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1902 | 1902 | 1899-03-04 | 3 | k | Widow in Zengcheng faced much hardship, led happy life nonetheless. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1903 | 1903 | 1899-03-04 | 3 | k | Civil corps in Zengcheng receive award for skill in training and parade. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1904 | 1904 | 1899-03-04 | 3 | k-l | Love between a prostitute and a talented scholar ends quickly. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 | ||
| 1905 | 1905 | 1899-03-04 | 3 | l | Volcano eruptes suddenly in Japan. | http://trove.nla.gov.au/newspaper/page/24102314 | 24102314 |
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]);