This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22790 | 22790 | 1910-05-14 | 2 | b-c | News in brief/ Petition to the establishment of national parliament. A commercial bank to be set up in Tianjin. Liang Cheng as Chinese ambassador to Germany. Redeem of the Tongguanshan mine in Anhui and the price. Chinese official in Tibet reports collaboration between Dalai Lama and Russian. Jiang Chunlin arrives Shanghai. River dredged between Beijing and Tianjin. Chinese government and army training in Mongolia. News restrictions on foreign business activities in China. Smoking officials will be punished. Dalai Lama is pardoned. Jiang Chunlin on why pigtail should be cut off. Lu Chuanlin resumes work. | China | http://trove.nla.gov.au/newspaper/page/26802623 | 26802623 | |
22796 | 22796 | 1910-05-14 | 3 | b-c | Report on the death of King Edward VII of Britain. | Britain | http://trove.nla.gov.au/newspaper/page/26802622 | 26802622 | |
22826 | 22826 | 1910-05-14 | 8 | b-c | Poems written by Liu Xiyan on the departure of Jiang Chunlin for the south. | China | http://trove.nla.gov.au/newspaper/page/26802631 | 26802631 |
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]);