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 |
---|---|---|---|---|---|---|---|---|---|
50219 | 50219 | 1931-04-25 | 2 | c | Battles in Sichuan province. Tibet troops are approaching Ganzi, of Sichuan. The Beijing-Hankou railway is still closed. Shi Yousan is detained by Zhang Xueliang. Jiang Jieshi on the current chaos in China. Han Fuqu in crisis. Proposals to the Legislative Council. Sichuan troops ready to fight. Mongolian people respond to the provisional constitution. Feng Yuxiang is trapped. Dai Jitao and Hu Hanmin show sympathy to each other. Zhang Xueliang convenes a military conference. Wu Tingyang visits Jiang Jieshi. Zhang Xueliang agrees to contribute to the reorganisation of Shanxi army. Wang Chonghui continues to revise the provisional constitution. | China | http://trove.nla.gov.au/newspaper/page/24090357 | 24090357 | |
50226 | 50226 | 1931-04-25 | 3 | c | Railway operation in Manchuria and the transportation of coal resources. | China | http://trove.nla.gov.au/newspaper/page/24090356 | 24090356 | |
50231 | 50231 | 1931-04-25 | 5 | c | Yu Youren and his romance. Zhou Fohai and his romance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090358 | 24090358 | |
50243 | 50243 | 1931-04-25 | 8 | c | French ship is stranded and robbed near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 | |
50244 | 50244 | 1931-04-25 | 8 | c | Train accident on the Guangzhou-Kowloon line. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 | |
50245 | 50245 | 1931-04-25 | 8 | c | Air mail plane from Britain to Australia has a forced landing on the way. | Australia | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 | |
50246 | 50246 | 1931-04-25 | 8 | c | Trade relationship between Russia and Canada. | Russia | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 | |
50247 | 50247 | 1931-04-25 | 8 | c | Australia news/ University students protest against the state Labour government for its proposal to set up clubs in the campus. A run on the Savings Bank of New South Wales. A man penalised in Melbourne for illegal wines. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 |
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]);