This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27643 | 27643 | 1913-07-26 | 2 | a-b | Kang Youwei returns to China and the report. | China | http://trove.nla.gov.au/newspaper/page/24092761 | 24092761 | |
27644 | 27644 | 1913-07-26 | 2 | b-c | An open letter to the central government authority in Beijing and jointly signed by local provincial governors. | China | http://trove.nla.gov.au/newspaper/page/24092761 | 24092761 | |
27645 | 27645 | 1913-07-26 | 2 | c-d | Division of the south and the north in China. | China | http://trove.nla.gov.au/newspaper/page/24092761 | 24092761 | |
27646 | 27646 | 1913-07-26 | 2 | d | A committee to be organised for the national constitution. | China | http://trove.nla.gov.au/newspaper/page/24092761 | 24092761 | |
27647 | 27647 | 1913-07-26 | 2-3 | d-a | A public speech by Long Jiguang in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24092761 | 24092761 | |
27648 | 27648 | 1913-07-26 | 3 | a | Guangdong businessmen in Hong Kong condemns rebellions like Hu Hanmin, Liao Zhongkai and Chen Jinghua. | China | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27651 | 27651 | 1913-07-26 | 3 | a | The second revolutionary wave arrives in China following independence of Jiangxi, Jiangsu, Guangxi, Fujian, Sichuan, Anhui, Hunan and Guangdong provinces. | China | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27656 | 27656 | 1913-07-26 | 3 | c-d | Beijing news/ Formal government to be organised in Beijing and the preparation. Beijing government and the foreign loans. Some prominent figures involved in the Xu Qiwen case will be exempt from punishment. Chen Qimei and his case. Zhang Ji wants to join the Republic Party. Telegram from Huang Xing to Yuan Shikai. Chen Fumin is arrested in the international settlement in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27657 | 27657 | 1913-07-26 | 3 | d | Guangdong news/ People in Guangdong welcome their new governor Chen Jiongming. Other social response in Guangdong to the appointment of Chen Jiongming. | China | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27663 | 27663 | 1913-07-26 | 7 | b | Reports on the second revolution in China. | China | http://trove.nla.gov.au/newspaper/page/24092764 | 24092764 | |
27666 | 27666 | 1913-07-26 | 8 | b-c | Miscellaneous report from China (politics and others). | China | http://trove.nla.gov.au/newspaper/page/24092767 | 24092767 | |
27667 | 27667 | 1913-07-26 | 8 | c | Investigation on the assassination of Song Jiaoren. | China | http://trove.nla.gov.au/newspaper/page/24092767 | 24092767 | |
27668 | 27668 | 1913-07-26 | 8 | c-d | Guangdong news/ Chen Jiongming declines to the appointment of Guangdong governorship. Hu Hanmin seeks to resign and the response. Chen Jiongming accepts the appointment of Guangdong governorship. Social panic in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24092767 | 24092767 |
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]);