This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31604 | 31604 | 1916-09-23 | 8 | a-b | Beijing news/ Local provinces and their tribute to the central government in Beijing. Central government helps Long Jiguang to attack Li Liejun in Guangdong. Guangdong people farewell Tang Shaoyi on his departure for Beijing. Another war breaks out in Hunan province. Opium from Yunnan province are confiscated in Shanghai. Lu Rongting writes to Liang Qichao. | China | http://trove.nla.gov.au/newspaper/page/24095419 | 24095419 | |
31605 | 31605 | 1916-09-23 | 8 | c-d | Guangdong news/ Members of the provincial legislature assembly complain that Long Jiguang is purchasing more weapons. Long Jiguang briberies Hong Kong newspapers. News on the Guangxi and Yunnan armies. Red Cross members arrives Foshan. | China | http://trove.nla.gov.au/newspaper/page/24095419 | 24095419 | |
31606 | 31606 | 1916-09-23 | 8 | d | Advertisement for Tat Shing & Company Tea Merchants, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095419 | 24095419 |
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]);