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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 51274 | 51274 | 1932-03-12 | 2 | b | Wounded soldier arrive Beijing from Manchuria. | 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 | |
| 51276 | 51276 | 1932-03-12 | 2 | e | Zhang Zongchang talks about his past opportunities. | 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 | |
| 51278 | 51278 | 1932-03-12 | 2 | f | Circular telegram issued by Zhang Fakui. | China | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 51285 | 51285 | 1932-03-12 | 8 | a | Manchuria formally declares independence. | China | 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 | |
| 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 | |
| 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 | |
| 51289 | 51289 | 1932-03-12 | 8 | a | Japanese diplomacy suffers a great loss. | Japan | 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 | |
| 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 | |
| 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 | |
| 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 |
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]);