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 | |
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 | |
54200 | 54200 | 1934-06-02 | 6 | a | Australian funds in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54201 | 54201 | 1934-06-02 | 6 | d | China refuses to purchase weapons from Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
54205 | 54205 | 1934-06-02 | 6 | e | Japan still seeks to occupy Timor. | Britain | 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 | |
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 | |
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 | |
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 | |
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 | |
54190 | 54190 | 1934-06-02 | 3 | a | Japan revises its China policy. | Japan | 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 | |
54202 | 54202 | 1934-06-02 | 6 | d | Russia apologises to Japan. | Japan | 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 | |
54199 | 54199 | 1934-06-02 | 6 | a | Russia to join the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
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 | |
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 | |
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 |
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]);