This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51274 | 51274 | 1932-03-12 | 2 | b | Wounded soldier arrive Beijing from Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090728 | 24090728 | |
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 | |
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]);