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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 56308 | 56308 | 1936-10-03 | 3 | d | Japanese execute Soviet Russian soldiers. | Russia | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 56315 | 56315 | 1936-10-03 | 8 | c | The bloody revolutionary movement in Spain. | 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 | |
| 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]);