This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48426 | 48426 | 1929-09-07 | 2 | b | Communist activists demonstrate at the front of the Chinese Consulate-General in San Francisco and the arrests (American, Russian, Hungarian, Greek, Italian, Japanese, and Chinese nationals). | America | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48427 | 48427 | 1929-09-07 | 2 | b | The Nationalist government in Nanjing meets to discuss the Russia policy. Russian authority to reorganise the Far Eastern Bank in Harbin. Zhang Xueliang sends Shen Honglie to Harbin for defence against Russian invasion. First meeting of Chinese and Russian delegates in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48428 | 48428 | 1929-09-07 | 2 | d | Japanese government appoints new ambassador to China. | Japan | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48429 | 48429 | 1929-09-07 | 2 | d | Feng Yuxiang is still in Shanxi province and his life there. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48430 | 48430 | 1929-09-07 | 2 | d | Mongolian troops on the war south to China. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48431 | 48431 | 1929-09-07 | 2 | d | Another meeting in Nanjing to reorganise various troops or armies, and its resolutions. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48432 | 48432 | 1929-09-07 | 2 | e | Yan Xishan resigns. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48433 | 48433 | 1929-09-07 | 2 | e | Zhang Zongchang in Japan accidentally shoots dead Xian Huai, former prince of Qing dynasty. | Japan | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48434 | 48434 | 1929-09-07 | 2 | e | Floods in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48435 | 48435 | 1929-09-07 | 2 | f | Japan's new policy towards China. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
48436 | 48436 | 1929-09-07 | 2 | f | New political changes in Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 |
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]);