This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51294 | 51294 | 1932-03-19 | 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/24090736 | 24090736 | |
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 | |
51297 | 51297 | 1932-03-19 | 2 | e | An interview with Cai Tingkai, commander of the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24090736 | 24090736 | |
51298 | 51298 | 1932-03-19 | 2 | e | The Youth Party supports the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24090736 | 24090736 | |
51299 | 51299 | 1932-03-19 | 2 | f | Chinese people question the power of Chinese navy. | China | http://trove.nla.gov.au/newspaper/page/24090736 | 24090736 | |
51300 | 51300 | 1932-03-19 | 2 | f | Sichuan troops come to help in Shanghai. Fighting Japanese invaders in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090736 | 24090736 |
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]);