This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7801 | 7801 | 1901-05-29 | 2 | a | The second part of a report from Tao Mo, governor of Guangdong and Guangxi provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7802 | 7802 | 1901-05-29 | 2 | b-c | The second part of a letter from Qiu Shuyuan to Tao Mo, governor of Guangdong and Guangxi provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7803 | 7803 | 1901-05-29 | 2 | c | Wang Kangnian's speech at the rally of Shanghai gentry, protesting against the treaty between China and Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7804 | 7804 | 1901-05-29 | 2 | d | Report on the Empress' temporary lodge in Xi'an. | China | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7805 | 7805 | 1901-05-29 | 2 | d | Reports from local governors suggesting political policies. | China | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7806 | 7806 | 1901-05-29 | 2 | d | Governor of Fujian province was impeached. | China | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7807 | 7807 | 1901-05-29 | 2 | d | Regulations, issued by Yuan Shikai, imperial commissioner of Shandong province, prohibits Boxers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7808 | 7808 | 1901-05-29 | 2 | e | British foreign secretary comments on China affairs; Li Hongzhang and Prince Qing ordered to settle the peace protocol with foreign governments as soon as possible due to famine in Shanxi and Shaanxi provinces; British soldiers arrive in Tongzhou from Tianjin; commander of international troops meets the Emperor of Japan on his way back to Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7809 | 7809 | 1901-05-29 | 2 | e | Population in Scotland, Ireland, Britain and the United Kingdom. | Other... | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7810 | 7810 | 1901-05-29 | 2 | e | King of England narrowly escapes from danger. | Britain | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7811 | 7811 | 1901-05-29 | 2 | f | German businessmen, the business capital. | Other... | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7812 | 7812 | 1901-05-29 | 2 | f | People of Transvaal, South Africa, return home after the Boer War. They now seek a settlement. | Other... | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7813 | 7813 | 1901-05-29 | 2 | f | Glass workers in Belgium on strike, creating huge losses for their employers.. | Australia | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7814 | 7814 | 1901-05-29 | 2 | f | Three Russian men were detained in Nagasaki, Japan, for spying. | Australia | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 | |
7815 | 7815 | 1901-05-29 | 2 | f | A letter from Honolulu about Yang Weibin, Chinese consul, and other news. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100055 | 24100055 |
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]);