This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32516 | 32516 | 1917-07-28 | 8 | a-c | Beijing news/ President Li Yuanhong orders to dissolve the parlaiment. Lu Rongting seeks mediation in Beijing. Feng Guozhang issues circular telegram against resotration of monarchy. Tan Yankai of Hunan prepares to solve the chaos by force. Discussion between Zhang Xun and Wang Shizhen before their restoration manoeuvre. Chen Jintao and Xu Shiying escape pulishment for their corruption. Naval commander Cheng arrives Shanghai. Luo Peijin and Liu Cunhou reach reconciliation. | China | http://trove.nla.gov.au/newspaper/page/24095783 | 24095783 | |
32517 | 32517 | 1917-07-28 | 8 | c-e | Guangdong news/ Lu Rongting on the current situation. A public gathering in Guangzhou against Ni Sichong. Chen Bingkun urges Feng Guozhang to start mediation between different factions. Navy will help joint defence of six provinces in the southwest. Yan Qihan secretly recruits troops. Flood in Heshan county. Flood relief in Chaozhou. Tan Haoming inspects flooding area in Xijiang area. Li Yaohan seeks more funds for flood relief. Portuguese warships sill in the Chinese water territory. A survey conducted in the Humen port area. | China | http://trove.nla.gov.au/newspaper/page/24095783 | 24095783 | |
32518 | 32518 | 1917-07-28 | 8 | e | Chinese Christian Association in Sydney calls for donations to the establishment of a Chinese school (Mr Choy Wan and Mr A. John Sing). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095783 | 24095783 | |
32519 | 32519 | 1917-07-28 | 8 | f | Advertisement for the Shanghai Cafe, Chinese Chop Suey House, 65-67 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095783 | 24095783 |
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]);