This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22857 | 22857 | 1910-05-28 | 2 | a-b | First part of the open letter from the Chinese Empire Reform Association in Honolulu to Prince Zai Tao. | America | http://trove.nla.gov.au/newspaper/page/26802641 | 26802641 | |
22858 | 22858 | 1910-05-28 | 2 | b | News in brief/ Yu Lang writes to Prince Zai Tao who is on overseas investigation for naval building. A foreign ambassador asks for a short stay in the Summer Palace. Some revolutionaries are arrested in Beijing. House refurbishment for Prince Regent. Rui Zheng and the chaos in Changsha, Hunan province. Police raid a photo studio in Beijing for arms smuggling. Li Jingyi asks for more funds from Beijing for mining project in Yunnan. New American ambassador to Beijing meets Prince Regent. Jiang Chunlin arrives Shanghai. | China | http://trove.nla.gov.au/newspaper/page/26802641 | 26802641 | |
22859 | 22859 | 1910-05-28 | 2 | b | Yin Chang is appointed general commander of Chinese army and his policy. | Germany | http://trove.nla.gov.au/newspaper/page/26802641 | 26802641 | |
22860 | 22860 | 1910-05-28 | 2 | b-d | Further report on Prince Zai Tao's overseas investigation on naval building. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802641 | 26802641 |
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]);