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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
54228 | 54228 | 1934-06-09 | 6 | d | Hot weather in India. | Other... | 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 | |
54226 | 54226 | 1934-06-09 | 6 | a | Japanese naval commander dies. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54225 | 54225 | 1934-06-09 | 6 | a | Puyi is sick. | China | 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 | |
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 | |
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 | |
54221 | 54221 | 1934-06-09 | 5 | b | A man in Guangzhou can see ghosts. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
54220 | 54220 | 1934-06-09 | 5 | a | Zhu Qinglan is now a monk. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
54219 | 54219 | 1934-06-09 | 3 | f | Repayment of war loans to America. | America | 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 | |
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 | |
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 | |
54215 | 54215 | 1934-06-09 | 3 | b | Japanese policy of mollification in China. | China | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54214 | 54214 | 1934-06-09 | 3 | b | Relations between America and Japan. | America | 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 | |
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 | |
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 | |
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 | |
54209 | 54209 | 1934-06-09 | 2 | d | Proposed solution to the Sino-Japanese problems. | China | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
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 | |
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 |
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]);