This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50176 | 50176 | 1931-04-11 | 2 | b | Editorial by the Tung Wah Times on the so-called disease of some politicians. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090341 | 24090341 | |
50177 | 50177 | 1931-04-11 | 2 | b | Preparation for the election at the national conference. Army provisions paid to the north China. Zhang Xueliang controls the whole north China and he seeks to set up military and financial committees. Russian oil export to Shanghai. Foreign missions may move from Beijing to Nanjing. Situation in Sichuan province. Jiang Jieshi on the provisional constitution after his clash with Hu Hanmin. Luo Yiqun talks on his return from Japan. Sichuan troops still seek to occupy Shaanxi province. Shanxi army still powerful. Chen Youren accompanies Russian envoy to Nanjing. Sun Lianzhong's troops waiting for the opportunity. Preparation for civil flight service between Beijing and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090341 | 24090341 | |
50189 | 50189 | 1931-04-11 | 8 | b | Bandits and robberies in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50190 | 50190 | 1931-04-11 | 8 | b | Earthquake in central America. | America | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50191 | 50191 | 1931-04-11 | 8 | b | Chinese government may stop import of foreign wheat. | Canada | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 |
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]);