This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28814 | 28814 | 1914-05-09 | 6 | a-b | News in brief/ Sun Baoqi suggests to set up more consular offices overseas. China to compensate foreign countries for their loss during the Revolution. The cabinet meeting in Beijing. Some people in Hong Kong recommend Kang Youwei to be the President of China. President Yuan Shikai suggests to revise the provisional constitution. | China | http://trove.nla.gov.au/newspaper/page/24093106 | 24093106 | |
28815 | 28815 | 1914-05-09 | 6 | b-c | French authority in the Guangzhou Bay to increase tax and their negotiations with the China side. French troops in Vietnam cross the boundary with China. Russian authority dispatches more troops to Jilin and Heilongjiang area (northeast of China). | China | http://trove.nla.gov.au/newspaper/page/24093106 | 24093106 |
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]);