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 |
---|---|---|---|---|---|---|---|---|---|
46409 | 46409 | 1927-11-12 | 2 | b | Editorial by Tung Wah Times on the bandits in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46410 | 46410 | 1927-11-12 | 2 | b | Mei Lanfang in Beijing is robbed and Zhang Hanju is murdered. | China | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46411 | 46411 | 1927-11-12 | 2 | c | Wu Peifu in Sichuan province and the report. | China | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46412 | 46412 | 1927-11-12 | 2 | d | China and Japan have stopped their negotiation over the railways in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46413 | 46413 | 1927-11-12 | 2 | e | Japan seeks to set up another consulate in Manchuria, the issues of Korea, and the talks with China. | China | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46414 | 46414 | 1927-11-12 | 2 | f | Song Qingling visits Soviet Russia and the welcome ceremony. | China | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46415 | 46415 | 1927-11-12 | 3 | b | Buddhism and arts in Wutaishan Mountain, Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24098591 | 24098591 | |
46416 | 46416 | 1927-11-12 | 3 | c | Wu Peifu and his activities in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24098591 | 24098591 | |
46417 | 46417 | 1927-11-12 | 3 | d | Proposal for the reform of village administration. | China | http://trove.nla.gov.au/newspaper/page/24098591 | 24098591 | |
46418 | 46418 | 1927-11-12 | 3 | d | Bandits in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24098591 | 24098591 | |
46419 | 46419 | 1927-11-12 | 3 | e | Yan Xishan issues telegram to condemn Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098591 | 24098591 | |
46420 | 46420 | 1927-11-12 | 5 | a | The Sun Club in Berlin and their naked sunbath. | Germany | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46421 | 46421 | 1927-11-12 | 5 | a | Soldiers of the Nationalist government ask for payment of their salary. The Communist forces occupy Yixing, Jiangsu province. A British woman is injured in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46422 | 46422 | 1927-11-12 | 5 | a-b | Japanese administration in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46423 | 46423 | 1927-11-12 | 5 | b | Japan wants to delay its talks with China over the Manchurian issues. | Japan | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46424 | 46424 | 1927-11-12 | 5 | b | Wang Jingwei returns to Guangzhou. Women guests crushed to death in a Shanghai restaurant on a false fire alarm. Security for the celebration of October Revolution at the Soviet Russian consulate in Shanghai. News on the war between Yan Xishan (Shanxi) and Zhang Zuolin (Fengxi). | China | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46425 | 46425 | 1927-11-12 | 7 | a | Australia news/ Captain of Dutch liner Almkerk is penalised in Freemantle, Western Australia, for illegal immigrants. Sailors found epidemic disease on board of liner from Singapore on arrival in Sydney. Bandits rob shops in Newtown, Sydney. Ferry Greycliffe sinks in Sydney harbour after a collision with another ship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 | |
46426 | 46426 | 1927-11-12 | 7 | b | Floods in New England, America. | America | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 | |
46427 | 46427 | 1927-11-12 | 7 | b | Guangdong news/ Business in Foshan. Brief biography of Zou Minchu, acting treasurer of the provincial government. Sericulture in Zhongshan and Shunde county. Local security corps organised in Xinhui county. Land price in Zhongshan county. Vietnamese authority abolishes new regulations on Chinese medicine. | China | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 | |
46428 | 46428 | 1927-11-12 | 8 | a-d | Guangdong news/ Guangzhou commercial chambers request to ban cotton export. School teachers are being taught the Nationalist Party principle. Model forest in the Baiyun Mountain. Nuns and house maids to be liberated in Guangdong. Crops harvest in Xinhui county. Department stores in Guangzhou to employ female shop assistants. Zhang Fakui talks to foreign journalists. Rumours in Macao, Zhongshan and Shunde on women's breast. Ferries in Huizhou are hijacked. Clan fighting in Dongguan county. Chinese in America warn new Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24098598 | 24098598 |
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]);