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 |
---|---|---|---|---|---|---|---|---|---|
53165 | 53165 | 1933-08-12 | 2 | c | Hu Hanmin, Duan Xipeng and Shi Ying and their recent talks. | China | http://trove.nla.gov.au/newspaper/page/24091326 | 24091326 | |
53166 | 53166 | 1933-08-12 | 2 | d | General Su Bingwen arrives Shanghai from Hangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091326 | 24091326 | |
53167 | 53167 | 1933-08-12 | 2 | e | Zhou Yawei on the military service law of the Republic of China. | China | http://trove.nla.gov.au/newspaper/page/24091326 | 24091326 | |
53168 | 53168 | 1933-08-12 | 2 | f | Japan deports Chinese students. | China | http://trove.nla.gov.au/newspaper/page/24091326 | 24091326 | |
53169 | 53169 | 1933-08-12 | 3 | b | Feng Yixiang and the communists. | China | http://trove.nla.gov.au/newspaper/page/24091325 | 24091325 | |
53171 | 53171 | 1933-08-12 | 3 | d | Ma Yinchu on the loans from America for the cotton growing in China. | China | http://trove.nla.gov.au/newspaper/page/24091325 | 24091325 | |
53172 | 53172 | 1933-08-12 | 3 | e | General Ma Zhanshan in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091325 | 24091325 | |
53173 | 53173 | 1933-08-12 | 3 | e | Zhang Ji to chair the representative office in north China. | China | http://trove.nla.gov.au/newspaper/page/24091325 | 24091325 | |
53174 | 53174 | 1933-08-12 | 5 | c | A changeable Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24091327 | 24091327 | |
53175 | 53175 | 1933-08-12 | 5 | d | Zhang Xueliang quits opium smoking. | China | http://trove.nla.gov.au/newspaper/page/24091327 | 24091327 | |
53178 | 53178 | 1933-08-12 | 7-8 | a-f | Guangdong news/ Chen Jitang orders to suppress the communists. Chen Jitang softens his attitude towards Jiang Jieshi. Guangdong authority denies arrival of warships from the north. The exchange rate of Hong Kong dollars and its influence in the Guangdong economy. Opium smuggling from Guizhou to Guangdong. Cai Tingkai leads his troops back to Fujian. The communists in Jiangxi province suffer huge loss. Panyu county government organises an educational conference. | China | http://trove.nla.gov.au/newspaper/page/24091329 | 24091329 | |
53183 | 53183 | 1933-08-12 | 6 | c | The 19th Route Army fights the communists. | China | http://trove.nla.gov.au/newspaper/page/24091330 | 24091330 |
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]);