This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
27649 | 27649 | 1913-07-26 | 3 | a | An attempt to assassinate the President of Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27650 | 27650 | 1913-07-26 | 3 | a | Boycott to Chinese fruit business in Canada. | Canada | 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 | |
27652 | 27652 | 1913-07-26 | 3 | b | Import and export in France in the first half of this year. | Britain | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27653 | 27653 | 1913-07-26 | 3 | b | Plot to assassinate monarch of Norway and the panic. | Britain | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27654 | 27654 | 1913-07-26 | 3 | c | Saskatchewan authority in Canada prohibits Chinese businessmen from employing white women. | Canada | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27655 | 27655 | 1913-07-26 | 3 | c | Miscellaneous on the war in Balkan peninsula. | Other... | 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 |
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]);