This data as json, CSV (advanced)
Suggested facets: column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23433 | 23433 | 1910-09-10 | 2 | a-b | First part of an article, selected from guo feng bao in Shanghai, on national parliament and the nation. | China | http://trove.nla.gov.au/newspaper/page/26802762 | 26802762 | |
23436 | 23436 | 1910-09-10 | 2 | c | Number of Russians in Mongolia and their distribution. | China | http://trove.nla.gov.au/newspaper/page/26802762 | 26802762 | |
23437 | 23437 | 1910-09-10 | 2 | c-d | Beijing news/ Prince Regent selects a prime minister. Influence of the new treaty signed between Russia and Japan. Liang Dunyan and Zhang Yintang. Financial crisis in local province. Proposed reform of army and government. Prince Qing and naval development. Russian interfere with official appointment in the ministry of foreign affairs. Railway project from Yunnan to Guangxi and foreign loans. | China | http://trove.nla.gov.au/newspaper/page/26802762 | 26802762 | |
23443 | 23443 | 1910-09-10 | 3 | c | Prince Regent wants to appoint former American president Theodore Roosevelt his advisor, even at a very high price. | China | http://trove.nla.gov.au/newspaper/page/26802761 | 26802761 | |
23450 | 23450 | 1910-09-10 | 3 | d | Beijing news/ Dutch authorities to force all Chinese residents in their colonies to be naturalised. Board of Revenue to check financial report of other ministries. China to participate a health exhibition in Germany. | China | http://trove.nla.gov.au/newspaper/page/26802761 | 26802761 | |
23452 | 23452 | 1910-09-10 | 6 | a-b | Political factions in the Beijing court and the effort to rehabilitate Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/26802766 | 26802766 | |
23463 | 23463 | 1910-09-10 | 7 | b | Special report from Beijing/ China may appoint Tang Entong as consul general to Australia. Wu Tingfang is in Shanghai. Zai Xun to tour Japan again. Wang Daxie is new ambassador to Japan and his entourage. | China | http://trove.nla.gov.au/newspaper/page/26802765 | 26802765 |
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]);