This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23742 | 23742 | 1910-11-05 | 2 | a-b | Former American president Theodore Roosevelt comments on the world situation and its future development, and comments by Tung Wah Times. | Other... | http://trove.nla.gov.au/newspaper/page/26802826 | 26802826 | |
23743 | 23743 | 1910-11-05 | 2 | c | Imperial edict on August 27 on appointment of several local officials. | China | http://trove.nla.gov.au/newspaper/page/26802826 | 26802826 | |
23744 | 23744 | 1910-11-05 | 2 | c | Important news/ Why Shanghai magistrate Cai Naihuang is dismissed. Zhang Mingqi and others suggest to organise a cabinet. Zai Tao and Na Tong conflict on the political reform. American industrial delegation on the way to Beijing. Board of Revenue reports financial deficit. | China | http://trove.nla.gov.au/newspaper/page/26802826 | 26802826 | |
23745 | 23745 | 1910-11-05 | 2 | c-d | Beijing news/ Board of Revenue reports on its savings. Zai Ze disagrees with foreign loans as suggested by Xi Liang and Rui Zheng. A Berlin newspaper comments on railway construction in China. Hankou prepares to host an exhibition. Number of Chinese nationals in Korea. Central government subsidises Yunnan for its military expenditure. Japanese government to welcome delegation of Chinese newspapers. | China | http://trove.nla.gov.au/newspaper/page/26802826 | 26802826 |
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]);