This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30862 | 30862 | 1915-12-25 | 6 | a-b | Beijing news/Yuan Shikai's daughter may marry son of previous Qing emperor. Yuan Keding, son of Yuan Shikai, conveys his regards to some influential people in order to get their supports. A strange calender named National Calender of Da Liang Empire is found in Beijing. Chinese government is preparing the emperor's palace. Lishang Glass Company in Hunan is approved to have exclusive right in dealing glass business for five years. Hunan is to restore an old paper plant. Mongolian bandits in Hailare attack people living there. Strange red snow occurs in Xian An Lin Mountains in Northeast China. Overseas Chinese in Russia oppose imperial system in China. | China | http://trove.nla.gov.au/newspaper/page/24095106 | 24095106 | |
30863 | 30863 | 1915-12-25 | 6 | b | News Miscellany/Chinese government sends more police to investigate Zhen Yucheng's assassination case and arrests many suspects. Letters and reports of Chinese officials to Yuan Shikai entitle Yuan as his majesty. Long Jiguang orders to ban newspapers from Hong Kong as they oppose imperial system. Mexico is still in riots. Guangdong is to return China's Rescuing Deposits to their owners. Long Jiguang requires the central government to ban newspapers from outside of China. | China | http://trove.nla.gov.au/newspaper/page/24095106 | 24095106 |
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]);