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 |
---|---|---|---|---|---|---|---|---|---|
46362 | 46362 | 1927-10-29 | 3 | e | Zhang Zongchang in Shandong prepares to attack Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46374 | 46374 | 1927-10-29 | 7 | a | Warning to the compatriots who want to take risk overseas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46363 | 46363 | 1927-10-29 | 3 | f | War ends in the south of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46357 | 46357 | 1927-10-29 | 3 | b | Wang Tianpei is executed and the report. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46352 | 46352 | 1927-10-29 | 2 | c | Visitor from Sichuan talks about Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24098576 | 24098576 | |
46376 | 46376 | 1927-10-29 | 7 | c | Troops from Nanjing on the way to Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46356 | 46356 | 1927-10-29 | 3 | b | The navigation in the Yangtze River after the cooperation between Wuhan and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46373 | 46373 | 1927-10-29 | 5 | c | The Yangtze River is not quiet. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46368 | 46368 | 1927-10-29 | 5 | b | Soviet Russia appoints new ambassador to France. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46361 | 46361 | 1927-10-29 | 3 | e | Soviet Russia and its economic invasion into Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46367 | 46367 | 1927-10-29 | 5 | b | Secretary of the British coal miners' union will not go to Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46365 | 46365 | 1927-10-29 | 5 | a | News on the war in north China. The Nationalist government and the Northern Expedition. Chinese National Chamber of Commerce and other commercial associations seek to borrow internal loans. British navy protect the Hong Kong and Shanghai Bank. Dog racing in Shanghai. Some British troops are leaving China. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46358 | 46358 | 1927-10-29 | 3 | c | News about Duan Qirui and the talks by Yang Zhen. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46360 | 46360 | 1927-10-29 | 3 | d | Morale of ordinary people in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46378 | 46378 | 1927-10-29 | 7 | c | Leon Trotsky is removed from the Bolshevik Party. | Russia | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46359 | 46359 | 1927-10-29 | 3 | c | Japanese government temporarily halts the negotiations with Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46364 | 46364 | 1927-10-29 | 3 | f | Japan and Russia have a conference on railway construction in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46366 | 46366 | 1927-10-29 | 5 | b | Industrial progress in the Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46380 | 46380 | 1927-10-29 | 8 | a-d | Guangdong news/ Li Fulin requires local civil corps to help suppress bandits. Collaboration between the Chinese Communists and bandits in Dongjiang area. The Nationalist government promulgates new regulation on divorce. Li Zongren and Bai Chongxi transfer prisoners of war from Sun Chuanfang to Guangdong. Few people in Guangzhou celebrate the birthday of Confucius. The 5th Army to aid Zengcheng. Restrictions on civil corps and peasants' associations for their role in the suppression of bandits. Old temples demolished in Chencun village. Army warship is hijacked near Guangzhou. Five people are arrested in Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24098582 | 24098582 | |
46372 | 46372 | 1927-10-29 | 5 | c | German government intervenes with the strike. | Germany | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46377 | 46377 | 1927-10-29 | 7 | c | Foreign gunboats in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46351 | 46351 | 1927-10-29 | 2 | b | First part of editorial by Tung Wah Times on the failure of the international disarmament conference in Geneva. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098576 | 24098576 | |
46354 | 46354 | 1927-10-29 | 2 | e | Financial status of Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24098576 | 24098576 | |
46353 | 46353 | 1927-10-29 | 2 | d | Cooperation between Shanghai, Nanjing and Wuhan and a declaration issued by its special committee. | China | http://trove.nla.gov.au/newspaper/page/24098576 | 24098576 | |
46369 | 46369 | 1927-10-29 | 5 | b | Cases of kidnap in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46355 | 46355 | 1927-10-29 | 2 | f | Battle between Jin Yunpeng and Feng Yuxiang ends. | China | http://trove.nla.gov.au/newspaper/page/24098576 | 24098576 | |
46370 | 46370 | 1927-10-29 | 5 | c | Bandits in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46371 | 46371 | 1927-10-29 | 5 | c | Bandits hijack ship near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46375 | 46375 | 1927-10-29 | 7 | b | Australia news/ Illegal Chinese immigrants in Sydney and the tragedy. Two Chinese brothers in Melbourne fight and injure each others. State government of New South Wales tries to retain the police commissioner. Two ships collide near Sydney. New South Wales government appoints new representative to London. The Melbourne Cup and horse racing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
46379 | 46379 | 1927-10-29 | 7 | c | A big Japanese girl comes to visit Guangdong. | Japan | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 |
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]);