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 |
---|---|---|---|---|---|---|---|---|---|
46467 | 46467 | 1927-11-26 | 2 | c | Bandits in north Anhui province (Fengtai county). | China | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 | |
46468 | 46468 | 1927-11-26 | 2 | d | The engagement of Jiang Jieshi and Song Meiling. | China | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 | |
46469 | 46469 | 1927-11-26 | 2 | d | A report on the troops under Zhang Zuolin and Yan Xishan. | China | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 | |
46470 | 46470 | 1927-11-26 | 2 | e | Zhang Zuolin's son Zhang Xueming and Tian Zhongyu's son Tian Jingshi are both studying economics in Japan. | China | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 | |
46471 | 46471 | 1927-11-26 | 2 | e | Swiss archaeologist and his research in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 | |
46472 | 46472 | 1927-11-26 | 2 | e | The Communists in the south of Hubei province are to be eliminated. | China | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 | |
46475 | 46475 | 1927-11-26 | 3 | c | Mei Lanfang after the robbery in his house. | China | http://trove.nla.gov.au/newspaper/page/24098607 | 24098607 | |
46476 | 46476 | 1927-11-26 | 3 | d | The politics and economy in Mongolia under control of Soviet Russian. | China | http://trove.nla.gov.au/newspaper/page/24098607 | 24098607 | |
46477 | 46477 | 1927-11-26 | 3 | e | Sun Ke is busy raising more funds. | China | http://trove.nla.gov.au/newspaper/page/24098607 | 24098607 | |
46480 | 46480 | 1927-11-26 | 5 | a | Disasters of war, locusts and drought in Shandong province. Political changes in Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46482 | 46482 | 1927-11-26 | 5 | a | Troops from Nanjing occupy Hankou and the report. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46488 | 46488 | 1927-11-26 | 5 | b | Jin Yunpeng is still alive. Professor Gao Renshan and nine students of the Beijing Normal University are arrested. Zhang Zuolin's troops take over Shijiazhuang and the orders issued Zhang. Song Qingling denies marriage with Chen Youren. Sun Ke to leave Hankou for Nanjing. Truce between Zhang Zuolin and Yan Xishan. Sun Chuanfang's army stage a comeback. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46491 | 46491 | 1927-11-26 | 7 | b | Guangdong news/ Banditry in Taishan county, Guangdong. Homeless people in Foshan and their demonstration. Bandit chieftain arrested in Dongguan. Tiger eats passers-by in Chaoyang county. Bandits in Xinhui county. Chen Village in Xinhui county is looted. | China | http://trove.nla.gov.au/newspaper/page/24098611 | 24098611 | |
46492 | 46492 | 1927-11-26 | 8 | a-d | Guangdong news/ Prisoners of war arrested from Ye Ting and He Long's troops are escorted to Guangzhou. Prisoners confess about Deng Yuanda. Sericulture and fishery in Shunde county. Government bonds to be issued for building of telephone communications. Local social security in Zhongshan and Shunde county. Salt shortage in Huizhou. Bandits kidnap people in central Guangzhou. Prices of imported dyestuff going up. Pensions paid to the families of revolutionary martyrs who died for the country. County magistrates are ordered to stay in their office for most of the time. Clan feud and fighting in Huiyang county. Police head Zhu Huiri warns the infiltration of communists into the trade unions. | China | http://trove.nla.gov.au/newspaper/page/24098614 | 24098614 |
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]);