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 |
|---|---|---|---|---|---|---|---|---|---|
| 52452 | 52452 | 1933-01-28 | 2 | b | Editorial by the Tung Wah Times on the Rehe issues and the motive of Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52453 | 52453 | 1933-01-28 | 2 | c | Soviet Russian government on the resumption of diplomatic relations with China. | Russia | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52454 | 52454 | 1933-01-28 | 2 | c | Central authority orders Chinese troops in Rehe to fight Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52455 | 52455 | 1933-01-28 | 2 | d | Chinese Ministry of Industry to set up big factory in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52456 | 52456 | 1933-01-28 | 2 | d | Chen Guohui is executed in Fujian. Two Korean men are arrested in Changchun for assassination. Japanese encourage independence of Mongolia. Fortification along the Yangtze River. Li Guojie is sentenced to three years' imprisonment in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52457 | 52457 | 1933-01-28 | 2 | f | Russian people welcome Chinese national hero of fighting Japanese. | Russia | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52458 | 52458 | 1933-01-28 | 2 | f | Japanese plan to eliminate Chinese armies in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52459 | 52459 | 1933-01-28 | 2 | f | Liu Wenhui stops fighting in Sichuan. Traitors in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52460 | 52460 | 1933-01-28 | 3 | a | Japanese invasion of Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24091097 | 24091097 | |
| 52461 | 52461 | 1933-01-28 | 3 | a | Wu Zhihui and his plan to save China. | China | http://trove.nla.gov.au/newspaper/page/24091097 | 24091097 | |
| 52462 | 52462 | 1933-01-28 | 3 | b | Japanese government prepares for a war in China. | Japan | http://trove.nla.gov.au/newspaper/page/24091097 | 24091097 | |
| 52463 | 52463 | 1933-01-28 | 3 | b | Japanese troops gather in north China. | France | http://trove.nla.gov.au/newspaper/page/24091097 | 24091097 | |
| 52464 | 52464 | 1933-01-28 | 3 | c | New appointment of some key Party officials including Huang Shaoxiong, Shi Pu, Shao Yuanchong and Kong Xiangxi. | China | http://trove.nla.gov.au/newspaper/page/24091097 | 24091097 | |
| 52465 | 52465 | 1933-01-28 | 3 | c | Song Qingling, Cai Yuanpei, Yang Quan, Li Zhaohuan, Lin Yutang and others organise the Chinese Civil Rights Protection Alliance (zhongguo minquan baozhang tongmeng) in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091097 | 24091097 | |
| 52466 | 52466 | 1933-01-28 | 5 | a | A letter from Zhou Zhenlin to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
| 52467 | 52467 | 1933-01-28 | 5 | a | Italian volcanologist takes adventure for scientific research. | Other... | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
| 52468 | 52468 | 1933-01-28 | 5 | b | A woman in Chicago sleeps for nine months. | America | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
| 52469 | 52469 | 1933-01-28 | 5 | c | Chinese communist leader Li Lisan and his romance with Gong Niru in Russia. | China | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
| 52470 | 52470 | 1933-01-28 | 5 | d | Research on the manufacturing of robot. | Other... | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
| 52471 | 52471 | 1933-01-28 | 5 | e | Amorous poems found in the government offices in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
| 52472 | 52472 | 1933-01-28 | 6-7 | a-f | Guangdong news/ Japanese goods on the Hong Kong market. Yin Zhiling on the way to Manila to help set up a branch of Chinese aviation. The Saving China Association in Guangzhou searches Japanese goods. Zhang Zhiying detains Huang Shaotang, captain of warship Jianru. Poll tax on Chinese immigrants in Singapore. The population in Guangzhou. Disasters in Dianbai county this year. Doctor in Taishan county rapes patients. People in Zhongshan county sue their magistrate Tang Shaoyi. Zengcheng county authority stops clan fighting. Two men in Kaiping county fight for the bridegroom. Fire in Zhaoqing injures two people. Entertainment in Nanhai county leads to tragedy. Zhongshan county government impose special levies on luxurious goods and consumption. | China | http://trove.nla.gov.au/newspaper/page/24091102 | 24091102 | |
| 52473 | 52473 | 1933-01-28 | 8 | a | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52474 | 52474 | 1933-01-28 | 8 | a | Japan and Soviet Russia may resume their treaty talks. | Britain | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52475 | 52475 | 1933-01-28 | 8 | a | Small countries uphold justice at the conference of the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52476 | 52476 | 1933-01-28 | 8 | b | British foreign secretary and his work within one day. | Britain | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52477 | 52477 | 1933-01-28 | 8 | b | Many Japanese Communist Party members are arrested. | Japan | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52478 | 52478 | 1933-01-28 | 8 | b | Japanese government slightly changes its policy towards the League of Nations. | Japan | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52479 | 52479 | 1933-01-28 | 8 | c | Some small countries propose to convene an international peace conference. | Britain | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52480 | 52480 | 1933-01-28 | 8 | d | Former French prime minister on the Manchurian issues. | Britain | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52481 | 52481 | 1933-01-28 | 8 | d | China and Japan to have a big war. | China | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
| 52482 | 52482 | 1933-01-28 | 8 | e | Australia news/ Young Chinese man is arrested in Sydney for using counterfeit bank notes. China purchase Australian flour. Australian export to China increase dramatically. Young man in Sydney is charged with murder. A declaration issued by the Sydney Chinese Saving China Association on the anniversary of the 1.28 Incident of Shanghai. Smallpox discovered on aboard of the passenger liner Taiping. Australian naval officer talks in Melbourne about Japanese aggressive policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 |
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]);