This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24200 | 24200 | 1911-01-21 | 6 | a-b | Announcement from the Society of Comrade, Beijing | Four tasks which the Scoiety of Comrades work on, including push the establishment of new Cabinet; participate in the drafting of the Constitution; plea to lift the ban on political party; educate Chinese people the knowledge of constitutional system. | China | http://trove.nla.gov.au/newspaper/page/24091609 | 24091609 |
24201 | 24201 | 1911-01-21 | 6 | b | Preparation for the visit of German Prince | Preparation to make the German Prince feel welcomed in his visit in China, including having one official, Feng Yuqian, who used to work in Chinese embassy in Germany to look after the whole reception affair. | China | http://trove.nla.gov.au/newspaper/page/24091609 | 24091609 |
24202 | 24202 | 1911-01-21 | 6 | b | High-level official, Zhao Xi, impeaches the Department of National Defense | Zhao Xi impeaches the Department of National Defense for its lack of responsibility. | China | http://trove.nla.gov.au/newspaper/page/24091609 | 24091609 |
24203 | 24203 | 1911-01-21 | 6 | b | The unstable situation regarding the Northern and Southern governors | Concern about the fact that the ministers of Nanyang and Beiyang were being unsupportive of the Beijing government's political reforms. | China | http://trove.nla.gov.au/newspaper/page/24091609 | 24091609 |
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]);