This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29032 | 29032 | 1914-07-11 | 2 | c-d | Newly appointed state councillors in China and their backgrounds (Xu Shichang, Sun Baoqi, Liang Dunyan, Zhu Qiqin, Zhang Qian, Duan Qirui, Zhang Zongxiang, Zhou Ziqin, Tang Hualong and Liu Guanxiong). | China | http://trove.nla.gov.au/newspaper/page/24093172 | 24093172 | |
29044 | 29044 | 1914-07-11 | 3 | c-d | Beijing news/ New seal for the credentials of China. Yu Shimei, Zhang Renjun and other fogeys of the Qing dynasty now living in Qingdao. Chinese Ministry of Internal Affairs and the purchase of grains. Wu Tingfang is reluctant to come back to politics. Chinese government to collect new stamp duties. Zhu Nianzu is to be sentenced. Wang Xianzhang is executed. Magistrate Li Tingyu of Jiangxi province is on trial. | China | http://trove.nla.gov.au/newspaper/page/24093171 | 24093171 | |
29056 | 29056 | 1914-07-11 | 8 | c-d | Guangdong news/ Long Jiguang plans to start army reforms. Disarmament would be effective way to maintain local security in Guangdong. Guangdong authority to issue new paper notes and preparation by the Bank of China. Market in panic in Foshan due to the new bank notes. Salary paid to government employees will be reviewed. Provincial officials to visit Xiangzhou, a tax-free zone. Epidemic (cholera) in Guangzhou and many people have fled. Fire in Zhaoqing burns many shops to ashes. A witch is frightened by a corpse. Shareholders of the Guangzhou-Hankou railway have different opinions. Bandits in Xinhui county hijack a ferry and kidnap more than 20 people. | China | http://trove.nla.gov.au/newspaper/page/24093178 | 24093178 |
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]);