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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 54190 | 54190 | 1934-06-02 | 3 | a | Japan revises its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
| 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 | |
| 54193 | 54193 | 1934-06-02 | 3 | d | France warns Japan on two points. | France | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 54198 | 54198 | 1934-06-02 | 6 | a | Central American countries recognise the Manchurian state. | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 54205 | 54205 | 1934-06-02 | 6 | e | Japan still seeks to occupy Timor. | Britain | http://trove.nla.gov.au/newspaper/page/24096040 | 24096040 | |
| 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]);