This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27883 | 27883 | 1913-09-20 | 3 | a | Small political parties in Beijing and their comments on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27884 | 27884 | 1913-09-20 | 3 | a-b | Japanese riots attack the Ministry of Foreign Affairs in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27885 | 27885 | 1913-09-20 | 3 | b | Four Japanese warships arrive Nanjing. | Britain | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27886 | 27886 | 1913-09-20 | 3 | b | Japan demands compensation from Chinese government for their loss or insult suffered in Shandong, Hankou, and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27887 | 27887 | 1913-09-20 | 3 | b | Zhang Xun and his army in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27888 | 27888 | 1913-09-20 | 3 | b | China has new cabinet under Xiong Xiling, and his ministers include Zhang Qian, Liang Qichao and Sun Baoqi. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27889 | 27889 | 1913-09-20 | 3 | b | Peace talks between Turkey and Bulgaria. | Other... | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27890 | 27890 | 1913-09-20 | 3 | b | Two islands near Tonga vanish. | America | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27891 | 27891 | 1913-09-20 | 3 | b-c | Japan want to rent Lushun (Port Arthur) for another 50 years. | Britain | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27892 | 27892 | 1913-09-20 | 3 | c | Foreign countries and the salt sale in China. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27893 | 27893 | 1913-09-20 | 3 | c | China seeks to recruit some Germany military officers and response of the international community. | Britain | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27894 | 27894 | 1913-09-20 | 3 | c | Murderers in Tokyo who assassinated Japanese foreign ministry official are executed. | Japan | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27895 | 27895 | 1913-09-20 | 3 | c | Clash between the Monarchists and the Republicans in Portugal. | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | ||
27896 | 27896 | 1913-09-20 | 3 | c-d | Guangdong news/ Long Jiguang's troops suppress rebellions in Guangzhou. Some armies have surrendered to Long Jiguang. Zhang Woquan is found embezzlement. Long Jiguang tries to retain value of the currency. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 |
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]);