This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
14883 | 14883 | 1905-10-14 | 2 | a-b | First part of three songs of the Chinese Empire Reform Association, written by Kang Youwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800799 | 26800799 | |
14884 | 14884 | 1905-10-14 | 2 | b-c | Imperial edict to abolish the imperial examination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800799 | 26800799 | |
14885 | 14885 | 1905-10-14 | 2 | c | School children in Shanghai organise themselves to protest against American immigration policy. Chinese businessmen in Vietnam protest against renewed American immigration policy. Second reply from Governor Qin Chunxuan to American consul in regards to the protest movement in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800799 | 26800799 | |
14886 | 14886 | 1905-10-14 | 2 | c-d | Chinese government to monopolise telephone and telegram. Telegram from Chinese students in Japan to the central government in Beijing in regards to the railway from Tianjin to Zhenjiang and pressure from Germany. Yuan Shikai donates to build the railway from Tianjin to Zhenjiang. China has secured another loan from Belgium for the railway building from Luzhou, Sichuan, to Hankou, Hubei province. Board of Revenue is trying to raise funds for officials' overseas investigation. Preparation of military parade and its commander. Comparison of postal service in China of 1901 and 1904. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800799 | 26800799 |
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]);