This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51243 | 51243 | 1932-03-05 | 2 | a | Journalist in Shanghai Qian Cangshuo fight for freedom of speech and his open letter. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
51244 | 51244 | 1932-03-05 | 2 | b | Declaration issued by the Chinese foreign ministry on the Japanese invasion of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
51245 | 51245 | 1932-03-05 | 2 | c | Japanese to rebuild the Lushun port in Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
51246 | 51246 | 1932-03-05 | 2 | d | Han Fuqu takes over tax administration in Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
51247 | 51247 | 1932-03-05 | 2 | d | Japanese organise new state government in Manchuria and the report. Japanese bomb Nanjing. He Chengrui arranges defence in Wuhan. Circular telegram jointly issued by Cai Yuanpei, Liu Jinghua, Zou Lu, Jiang Menglin, Wang Shiyan and Mei Yiqi on the atrocities of Japanese troops. Japanese troops occupy university campus in Shanghai. Professors of the Zhongshan University demand salary payment. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 |
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]);