This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20303 | 20303 | 1908-11-28 | 3 | b-c | China news. Guangxi authority recruits and trains more army to deal with bandits. Fuzhou destroys opium smoking sets. The Emperor's health problem in the past few months. Petition from Manchurian representatives for establishment of parliament. Yuan Shikai is impeached and is on sick leave now. Duan Fang and Chen Qitai jointly impeach Yang Chongyi. Epidemic in Beijing and the casualties. Tang Shaoyi's speech in Japan. | China | http://trove.nla.gov.au/newspaper/page/26801963 | 26801963 | |
20327 | 20327 | 1908-11-28 | 8 | b-c | A reply from Tung Wah Hospital in Hong Kong to the Sydney tong shan tang, association of Xiangshan people with appreciation for their donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801970 | 26801970 |
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]);