This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23983 | 23983 | 1910-12-17 | 2 | a-b | A petition from the Chinese Empire Reform Association in Chicago to Prince Zai Xun for the establishment of national parliament and the lift of ban on political parties. | America | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 | |
23984 | 23984 | 1910-12-17 | 2 | b-c | Approval to organise a Chinese cabinet. | China | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 | |
23985 | 23985 | 1910-12-17 | 2 | c | Chinese government is considering taking over Macao. | China | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 | |
23986 | 23986 | 1910-12-17 | 2 | c | Correspondence from Japan/ Pessimism in Korea after the nation is conquered. | Japan | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 | |
23987 | 23987 | 1910-12-17 | 2 | c-d | Beijing news/ Arbitration office to be established in local provinces. China to regain its control on postal service. Zai Ze suggests to set up insurance company in China. Former Shanghai magistrate Cai Naihuang after removal. Railway project from Yantai to Weifang in Shandong province. China fails to demarcate its border with Russia. Mongolia will turn into the second Manchuria. British and French companies exploit mining resources in Yunnan province. Negotiation with British on the border between Yunnan and Burma. | China | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 |
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]);