This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51197 | 51197 | 1932-02-20 | 2 | a-f | Miscellaneous report on the Japanese invasion of Manchuria and Shanghai, and the social response of Chinese society. | China | http://trove.nla.gov.au/newspaper/page/24090704 | 24090704 | |
51198 | 51198 | 1932-02-20 | 3 | a | American newspaper surveys the Japanese troops in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51200 | 51200 | 1932-02-20 | 3 | a | Circular telegram issued by prominent people of the National Crisis Salvation Association. | China | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51201 | 51201 | 1932-02-20 | 3 | b | Students in Hunan organise demonstration and associations against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51202 | 51202 | 1932-02-20 | 3 | e | Japanese troops occupy coal mines in Xi'an, of Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51205 | 51205 | 1932-02-20 | 5 | a | British nationals injured during the Japanese invasion of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090705 | 24090705 | |
51207 | 51207 | 1932-02-20 | 5 | b | Resistance to Japanese invasion in Heilongjiang province and the army unit. | China | http://trove.nla.gov.au/newspaper/page/24090705 | 24090705 | |
51209 | 51209 | 1932-02-20 | 6 | b | Guangdong news/ Air force troops and police will not be involved in the internal fighting. Chen Jinjie of the Fourth Group Army runs away with public funds. Battery industry in prosperous in Guangzhou. Wu Qiwei reports his travel. The Fourth Group Army sets up a pressgang office. Disease of Hu Hanmin. Provincial bank to issue new bank notes. Commissioner of appeasement on their way to start working. Extortion in Jiangmen. Gambling and tax in Guangzhou. Budget for the implementation of appeasement policy. | China | http://trove.nla.gov.au/newspaper/page/24090708 | 24090708 | |
51210 | 51210 | 1932-02-20 | 7 | a | A joint declaration issued by the army officers and soldiers in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090707 | 24090707 | |
51211 | 51211 | 1932-02-20 | 7 | b | Zhang Xueliang replies to Wu Zhihui. | China | http://trove.nla.gov.au/newspaper/page/24090707 | 24090707 | |
51212 | 51212 | 1932-02-20 | 7 | c | Two proposals by Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24090707 | 24090707 | |
51215 | 51215 | 1932-02-20 | 8 | a | Japanese troops bombs Shanghai, the international settlement and the resistance of Chinese army. | China | http://trove.nla.gov.au/newspaper/page/24090710 | 24090710 | |
51217 | 51217 | 1932-02-20 | 8 | b | Miscellaneous report on Japanese invasion of Shanghai, resistance of Chinese troops, and responses of other foreign countries. | China | http://trove.nla.gov.au/newspaper/page/24090710 | 24090710 |
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]);