This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46035 | 46035 | 1927-08-13 | 3 | b | Financial crisis in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098487 | 24098487 | |
46036 | 46036 | 1927-08-13 | 3 | b | Foreign missions in Beijing request to set up protective area inland. | China | http://trove.nla.gov.au/newspaper/page/24098487 | 24098487 | |
46037 | 46037 | 1927-08-13 | 3 | b | Chen Yimiao and Lu Dianchen declare independence in Jiaozhou, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098487 | 24098487 | |
46038 | 46038 | 1927-08-13 | 3 | c-d | Zhu Zhaoxin as the representative of the Nationalist government. Internal conflict with the Zhang Zuolin's army. Feng Yuxiang arrests Communist members in Beijing. Feng Yuxiang eliminates communists. Wu Peifu in Nanyang. Zhang Zuolin's troops on guard. Beijing government appoints another ambassador to Italy. Xia Douyan on Tang Shengzhi. Beijing government protests against Japan. Overseas missions urge the Beijing government to pay their salary. University restructure in Beijing. Zhang Xueliang asks Sun Chuanfang to govern Shandong. Borodin's wife is released. The Union company in Tianjin is closed down. | China | http://trove.nla.gov.au/newspaper/page/24098487 | 24098487 |
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]);