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 |
---|---|---|---|---|---|---|---|---|---|
25521 | 25521 | 1912-01-06 | 2 | b | Wu Tingfang's letter to emperor | Army general Wu Tingfang's letter to emperor explaining it isn't his fault for loss of Wuhan to revolutionaries. | Other... | http://trove.nla.gov.au/newspaper/page/24092059 | 24092059 |
25528 | 25528 | 1912-01-06 | 3 | b | Japan and powerful nations | Japan expresses its willingness to be friends of powerful nations. | Japan | http://trove.nla.gov.au/newspaper/page/24092058 | 24092058 |
25529 | 25529 | 1912-01-06 | 3 | b | War between Italy and Turkey | War between Italy and Turkey is still going resulted in many casualties. | Other... | http://trove.nla.gov.au/newspaper/page/24092058 | 24092058 |
25530 | 25530 | 1912-01-06 | 3 | b | Russia refuses salvation army | Russia refuses entry of salvation army into Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24092058 | 24092058 |
25531 | 25531 | 1912-01-06 | 3 | b | British King's trip | British king is on his way back to London. | Other... | http://trove.nla.gov.au/newspaper/page/24092058 | 24092058 |
25532 | 25532 | 1912-01-06 | 3 | b | Navy chief fled to Hong Kong | Defeated government navy chief first hid in Shanghai and then fled to Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24092058 | 24092058 |
25533 | 25533 | 1912-01-06 | 3 | b | Message from Japan | Qing government can not get any foreign loans. Buddhist abbot in Wuhan worries about future of his temple. Japanese sympathised for revolution is coming to China. | Japan | http://trove.nla.gov.au/newspaper/page/24092058 | 24092058 |
25539 | 25539 | 1912-01-06 | 6 | b | Foreign warships in China | American navy department lists number of foreign warships in China. | America | http://trove.nla.gov.au/newspaper/page/24092063 | 24092063 |
25540 | 25540 | 1912-01-06 | 6 | b | Xiangshan army | Xiangshan army backs the Guangdong North Expeditionary Army set up recently. | Other... | http://trove.nla.gov.au/newspaper/page/24092063 | 24092063 |
25541 | 25541 | 1912-01-06 | 6 | b | Message from Guangdong Railway Company | Message from Guangdong Railway Company about its meeting of discussion on railway shares. | Other... | http://trove.nla.gov.au/newspaper/page/24092063 | 24092063 |
25543 | 25543 | 1912-01-06 | 7 | b | New Zealand news | China's Consul-General to New Zealand returns to China for his service leave. Its interpreter asks for return to China as he is to finish his three year term. | Other... | http://trove.nla.gov.au/newspaper/page/24092062 | 24092062 |
25544 | 25544 | 1912-01-06 | 7 | b | China revolution news | Mongolia decides to support government against revolutionaries and states independent. Yuan Shikai asks Empress for military funds. Northern expeditionary army ready for another war with government troops. Revolutionaries attacked Hankou again but failed. Yuan Shikai asks for resignation due to poor economic situation and Empress agrees to give him more military funds to keep him. Prince receives a message from 15 senior military officials for more military funds. Revolutionary troops withdraw from Hanyang. Minister for Transport asks for resignation due to his agreement on withdrawing government troops. (continued from page 3) | Other... | http://trove.nla.gov.au/newspaper/page/24092062 | 24092062 |
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]);