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 |
---|---|---|---|---|---|---|---|---|---|
53067 | 53067 | 1933-07-15 | 2 | a | Editorial on the future of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091294 | 24091294 | |
53072 | 53072 | 1933-07-15 | 3 | a | Crisis in north China following Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53073 | 53073 | 1933-07-15 | 3 | a | Central government in Nanjing to deal with Feng Yuxiang by force. | China | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53079 | 53079 | 1933-07-15 | 5 | a | Story of Chinese general Ma Zhanshan and Su Bingwen. | China | http://trove.nla.gov.au/newspaper/page/24091295 | 24091295 | |
53083 | 53083 | 1933-07-15 | 5 | a | A notice issued by the Zengcheng lian fu tang in Sydney on the transfer of remains of Chinese fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091295 | 24091295 | |
53084 | 53084 | 1933-07-15 | 7-8 | a-f | Guangdong news/ Cai Tingkai leads his troops back to Guangdong. Oppositions to the loans from America. Jiang Jieshi's envoy Zhang Mianzhong arrives Guangzhou. Chen Jitang orders to teach Filial Classics (xiao jing). Six warplanes arrive Guangzhou. Floods in local Guangdong. Japanese fishing boats invade Nan'ao county and the loss of Chinese territory. Army commander Xiang Hanpin promotes horse carriages. Fire in Huiyang county. Preparation for the establishment of provincial bank of agriculture and commerce. | China | http://trove.nla.gov.au/newspaper/page/24091297 | 24091297 | |
53074 | 53074 | 1933-07-15 | 3 | b | Chinese government secures loans from America. | America | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53085 | 53085 | 1933-07-15 | 6 | b | Trade between Australia and China, in particular of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091298 | 24091298 | |
53068 | 53068 | 1933-07-15 | 2 | c | Wang Jingwei on the truce with Japanese and how to save China. | China | http://trove.nla.gov.au/newspaper/page/24091294 | 24091294 | |
53075 | 53075 | 1933-07-15 | 3 | c | Japanese encourages independence movement in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53080 | 53080 | 1933-07-15 | 5 | c | Japanese economic invasion after the truce signed. | China | http://trove.nla.gov.au/newspaper/page/24091295 | 24091295 | |
53086 | 53086 | 1933-07-15 | 6 | c | Russia signs nonaggression pacts with Romania, Czech Slovakia, Turkey and other countries. | Britain | http://trove.nla.gov.au/newspaper/page/24091298 | 24091298 | |
53069 | 53069 | 1933-07-15 | 2 | d | Youth Party Leader Zeng Qin on their attitude towards Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091294 | 24091294 | |
53076 | 53076 | 1933-07-15 | 3 | d | Japanese immigrants in Manchuria and the inland of China. | China | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53077 | 53077 | 1933-07-15 | 3 | d | Ma Zhanshan and Su Bingwen arrive Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53087 | 53087 | 1933-07-15 | 6 | d | A British missionary on the Manchurian issues. | Britain | http://trove.nla.gov.au/newspaper/page/24091298 | 24091298 | |
53070 | 53070 | 1933-07-15 | 2 | e | Another report on the truce between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091294 | 24091294 | |
53078 | 53078 | 1933-07-15 | 3 | e | Wu Tiecheng suppresses anti-Japanese movement. | China | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53081 | 53081 | 1933-07-15 | 5 | e | Poems to the Chinese graves written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091295 | 24091295 | |
53082 | 53082 | 1933-07-15 | 5 | e | Chinese communities in Dunedin, Auckland of New Zealand and Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091295 | 24091295 | |
53088 | 53088 | 1933-07-15 | 6 | e | Australia news/ The development plan for Northern Territory. Chinese shop robbed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091298 | 24091298 | |
53071 | 53071 | 1933-07-15 | 2 | f | Luo Wengan resigns as Chinese foreign minister and to be replaced by Huang Fu. | China | http://trove.nla.gov.au/newspaper/page/24091294 | 24091294 |
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]);