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 |
---|---|---|---|---|---|---|---|---|---|
46060 | 46060 | 1927-08-20 | 2 | c | Envoy of French government arrives Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46062 | 46062 | 1927-08-20 | 2 | d | Floods in Jingxian county, south Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46063 | 46063 | 1927-08-20 | 2 | d | British and Danish ambassadors urge Chinese government to pay telegram fees. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46064 | 46064 | 1927-08-20 | 2 | e | Zhang Zuolin fails to set up alliance with Yan Xishan in Shanxi. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46065 | 46065 | 1927-08-20 | 2 | e | Zhang Zuolin issues a declaration. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46066 | 46066 | 1927-08-20 | 2 | e | Zhang Zuochang recruits 5,000 Russian soldiers. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46067 | 46067 | 1927-08-20 | 3 | b | Yan Xishan sees off Kong Geng. | China | http://trove.nla.gov.au/newspaper/page/24098495 | 24098495 | |
46068 | 46068 | 1927-08-20 | 3 | b | World sports game to be held in Holland next year. | China | http://trove.nla.gov.au/newspaper/page/24098495 | 24098495 | |
46069 | 46069 | 1927-08-20 | 3 | b | Yang Hu, police chief in Shanghai, arrests Chen Yannian, son of Chen Duxiu. | China | http://trove.nla.gov.au/newspaper/page/24098495 | 24098495 | |
46071 | 46071 | 1927-08-20 | 3 | d | Protest from the Beijing foreign ministry against Portuguese authority on the troops in Macao. | China | http://trove.nla.gov.au/newspaper/page/24098495 | 24098495 | |
46077 | 46077 | 1927-08-20 | 5 | c | Jiang Jieshi secretly goes to Ningbo, Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46078 | 46078 | 1927-08-20 | 5 | c | Possible cooperation between Jiang Jieshi in Nanjing and Feng Yuxiang in Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46079 | 46079 | 1927-08-20 | 5 | d | Jiang Jieshi steps down. | China | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46085 | 46085 | 1927-08-20 | 7 | b | Jiang Jieshi's troops retreat to Zhenjiang, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 | |
46087 | 46087 | 1927-08-20 | 9 | a-d | Guangdong news/ Businessmen requires the government to intervene the return of public houses occupied by the strikers. Zhu Jiahua sets up special offices for the minority people in Hainan island. Provincial government bans young people from smoking and drinking. Wife murders the family. Horse racing prepared in Guangzhou. Workers of a match factory in Guangzhou on strike. Strike of the Sincere Company employees and the solution. Communists in Hainan island. Bandits in Xinhui and Dongguan county. Pagoda to be built in the Huanghuagang. Harvest in Zhongshan county. | China |
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]);