This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48371 | 48371 | 1929-08-17 | 2 | d | Kong Xiangxi talks on his return to Beiping. Business in Manchuria. Another internal fighting in Sichuan. Reorganisation of the Northwest army. Zhang Xueliang and Yan Xishan are leaving Beiping after a talk with Jiang Jieshi. Han Fuqu sends telegram to Jiang Jieshi and resigns. Effort of Chinese government to take back the provisional court and the consular jurisdiction in Shanghai. Negotiation over the Manchurian railways. Jiang Jieshi reaches agreement with Zhang Xueliang, Yan Xishan and Feng Yuxiang on the current situations during their talks in Beiping. | China | http://trove.nla.gov.au/newspaper/page/24099323 | 24099323 | |
48375 | 48375 | 1929-08-17 | 3 | d | Famine in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24099322 | 24099322 | |
48382 | 48382 | 1929-08-17 | 8 | d | Floods in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 | |
48383 | 48383 | 1929-08-17 | 8 | d | Foreign missions refuse to give up their consular jurisdiction in China. | China | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 |
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]);