This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49891 | 49891 | 1931-01-17 | 2 | c | Japanese cabinet has finalised its new policy in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49892 | 49892 | 1931-01-17 | 2 | c | Cuba to set up sugar factory in China. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49893 | 49893 | 1931-01-17 | 2 | c | Xiong Shihui and Yang Yongtai are seriously injured in a plane accident. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49894 | 49894 | 1931-01-17 | 2 | d | The Communist Party in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49895 | 49895 | 1931-01-17 | 2 | d | Jiang Jieshi retains Deng Ying and He Jian. Chinese Communist Party has a Soviet conference in Ningbo, of Zhejiang province. Organisational regulations of the National Conference. Why Zhu Peide resigns. Jiang Jieshi to arrive Wuhan. Jiang Jieshi to take over Manchuria. Zhang Xueliang leaves Tianjin for Shenyang. Salt sale in Jilin and Heilongjiang province. Arsenal explodes in Shanghai. Yan Xishan stays in Puyi's house in Tianjin. Reorganisation of Zhang Xueliang and Yan Xishan's troops. Shi Yousan support Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49896 | 49896 | 1931-01-17 | 3 | a | Gambling tax in the French concession in Shanghai and its use. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49897 | 49897 | 1931-01-17 | 3 | a | Clash between Chinese and Japanese police in Jilin and the negotiations. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49899 | 49899 | 1931-01-17 | 3 | b | Chinese government issues new tax regulations on exports. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49900 | 49900 | 1931-01-17 | 3 | b | Nationalist authority in Nanjing prohibits government officials from being involved in business. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49901 | 49901 | 1931-01-17 | 3 | c | Problems in Fujian province that need to be solved. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49902 | 49902 | 1931-01-17 | 3 | c | Famine victims in Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49903 | 49903 | 1931-01-17 | 3 | d | Sichuan province still in chaos. | China | http://trove.nla.gov.au/newspaper/page/24090239 | 24090239 | |
49905 | 49905 | 1931-01-17 | 5 | d | Lin Zhenxiong after the closure of the Huangpu Military Academy. | China | http://trove.nla.gov.au/newspaper/page/24090241 | 24090241 | |
49909 | 49909 | 1931-01-17 | 6-7 | a-d | Guangdong news/ Guangdong owes 20 million unpaid debts. War in the Beijiang area. Armed ship and their monopoly of navigation in Xijiang area. Sale of government bonds ends. Human traffic in Guangzhou and the government's effort to crush their organisation. Mint in Guangzhou to stop production soon. Troops and security guards are ordered to guard against communists. Unemployed Chinese returned from Nanyang are going to the Beijiang area for coal mining. Wang Jingwei may be in Vietnam now. Provincial government bans any more conscription. Communist disasters in Haifeng. Appeal of the alcohol and tea businessmen in Taishan. Exorbitant taxes in Taishan. Women in Gaoyao county promote Chinese products. Bandits in Zhongshan extort firewood ships. New police forces to be organised in Zhongshan to deal with the bandits. Registration of land tax in Gaoyao county. Nationalist troops loot villages in Dongguan. Brothels in Jiangmen are moved to a new place. Panyu county houses lepers. Maternal clinic set up in Zengcheng county. | China | http://trove.nla.gov.au/newspaper/page/24090244 | 24090244 | |
49911 | 49911 | 1931-01-17 | 8 | b | People in Shanghai support to ban dog racing. Disasters of bandits in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 |
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]);