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 |
---|---|---|---|---|---|---|---|---|---|
52799 | 52799 | 1933-04-29 | 2 | d | Jiang Jieshi's non-resistance policy to Japanese invasion and the social response. | China | http://trove.nla.gov.au/newspaper/page/24091204 | 24091204 | |
52800 | 52800 | 1933-04-29 | 2 | e | Bombs found in Zhang Xueliang's residence in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091204 | 24091204 | |
52801 | 52801 | 1933-04-29 | 3 | a | Japanese army invades fortifications in the south of Great Wall. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52802 | 52802 | 1933-04-29 | 3 | b | Japanese aid White Russian Party. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52803 | 52803 | 1933-04-29 | 3 | b | Song Ziwen on the trade treaty with Japan. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52804 | 52804 | 1933-04-29 | 3 | b | He Zhuguo retreats from north China following the orders. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52805 | 52805 | 1933-04-29 | 3 | c | Sun Dianying's troops gather in Guyuan. Yu Youren, Sun Ke and Dai Jitao on the unified administration of Chinese army and politics. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52807 | 52807 | 1933-04-29 | 3 | d | Chinese communities in Thailand and their life. Thailand government start policy of assimilation towards the Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52808 | 52808 | 1933-04-29 | 3 | e | A meeting of the Central government in Nanjing to save China and resist to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52809 | 52809 | 1933-04-29 | 3 | f | Li Liejun advocates transparent politics. | China | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
52810 | 52810 | 1933-04-29 | 5 | a | Battles in north China between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091206 | 24091206 | |
52814 | 52814 | 1933-04-29 | 7-8 | a-f | Guangdong news/ The Southwest authority discusses the plan to dispatch troops to fight Japanese invaders in the north. Hu Hanmin on the current situations. Zhu Qinglan reports the war in north China with Japanese invaders. Warplanes manufactured in Guangzhou. Local counties jointly save grains in Guangdong. Government employees required to wear clothes made from local fabrics. Cai Tingkai accepts warplanes donated by American Chinese communities. Silk industry in Guangdong. Epidemic in the Dongjiang area. | China | http://trove.nla.gov.au/newspaper/page/24091207 | 24091207 | |
52815 | 52815 | 1933-04-29 | 6 | a | Aggression of Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52816 | 52816 | 1933-04-29 | 6 | b | Japan and Russia may break off due to the disputes over the railway management. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52818 | 52818 | 1933-04-29 | 6 | c | Crisis in Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 | |
52822 | 52822 | 1933-04-29 | 6 | d | Japanese seek to organise another puppet government in north China. | China | http://trove.nla.gov.au/newspaper/page/24091208 | 24091208 |
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]);