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 |
---|---|---|---|---|---|---|---|---|---|
30802 | 30802 | 1915-12-11 | 3 | b | Declaration of Chinese Women Petition Association on calling Chinese women to air their views on restoring imperial system. | China | http://trove.nla.gov.au/newspaper/page/24095083 | 24095083 | |
30803 | 30803 | 1915-12-11 | 3 | b | Jiang Shili in Japan is wounded severely by gun-shot for his efforts to support restoring imperial system in China. | Japan | http://trove.nla.gov.au/newspaper/page/24095083 | 24095083 | |
30813 | 30813 | 1915-12-11 | 6 | b | News miscellany/Tan Hualong resigns and plans to go to Japan and America. Generals in various provinces promise to the president to shoulder responsibilities of keeping social stabilities. A police is killed and another is injured by the riot party members in Shanghai. Qian Longxun is appointed head of Ping Zheng Yuan. Newspapers in Guangdong are ordered not to publicise anti-imperial system articles. | China | http://trove.nla.gov.au/newspaper/page/24095088 | 24095088 | |
30815 | 30815 | 1915-12-11 | 7 | b | Shanghai riot/ 'Zhaohe' warship in Shanghai rebels but now is pacified. | China | http://trove.nla.gov.au/newspaper/page/24095087 | 24095087 | |
30818 | 30818 | 1915-12-11 | 8 | b | Government troops have almost wiped off bandits in Yunnan but British and German people are active there for unknown reasons. | China | http://trove.nla.gov.au/newspaper/page/24095092 | 24095092 |
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]);