This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51408 | 51408 | 1932-04-16 | 2 | c | Wang Jingwei on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51409 | 51409 | 1932-04-16 | 2 | c | Number of casualties of the 19th Route Army during their fighting with Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51410 | 51410 | 1932-04-16 | 2 | d | Why Japanese troops are withdrawing from Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51411 | 51411 | 1932-04-16 | 2 | d | The Nationalist government in Nanjing refuses to recognise the Manchuria state. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51412 | 51412 | 1932-04-16 | 2 | e | Wounded soldiers on their way to the front after recovery. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51413 | 51413 | 1932-04-16 | 2 | e | Resistance to the Japanese invasion in Manchuria. Refugees near Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51414 | 51414 | 1932-04-16 | 3 | a | Investigators of the League of Nations in Shanghai and their work. | China | http://trove.nla.gov.au/newspaper/page/24090767 | 24090767 | |
51415 | 51415 | 1932-04-16 | 3 | d | Wu Tiecheng delivers a speech in Huamao Hotel in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090767 | 24090767 | |
51416 | 51416 | 1932-04-16 | 3 | e | The Second Session of the Nanjing government on the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090767 | 24090767 | |
51417 | 51417 | 1932-04-16 | 3 | e | More than 600 Chinese disappear during the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090767 | 24090767 | |
51420 | 51420 | 1932-04-16 | 5 | c | Traitors in Shenyang during the national crisis. | China | http://trove.nla.gov.au/newspaper/page/24090769 | 24090769 | |
51421 | 51421 | 1932-04-16 | 5 | d | Chinese government rebuffs the ultimate of Japan. | China | http://trove.nla.gov.au/newspaper/page/24090769 | 24090769 | |
51425 | 51425 | 1932-04-16 | 6 | b | Guangdong news/ Luo Zhuoying wins victory against the Communist troops in Jiangxi province. A letter from the ambulance corps in Shanghai. Fund-raising in Guangzhou for the war of resistance to Japanese invasion. Police office in Guangzhou is bombed. Loss of the 19th Route Army. Air force prepares for night flight. Zhang Fakui leads his troops leave Quanzhou. Survey on the self-defence weapons in the south counties of Guangdong. Taishan county magistrate raises funds. Clan fighting brewed in Xinhui county. Taishan people mourns death of their natives in the Shanghai battle with Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090772 | 24090772 | |
51426 | 51426 | 1932-04-16 | 7 | a | Wang Zhaoming reports the reply to Japan's ultimate. | China | http://trove.nla.gov.au/newspaper/page/24090771 | 24090771 | |
51427 | 51427 | 1932-04-16 | 7 | b | The Commercial Press (shang wu yi shu guan) in Shanghai is bombed. | China | http://trove.nla.gov.au/newspaper/page/24090771 | 24090771 | |
51428 | 51428 | 1932-04-16 | 7 | c | Foreign report on the retreat of Chinese troops from Shanghai after the battle with Japanese army. Japanese troops want to occupy Shanghai forever. | China | http://trove.nla.gov.au/newspaper/page/24090771 | 24090771 | |
51429 | 51429 | 1932-04-16 | 8 | a | Recent relations between Russia and Japan. | China | http://trove.nla.gov.au/newspaper/page/24090774 | 24090774 | |
51431 | 51431 | 1932-04-16 | 8 | a | Peace talks between China and Japan halts again. | China | http://trove.nla.gov.au/newspaper/page/24090774 | 24090774 | |
51436 | 51436 | 1932-04-16 | 8 | b | Peace talks between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24090774 | 24090774 | |
51437 | 51437 | 1932-04-16 | 8 | b | Representatives of the League of Nations arrive Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090774 | 24090774 |
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]);