This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
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 | |
48439 | 48439 | 1929-09-07 | 3 | b | Japanese cabinet and their rapid advancement policy in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099348 | 24099348 |
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]);