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 |
---|---|---|---|---|---|---|---|---|---|
54894 | 54894 | 1935-02-23 | 2 | a | Editorial on the communist troops fleeing from Guizhou to Sichuan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096335 | 24096335 | |
54895 | 54895 | 1935-02-23 | 2 | a | China news/ The cooperation between Guangzhou and Nanjing. Operation and profit of the railway from Beijing to Hankou. Japanese want to take over rich mineral resources in the northwest China. International journalists to visit former communist base in Jiangxi. The communist troops are crossing Wujiang River in Sichuan province. Post services in Manchuria. Japanese force Korean people to immigrate to Manchuria. Japanese control of Manchuria. Zhao Dazhong and his collaboration with bandits. | China | http://trove.nla.gov.au/newspaper/page/24096335 | 24096335 | |
54896 | 54896 | 1935-02-23 | 3 | a | Chinese communities in San Francisco entertain General Cai Tingkai and his secretary. | America | http://trove.nla.gov.au/newspaper/page/24096334 | 24096334 | |
54897 | 54897 | 1935-02-23 | 3 | d | Jiang Jieshi arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096334 | 24096334 | |
54898 | 54898 | 1935-02-23 | 3 | d | Debts of Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24096334 | 24096334 | |
54899 | 54899 | 1935-02-23 | 3 | d | Jiang Jieshi and his New Life Movement. | China | http://trove.nla.gov.au/newspaper/page/24096334 | 24096334 | |
54900 | 54900 | 1935-02-23 | 3 | e | How rich is Xikang province in China. | China | http://trove.nla.gov.au/newspaper/page/24096334 | 24096334 | |
54901 | 54901 | 1935-02-23 | 3 | e | American government is closely watching Japanese occupation of Asian market. | America | http://trove.nla.gov.au/newspaper/page/24096334 | 24096334 | |
54902 | 54902 | 1935-02-23 | 3 | e | Liu Guitang leads his troops fleeing far north of China. | China | http://trove.nla.gov.au/newspaper/page/24096334 | 24096334 | |
54903 | 54903 | 1935-02-23 | 5 | a | The eighth part of a study on the development of northwest China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096336 | 24096336 | |
54904 | 54904 | 1935-02-23 | 7-8 | a-f | Guangdong news/ Provincial governor Lin Yungai resigns. The communist troops in Sichuan, Guizhou and other parts of south China. Gu Gongyu and Hu Shi. Tan Qixiu arrives Guangzhou. Business in Guangzhou. Banking in Hong Kong and the business last year. Gold mining in Enping county. Gaoyao county authority investigate rural education. Police office detained in Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24096338 | 24096338 | |
54905 | 54905 | 1935-02-23 | 6 | a | Chinese General Cai Tingkai comes to visit Australia. Communications between Cai Tingkai and the Chinese Welcome Committee in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54906 | 54906 | 1935-02-23 | 6 | a | Daily Telegraph in London on the future Yellow Peril. | Britain | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54907 | 54907 | 1935-02-23 | 6 | b | British and the naval port in Singapore. | Britain | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54908 | 54908 | 1935-02-23 | 6 | b | Hong Kong and Guangdong to jointly fight pirates. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54909 | 54909 | 1935-02-23 | 6 | c | American defence in the Pacific region. | Britain | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54910 | 54910 | 1935-02-23 | 6 | c | Atrocities of the communists in north Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54911 | 54911 | 1935-02-23 | 6 | d | Australia news/ Chinese swimmer Guo Zhenheng will not visit Sydney. Indian immigrant permitted to land for a visit to his family in Australia. White man is penalised for opium smuggling. New materials invented in Sydney for ship building. Chinese communities in Sydney prepare to welcome General Cai Tingkai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 |
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]);