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 |
---|---|---|---|---|---|---|---|---|---|
51295 | 51295 | 1932-03-19 | 2 | b | Circular telegram jointly issued by Zhang Binglin, Zhang Yilin, Wen Zongyao, Zhao Hengti, Peng Yunyi, Shen Junru, Li Genyuan and Zhao Zhengping. | China | http://trove.nla.gov.au/newspaper/page/24090736 | 24090736 | |
51296 | 51296 | 1932-03-19 | 2 | b | Jiang Jieshi seeks advice of Chen Mingshu. Bankers in Shanghai donate to the Chinese army. Japanese troops use gas bombs in Shanghai. Fires in Wusong, Shanghai. Wong Huiteng fights to death in Shanghai. The 19th Route Army thanks various social circles. | China | http://trove.nla.gov.au/newspaper/page/24090736 | 24090736 | |
51305 | 51305 | 1932-03-19 | 6 | b | Guangdong news/ Guangdong provincial government dispatches troops to aid Shanghai. Overseas Chinese communities donate to help the Chinese army. Brief biography of airforce unit commander Huang Yuquan who dies in the battle with Japanese. Chinese society helps the army and the report. Patriotism of the students in Guangzhou. Buddhists in Guangdong help the Chinese army. Chinese airforce tests the gas bombs. Munitions factory in Guangzhou manufacturing more weapons. | China | http://trove.nla.gov.au/newspaper/page/24090740 | 24090740 | |
51311 | 51311 | 1932-03-19 | 8 | b | Internal chaos is imminent in Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090742 | 24090742 | |
51312 | 51312 | 1932-03-19 | 8 | b | Police in Shanghai raid communist offices. | China | http://trove.nla.gov.au/newspaper/page/24090742 | 24090742 |
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]);