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 |
---|---|---|---|---|---|---|---|---|---|
55465 | 55465 | 1935-09-28 | 3 | a | The Comintern interferes with internal affairs of the United States of America and its possible affects. | America | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55472 | 55472 | 1935-09-28 | 8 | a | Japanese are planning new manoeuvre in China. | Britain | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 | |
55473 | 55473 | 1935-09-28 | 8 | d | British economic expert comes to visit China for a possible aid. | Britain | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 | |
55475 | 55475 | 1935-09-28 | 8 | d | British fleet found in the Mediterranean Sea. | Britain | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 | |
55476 | 55476 | 1935-09-28 | 8 | e | The last peace proposal from the League of Nations. | Britain | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 | |
55460 | 55460 | 1935-09-28 | 2 | b | Chen Shuren resigns as director of the Overseas Chinese Commission of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55461 | 55461 | 1935-09-28 | 2 | b | Wang Jingwei resumes to work and Jiang Jieshi flies to Chengdu, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55462 | 55462 | 1935-09-28 | 2 | c | Li Zhenhua is arrested in Beijing for being involved in the case of Liu Zuozhou. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55463 | 55463 | 1935-09-28 | 2 | d | More than 300 villages are flooded in north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24096587 | 24096587 | |
55466 | 55466 | 1935-09-28 | 3 | b | Radio communication connect China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55470 | 55470 | 1935-09-28 | 6-7 | a-f | Guangdong news/ Self-government movement in Guangdong will continue. Provincial government is preparing for its three-year development plan. Police in Guangzhou to stop women from wearing colourful clothes. Coal production in Guangdong. Chinese and foreign businessmen fight for the rice market in Shantou. Plan of military training for the army and government staff. Shantou authority tries to protect local railways. Sales of Chinese products domestically and on the international market. Business still dull in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24096591 | 24096591 | |
55471 | 55471 | 1935-09-28 | 8 | a | Meeting notice of the Chinese Chamber of Commerce in NSW. | China | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 | |
55474 | 55474 | 1935-09-28 | 8 | d | Farmers in France to have a revolution. | France | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 | |
55467 | 55467 | 1935-09-28 | 3 | d | German treasurer advises his fellow people to lead a thrifty life. | Germany | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55464 | 55464 | 1935-09-28 | 3 | a | Japanese propaganda on the political and economic cooperation between China and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55469 | 55469 | 1935-09-28 | 3 | d | Jiang Zuobin arrives Nagasaki. | Japan | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55468 | 55468 | 1935-09-28 | 3 | d | Coup under the way in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55477 | 55477 | 1935-09-28 | 8 | f | Australia news/ Passenger liner to Hong Kong Changte in storm now. Flour price in Sydney going up. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 |
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]);