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 |
---|---|---|---|---|---|---|---|---|---|
51512 | 51512 | 1932-05-14 | 2 | b | First part of an open letter from a students' association in China to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24090800 | 24090800 | |
51513 | 51513 | 1932-05-14 | 2 | d | Cai Tingkai, commander of the 19th Route Army, asks the Chinese communities in America for donations to purchase war planes. | China | http://trove.nla.gov.au/newspaper/page/24090800 | 24090800 | |
51514 | 51514 | 1932-05-14 | 2 | e | Resistance to Japanese invasion in Manchuria. The Manchurian state cedes four counties to Japan. Ma Zhanshan reports conspiracy of establishment of the Manchurian state. Nanjing government refuse to accept diplomatic notes of the Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24090800 | 24090800 | |
51515 | 51515 | 1932-05-14 | 3 | a | A conference in Luoyang, Henan province, on the national crisis. | China | http://trove.nla.gov.au/newspaper/page/24090799 | 24090799 | |
51516 | 51516 | 1932-05-14 | 3 | a | The canal project in north Jiangsu province to be completed soon. | China | http://trove.nla.gov.au/newspaper/page/24090799 | 24090799 | |
51517 | 51517 | 1932-05-14 | 3 | c | Open letter from the Saving China Association of the Chinese People to the delegation of the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24090799 | 24090799 | |
51518 | 51518 | 1932-05-14 | 3 | d | Retired naval officer Chen Minggao questions Chen Shaokuan. | China | http://trove.nla.gov.au/newspaper/page/24090799 | 24090799 | |
51519 | 51519 | 1932-05-14 | 5 | a | Ye Xiasheng on the future of the Chinese Nationalist Party (Guomindang). | China | http://trove.nla.gov.au/newspaper/page/24090801 | 24090801 | |
51522 | 51522 | 1932-05-14 | 6-7 | a | Guangdong news/ Proposal to save expenses of naval and air force troops. Students in Guangzhou raise funds to purchase a war plane. Japanese consul protests against comments of some Guangzhou newspapers. History of the aviation industry in Guangdong. Coal mine found in Gaoyao. Tang Shaoyi seeks another appointment. A family in Taishan is poisoned by mosquito incense. Police in Taishan county guard against penetration of Japanese spies. Flooding of Guangdong rivers. Communist members arrested in Jieyang county. Nanhai county authority dispatches troops to pacify clan fighting. Villagers in Panyu train their own security corps. News from Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24090804 | 24090804 | |
51525 | 51525 | 1932-05-14 | 8 | c | Truce agreement signed in Shanghai between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24090805 | 24090805 | |
51529 | 51529 | 1932-05-14 | 8 | d | Resistance to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090805 | 24090805 | |
51530 | 51530 | 1932-05-14 | 8 | d | British foreign secretary report the situation in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090805 | 24090805 |
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]);