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 |
---|---|---|---|---|---|---|---|---|---|
54221 | 54221 | 1934-06-09 | 5 | b | A man in Guangzhou can see ghosts. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
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 | |
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 | |
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 | |
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 | |
54228 | 54228 | 1934-06-09 | 6 | d | Hot weather in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54218 | 54218 | 1934-06-09 | 3 | e | Japanese Prime Minister explains his China policy. | Japan | 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 | |
54226 | 54226 | 1934-06-09 | 6 | a | Japanese naval commander dies. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54215 | 54215 | 1934-06-09 | 3 | b | Japanese policy of mollification in China. | 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 | |
54209 | 54209 | 1934-06-09 | 2 | d | Proposed solution to the Sino-Japanese problems. | China | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
54225 | 54225 | 1934-06-09 | 6 | a | Puyi is sick. | China | 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 | |
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 | |
54224 | 54224 | 1934-06-09 | 6 | a | The Philippines welcomes Australian trade delegation. | Other... | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
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 | |
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 | |
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 | |
54220 | 54220 | 1934-06-09 | 5 | a | Zhu Qinglan is now a monk. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 |
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]);