This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20302 | 20302 | 1908-11-28 | 3 | b | Various reports on the preparation for constitutional reform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801963 | 26801963 | |
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 | |
20304 | 20304 | 1908-11-28 | 3 | d | Guangdong news. Survey prepared on road transportation and inland navigation. Negotiation with French consul over the capture of Chinese criminals. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801963 | 26801963 |
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]);