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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
54220 | 54220 | 1934-06-09 | 5 | a | Zhu Qinglan is now a monk. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
54224 | 54224 | 1934-06-09 | 6 | a | The Philippines welcomes Australian trade delegation. | Other... | 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 | |
54226 | 54226 | 1934-06-09 | 6 | a | Japanese naval commander dies. | Japan | 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 | |
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 | |
54214 | 54214 | 1934-06-09 | 3 | b | Relations between America and Japan. | America | 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 | |
54221 | 54221 | 1934-06-09 | 5 | b | A man in Guangzhou can see ghosts. | China | http://trove.nla.gov.au/newspaper/page/24096045 | 24096045 | |
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 | |
54227 | 54227 | 1934-06-09 | 6 | c | Recent negotiations between Russia and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54209 | 54209 | 1934-06-09 | 2 | d | Proposed solution to the Sino-Japanese problems. | China | http://trove.nla.gov.au/newspaper/page/24096044 | 24096044 | |
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 | |
54228 | 54228 | 1934-06-09 | 6 | d | Hot weather in India. | Other... | 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 | |
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 | |
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 | |
54218 | 54218 | 1934-06-09 | 3 | e | Japanese Prime Minister explains his China policy. | Japan | 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 | |
54219 | 54219 | 1934-06-09 | 3 | f | Repayment of war loans to America. | America | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
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 |
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]);