This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
14138 | 14138 | 1905-01-07 | 2 | a-b | An editorial on magnanimity. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800605 | 26800605 | |
14139 | 14139 | 1905-01-07 | 2 | b-c | History of newspaper publishing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800605 | 26800605 | |
14140 | 14140 | 1905-01-07 | 2 | c | Army training in China. American ambassador inquires into currency changes in China. Russian troops are savage in Manchuria. Germans have military exercise in Jiangxi province. Germany asks to open Laizhou, Shandong province, for business. China to re-organise its navy. Zhang Bishi had a discussion with Empress Dowager regarding overseas Chinese and their business activities in China. Female talents Jin Zijun and her sister are going to study in London. Belgian government appoints a consul to Yunnan province in China. | China | http://trove.nla.gov.au/newspaper/page/26800605 | 26800605 | |
14141 | 14141 | 1905-01-07 | 2 | d | New imperial commissioner of Guangxi; his cooperation with Qin Chunxuan. Guangdong sends students to study in Japanese army school. Governor Qin Chunxuan awards soldiers for their bravery in suppression of Guangxi bandits. Gaoyao county encourages cultivation of wasteland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800605 | 26800605 | |
14142 | 14142 | 1905-01-07 | 2 | d | Report on political reform in Russia. | Britain | http://trove.nla.gov.au/newspaper/page/26800605 | 26800605 |
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]);