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 |
---|---|---|---|---|---|---|---|---|---|
56304 | 56304 | 1936-10-03 | 3 | a | The attitude 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 | |
56311 | 56311 | 1936-10-03 | 8 | a | Australia exports flour to Manchuria. | Japan | 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 | |
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 | |
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 | |
56314 | 56314 | 1936-10-03 | 8 | b | Japanese economic invasion of south China. | Japan | 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 | |
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 | |
56307 | 56307 | 1936-10-03 | 3 | c | The military power of the Soviet Union. | France | http://trove.nla.gov.au/newspaper/page/24097011 | 24097011 | |
56309 | 56309 | 1936-10-03 | 5 | c | Hitler and his supporters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097013 | 24097013 | |
56315 | 56315 | 1936-10-03 | 8 | c | The bloody revolutionary movement in Spain. | Britain | 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 | |
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 | |
56317 | 56317 | 1936-10-03 | 8 | d | Attack on Japanese sailors in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097018 | 24097018 | |
56318 | 56318 | 1936-10-03 | 8 | e | Japanese new demands from China. | Britain | 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 | |
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 |
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]);