This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48330 | 48330 | 1929-08-03 | 2 | a | A historical review on the Russian invasion into China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 | |
48331 | 48331 | 1929-08-03 | 2 | c | Famine victims in Gansu province. Foreign minister Wang Zhengting says Chinese government is studying the Russian issues. Chinese government to close the office for Sino-Foreign Negotiations. Zhang Xueliang on the current situations. Farewell words by Feng Yuxiang before his leaving China. Yan Xishan is also planning for an overseas tour. | China | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 | |
48332 | 48332 | 1929-08-03 | 2 | d | Japanese government sets up a colony department. | Japan | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 | |
48333 | 48333 | 1929-08-03 | 2 | f | Li Pinxian is going to Zhengzhou. Ministry of Internal Affairs promotes local self-government at county level. Feng Yuxiang steps down and the aftermath. Yu Youren is very pessimistic. Relation between Sun Chuanfang and Zhang Xueliang. Japanese demolish railway near Shenyang, Liaoning province. Zhang Jinghui arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 |
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]);