This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25660 | 25660 | 1912-01-27 | 7 | a-b | Australia news | Australia exports develop over last year, statistics listed. An European youngster killed Xian Jiang and was arrested. Federal government notifies all states to watch on African ships, preventing plague enterig. Australia is to have Chinese overseas students. A number of German people immigrate to Brisbane. Japanese is to expand shipping business in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
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 |
25667 | 25667 | 1912-01-27 | 7 | c | The emperor's abdication may fail | Her majesty opposes the emperor's abdication. | America | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
25668 | 25668 | 1912-01-27 | 7 | c | Brief introduction about Bian Zhenxing | Bian Zhengxing is a straightforward and brave army official in the north expedition army. | Other... | 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]);