This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32172 | 32172 | 1917-03-24 | 6 | b-c | Guangdong news/ Governor Zhu Qinglan is urged to support the establishment of Guangzhou University. Government troops in Zhaoqing are suppressing bandits. Lu Rongting and Zhu Qinglan mourn the death of Liu Yongfu. Government military commanders are bribed by bandits. The breakup of America and Germany and its influence on the business in Guangzhou. Hong Kong governor to visit Guangzhou. Bandits suppressed in Dongguan county. Xu Mian in Guangzhou. Seven village women are kidnapped by bandits in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24095637 | 24095637 | |
32175 | 32175 | 1917-03-24 | 7 | b-c | News on the World War I (Poland after the War, revolutionary movement in Russia, China regains concessions in Tianjin). | China | http://trove.nla.gov.au/newspaper/page/24095636 | 24095636 |
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]);