This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27847 | 27847 | 1913-09-13 | 2 | b-c | Orders issued by interim president Yuan Shikai on July 26 and 27 on national renovation and appointment of officials in Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24092817 | 24092817 | |
27864 | 27864 | 1913-09-13 | 3 | b-c | Beijing news/ George Morrison and his comments on the current situations in China. Chinese ambassador to Japan Sun Baoqi returns and reports to President Yuan Shikai. Five foreign countries agree to lend loans to China. Nationalist members boycott to the parliament. Xiong Xiling returns to Rehe in a hurry. Ying Guixin hides somewhere in Pudong for a further escape to Japan. Zuo Xianzhang, leader of the Zong She, is executed in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24092816 | 24092816 | |
27870 | 27870 | 1913-09-13 | 7 | b-c | Britain dispatches more warships to China. | Britain | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 |
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]);