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 |
---|---|---|---|---|---|---|---|---|---|
50619 | 50619 | 1931-08-15 | 8 | c | Yan Xishan returns to Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
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 | |
50615 | 50615 | 1931-08-15 | 8 | b | Train bombed in Germany. | Germany | 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 | |
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 | |
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 | |
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 | |
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 | |
50618 | 50618 | 1931-08-15 | 8 | b | Police fight communists in Prussia. | Britain | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
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 | |
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 | |
50614 | 50614 | 1931-08-15 | 8 | b | Ms Johnson arrives Tokyo. | Japan | 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 | |
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 | |
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 | |
50622 | 50622 | 1931-08-15 | 8 | c | Hurricane in Japan and the injuries. | Japan | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
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 | |
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 | |
50616 | 50616 | 1931-08-15 | 8 | b | Foreign immigrants are leaving America. | America | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50607 | 50607 | 1931-08-15 | 3 | e | Floods in Fuzhou, capital of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
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 | |
50617 | 50617 | 1931-08-15 | 8 | b | Cuba authority destroys enemy's office. | America | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
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 | |
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 | |
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 | |
50623 | 50623 | 1931-08-15 | 8 | c | Another bomb explosion in India. | Other... | 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]);