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 |
---|---|---|---|---|---|---|---|---|---|
50129 | 50129 | 1931-03-28 | 2 | d | Japanese medical association purchase books of Chinese medicine from Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090325 | 24090325 | |
50130 | 50130 | 1931-03-28 | 2 | d | The Nationalist Party controls election of delegates to the national conference. The Nationalists in Beijing. Reorganisation of the troops formerly under Feng Yuxiang. Lu Diping resigns unexpectedly. Shi Yousan seeks to expand his troops. The communists in the south of Jiangxi. Munitions factory in Shanxi province. Train derails on the way from Beijing to Hankou. Shops in Shanghai prohibited from banking business. Hu Hanmin on hunger strike. | China | http://trove.nla.gov.au/newspaper/page/24090325 | 24090325 | |
50134 | 50134 | 1931-03-28 | 3 | d | Japanese invasion in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24090324 | 24090324 | |
50136 | 50136 | 1931-03-28 | 5 | d | Tea waiter in the Shanghai court. Waitress and the restaurants in Beijing. Academic field in Fuzhou, Fujian province, and their stories. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090326 | 24090326 |
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]);