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 |
---|---|---|---|---|---|---|---|---|---|
46429 | 46429 | 1927-11-19 | 2 | b | An open telegram issued by the Chinese National Chamber of Commerce in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098600 | 24098600 | |
46438 | 46438 | 1927-11-19 | 3 | b | Soviet Russian authority refuse to return the assets confiscated from Chinese immigrants. | Russia | http://trove.nla.gov.au/newspaper/page/24098599 | 24098599 | |
46439 | 46439 | 1927-11-19 | 3 | b | Huge amount of archives documents of the Qing dynasty are sold to Japanese. | China | http://trove.nla.gov.au/newspaper/page/24098599 | 24098599 | |
46453 | 46453 | 1927-11-19 | 5 | b | An international anti-Communist conference in Hague. | Other... | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46454 | 46454 | 1927-11-19 | 5 | b | The unemployed workers in Tokyo and their requests. | Japan | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46455 | 46455 | 1927-11-19 | 5 | b | German invents new ship. | Germany | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46456 | 46456 | 1927-11-19 | 5 | b | Dutch liner Almkerk sacks all Chinese sailors. | Other... | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46457 | 46457 | 1927-11-19 | 5 | b | Korean woman arrested in Tokyo after a celebration of the October Revolution. | Japan | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46458 | 46458 | 1927-11-19 | 5 | b | France and Yugoslavia sign a treaty. | Britain | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46464 | 46464 | 1927-11-19 | 7 | b | Hunan authority asks Russian consul to leave. A few Nationalist members are arrested in Hubei for their sympathy with the Communist Party. Tang Shengzhi in Anhui. Chen Duxiu arrives Moscow. Feng Yuxiang appoints Lu Zhonglin to attack Fengxi army. Foreign missions in Beijing ask Japan to dispatch more troops to China. Various sides in the war in China. Zhang Xueliang stay strong. Lu Xingyuan is removed. Tang Shengzhi and Zhang Zuolin. Wedding of Jiang Jieshi and Song Meiling. Jin Yunpeng is still alive. | China | http://trove.nla.gov.au/newspaper/page/24098603 | 24098603 |
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]);