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 |
---|---|---|---|---|---|---|---|---|---|
46065 | 46065 | 1927-08-20 | 2 | e | Zhang Zuolin issues a declaration. | 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 | |
46066 | 46066 | 1927-08-20 | 2 | e | Zhang Zuochang recruits 5,000 Russian soldiers. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
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 | |
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 | |
46059 | 46059 | 1927-08-20 | 2 | b | Tung Wah Times comments on China's diplomacy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46070 | 46070 | 1927-08-20 | 3 | c | The South China Morning Post in Hong Kong comments on Japan's China policy. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098495 | 24098495 | |
46082 | 46082 | 1927-08-20 | 7 | b | Storm in France and the damages. | France | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 | |
46086 | 46086 | 1927-08-20 | 7 | c | Stories of Borodin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 | |
46083 | 46083 | 1927-08-20 | 7 | b | Riots in Ukraine. | France | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 | |
46074 | 46074 | 1927-08-20 | 5 | a | Riots in Bolivia, South America. | America | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46073 | 46073 | 1927-08-20 | 5 | a | Railway workers on strike in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
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 | |
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 | |
46084 | 46084 | 1927-08-20 | 7 | b | Portuguese government deport political criminals. | Other... | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 | |
46075 | 46075 | 1927-08-20 | 5 | b | Political chaos in Portugal. | Other... | 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 | |
46079 | 46079 | 1927-08-20 | 5 | d | Jiang Jieshi steps down. | China | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
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 | |
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 | |||
46062 | 46062 | 1927-08-20 | 2 | d | Floods in Jingxian county, south Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46072 | 46072 | 1927-08-20 | 5 | a | Epidemic disease in Soviet Russia. Soviet advisers are leaving China. | Other... | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46060 | 46060 | 1927-08-20 | 2 | c | Envoy of French government arrives Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46061 | 46061 | 1927-08-20 | 2 | c | Chinese students in America and their nationalism. | America | 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 | |
46076 | 46076 | 1927-08-20 | 5 | b | Britain to build big warship. | Britain | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46081 | 46081 | 1927-08-20 | 7 | a | Australia news/ Chinese truck driver is wanted for an interview after an accident in Sydney. A young girl in Melbourne is poisoned to death. Japanese football team has a match in Victoria. Fire on passenger liner Taiping. A strange life case in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 | |
46080 | 46080 | 1927-08-20 | 7 | a | Advertisement for The Sun company in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 |
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]);