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 |
---|---|---|---|---|---|---|---|---|---|
55895 | 55895 | 1936-03-21 | 2 | d | China news/ The Central Administrative Council approves development plan of Sichuan province. He Yingqin, Cheng Qian, Chen Shaokuan and Yang Jie meet to reform the army system. Japanese military policy and the railway transportation in Beijing. The Nanjing government dispatches two warships to appease overseas Chinese communities. Guangxi provincial government to be reformed. Han Fuqu and Song Zheyuan agree to jointly resist Japanese invasion. The Nanjing government orders to implement new tax regulations from next month. Borodin arrives Shanghai secretly. Japanese invade Chinese with the stick and the carrot. | China | http://trove.nla.gov.au/newspaper/page/24096784 | 24096784 | |
55900 | 55900 | 1936-03-21 | 3 | d | Both Britain and America are strengthen their national defence. | America | http://trove.nla.gov.au/newspaper/page/24096783 | 24096783 | |
55901 | 55901 | 1936-03-21 | 3 | d | Graves of the unknown fallen soldiers of the 19th Route Army in Shanghai suburb and a speech by Zhang Zhizhong. | China | http://trove.nla.gov.au/newspaper/page/24096783 | 24096783 | |
55910 | 55910 | 1936-03-21 | 8 | d | Japanese deport Russian immigrants from Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24096790 | 24096790 | |
55911 | 55911 | 1936-03-21 | 8 | d | The war clouds over the Rhein River. | Britain | http://trove.nla.gov.au/newspaper/page/24096790 | 24096790 |
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]);