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 |
---|---|---|---|---|---|---|---|---|---|
46088 | 46088 | 1927-08-27 | 2 | b | Tung Wah Times on the change of political situations in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098504 | 24098504 | |
46089 | 46089 | 1927-08-27 | 2 | b-c | Conflict between the rightists and the leftists with the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24098504 | 24098504 | |
46090 | 46090 | 1927-08-27 | 2 | c | Chen Diaoyuan defects and the report from Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098504 | 24098504 | |
46091 | 46091 | 1927-08-27 | 2 | d | A survey on the troops under Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24098504 | 24098504 | |
46092 | 46092 | 1927-08-27 | 2 | f | Zhang Zuolin is trying to collect military provision. Zhang borrows foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24098504 | 24098504 | |
46093 | 46093 | 1927-08-27 | 2 | f | Zhang Xueliang in the eyes of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24098504 | 24098504 | |
46094 | 46094 | 1927-08-27 | 3 | b | Products of the munitions factory in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098503 | 24098503 | |
46095 | 46095 | 1927-08-27 | 3 | b | Zhang Zuolin's envoy signs agreement with Russian on the telephone communications. | China | http://trove.nla.gov.au/newspaper/page/24098503 | 24098503 | |
46096 | 46096 | 1927-08-27 | 3 | c | Feng Yuxiang and his recent military strategies. | China | http://trove.nla.gov.au/newspaper/page/24098503 | 24098503 | |
46097 | 46097 | 1927-08-27 | 3 | d | Long Yun is removed from Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24098503 | 24098503 | |
46098 | 46098 | 1927-08-27 | 3 | d | Brazil cancels the restrictions imposed upon Chinese immigrants. | Other... | http://trove.nla.gov.au/newspaper/page/24098503 | 24098503 | |
46099 | 46099 | 1927-08-27 | 3 | d | The Far East Bank is closed down in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098503 | 24098503 | |
46100 | 46100 | 1927-08-27 | 5 | a | Crisis in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46101 | 46101 | 1927-08-27 | 5 | a | Sun Chuanfang's troops occupy Yangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46102 | 46102 | 1927-08-27 | 5 | a | Local provincial governments in Italy present planes to the Prime Minister Benito Mussolini. | Other... | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46103 | 46103 | 1927-08-27 | 5 | b | Fire in France and the damages. | France | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46104 | 46104 | 1927-08-27 | 5 | b | Martial law enforced in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46105 | 46105 | 1927-08-27 | 5 | c | Robbery in Vladivostok. | Britain | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46106 | 46106 | 1927-08-27 | 5 | c | Rumours on riots in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46107 | 46107 | 1927-08-27 | 5 | c | Foreign powers on the change in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46108 | 46108 | 1927-08-27 | 5 | c | Possible comprise between Feng Yuxiang and Sun Chuanfang. | China | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46109 | 46109 | 1927-08-27 | 5 | c | The Nationalist Government authorities move from Wuhan to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46110 | 46110 | 1927-08-27 | 7 | a | Australia news/ A Chinese dies in an accident in Melbourne. A family of five are murdered in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24098507 | 24098507 | |
46111 | 46111 | 1927-08-27 | 7 | a | Leader of the Nationalist party in Egypt dies. | Other... | http://trove.nla.gov.au/newspaper/page/24098507 | 24098507 | |
46112 | 46112 | 1927-08-27 | 7 | b | Storm in Macao. | Other... | http://trove.nla.gov.au/newspaper/page/24098507 | 24098507 | |
46113 | 46113 | 1927-08-27 | 7 | b | Bandits Red Gun Society in Henan. | China | http://trove.nla.gov.au/newspaper/page/24098507 | 24098507 | |
46114 | 46114 | 1927-08-27 | 7 | c | Beggar is appointed military officer in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098507 | 24098507 | |
46115 | 46115 | 1927-08-27 | 9 | a-d | Guangdong news/ Military conflict in Xinhui county. Bandits in Zengcheng county. Zhu Jiahua suggests to ban opium thoroughly. Ferries support the boycott to Japanese goods. Boycott to Japanese goods in Wuzhou, Guangxi. Hunan people suffer from the Communists. New houses to be built for the strikers. Vietnamese government proposes to stop trade of Chinese medicine. Reorganisation of the provincial government. Gan Naiguan is returning to Guangdong. Qian Dajun returns to Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098510 | 24098510 |
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]);