This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25453 | 25453 | 1911-12-23 | 3 | a | Welcome revolutionary leader | Singapore people welcome arrival of Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25454 | 25454 | 1911-12-23 | 3 | a | Are Britain and Japan to help negotiating peace settlement in China? | Britain and Japan may help the government and the revolutionaries negotiate on peace solution. | China | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25455 | 25455 | 1911-12-23 | 3 | a | German spies on British military | A German spy is found to spy on British military. | Britain | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25456 | 25456 | 1911-12-23 | 3 | a | British emperor's trip in India | Glorious ceremonies are held in various places in India for arrival of British emperor. | Other... | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25457 | 25457 | 1911-12-23 | 3 | a | British parliament's conference terminates | British parliament's conference is to reopen next year. | Britain | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25458 | 25458 | 1911-12-23 | 3 | a | Purse's crisis | British foreign minister cables Russia that a new Purse government should be established for settling the crisis. | Britain | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25459 | 25459 | 1911-12-23 | 3 | a | Britain and Germany are to fight each other | A British senator says in New York that a war will occur between Britain and Germany. | America | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25460 | 25460 | 1911-12-23 | 3 | b | American navy is powerful | American navy has 99 various warships and the president inspects navy port. | America | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25461 | 25461 | 1911-12-23 | 3 | b | Many poor people in Japan commit suicide | Japan domestic ministry reports that number of poor people committing suicide is rapidly rising. | Japan | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25462 | 25462 | 1911-12-23 | 3 | b | Overseas Chinese students supported by the government are short of fund | No fund is provided from the government to overseas students in America since the revolutionary uprising. | America | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25463 | 25463 | 1911-12-23 | 3 | b | Current situation of abnegated prince of Man nationality | Fu Jun, the abnegated prince, is now living in inner Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25464 | 25464 | 1911-12-23 | 3 | b | Man people support revolution too | A Man person supports political revolution but opposes anti-Man revolution. | China | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25465 | 25465 | 1911-12-23 | 3 | c | Beijing news | Current situation in Beijing. Chinese overseas students in Japan attempt to return to China for revolution. Seng Xuanhui's rest garden in Souzhou is changed to Red Cross office. Wei Guangxi refuses to take government office. Government officials compete to draw deposits from banks. | China | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25466 | 25466 | 1911-12-23 | 3 | c-d | Guangdong news | Guangdong is to organise education association. Zhu Xingyi with relatives escaped after revolution. Huang Nin attempts to escape. Guangdong drives away gamblers. Previous official tried to escape when revolution started. Long Shichu leads government of Zhaocheng, Guangdong. Military commander Hu takes office. Many people compete to join volunteers troop of revolutionary army. A new flag was set up in front of military building. | China | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
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]);