This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21207 | 21207 | 1909-06-26 | 2 | c-d | Imperial edict on March 21 reappoints some officials who were removed from office in the past. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802230 | 26802230 | |
21214 | 21214 | 1909-06-26 | 3 | c-d | Guangdong news. Governor Zhang Renjun is determined to take over Xisha island in South China Sea. Plan for railway connection between Guangxi and Guangdong. Flooding in Huaiji county and the casualties. Flooding victims in Qingyuan and Beijiang River area. Agreement between Zhang Zhidong and British bank of the loans to Guangzhou-Hankou railway project. Gao Er'qian might be promoted to negotiating envoy of Guangdong. A girl in Panyu county is brought to trial for breaking off the engagement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802229 | 26802229 |
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]);