This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52153 | 52153 | 1932-11-05 | 8 | a | The 19th Route Army takes over Longyan, of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52154 | 52154 | 1932-11-05 | 8 | a | Chinese people donate to the volunteer armies in Manchuria for their fighting of Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52155 | 52155 | 1932-11-05 | 8 | a | Overseas Chinese Commission in Nanjing publicises donations from overseas Chinese communities to the war of resistance. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52156 | 52156 | 1932-11-05 | 8 | a | Chinese volunteer armies in Manchuria and their fighting. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52157 | 52157 | 1932-11-05 | 8 | b | British Foreign Secretary reports current situations in China. | Britain | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52158 | 52158 | 1932-11-05 | 8 | b | Generals Ma Zhanshan, Su Bingwen and Tang Juwu report their victories. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52159 | 52159 | 1932-11-05 | 8 | b | Jiang Jieshi orders Han Fuqu to stop internal fighting. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52160 | 52160 | 1932-11-05 | 8 | c | The war in Sichuan province between Liu Xiang and Liu Wenhui. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52161 | 52161 | 1932-11-05 | 8 | c | American government refuse to send delegate to the conference of League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52162 | 52162 | 1932-11-05 | 8 | c | Japan and Russia to sign a nonaggression pact. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52163 | 52163 | 1932-11-05 | 8 | d | Speech by German member of the delegation of League of Nations on the Chinese situations. | Germany | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52164 | 52164 | 1932-11-05 | 8 | d | Han Fuqu follows orders and stops the battle with Liu Zhennian. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52165 | 52165 | 1932-11-05 | 8 | e | Tang Yulin reports that Japanese are seeking to occupy Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52166 | 52166 | 1932-11-05 | 8 | e | The communist troops under Mao Zedong take over Shaowu county of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52167 | 52167 | 1932-11-05 | 8 | e | Provincial governments of Canada to sell wheat to China. | Canada | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52168 | 52168 | 1932-11-05 | 8 | f | General Su Bingwen in Manchuria releases Japanese POWs. | Russia | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52169 | 52169 | 1932-11-05 | 8 | f | Shanghai municipal government to rebuild Zhabei district. | China | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52170 | 52170 | 1932-11-05 | 8 | g | British foreign secretary on the open-door policy in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52171 | 52171 | 1932-11-05 | 8 | g | Australia news/ Another case of suicide on the Sydney Harbour Bridge. A meeting of state premiers in Melbourne promotes agricultural development. An industrial association in Melbourne keen to promote the trade between Australia and the Far East. An used-car dealer in Sydney is penalised for tax evasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 |
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]);