This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50964 | 50964 | 1931-12-19 | 2 | c | Ma Zhanshan, chairman of the Heilongjiang provincial government, fight Japanese invaders. Donations to the Heilongjiang army. Detailed report on Ma Zhanshan's resistance to Japanese. Japanese in Tianjin contribute to the invasion. | China | http://trove.nla.gov.au/newspaper/page/24090637 | 24090637 | |
50965 | 50965 | 1931-12-19 | 2 | f | Floods in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090637 | 24090637 | |
50966 | 50966 | 1931-12-19 | 3 | a | Ma Zhanshan reports his resistance to Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090636 | 24090636 | |
50967 | 50967 | 1931-12-19 | 3 | b | Zhang Fakui requests to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090636 | 24090636 | |
50968 | 50968 | 1931-12-19 | 3 | c | Japanese government requests all Japanese ships in China to stop. | China | http://trove.nla.gov.au/newspaper/page/24090636 | 24090636 | |
50969 | 50969 | 1931-12-19 | 3 | c | Japanese troops land in Fuzhou, of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090636 | 24090636 | |
50970 | 50970 | 1931-12-19 | 3 | d | Price of Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090636 | 24090636 | |
50971 | 50971 | 1931-12-19 | 3 | d | The Yangtze River area sees a coal shortage after the fall of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090636 | 24090636 | |
50972 | 50972 | 1931-12-19 | 3 | e | Whereabouts of Wu Peifu. Demonstrations of school teachers and students in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090636 | 24090636 | |
50974 | 50974 | 1931-12-19 | 5 | a-c | Demonstrations in China (of merchants, industrialists, professors, bankers and others) against the dictatorship of Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24090638 | 24090638 | |
50975 | 50975 | 1931-12-19 | 5 | d | Excuse of Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090638 | 24090638 | |
50977 | 50977 | 1931-12-19 | 6 | c | Guangdong news/ Bao Mingling, secretary of the foreign ministry of the Nanjing government, is under investigation for misconduct. The Communist troops enter Longyan of Fujian province from Guangdong. Huang Shaoxiong is leaving Shanghai. Preparation for the Fourth Session of Plenary in Guangzhou. The cement factory in the south suburb of Guangzhou resume production. Hu Hanmin returns to Guangdong. Defence in Humen. | China | http://trove.nla.gov.au/newspaper/page/24090641 | 24090641 | |
50978 | 50978 | 1931-12-19 | 7 | a | Japanese war planes twice bomb Jinzhou, of Liaoning province, and the second part of a survey on the casualties. | China | http://trove.nla.gov.au/newspaper/page/24090640 | 24090640 | |
50979 | 50979 | 1931-12-19 | 7 | b | Records of Japanese invasion of Manchuria and the fall of 25 cities. | China | http://trove.nla.gov.au/newspaper/page/24090640 | 24090640 | |
50983 | 50983 | 1931-12-19 | 8 | a | Demonstration of students in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090643 | 24090643 | |
50987 | 50987 | 1931-12-19 | 8 | b | Japanese troops in Manchuria. Zhang Xueliang rebuffs rumours. | China | http://trove.nla.gov.au/newspaper/page/24090643 | 24090643 | |
50988 | 50988 | 1931-12-19 | 8 | c | Jiang Jieshi resigns once again. | China | http://trove.nla.gov.au/newspaper/page/24090643 | 24090643 | |
50990 | 50990 | 1931-12-19 | 8 | d | Jiang Jieshi still in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090643 | 24090643 | |
50991 | 50991 | 1931-12-19 | 8 | d | Battle between Chinese civilians and Japanese troops in the south of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090643 | 24090643 |
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]);