This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52351 | 52351 | 1932-12-24 | 2 | c | Zeng Qi sends telegram to the military commanders in Sichuan province which advises them to stop internal fighting. | China | http://trove.nla.gov.au/newspaper/page/24091066 | 24091066 | |
52352 | 52352 | 1932-12-24 | 2 | d | An appeal from the Chinese army commanders in Manchuria to the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24091066 | 24091066 | |
52355 | 52355 | 1932-12-24 | 2 | e | Japan and Soviet Russia fail to reach agreement on non-aggressive pact. | China | http://trove.nla.gov.au/newspaper/page/24091066 | 24091066 | |
52356 | 52356 | 1932-12-24 | 2 | f | Chinese armies in Manchuria and their fighting of Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091066 | 24091066 | |
52358 | 52358 | 1932-12-24 | 2 | f | Chinese troops in Liaoning and Rehe fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091066 | 24091066 | |
52359 | 52359 | 1932-12-24 | 2 | f | Japanese navy are building fortifications in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091066 | 24091066 | |
52360 | 52360 | 1932-12-24 | 2 | f | Puyi, emperor of the Manchurian state, marries a Japanese girl. | China | http://trove.nla.gov.au/newspaper/page/24091066 | 24091066 | |
52361 | 52361 | 1932-12-24 | 3 | a | Japanese report to the League of Nations on the Manchurian issues. | China | http://trove.nla.gov.au/newspaper/page/24091065 | 24091065 | |
52362 | 52362 | 1932-12-24 | 3 | a | A speech of Gu Weijun, representative of the Chinese government, to the League of Nations conference. | China | http://trove.nla.gov.au/newspaper/page/24091065 | 24091065 | |
52363 | 52363 | 1932-12-24 | 3 | b | Tram workers in Shanghai on strike. | China | http://trove.nla.gov.au/newspaper/page/24091065 | 24091065 | |
52365 | 52365 | 1932-12-24 | 3 | e | Orders issued by the Nanjing government to the troops in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24091065 | 24091065 | |
52367 | 52367 | 1932-12-24 | 5 | b | Memorial service held in Qinghai province for the sea. | China | http://trove.nla.gov.au/newspaper/page/24091067 | 24091067 | |
52369 | 52369 | 1932-12-24 | 6-7 | a-f | Guangdong news/ Anti-Chinese movement in Mexico. Execution of Li Lisheng and Yin Rong in Guangzhou for corruption. Li Xiangen on the road projects in Guangdong. A report on the Chinese troops in Manchuria. Cargo ships detained for their transportation of material assistance to the communists. A fire in Shantou and the tragedy. More than 100 villagers in Nanxiong are moving. Bandits in the Dongjiang area. A train derails in Ningyang. Woman commits suicide for her husband. A girl student defeats her teacher for poem writing. Accident at the Zhaoqing electricity supply office. Chamber of commerce in Zhongshan county promote Chinese products. Japanese goods burned in Dongguan county. Bandits in Taishan county. Bandits in Boluo county. | China | http://trove.nla.gov.au/newspaper/page/24091070 | 24091070 | |
52376 | 52376 | 1932-12-24 | 8 | c | Japanese troops attack the Chinese army in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091071 | 24091071 | |
52378 | 52378 | 1932-12-24 | 8 | d | Song Ziwen, Sun Ke, Wu Chaoshu, Chen Gongbo and others request the Nationalist government to fight and regain the lost territories. And the response of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24091071 | 24091071 |
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]);