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 |
---|---|---|---|---|---|---|---|---|---|
54813 | 54813 | 1935-01-26 | 2 | c | Jiang Jieshi flies to Shanghai. Shang Lizi talks in Xuzhou, north Jiangsu province. Comet seen in Tangshan, Hebei province. Huang Shaoxiong to Zhejiang. Railway construction in Shandong. Chen Cheng on the victory of suppression of the communist troops in Fujian. Liu Xiang on the way to Nanjing. Yan Xishan observes a period of mourning for his deceased father. Construction of the Longhai railway to be completed. | China | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 | |
54815 | 54815 | 1935-01-26 | 3 | a | Liu Guitang in collaboration with pirates. | China | http://trove.nla.gov.au/newspaper/page/24096302 | 24096302 | |
54816 | 54816 | 1935-01-26 | 3 | b | Chinese and American governments are preparing for aviation cooperation. | China | http://trove.nla.gov.au/newspaper/page/24096302 | 24096302 | |
54817 | 54817 | 1935-01-26 | 3 | c | War clouds over north Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096302 | 24096302 | |
54818 | 54818 | 1935-01-26 | 3 | d | Kong Xiangxi talks to journalists. Japanese immigration to Jilin province. Wang Jingwei denies any changes of financial policy. Zhang Qun on the way to urge Huang Fu to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096302 | 24096302 | |
54822 | 54822 | 1935-01-26 | 7-8 | a-f | Guangdong news/ Second part of the open letter issued by Hu Hanmin and 26 other members of the Central Executive Committee. Jiang Jieshi and Wang Jingwei urge Hu Hanmin to come north. The communist troops fleeing west from south China and the efforts to eliminate all communists. Exhibition of Chinese local products in Guangzhou. A survey on social education in Hainan island. Fire in Gaoyao. Dongguan county trains young reserves of the army. Exhibition of agricultural products in Panyu. Bandits arrested in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24096306 | 24096306 |
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]);