This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55007 | 55007 | 1935-04-13 | 2 | b | China news/ British expert on the infrastructure development in Guangxi. Song Meiling arrives Chongqing. Security troops in Yutian release their garrisons. Japanese army in north China. Jiang Jieshi orders to continue elimination of all communist troops. Hundreds of associations nation-wide sent telegram to Jiang Jieshi and Wang Jingwei appealing to save industry and commerce. Kong Xiangxi talks on his arrival in Shanghai. Lord Leyton comments on the proposed cooperation between China and Japan. League of Nations on the status of China. British colonies on high alert and the military forces in Singapore. Japanese ambition in the Far East and the expansion of Britain, Russia and America. | China | http://trove.nla.gov.au/newspaper/page/24096391 | 24096391 | |
55012 | 55012 | 1935-04-13 | 5 | b | A visit to scenic spots in Luoyang, of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24096392 | 24096392 | |
55018 | 55018 | 1935-04-13 | 8 | b | Chinese gambling in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096397 | 24096397 |
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]);