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 |
---|---|---|---|---|---|---|---|---|---|
52713 | 52713 | 1933-04-01 | 2 | c | A recent talks by Song Ziwen. Yan Xishan to help Zhang Xueliang. Tianjin in crisis. People in Beijing donate to purchase warplanes. The 19th Route Army ready to go north. Japanese naval fleet gather in Shanghai, Nanjing and Wuhan. Nanjing has a cold winter. | China | http://trove.nla.gov.au/newspaper/page/24091172 | 24091172 | |
52714 | 52714 | 1933-04-01 | 3 | a | The war in north China between Chinese and Japanese armies. | China | http://trove.nla.gov.au/newspaper/page/24091171 | 24091171 | |
52715 | 52715 | 1933-04-01 | 3 | d | Russian government is closely watching the war in Rehe, north China. | China | http://trove.nla.gov.au/newspaper/page/24091171 | 24091171 | |
52718 | 52718 | 1933-04-01 | 3 | e | Russian ship arrives Shanghai after the resumption of diplomatic relations. | China | http://trove.nla.gov.au/newspaper/page/24091171 | 24091171 | |
52720 | 52720 | 1933-04-01 | 3 | f | Associations in Beijing urge Jiang Jieshi to come north. | China | http://trove.nla.gov.au/newspaper/page/24091171 | 24091171 | |
52721 | 52721 | 1933-04-01 | 3 | f | Feng Yuxiang and his life recently. Bandits in Shanghai demand ransom from Song Qingling. Wong Zhaoyuan to go to Rehe. | China | http://trove.nla.gov.au/newspaper/page/24091171 | 24091171 | |
52723 | 52723 | 1933-04-01 | 5 | b | Poems by Chinese general Su Bingwen. | China | http://trove.nla.gov.au/newspaper/page/24091173 | 24091173 | |
52725 | 52725 | 1933-04-01 | 7-8 | a-f | Guangdong news/ Situation in Guangdong since the war breaks up in Rehe, north China. China and Japan have entered a period of military conflict. Methods to donate to the Chinese armies in Guangzhou. Guangzhou speeds its air defence plan. Municipal authority to ban prostitution. Yu Hanmou vows to fight Japanese invaders. Representatives of Yunnan, Guizhou and Hunan province meet special envoy of the central government. Overseas Chinese propaganda team to leave Guangzhou for the north soon. Troops mobilised in the southwest to fight Japanese invaders in the north. Police in Hong Kong arrest Japanese women who are involved in illegal massage. A normal school in Dongguan on strike. A family tragedy in Zengcheng. Bandits in Taishan and Panyu county. | China | http://trove.nla.gov.au/newspaper/page/24091175 | 24091175 | |
52726 | 52726 | 1933-04-01 | 6 | a | Chinese troops retreat from the Tianjin-Yuguan railway. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52727 | 52727 | 1933-04-01 | 6 | a | Japan and the puppet Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52728 | 52728 | 1933-04-01 | 6 | a | Japanese still seek to occupy more islands in the Pacific. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52731 | 52731 | 1933-04-01 | 6 | b | Split within the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52732 | 52732 | 1933-04-01 | 6 | b | Japan, Russia and the Manchurian state have a joint meeting. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52734 | 52734 | 1933-04-01 | 6 | d | Conflicts between warlords in China. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52735 | 52735 | 1933-04-01 | 6 | d | Japan to quit the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
52737 | 52737 | 1933-04-01 | 6 | e | The war in north China between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 |
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]);