This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46352 | 46352 | 1927-10-29 | 2 | c | Visitor from Sichuan talks about Wu Peifu. | 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 | |
46354 | 46354 | 1927-10-29 | 2 | e | Financial status of Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24098576 | 24098576 | |
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 | |
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 | |
46357 | 46357 | 1927-10-29 | 3 | b | Wang Tianpei is executed and the report. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
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 | |
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 | |
46360 | 46360 | 1927-10-29 | 3 | d | Morale of ordinary people in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
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 | |
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 | |
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 | |
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 | |
46369 | 46369 | 1927-10-29 | 5 | b | Cases of kidnap in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46373 | 46373 | 1927-10-29 | 5 | c | The Yangtze River is not quiet. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
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 | |
46377 | 46377 | 1927-10-29 | 7 | c | Foreign gunboats in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
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 |
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]);