This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48688 | 48688 | 1929-11-30 | 8 | c | Chinese government to abolish consular jurisdiction from January 1, 1930. The Nationalist troops take over Xiangfan, Hubei province. Zhang Fakui and his troops are still active. Song Ziwen seeks to buy over Feng Yuxiang's army. Internal fighting of the Nationalist politicians and military officers. Russian planes bomb Chinese mines. China may lose Manchuria. Internal fighting of the Chinese army in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099453 | 24099453 | |
48689 | 48689 | 1929-11-30 | 8 | f | News from Guangdong and Guangxi after the truce between Jiang Jieshi and Feng Yuxiang. Chinese government publicises crime committed by Russian troops. The truce between Jiang Jieshi and Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24099453 | 24099453 |
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]);