This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56227 | 56227 | 1936-09-05 | 2 | c | China news/ China exports salt to Japan. The Communist troops under He Long and Xiao Ke attack Gansu and Qinghai province. Kong Xiangxi on the currency system in China and America. The central government troops start to attack Guangxi. Song Zheyuan in Hebei province to engage more Japanese advisors. Tens of thousands of peasants are leaving their home villages. Election of the delegates to the national congress in Liaoning, Jilin, Heilongjiang and Rehe province. Feng Yuxiang, Zhang Fakui and Deng Hanxiang are all in the Lushan Mountain of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24096978 | 24096978 | |
56229 | 56229 | 1936-09-05 | 3 | a | Sale of Chinese silk products in Vietnam. | China | http://trove.nla.gov.au/newspaper/page/24096977 | 24096977 | |
56233 | 56233 | 1936-09-05 | 3 | d | Rumour in Japan claims that France invest in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096977 | 24096977 | |
56234 | 56234 | 1936-09-05 | 3 | d | Chinese consul in Korea is detained by Japanese police. | China | http://trove.nla.gov.au/newspaper/page/24096977 | 24096977 | |
56239 | 56239 | 1936-09-05 | 6-7 | a-d | Guangdong news/ The central government troops gather in the north of Guangdong province for coming military action. Central authority in Nanjing to reform the currency system in Guangdong. Chen Lizhen is appointed chief supervisor of the Sincere Company in Shanghai and the report. Guangdong province prepares to reform currency system. Commerce and industry in Guangxi. The magistrate and the prisoner in Dongguan county. Bandits in Zhongshan county. Floods in Kaiping. | China | http://trove.nla.gov.au/newspaper/page/24096982 | 24096982 | |
56241 | 56241 | 1936-09-05 | 8 | a | Attack on British soldiers in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096985 | 24096985 | |
56244 | 56244 | 1936-09-05 | 8 | c | Demonstrations in Chengdu, Sichuan province, against Japanese invasion. Japanese want to set up consulate office in Chengdu and the protest. | China | http://trove.nla.gov.au/newspaper/page/24096985 | 24096985 |
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]);