This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28742 | 28742 | 1914-04-25 | 2 | c-d | Chinese cabinet to set up border demarcation committee. Naval training in China. Chinese Ministry of Internal Affairs to unify water police. Foreign missions in Beijing propose to revise China's tariff treaties and the response of Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24093086 | 24093086 | |
28755 | 28755 | 1914-04-25 | 3 | c-d | Beijing news/ Presidential office organises a consulting committee on national affairs. Chinese Ministry of Finance to borrow more foreign loans. President Yuan Shikai to abolish some taxes. Premier Sun Baoqi restructures some foreign affairs departments. Li Yuanhong presents betrothal gifts to Yuan Shikai's son. Agreement between China and Japan over the Changli Incident in Zhili (Hebei) province. Bandits in Anhui province capture Liu'an county town and kidnap French missionary. China's effort to take back the international court in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24093085 | 24093085 |
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]);