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 |
---|---|---|---|---|---|---|---|---|---|
54195 | 54195 | 1934-06-02 | 3 | e | American troops on the way to seize the Panama Canal. | America | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
54206 | 54206 | 1934-06-02 | 6 | f | Australia news/ The Federal Bank of Reserve reduces interest rate. White girl detained from a Chinese fruit shop in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54200 | 54200 | 1934-06-02 | 6 | a | Australian funds in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54203 | 54203 | 1934-06-02 | 6 | e | Brazil restricts foreign immigrants. | Japan | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54194 | 54194 | 1934-06-02 | 3 | d | British Prime Minister talks on the international situations. | Britain | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
54198 | 54198 | 1934-06-02 | 6 | a | Central American countries recognise the Manchurian state. | Japan | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54189 | 54189 | 1934-06-02 | 2 | b | China news/ Council of Legislature in Nanjing outlines four key points for the foreign policy. Jiang Jieshi orders provincial governments to start the New Life Movement. Appeasement commissioner in Mongolia. Jiang Jieshi calls Wang Jingwei to Jiangxi. A military meeting in Beijing. The eighth part of the draft constitution of the Republic of China. Sichuan troops suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24096034 | 24096034 | |
54201 | 54201 | 1934-06-02 | 6 | d | China refuses to purchase weapons from Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54191 | 54191 | 1934-06-02 | 3 | b | Chinese volunteer armies in Manchuria and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
54188 | 54188 | 1934-06-02 | 2 | a | Editorial on the direct dialogue between China and Japan and the aftermath. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096034 | 24096034 | |
54193 | 54193 | 1934-06-02 | 3 | d | France warns Japan on two points. | France | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
54204 | 54204 | 1934-06-02 | 6 | e | Guangdong government entertains the Australian trade delegation. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54197 | 54197 | 1934-06-02 | 7-8 | a-f | Guangdong news/ Guangdong, Fujian, Guangxi, Guizhou and Yunnan provinces to have joint defence. The southwest authority responds to the draft constitution. More government bonds to be issued for the purpose of national defence. Battles with the communist troops in the southwest. Business in Guangzhou in the past three years. Business in Zhongshan county. Every people of a village in Boluo is murdered and the investigation. Government officials visits prostitute. Hong Kong businessman is kidnapped in Zhongshan. Drama performance in Panyu and the casualties. | China | http://trove.nla.gov.au/newspaper/page/24096039 | 24096039 | |
54196 | 54196 | 1934-06-02 | 5 | a | History of Japanese invasion of China in the past sixty years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096037 | 24096037 | |
54192 | 54192 | 1934-06-02 | 3 | b | Japan may put forward new requests to China. | China | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
54190 | 54190 | 1934-06-02 | 3 | a | Japan revises its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
54205 | 54205 | 1934-06-02 | 6 | e | Japan still seeks to occupy Timor. | Britain | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54202 | 54202 | 1934-06-02 | 6 | d | Russia apologises to Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54199 | 54199 | 1934-06-02 | 6 | a | Russia to join the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 |
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]);