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 |
---|---|---|---|---|---|---|---|---|---|
50601 | 50601 | 1931-08-15 | 2 | c | Japanese police shoot Chinese farmers in Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24090487 | 24090487 | |
50603 | 50603 | 1931-08-15 | 2 | f | Song Qingling invites Hu Hanmin to come to France for a rest. | China | http://trove.nla.gov.au/newspaper/page/24090487 | 24090487 | |
50604 | 50604 | 1931-08-15 | 3 | a | Atrocities of Japanese police in Jilin province, Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50605 | 50605 | 1931-08-15 | 3 | b | Returned Chinese from Korea present their petition to the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50606 | 50606 | 1931-08-15 | 3 | d | Chinese Communist troops loot Jianning, of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50607 | 50607 | 1931-08-15 | 3 | e | Floods in Fuzhou, capital of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090486 | 24090486 | |
50612 | 50612 | 1931-08-15 | 6-7 | a-d | Guangdong news/ Survey on the disasters in Sihui, Panyu, Gaoming and other areas. Relief work in the disastrous area. Commercial chamber unable to sell the military bonds. Obstacles to the opium ban in local counties. Relief work in the disastrous areas. Bandits in Panyu, Shunde and Zhongshan counties. Car drivers in Zhongshan on strike. Taishan county builds a rehabilitation centre. Butchers in Kaiping county request to abolish factory of animal manslaughtering. Road projects in Gaoyao. | China | http://trove.nla.gov.au/newspaper/page/24090491 | 24090491 | |
50613 | 50613 | 1931-08-15 | 8 | b | Shi Yousan leads his defeated troops to Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50619 | 50619 | 1931-08-15 | 8 | c | Yan Xishan returns to Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50620 | 50620 | 1931-08-15 | 8 | c | The Yangtze River is flooding. | China | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 |
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]);