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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
46073 | 46073 | 1927-08-20 | 5 | a | Railway workers on strike in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46074 | 46074 | 1927-08-20 | 5 | a | Riots in Bolivia, South America. | America | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46075 | 46075 | 1927-08-20 | 5 | b | Political chaos in Portugal. | Other... | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46076 | 46076 | 1927-08-20 | 5 | b | Britain to build big warship. | Britain | 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 | |
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 | |
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 | |
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 | |
46082 | 46082 | 1927-08-20 | 7 | b | Storm in France and the damages. | France | 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 | |
46084 | 46084 | 1927-08-20 | 7 | b | Portuguese government deport political criminals. | Other... | http://trove.nla.gov.au/newspaper/page/24098499 | 24098499 | |
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 | |
46086 | 46086 | 1927-08-20 | 7 | c | Stories of Borodin. | Tung Wah | 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]);