This data as json, CSV (advanced)
Suggested facets: page, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21942 | 21942 | 1909-11-13 | 2 | a-c | First part of editorial on the Anglo-Saxon race and education in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802392 | 26802392 | |
21943 | 21943 | 1909-11-13 | 2 | c | News in brief/ Imperial scholar Zhang Yinlin on the political crisis. Jiangsu governor Zhang Renjun reviews new recruits in the army. The last wish of Zhang Zhidong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802392 | 26802392 | |
21944 | 21944 | 1909-11-13 | 2 | c-d | Xu Zheng (Junmian) is appointed acting chairman of the Chinese Empire Reform Association, and his visit to New York and Boston. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802392 | 26802392 | |
21945 | 21945 | 1909-11-13 | 2-3 | d-a | Beijing news/ Order to ban both local and imported opium. Russia and Japan compete against each other in Mongolia. Prince Qing recommends talents. Xi Liang reports on his negotiation with Japanese. Sun Jialai and other staff in the Political Consulting Institute (zi zheng yuan). Tsar of Russia presents gifts to the Chinese ministry of foreign affairs. | China | http://trove.nla.gov.au/newspaper/page/26802392 | 26802392 |
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]);