This data as json, CSV (advanced)
date (date) 7 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
1910 | 1910 | 1899-03-08 | 2 | g-h | French gunboats in Yangtze River deliberately provoked; Rung Lu inspects troops in Beijing and Tianjin; the Emperor plans to build another palace near Tianjin; reformists in Guangdong still in danger. | http://trove.nla.gov.au/newspaper/page/24102318 | 24102318 | ||
1967 | 1967 | 1899-03-15 | 3 | g-h | Statistics on Japan's imports and exports. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
1981 | 1981 | 1899-03-18 | 2 | g-h | Report submitted by Governor of Guizhou to the Empress on the suppression of Miao nationality rebellion. | http://trove.nla.gov.au/newspaper/page/24102330 | 24102330 | ||
2008 | 2008 | 1899-03-22 | 2 | g-h | Drought in various areas of New South Wales. | http://trove.nla.gov.au/newspaper/page/24102334 | 24102334 | ||
2021 | 2021 | 1899-03-22 | 3 | g-h | Tall man in Australia. | http://trove.nla.gov.au/newspaper/page/24102333 | 24102333 | ||
2077 | 2077 | 1899-03-29 | 3 | g-h | Jiangsu and Zhejiang provinces store grain in preparation for possible famine. | http://trove.nla.gov.au/newspaper/page/24102341 | 24102341 |
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]);