This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50128 | 50128 | 1931-03-28 | 2 | b | Second and final part of comments by Tung Wah Times on Japan's new policy on railway construction and management in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090325 | 24090325 | |
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 |
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]);