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 |
---|---|---|---|---|---|---|---|---|---|
51346 | 51346 | 1932-04-02 | 2 | b | Open letter issued by the 19th Route Army to the Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24090752 | 24090752 | |
51348 | 51348 | 1932-04-02 | 2 | d | Zhang Xueliang's troops on the way to the front to take back the lost territories. | China | http://trove.nla.gov.au/newspaper/page/24090752 | 24090752 | |
51349 | 51349 | 1932-04-02 | 2 | e | Cai Tingkai of the 19th Route Army rebuffs rumours. | China | http://trove.nla.gov.au/newspaper/page/24090752 | 24090752 | |
51350 | 51350 | 1932-04-02 | 2 | e | Japanese conditions for peace in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090752 | 24090752 | |
51352 | 51352 | 1932-04-02 | 2 | f | Resistance to Japanese invasion in Manchuria. The Manchuria under Japanese control. | China | http://trove.nla.gov.au/newspaper/page/24090752 | 24090752 | |
51353 | 51353 | 1932-04-02 | 3 | a | Relations between Russia and Japan deteriorates. | China | http://trove.nla.gov.au/newspaper/page/24090751 | 24090751 | |
51355 | 51355 | 1932-04-02 | 3 | c | A letter from Qin Chunxuan to Quan Yangyi. | China | http://trove.nla.gov.au/newspaper/page/24090751 | 24090751 | |
51356 | 51356 | 1932-04-02 | 3 | e | Memorial services in Shanghai for the soldiers killed in the fighting with Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24090751 | 24090751 | |
51361 | 51361 | 1932-04-02 | 5 | e | American naval forces in the Pacific. | China | http://trove.nla.gov.au/newspaper/page/24090753 | 24090753 | |
51363 | 51363 | 1932-04-02 | 6 | b | Guangdong news/ Zhu Zhaoxin advocates the resistance to Japanese invasion. Foreign Affairs Association in the Southwest China condemns the Manchurian state. Guangdong navy has a submarine mines unit. Message from the south-west authorities to the 19th Route Army. Yu Hanmou has departed to eradicate the communists. Warning to the people who are still keen to internal fighting. Volunteer unit turns now into an ambulance corps. | China | http://trove.nla.gov.au/newspaper/page/24090756 | 24090756 | |
51364 | 51364 | 1932-04-02 | 7 | a | Miscellaneous report on the Japanese invasion of China and the resistance movement in China. | China | http://trove.nla.gov.au/newspaper/page/24090755 | 24090755 | |
51367 | 51367 | 1932-04-02 | 8 | a | Japan withdraws some troops from China. Peace talks between China and Japan fails in Shanghai. Japanese control tariff income in Manchuria. Japanese destroy theatre in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090758 | 24090758 |
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]);