This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid | date | page | column | title | description ▲ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50124 | 50124 | 1931-03-21 | 8 | c | The best plane manufactured in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50108 | 50108 | 1931-03-21 | 2 | e | Song Ziwen on the current situations. Loans for the construction of Longhai railway. Chen Youren still in Shanghai. Shanxi people request to sell the munitions factory. Japanese troops on exercise in Beijing. Five requests from the people in Shanxi province. Female communists in Hubei are involved in prostitution for their propaganda. Ma Xiaojun arrives Shanghai and talks on the Guangxi situation. Yan Xishan to stage a comeback. Zhang Xueliang seeks to take over the munitions factory in Shanxi. Police in Tianjin arrest communists. Wang Zhengting on the negotiations between China and Russia. Gu Weijun and Luo Wengan on the way to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50109 | 50109 | 1931-03-21 | 3 | a | Rich mineral resources in Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090315 | 24090315 | |
50120 | 50120 | 1931-03-21 | 8 | b | Population in India. | Other... | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50111 | 50111 | 1931-03-21 | 3 | b | People in Sichuan province suffer from the armies. | China | http://trove.nla.gov.au/newspaper/page/24090315 | 24090315 | |
50121 | 50121 | 1931-03-21 | 8 | b | New plane in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50107 | 50107 | 1931-03-21 | 2 | d | Nanjing government to secure the loans from America. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50118 | 50118 | 1931-03-21 | 8 | b | Jewellery shop in New York robbed. | America | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50123 | 50123 | 1931-03-21 | 8 | c | Japanese businessman murders Russian trading partner. | Japan | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50119 | 50119 | 1931-03-21 | 8 | b | Italian government debates their immigration policy. | Other... | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50105 | 50105 | 1931-03-21 | 2 | c | Huang Shaoxiong and Chen Jitang are both leaving Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50114 | 50114 | 1931-03-21 | 5 | a | Hong Kong news/ Analysis on the world-wide economic recession. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090317 | 24090317 | |
50110 | 50110 | 1931-03-21 | 3 | b | Guizhou provincial government to improve the water projects in the rural area. | China | http://trove.nla.gov.au/newspaper/page/24090315 | 24090315 | |
50116 | 50116 | 1931-03-21 | 6-7 | a-d | Guangdong news/ Chen Jitang to retreat all Guangdong armies from Guangxi. Li Mingrui leads remains of his troops to the Beijiang area. Guangzhou branch of the Nationalist Party suggests to impose more business taxes. Another secret society in Guangzhou. Poultry in Guangzhou and the taxes. Martial law in Wuzhou, Guangxi. Gold mine in Zengcheng. The communists in the south of Jiangxi province. More troops dispatched to the east to suppress bandits. Shipping businessmen prohibited from self-defence. Cattail bags also applicable to taxation. Underground mint raided in Shantou. The Zhongshan county under new magistrate Tang Shaoyi. Troops and police in Dongguan county suppress bandits. Gambling in Shantou and a public gathering to ban the gambling. Zengcheng county to build new prison and the social response. Water projects in Gaoyao county. Monster found in a lake of Huizhou. Panyu to be the first county of self-government. | China | http://trove.nla.gov.au/newspaper/page/24090320 | 24090320 | |
50103 | 50103 | 1931-03-21 | 2 | b | First 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/24090316 | 24090316 | |
50104 | 50104 | 1931-03-21 | 2 | c | Debates and fighting in Japanese parliament. | Japan | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50106 | 50106 | 1931-03-21 | 2 | d | Current situation in Guangxi and proposals for solutions. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50117 | 50117 | 1931-03-21 | 8 | b | Chinese ship sinks in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50112 | 50112 | 1931-03-21 | 3 | d | Chen Jiageng to invest in the Zhangpu coal mines in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090315 | 24090315 | |
50125 | 50125 | 1931-03-21 | 8 | c | Australia news/ A doctor is sentenced to compensate. A plane accident in Sydney due to the storm. Police arrest gamblers in Sydney. Police in Sydney arrest thieves. Muddy streets in Chatswood, Sydney. Farewell to Chinese businessman Lei Miaohui. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50113 | 50113 | 1931-03-21 | 3 | e | American senate discuss the trade with China. | America | http://trove.nla.gov.au/newspaper/page/24090315 | 24090315 | |
50122 | 50122 | 1931-03-21 | 8 | b | American people and their income. | America | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50127 | 50127 | 1931-03-21 | 8 | e | Advertisement for new books available from The Chinese World in San Francisco. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50115 | 50115 | 1931-03-21 | 5 | b | A survey on the disasters of communists in the west of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24090317 | 24090317 | |
50126 | 50126 | 1931-03-21 | 8 | e | A meeting notice by the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 |
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]);