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 |
---|---|---|---|---|---|---|---|---|---|
51089 | 51089 | 1932-01-23 | 2 | c | Chinese communities in Cuba donate to Ma Zhanshan for his fighting Japanese invaders. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090670 | 24090670 | |
51090 | 51090 | 1932-01-23 | 2 | c | More then 20,000 students are driven away from Nanjing. The Nationalist Party offices in Shanxi and Shaanxi provinces are destroyed by students. Deng Yanda is executed in Nanjing and the social response. | China | http://trove.nla.gov.au/newspaper/page/24090670 | 24090670 | |
51098 | 51098 | 1932-01-23 | 6 | c | Guangdong news/ The Fourth Group Army purchases weapons and the disputes. Students' demonstration in Guangzhou against Japanese invasion. Communist troops in Fujian province. Commercial chambers in Guangzhou request to stop sales of military bonds. | China | http://trove.nla.gov.au/newspaper/page/24090674 | 24090674 | |
51101 | 51101 | 1932-01-23 | 7 | c | Ma Zhanshan fights Japanese invaders and the report. | China | http://trove.nla.gov.au/newspaper/page/24090673 | 24090673 | |
51110 | 51110 | 1932-01-23 | 8 | c | Japanese in Shanghai shoot Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24090676 | 24090676 | |
51111 | 51111 | 1932-01-23 | 8 | c | Nanjing government to break off diplomatic relations with Japan. | China | http://trove.nla.gov.au/newspaper/page/24090676 | 24090676 | |
51112 | 51112 | 1932-01-23 | 8 | c | Australia news/ Floods in Queensland. Federal government reports the debts. The communists in Darwin prepare for an uprising. Federal government to revise the import tariff rate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090676 | 24090676 |
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]);