This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48573 | 48573 | 1929-10-26 | 2 | b | Comments written by Chen Zhenli question Chinese deputy-consul in Australia Li Hong for his speech at the National Day celebration in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48574 | 48574 | 1929-10-26 | 2 | c | Precautions against Russian invasion along the Mongolian and Manchurian borders. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48575 | 48575 | 1929-10-26 | 2 | d | Circulation of Russian currency stopped in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48576 | 48576 | 1929-10-26 | 2 | d | Japan prepares to deal with the possible war in north Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48577 | 48577 | 1929-10-26 | 2 | d | Zhang Xueliang sends telegram to the central government in Nanjing on the case of Gu Weijun, Liang Shiyi and Wang Kemin. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48578 | 48578 | 1929-10-26 | 2 | e | Negotiations between China and Russia halted. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48579 | 48579 | 1929-10-26 | 2 | e | Japan provides weapons to Russian troops and the evidence. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48580 | 48580 | 1929-10-26 | 2 | e | Communist leader Peng Bai is executed in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48581 | 48581 | 1929-10-26 | 2 | f | Tang Shengzhi and Fang Zhenwu are detained and the report. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48582 | 48582 | 1929-10-26 | 2 | f | The Fourth Army Division to attack Wuhan under the order of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 | |
48583 | 48583 | 1929-10-26 | 2 | f | Sun Liangcheng suddenly arrives Nanjing to meed Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099405 | 24099405 |
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]);