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 |
---|---|---|---|---|---|---|---|---|---|
54852 | 54852 | 1935-02-09 | 3 | b | America purchases silver from around the world. | America | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54865 | 54865 | 1935-02-09 | 6 | b | American government opposes to the establishment of an international court. | America | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54855 | 54855 | 1935-02-09 | 3 | d | American senators propose to investigate Japanese breach of the Washington agreement. | America | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54871 | 54871 | 1935-02-09 | 6 | f | Australia news/ Australia and Japan start talks on trade agreement. Women in Queensland demand equal fights with men. Chinese communities in Brisbane welcome Chinese general Qiu Zhaoshen. Japanese confidence on the New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54862 | 54862 | 1935-02-09 | 6 | a | British government on the coming crisis in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54860 | 54860 | 1935-02-09 | 7 | a-f | Business in Beihai, of Guangxi province. Bandits rob a silk products shop in Xinhui. Heavy burdens of the peasants in Chaozhou and Meixian. Gambling in Nanhai and the fighting. Villages are flooded in Nan'ao county. | China | http://trove.nla.gov.au/newspaper/page/24096320 | 24096320 | |
54849 | 54849 | 1935-02-09 | 2 | c | China news/ Government troops in Guizhou fight the communists. Japanese in Manchuria. Cotton production in Shaanxi province. Troops manoeuvre in Fujian province. Bandits and government troops fight in Xuzhou, north Jiangsu province. Expenses of the Government officials. Li Jiayu on the suppression of communists. | China | http://trove.nla.gov.au/newspaper/page/24096319 | 24096319 | |
54856 | 54856 | 1935-02-09 | 3 | d | Chinese soldiers in Shanghai do not know Mrs Jiang Jieshi, Song Meiling. | China | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54864 | 54864 | 1935-02-09 | 6 | b | Conflicts on the border of Mongolia, Russia and Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54869 | 54869 | 1935-02-09 | 6 | e | Diplomatic relations between America and Russia may break off. | America | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54848 | 54848 | 1935-02-09 | 2 | a | Editorial by Tung Wah Times on the political principles. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096319 | 24096319 | |
54870 | 54870 | 1935-02-09 | 6 | e | Fiji welcomes Prince of Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54857 | 54857 | 1935-02-09 | 3 | d | Japanese administration in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54853 | 54853 | 1935-02-09 | 3 | c | Japanese in Manchuria are selling drugs. | China | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54867 | 54867 | 1935-02-09 | 6 | c | Japanese seek to topple the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54866 | 54866 | 1935-02-09 | 6 | c | Jiang Jieshi reaches agreement with Japanese. | Japan | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54858 | 54858 | 1935-02-09 | 3 | e | Police in Japan arrest communist activists. | Japan | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54851 | 54851 | 1935-02-09 | 3 | a | Resistance of Chinese troops to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54854 | 54854 | 1935-02-09 | 3 | c | Singaporean authority restricts entry of foreign servicemen. | Singapore | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54861 | 54861 | 1935-02-09 | 5 | a | Sixth part of a study on the development of northwest China. | China | http://trove.nla.gov.au/newspaper/page/24096322 | 24096322 | |
54850 | 54850 | 1935-02-09 | 3 | a | Sun Ke says Wang Chonghui is leaving Beijing for Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54859 | 54859 | 1935-02-09 | 3 | e | Tang Shengzhi resumes new appointment. Import of foreign rice increases dramatically. | China | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54863 | 54863 | 1935-02-09 | 6 | a | The Seventh Congress of the Soviet Communist Party in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54868 | 54868 | 1935-02-09 | 6 | d | The communists in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 |
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]);