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 |
---|---|---|---|---|---|---|---|---|---|
45235 | 45235 | 1926-10-16 | 8 | a-d | Guangdong news/ Report on the strike and labour movement in Guangzhou. Railway managers changed. Employees of The Sincere Company in Guangzhou on strike and the report. Whereabouts of Wei Bangping. The Guangzhou government and its attitude toward Britain. More commuters between Guangzhou and Hong Kong. Floods in Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24101750 | 24101750 | |
45234 | 45234 | 1926-10-16 | 7 | c-d | News on the war in China between the south and the north. News on the strike in Guangzhou and Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24101747 | 24101747 | |
45233 | 45233 | 1926-10-16 | 7 | b | The fall of Jiujiang in Jiangxi province and Wuchang in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101747 | 24101747 | |
45232 | 45232 | 1926-10-16 | 7 | a-b | Australia news/ Smuggled opium seized in Melbourne. Russian refugees escape to Australia. Bathroom is compulsory for residential house. Chinese community in Sydney celebrates the National Day on October 10 and speakers include Wu Zhaoquan, Zhao Zhongguang, Chen Xiafu, Liu Guangfu, Guo Jianying, Pan Yonghan, Zheng Fanchang, and Li Run, Ling Shu'an (Ying). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101747 | 24101747 | |
45231 | 45231 | 1926-10-16 | 6 | c-d | Chinese businessmen in the Philippines fight for their own rights. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101748 | 24101748 | |
45230 | 45230 | 1926-10-16 | 6 | b | Chinese community in Java fights for equal treatment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101748 | 24101748 | |
45229 | 45229 | 1926-10-16 | 6 | a-b | Wu Peifu is defeated in Hanyang and the detailed report. | China | http://trove.nla.gov.au/newspaper/page/24101748 | 24101748 | |
45228 | 45228 | 1926-10-16 | 5 | c | Rumours on the war between China and Japan in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24101745 | 24101745 | |
45227 | 45227 | 1926-10-16 | 5 | a-c | Miscellaneous report on the war in China between the north and the south. | China | http://trove.nla.gov.au/newspaper/page/24101745 | 24101745 | |
45226 | 45226 | 1926-10-16 | 3 | f | Japan, Soviet Russia and the problem of north Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24101743 | 24101743 | |
45225 | 45225 | 1926-10-16 | 3 | e | Japan supports the withdrawal of extraterritoriality from China. | Japan | http://trove.nla.gov.au/newspaper/page/24101743 | 24101743 | |
45224 | 45224 | 1926-10-16 | 3 | e | Anticommunist association in Shanghai issues a circular telegram that condemns the Guangzhou government. | China | http://trove.nla.gov.au/newspaper/page/24101743 | 24101743 | |
45223 | 45223 | 1926-10-16 | 3 | d | Zhang Zongchang, Chu Yupu, Wu Peifu and Zhang Zuolin to jointly wipe out the communists. | China | http://trove.nla.gov.au/newspaper/page/24101743 | 24101743 | |
45222 | 45222 | 1926-10-16 | 3 | d | Negotiation between commercial chambers and army commander in Wuhan before the fall of this city. | China | http://trove.nla.gov.au/newspaper/page/24101743 | 24101743 | |
45221 | 45221 | 1926-10-16 | 2 | e | Clash between British warships and Yang Sen's troops in Wanxian, of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101744 | 24101744 | |
45220 | 45220 | 1926-10-16 | 2 | d | Sun Chuanfang's circular telegram to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24101744 | 24101744 | |
45219 | 45219 | 1926-10-16 | 2 | c-d | Article selected from a China newspaper on the peace movement in China. | China | http://trove.nla.gov.au/newspaper/page/24101744 | 24101744 |
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]);