This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50315 | 50315 | 1931-05-23 | 2 | d | The Communist troops under He Long still on the border of Yuandang. Hundreds of bodies collected in Shanghai last year. Shenyang authority guards against the Communists. China and Norway reach agreement on the consular jurisdiction. Proposal to reduce the size of provincial administration. Telegram from Liu Wenhui and Liu Xiang to Panchen Lama. Yang Hu narrowly escapes from a murder by his chef. Jiang Jieshi to give up the position of education minister. Zhang Xueliang meets Shang Zhen. Nanjing prepares to welcome Zhang Xueliang. Panchen Lama to arrive Nanjing. Yang Sen seeks alliance of Deng Xihou in order to fight Liu Xiang. Zhang Xueliang and his plan to reorganise the Shanxi army. New political faction in the northwest of China. Zhang Xueliang seeks to promote business in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090389 | 24090389 | |
50320 | 50320 | 1931-05-23 | 3 | d | Japanese in Hankou, Hubei province, are involved in arms smuggling. | China | http://trove.nla.gov.au/newspaper/page/24090388 | 24090388 | |
50325 | 50325 | 1931-05-23 | 5 | d | Three notices issued by the Chinese Consulate-General in Australia on the registration of overseas Chinese, shares of railway projects in China and other issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090390 | 24090390 |
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]);