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 |
---|---|---|---|---|---|---|---|---|---|
54214 | 54214 | 1934-06-09 | 3 | b | Relations between America and Japan. | America | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54219 | 54219 | 1934-06-09 | 3 | f | Repayment of war loans to America. | America | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54208 | 54208 | 1934-06-09 | 2 | b | Can the New Life Movement save China, first part of an article written by Wang Zhengheng. | China | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
54209 | 54209 | 1934-06-09 | 2 | d | Proposed solution to the Sino-Japanese problems. | China | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
54210 | 54210 | 1934-06-09 | 2 | e | The ninth and final part of the draft constitution of the Republic of China. Sichuan troops suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
54211 | 54211 | 1934-06-09 | 2 | f | Airports to be built in Sichuan and Tibet. | China | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
54212 | 54212 | 1934-06-09 | 3 | a | Japanese in Jilin purchase agricultural land at a cheap price. | China | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54213 | 54213 | 1934-06-09 | 3 | a | Possibility of direct dialogue between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54215 | 54215 | 1934-06-09 | 3 | b | Japanese policy of mollification in China. | China | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54220 | 54220 | 1934-06-09 | 5 | a | Zhu Qinglan is now a monk. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
54221 | 54221 | 1934-06-09 | 5 | b | A man in Guangzhou can see ghosts. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
54223 | 54223 | 1934-06-09 | 7-8 | a-f | Guangdong news/ Airforce troops in Guangdong relieve garrisons. Suppress of the communist troops in the southeast. Chinese government to change its currency system. Unified tax collection in Guangdong. Boat people in Guangdong and their life. | China | http://trove.nla.gov.au/newspaper/page/24096047 | 24096047 | |
54225 | 54225 | 1934-06-09 | 6 | a | Puyi is sick. | China | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54217 | 54217 | 1934-06-09 | 3 | d | Trade talks between Britain and Japan may fail. | Japan | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54218 | 54218 | 1934-06-09 | 3 | e | Japanese Prime Minister explains his China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54226 | 54226 | 1934-06-09 | 6 | a | Japanese naval commander dies. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54227 | 54227 | 1934-06-09 | 6 | c | Recent negotiations between Russia and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54229 | 54229 | 1934-06-09 | 6 | d | Brother of Emperor of Japan becomes ambassador to Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54224 | 54224 | 1934-06-09 | 6 | a | The Philippines welcomes Australian trade delegation. | Other... | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54228 | 54228 | 1934-06-09 | 6 | d | Hot weather in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54216 | 54216 | 1934-06-09 | 3 | c | The war clouds over Manchuria between Japan and Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54207 | 54207 | 1934-06-09 | 2 | a | Editorial in commemoration of the May Fourth Movement of 1919. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
54222 | 54222 | 1934-06-09 | 5 | f | Hop Yek & Co in Sydney moves to 50 Dixon Street. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
54230 | 54230 | 1934-06-09 | 6 | d | Australia news/ Australian businessmen to set up a Far East Trade company. New regulations on the sale of tobacco products. Woman pilot flies from Britain to Australia. Australian export to China. French man arrives Sydney by a Chinese ship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 |
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]);