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 |
---|---|---|---|---|---|---|---|---|---|
50600 | 50600 | 1931-08-15 | 2 | b | Editorial by Tung Wah Times on the domestic troubles and foreign invasions of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090487 | 24090487 | |
50601 | 50601 | 1931-08-15 | 2 | c | Japanese police shoot Chinese farmers in Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24090487 | 24090487 | |
50602 | 50602 | 1931-08-15 | 2 | d | Korean people murder Chinese immigrants in Korea and the report. Chinese nationals are fleeing Korea. Chinese consulate in Korea is set on fire. Japan has different opinions towards the anti-Chinese movement in Korea. And other report on the anti-Chinese movement in Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24090487 | 24090487 | |
50603 | 50603 | 1931-08-15 | 2 | f | Song Qingling invites Hu Hanmin to come to France for a rest. | China | http://trove.nla.gov.au/newspaper/page/24090487 | 24090487 | |
50604 | 50604 | 1931-08-15 | 3 | a | Atrocities of Japanese police in Jilin province, Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50605 | 50605 | 1931-08-15 | 3 | b | Returned Chinese from Korea present their petition to the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50606 | 50606 | 1931-08-15 | 3 | d | Chinese Communist troops loot Jianning, of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50607 | 50607 | 1931-08-15 | 3 | e | Floods in Fuzhou, capital of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50608 | 50608 | 1931-08-15 | 5 | a | Hong Kong news/ Chinese man Hu Zongde, who returns from America, is robbed in Hong Kong. Hong Kong government to ban prostitution and the preparation. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090488 | 24090488 | |
50609 | 50609 | 1931-08-15 | 5 | c | Virgin girls refuses to marry and her advertisement. Make fun of a tutor in the private school. Different names for bride. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090488 | 24090488 | |
50610 | 50610 | 1931-08-15 | 5 | e | Notice issued by the Chinese Consulate-General in Sydney and the Consulate in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090488 | 24090488 | |
50611 | 50611 | 1931-08-15 | 6 | a | Notice issued by the Chinese Consulate-General in Sydney on the government pension paid to the old Chinese people in Queensland with contact details: D. Monchin Lum (Lin Wenchuan), of Kwong Sang, Toowoomba, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090491 | 24090491 | |
50612 | 50612 | 1931-08-15 | 6-7 | a-d | Guangdong news/ Survey on the disasters in Sihui, Panyu, Gaoming and other areas. Relief work in the disastrous area. Commercial chamber unable to sell the military bonds. Obstacles to the opium ban in local counties. Relief work in the disastrous areas. Bandits in Panyu, Shunde and Zhongshan counties. Car drivers in Zhongshan on strike. Taishan county builds a rehabilitation centre. Butchers in Kaiping county request to abolish factory of animal manslaughtering. Road projects in Gaoyao. | China | http://trove.nla.gov.au/newspaper/page/24090491 | 24090491 | |
50613 | 50613 | 1931-08-15 | 8 | b | Shi Yousan leads his defeated troops to Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50614 | 50614 | 1931-08-15 | 8 | b | Ms Johnson arrives Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50615 | 50615 | 1931-08-15 | 8 | b | Train bombed in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50616 | 50616 | 1931-08-15 | 8 | b | Foreign immigrants are leaving America. | America | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50617 | 50617 | 1931-08-15 | 8 | b | Cuba authority destroys enemy's office. | America | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50618 | 50618 | 1931-08-15 | 8 | b | Police fight communists in Prussia. | Britain | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50619 | 50619 | 1931-08-15 | 8 | c | Yan Xishan returns to Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50620 | 50620 | 1931-08-15 | 8 | c | The Yangtze River is flooding. | China | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50621 | 50621 | 1931-08-15 | 8 | c | Martial law enforced in Berlin. | Britain | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50622 | 50622 | 1931-08-15 | 8 | c | Hurricane in Japan and the injuries. | Japan | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50623 | 50623 | 1931-08-15 | 8 | c | Another bomb explosion in India. | Other... | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50624 | 50624 | 1931-08-15 | 8 | c | Australia news/ NSW state government borrows more loans. Astronomical observatory in Sydney predicts another earthquake. Federal treasurer delivers a budget report. Huge amount of money found in a Sydney park. Chinese government appoints new consul to Melbourne. A train collision in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50625 | 50625 | 1931-08-15 | 8 | e | The Chinese Chamber of Commerce calls for donations to the disastrous areas in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 |
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]);