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 |
---|---|---|---|---|---|---|---|---|---|
52204 | 52204 | 1932-11-19 | 2 | c | Japanese planes shot down in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52206 | 52206 | 1932-11-19 | 2 | d | Properties of Chen Guohui are confiscated in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52207 | 52207 | 1932-11-19 | 2 | e | A great union of the Han and Mongolian people in Manchurian mountains. | China | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52208 | 52208 | 1932-11-19 | 2 | f | Chinese Communist leader Chen Duxiu is arrested in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52209 | 52209 | 1932-11-19 | 2 | g | Zhang Xueliang talks to journalists about the report of the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52210 | 52210 | 1932-11-19 | 2 | g | Tang Juwu fights in Chaoyang, Liaoning province. Plainclothes units of the Chinese army in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52211 | 52211 | 1932-11-19 | 3 | a | A circular telegram issued by Wang Delin, general commander in Jilin province, to the Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24091023 | 24091023 | |
52212 | 52212 | 1932-11-19 | 3 | c | The Wuhan government under Jiang Jieshi issues land regulations. | China | http://trove.nla.gov.au/newspaper/page/24091023 | 24091023 | |
52213 | 52213 | 1932-11-19 | 3 | d | Envoy of German people arrives Shanghai for a visit. | China | http://trove.nla.gov.au/newspaper/page/24091023 | 24091023 | |
52214 | 52214 | 1932-11-19 | 3 | f | First part of a circular telegram issued by Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24091023 | 24091023 | |
52215 | 52215 | 1932-11-19 | 5 | a | Fourth and final part of abstract of the report prepared by delegation of the League of Nations on the future of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091026 | 24091026 | |
52218 | 52218 | 1932-11-19 | 6-7 | a-f | Guangdong news/ The Southwest Executive Committee and the Political Commission urge to stop internal fighting in Sichuan and Shandong province. The 19th Route Army to organise an airforce unit and its plan. Chen Guohui is punished in Fujian province. Prospect of rice harvest in Guangdong. Electricity supply to be completed for the Zhujiang River bridge. The whereabouts of Xiao Lin. New three-year plan for the expansion of airforce troops. Jiang Guanglai brings his family to Fujian province. Fishing industry in Chaozhou and Shantou. Mining resources in Chaozhou and Meixian county. Strong wind in Haikang county and the damages. Gaoyao county authority reforms the old marriage custom. Zhou Zhizheng punishes robbers on his way home in Shunde county. Clan tragedy in Zengcheng county while fighting for the ancestral properties. | China | http://trove.nla.gov.au/newspaper/page/24091028 | 24091028 | |
52222 | 52222 | 1932-11-19 | 8 | b | Chinese armies in Manchuria and their fighting of Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 |
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]);