This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4660 | 4660 | 1900-03-03 | 2 | b-c | Foreign countries should intervene and push for China's reform. | Singapore | http://trove.nla.gov.au/newspaper/page/24102718 | 24102718 | |
5227 | 5227 | 1900-05-16 | 2 | b-c | Hong Kong Governor offers protection for reformers, who are threatened by the Chinese government. | Singapore | http://trove.nla.gov.au/newspaper/page/24102804 | 24102804 | |
5821 | 5821 | 1900-08-11 | 2 | b-c | An article on the advantages of Chinese businessmen uniting together. | Singapore | http://trove.nla.gov.au/newspaper/page/24102904 | 24102904 | |
6421 | 6421 | 1900-11-10 | 2 | b-c | A prominent Japanese talks about Russia's ambitions for east Asia, China's situation and its future, and Japan's relations with Russia and China. | Singapore | http://trove.nla.gov.au/newspaper/page/24103012 | 24103012 | |
6738 | 6738 | 1900-12-29 | 2 | b-c | Zhang Zhidong contacts Japanese ambassador to China to continue negotiating for peace. | Singapore | http://trove.nla.gov.au/newspaper/page/24103065 | 24103065 | |
7735 | 7735 | 1901-05-22 | 2 | b-c | A letter from Tao Mo, governor of Guangdong and Guangxi provinces, to the Chinese consul in Singapore in regards to Qiu Shuyuan and Lin Wenqing. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
9806 | 9806 | 1902-02-19 | 2 | b-c | Comments on the Emperor's return to Beijing. | Singapore | http://trove.nla.gov.au/newspaper/page/24100330 | 24100330 | |
23050 | 23050 | 1910-07-02 | 2 | b-c | Kang Youwei in Singapore talks about current situation in China and its future development. | Singapore | http://trove.nla.gov.au/newspaper/page/26802682 | 26802682 |
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]);