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 |
---|---|---|---|---|---|---|---|---|---|
40317 | 40317 | 1923-09-01 | 2 | e | Qi Xieyuan denies any donations to the presidential election. | China | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40318 | 40318 | 1923-09-01 | 2 | e-f | Liu Xianshi denies any banditry in Guiyang, capital of Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40319 | 40319 | 1923-09-01 | 2 | f | Zhang Qihuang becomes new governor of Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40320 | 40320 | 1923-09-01 | 3 | a | A circular telegram issued by the Guangdong public security association. | China | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 | |
40321 | 40321 | 1923-09-01 | 3 | a-b | A letter from Cao Kun to Yang Du. | China | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 | |
40322 | 40322 | 1923-09-01 | 3 | b-c | Campaign for presidential election in China. | China | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 | |
40323 | 40323 | 1923-09-01 | 3 | c | Wu Peifu supports to unify China by force. | China | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 | |
40324 | 40324 | 1923-09-01 | 3 | c-d | Army from the north enter Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 | |
40326 | 40326 | 1923-09-01 | 3 | e | A cargo ship is on fire on its way from Shanghai to Tokyo. | China | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 | |
40331 | 40331 | 1923-09-01 | 6 | a-b | Shareholders of the Xinning railway line issue an open letter. | China | http://trove.nla.gov.au/newspaper/page/24094532 | 24094532 | |
40332 | 40332 | 1923-09-01 | 6 | b-c | Chinese businessman Liang Chuang celebrates his 60th birthday in Shanghai and congratulations from Liang Qichao, Xiong Xiling, Wang Daxie, Lin Changmin, Wang Chonghui, Li Zhongyue, Li Hanfen, Yang Hao, Wang Tiduan, Wang Zhaoji, Kang Youwei, Zhang Qian, and many others. Liang is major shareholder of Wing On companies in Hong Kong, Shanghai and Sydney, of Wing On textile company in Shanghai and Guangming electronics company in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094532 | 24094532 | |
40343 | 40343 | 1923-09-01 | 7 | c | Preparation for presidential election in China. | China | http://trove.nla.gov.au/newspaper/page/24094531 | 24094531 |
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]);