This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25636 | 25636 | 1912-01-27 | 2 | b | Letter from Henan Petition Bureau to Yuan Shikai | A letter to Yuan Shikai calls on him to support the establishment of a republic China. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25649 | 25649 | 1912-01-27 | 3 | b | Changes of Japanese army commander | The general commander of Japanese ground troops is changed. | Japan | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25650 | 25650 | 1912-01-27 | 3 | b | Canada is to limit Chinese overseas students | A high tax is to be levied by Canada government to limit entrance of Chinese students. | Canada | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25651 | 25651 | 1912-01-27 | 3 | b | The American congress votes for rejection of America-Russia treaty | American congress votes to end the treaty between America and Russia due to Russia's frequent violation to the treaty. | America | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25652 | 25652 | 1912-01-27 | 3 | b | He De's (nnn) properties | He De, the ex-ambassador in China, left a huge property to his wife and children when passed away. | Britain | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25653 | 25653 | 1912-01-27 | 3 | b | Record of welcoming overseas students | A ceremony held in Singapore to welcome overseas students from Britain returning to China. | Singapore | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25657 | 25657 | 1912-01-27 | 6 | b | Foreign troops in the embassies in Beijing | Statistics of troops in foreign embassies in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24092087 | 24092087 |
25658 | 25658 | 1912-01-27 | 6 | b | The first election with women involved in Louisiana state in America | Alexandria won the election first attended by women in Louisiana and an old woman died of heart attack due to over excitement. | America | http://trove.nla.gov.au/newspaper/page/24092087 | 24092087 |
25661 | 25661 | 1912-01-27 | 7 | b | Riot in the China's west border | Some revolutionary troops occupied several places in Xingjiang and neighbouring areas. | Russia | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
25662 | 25662 | 1912-01-27 | 7 | b | Russia and Mongolia | Russia refuses China to enter Mongolia since Mongolia declared independence. | Russia | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
25663 | 25663 | 1912-01-27 | 7 | b | Japan and Manchu | Newspapers in Japan encourage their government to protect Manchu. | Japan | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
25664 | 25664 | 1912-01-27 | 7 | b | Manchu people and Yuan Shikai | Manchu young officials oppose the abdication of the emperor and assassinations on Yuan Shikai are assumed to be conspired by them. | China | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
25665 | 25665 | 1912-01-27 | 7 | b | Sun and Yuan neither compromises | Sun Yatsen wants the emperor abdicate and he opposes Yuan Shikai to set up a republic by himself. | China | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
25666 | 25666 | 1912-01-27 | 7 | b | Volunteers troops of the north expedition army vow not to return alive | Volunteers troops of the revolutionary army vows to throw down the Qing government and won't return alive. | China | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
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]);