This data as json, CSV (advanced)
Suggested facets: date, page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4871 | 4871 | 1900-03-28 | 2 | f | The value of China's national debt. | Singapore | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
5097 | 5097 | 1900-04-28 | 2 | f | The Spring Festival couplets which Chinese wrote in Singapore clearly expressed their love of the Emperor. | Singapore | http://trove.nla.gov.au/newspaper/page/24102783 | 24102783 | |
6216 | 6216 | 1900-10-03 | 2 | f | Sun Yatsen's attempt to assassinate Kang Youwei, which was masterminded by Liu Xuexun in Beijing. The whereabouts of Sun Yatsen after that. | Singapore | http://trove.nla.gov.au/newspaper/page/24102969 | 24102969 | |
6304 | 6304 | 1900-10-17 | 2 | f | Further report on Sun Yatsen and the attempt to assassinate Kang Youwei in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6475 | 6475 | 1900-11-21 | 2 | f | The Boer War. Britain's military expenditure for their war in South Africa. | Singapore | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
7021 | 7021 | 1901-02-06 | 2 | f | Zhang Zhidong has three favourite students: Yang Rui, Liang Qichao, and Fu Cixiang. | Singapore | http://trove.nla.gov.au/newspaper/page/24099942 | 24099942 | |
7207 | 7207 | 1901-03-09 | 2 | f | A rich man in Britain built a cool room to store food. | Singapore | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
7750 | 7750 | 1901-05-22 | 2 | f | Huang Fucheng and Li Ai'sheng, both from Fujian province, cultivate wasteland with hundreds of peasants coming from Fujian, China. Deng Gongshu and Zheng Zaoshang, both from Guangdong, are keen to follow. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7838 | 7838 | 1901-06-01 | 2 | f | Report on Zhang Zhidong's response to the protest rally of Shanghai gentry against the treaty with Russia. | Singapore | http://trove.nla.gov.au/newspaper/page/24100059 | 24100059 | |
7841 | 7841 | 1901-06-01 | 2 | f | A women's university was been established in Tokyo. | Singapore | http://trove.nla.gov.au/newspaper/page/24100059 | 24100059 | |
7892 | 7892 | 1901-06-08 | 2 | f | Some Chinese are not happy on seeing rickshawmen of the Prince with gold necklace. | Singapore | http://trove.nla.gov.au/newspaper/page/24100067 | 24100067 | |
9214 | 9214 | 1901-11-30 | 2 | f | Prince Chun is on the way back to China after visiting Germany. | Singapore | http://trove.nla.gov.au/newspaper/page/24100249 | 24100249 | |
9364 | 9364 | 1901-12-18 | 2 | f | The first part of a report on Dong Fuxiang and his army. | Singapore | http://trove.nla.gov.au/newspaper/page/24100269 | 24100269 | |
9960 | 9960 | 1902-03-08 | 2 | f | Germany will once again help China stamp out rebells if necessary; Germany wants to access to all privileges other nations in China enjoy. | Singapore | http://trove.nla.gov.au/newspaper/page/24100347 | 24100347 | |
10021 | 10021 | 1902-03-15 | 2 | f | Poems in praise of Lin Zhiyi, a Chinese businessman and philanthropist in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
42739 | 42739 | 1925-02-21 | 3 | f | Ships between China and Singapore take precautions against pirates. | Singapore | http://trove.nla.gov.au/newspaper/page/24101033 | 24101033 | |
45712 | 45712 | 1927-05-14 | 2 | f | Chinese community in Singapore and its declaration. | Singapore | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
54063 | 54063 | 1934-04-14 | 3 | f | Britain dispatches more troops to Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 |
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]);