This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30978 | 30978 | 1916-02-26 | 2 | a-c | Liang Qichao's comment on China's restoring imperial system and foreign powers' advice to Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24095171 | 24095171 | |
30990 | 30990 | 1916-02-26 | 6 | a-c | Guangdong news/Details of riot party members' bombing the power bureau in Guangzhou. A bomb is found on a street of Guangzhou. Guangdong governor's building is heavily guarded. Bandits in Qingyuan, Guangdong are active. Kaiping, Guangdong, sets up an education promotion association. Xiangshan government in Guangdong decides to reduce tax on oil-makers. Metals such as copper and iron are selling well due to the Europe War. Liu Jin is killed by bandits in Huadi, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24095175 | 24095175 | |
30993 | 30993 | 1916-02-26 | 8 | a-c | Special issue/ Sun Hongyi's public letter to all Chinese, condemning Yuan Shikai's brutalities during his rule. | China | http://trove.nla.gov.au/newspaper/page/24095177 | 24095177 |
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]);