This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17873 | 17873 | 1907-08-03 | 3 | a-b | Guangdong news. Friendship between Qin Chunxuan and Hu Fan. Preparation underway to establish some army schools in Guangzhou. Zhou Fu will not be demoted. Hunan railway company comes to raise funds in Guangdong. New governor Qin Chunxuan and his entourage. Qin Chunxuan suggests to use Beiyang military officers to train the New Army of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17886 | 17886 | 1907-08-03 | 6 | a-b | First part of travel notes to Germany, written by Kang Youwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801424 | 26801424 | |
17902 | 17902 | 1907-08-03 | 8 | a-b | Fourth part of the report, prepared by Xu Rui, envoy of Chinese government, suggests to set up China Prosperity Commercial Company (zhongguo zhenxing shangwu zong gongsi) among overseas Chinese communities in order to protect the interest of China and overseas Chinese communities. The company will include steamship company, bank and insurance company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801426 | 26801426 |
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]);