This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37555 | 37555 | 1921-09-10 | 2 | c-d | First part of the proposals to revise the constitution of the League of Nations, reported by Diao Deren, journalist of The Eastern Times in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24093679 | 24093679 | |
37556 | 37556 | 1921-09-10 | 2 | e-f | Chinese Premier Jin Yunpeng talks on current situations. | China | http://trove.nla.gov.au/newspaper/page/24093679 | 24093679 | |
37558 | 37558 | 1921-09-10 | 3 | b | Clashes between school students and businessmen in Xiamen (Amoy) and an analysis. | China | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37559 | 37559 | 1921-09-10 | 3 | b-c | Foreign missions in Beijing discuss the proposal by Chinese government to revise its customs regulations. | China | http://trove.nla.gov.au/newspaper/page/24093678 | 24093678 | |
37567 | 37567 | 1921-09-10 | 6 | c | News in brief/ Chinese government to send Gu Weijun, ambassador to London, to the Washington Conference. Unification Association in Shanghai proposes to send Qin Chunxuan, Li Yuanhong and Wang Zhengting to Beijing for unification talks. Jin Yunpeng is to resign. Zhao Hengti orders attack to Hubei province. Nobody supports Lu Yongxiang and his united government proposal. Wang Zhanyuan asks for help from the central government in Beijing. Sun Yatsen convenes a meeting for expedition to the North. Sun Yatsen seeks to send envoy to the Washington Conference. Sun Yatsen decides to take over Hubei and Jiangxi provinces. | China | http://trove.nla.gov.au/newspaper/page/24093683 | 24093683 |
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]);