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 |
---|---|---|---|---|---|---|---|---|---|
53089 | 53089 | 1933-07-22 | 2 | a | Editorial further comments on the future of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53095 | 53095 | 1933-07-22 | 3 | a | Japanese invasion of China and their cost. | China | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53100 | 53100 | 1933-07-22 | 5 | a | Japan's Indo-China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24091303 | 24091303 | |
53105 | 53105 | 1933-07-22 | 6 | a | Population increase in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091306 | 24091306 | |
53106 | 53106 | 1933-07-22 | 6 | a | Japanese naval fleets and its development plan. | Japan | http://trove.nla.gov.au/newspaper/page/24091306 | 24091306 | |
53104 | 53104 | 1933-07-22 | 7-8 | a-f | Guangdong news/ The opposition to Jiang Jieshi in the southwest. Cai Tingkai organises a spy unit. The Southwest Foreign Affairs Association refuses to recognise the Nanjing government. Local courts and its operation in Guangdong. Civil corps in Guangdong and Guangxi. Zhang Yan reports that his troops have arrived Shaoguan. Many soldiers request to leave the 19th Route Army. Xiao Focheng warns Wang Zhaoming. Huang Jie to return to Guangzhou. The communists troops leave Xunwu in Jiangxi province. Import of agricultural products to Manchuria banned. Journalists detained in Guangzhou. An old woman remarries in Enping county. Japanese envoy meets Wang Jingwei. Aircraft factory in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091305 | 24091305 | |
53096 | 53096 | 1933-07-22 | 3 | b | The world economic conference in Washington and the speeches. | China | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53090 | 53090 | 1933-07-22 | 2 | c | Yang Xingfo is assassinated in Shanghai. The Chinese Civil Rights Protection Alliance in Shanghai, Song Qingling and Cai Yuanpei. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53101 | 53101 | 1933-07-22 | 5 | c | Sun Dianying and his resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091303 | 24091303 | |
53107 | 53107 | 1933-07-22 | 6 | c | The future of Puyi, dethroned emperor of Qing dynasty. | Japan | http://trove.nla.gov.au/newspaper/page/24091306 | 24091306 | |
53108 | 53108 | 1933-07-22 | 6 | c | French naval forces. | France | http://trove.nla.gov.au/newspaper/page/24091306 | 24091306 | |
53091 | 53091 | 1933-07-22 | 2 | d | Budget prepared by the Nanjing government for 1933. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53092 | 53092 | 1933-07-22 | 2 | d | Japanese troops are withdrawing. The battlefields in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53097 | 53097 | 1933-07-22 | 3 | d | American government accepts silver from Britain for debt repayment. | America | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53098 | 53098 | 1933-07-22 | 3 | d | The independence movement in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53102 | 53102 | 1933-07-22 | 5 | d | The Chinese School in Melbourne and its growth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091303 | 24091303 | |
53099 | 53099 | 1933-07-22 | 3 | e | Muslims in Xinjiang and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53103 | 53103 | 1933-07-22 | 5 | e | Chinese communities in Auckland and Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091303 | 24091303 | |
53109 | 53109 | 1933-07-22 | 6 | e | Australia news/ Bank of Reserve issues new bank notes of half pound. A miser in Sydney and his story. Hails in Western Australia. White woman injures a Chinese man in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091306 | 24091306 | |
53093 | 53093 | 1933-07-22 | 2 | f | The last words of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53094 | 53094 | 1933-07-22 | 2 | f | China starts to manufacture planes. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 |
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]);