This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39488 | 39488 | 1923-02-17 | 14 | a | Statistics on China's national debt prepared by the Treasury in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
39489 | 39489 | 1923-02-17 | 14 | a | Cao Rulin and Lu Zongyu and the foreign loans to China. | China | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
39493 | 39493 | 1923-02-17 | 15 | a | Overseas Chinese communities request disarmament in China. | China | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39494 | 39494 | 1923-02-17 | 15 | a-b | Russian refugees in Beijing and their sufferings. | China | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39496 | 39496 | 1923-02-17 | 15 | b | Conditions of the peace talks between Zhang Zuolin and Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39524 | 39524 | 1923-02-17 | 21 | a-b | News in brief/ Political groups in Baoding and Tianjin have different opinion on the presidential election in China. Cao Kun sends telegram to President Li Yuanhong on the case of Luo Wengan. Sun Yatsen sends telegram to Zhang Shaozeng on the national parliament of 1919. Luo Wengan is released. Cao Kun is sleepless at night. Zhang Shaozeng sends envoy Zhang Shizhao to meet Sun Yatsen and Qin Chunxuan in the south for national unification. Army commander Xia Sheng writes to Guangzhou people on the political situation. Li Houji is trying to retain his power. | China | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 |
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]);