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 |
---|---|---|---|---|---|---|---|---|---|
56306 | 56306 | 1936-10-03 | 3 | c | A notice issued by General Cai Tingkai on the rehabilitation of the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24097011 | 24097011 | |
56305 | 56305 | 1936-10-03 | 3 | a | Associations in Shanghai issue circular telegram to support the resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097011 | 24097011 | |
56317 | 56317 | 1936-10-03 | 8 | d | Attack on Japanese sailors in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56311 | 56311 | 1936-10-03 | 8 | a | Australia exports flour to Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56320 | 56320 | 1936-10-03 | 8 | g | Australia news/ Chinese market gardener is injured in Sydney. A white man is arrested in Sydney for smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56303 | 56303 | 1936-10-03 | 2 | c | China news/ Jiang Jieshi and Cai Tingkai jointly issue a declaration to rehabilitate the 19th Route Army. Japanese in Chengdu, of Sichuan province. New tariff regulations in Hebei province and the economic independence in north China. Liu Xiang issues a declaration to resist Japanese invasion and to save the nation. A Saving China Association organised in Nanning, Guangxi province. The Nanjing government issues a declaration on the Chengdu Incident, Sichuan province. Chinese in Spain are leaving due to the revolution crisis. | China | http://trove.nla.gov.au/newspaper/page/24097012 | 24097012 | |
56302 | 56302 | 1936-10-03 | 2 | b | Comments on the crisis in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097012 | 24097012 | |
56313 | 56313 | 1936-10-03 | 8 | b | Exercise of the Soviet Union army. | Britain | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56310 | 56310 | 1936-10-03 | 6-7 | a-d | Guangdong news/ Warplanes of the Nanjing government bomb Guilin and Liuzhou in Guangxi province. Jiang Jieshi's plan to fight the Guangxi army. Guangxi army in Beihai surrender to Jiang Jieshi. Guangdong financial authority on the currency exchange. Guangdong provincial government to ban gambling from September. Secret organisation in Guangzhou to fight Jiang Jieshi. Military conflict between Guangxi and the central government in Nanjing. General Cai Tingkai inspects Beihai in Guangxi province. Silver sales in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24097016 | 24097016 | |
56309 | 56309 | 1936-10-03 | 5 | c | Hitler and his supporters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097013 | 24097013 | |
56314 | 56314 | 1936-10-03 | 8 | b | Japanese economic invasion of south China. | Japan | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56308 | 56308 | 1936-10-03 | 3 | d | Japanese execute Soviet Russian soldiers. | Russia | http://trove.nla.gov.au/newspaper/page/24097011 | 24097011 | |
56318 | 56318 | 1936-10-03 | 8 | e | Japanese new demands from China. | Britain | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56316 | 56316 | 1936-10-03 | 8 | d | Japanese troops land in Beihai of Guangxi province. | Japan | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56319 | 56319 | 1936-10-03 | 8 | f | Relations between China and Japan deteriorate. | China | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56312 | 56312 | 1936-10-03 | 8 | a | Russian submarines gather in the Far East. | Japan | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56304 | 56304 | 1936-10-03 | 3 | a | The attitude of the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24097011 | 24097011 | |
56315 | 56315 | 1936-10-03 | 8 | c | The bloody revolutionary movement in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56307 | 56307 | 1936-10-03 | 3 | c | The military power of the Soviet Union. | France | http://trove.nla.gov.au/newspaper/page/24097011 | 24097011 |
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]);