This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27693 | 27693 | 1913-08-02 | 8 | a | Parliamentarian Zhang Lie and his motions in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24092775 | 24092775 | |
27694 | 27694 | 1913-08-02 | 8 | a-b | Jiang Fangzhen, principal of the Baoding Military Academy, commits suicide and the report. | China | http://trove.nla.gov.au/newspaper/page/24092775 | 24092775 | |
27695 | 27695 | 1913-08-02 | 8 | b-c | Railway in Hunan province is nationalised and the report. | China | http://trove.nla.gov.au/newspaper/page/24092775 | 24092775 | |
27696 | 27696 | 1913-08-02 | 8 | c | Chinese community in Japan lists crimes committed by Huang Xing. | Japan | http://trove.nla.gov.au/newspaper/page/24092775 | 24092775 | |
27697 | 27697 | 1913-08-02 | 8 | c-d | Investigation on the assassination of Song Jiaoren. | China | http://trove.nla.gov.au/newspaper/page/24092775 | 24092775 | |
27698 | 27698 | 1913-08-02 | 8 | d | Guangdong news/ Wang Baozhi, of Dongguan county, lists crimes committed by Hu Hanmin. Guangdong people question Hu Hanmin on his leaving. New shares on sale for the Guangzhou-Hankou railway line. Feud and fighting between two families, Chen and Lin, in Xinhui county. People of Heshan county demonstrate against their magistrate Wu Xixing. | China | http://trove.nla.gov.au/newspaper/page/24092775 | 24092775 |
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]);