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 |
---|---|---|---|---|---|---|---|---|---|
51293 | 51293 | 1932-03-12 | 8 | b | Miscellaneous report on the battles between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51292 | 51292 | 1932-03-12 | 8 | b | Fighting of the Chinese communities in Penang, Malaysia. | Singapore | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51291 | 51291 | 1932-03-12 | 8 | b | Feng Yuxiang leads his troops to fight Japanese. | China | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51290 | 51290 | 1932-03-12 | 8 | b | American government to assist the League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51289 | 51289 | 1932-03-12 | 8 | a | Japanese diplomacy suffers a great loss. | Japan | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51288 | 51288 | 1932-03-12 | 8 | a | Chinese delegate to the League of Nations Yan Huiqing lists crimes of Japanese invaders. | Britain | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51287 | 51287 | 1932-03-12 | 8 | a | Chinese in Shanghai celebrate the victory of the 19th Route Army. | Australia | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51286 | 51286 | 1932-03-12 | 8 | a | Japanese set up the Bank of Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51285 | 51285 | 1932-03-12 | 8 | a | Manchuria formally declares independence. | China | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51284 | 51284 | 1932-03-12 | 7 | d | Chinese communities in Sydney donate to the war of resistance to Japanese invasion and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090731 | 24090731 | |
51283 | 51283 | 1932-03-12 | 6-7 | b | Guangdong news/ The Guangzhou after the war in Shanghai. Professors of the Zhongshan University urge Hu Hanmin to join the politics again. Poems by Yu Youren. Jiang Jieshi's message to the army officers and soldiers nation-wide. Alarm of national crisis in Guangzhou. Chinese communities in Macao support the resistance to Japanese invasion. Guangzhou on high alert. Guangdong people celebrate victory of the 19th Route Army. Dyke breaks in Sihui county. Bandits arrested in Dongguan county. Anti-Japanese Association in Chao'an entertains the soldiers returned from the anti-Japanese front. Bandit chieftain executed in Nanhai county. Clan fighting in Foshan. Application for exemption of tax in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24090732 | 24090732 | |
51282 | 51282 | 1932-03-12 | 5 | d | Chinese communities in Brisbane and Sydney donate to the resistance to Japanese invasion and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090729 | 24090729 | |
51281 | 51281 | 1932-03-12 | 5 | a | Battles between Chinese and Japanese troops. Preparation by Cai Tingkai for resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090729 | 24090729 | |
51280 | 51280 | 1932-03-12 | 3 | c | Real motives of Puyi, dethroned emperor of Qing dynasty. | China | http://trove.nla.gov.au/newspaper/page/24090727 | 24090727 | |
51279 | 51279 | 1932-03-12 | 3 | a | Two representatives from Heilongjiang province on Ma Zhanshan. | China | http://trove.nla.gov.au/newspaper/page/24090727 | 24090727 | |
51278 | 51278 | 1932-03-12 | 2 | f | Circular telegram issued by Zhang Fakui. | China | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 | |
51277 | 51277 | 1932-03-12 | 2 | f | Revenue of the Chinese customs. | China | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 | |
51276 | 51276 | 1932-03-12 | 2 | e | Zhang Zongchang talks about his past opportunities. | China | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 | |
51275 | 51275 | 1932-03-12 | 2 | c | Plague in north Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 | |
51274 | 51274 | 1932-03-12 | 2 | b | Wounded soldier arrive Beijing from Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 | |
51273 | 51273 | 1932-03-12 | 2 | a | Chinese communities in Sydney organise a fund-raising committee for China's resistance to Japanese invasion (dui ri zhan fei chou bei hui), the China Progressive Association, which calls for donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 |
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]);