This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
10058 | 10058 | 1902-03-19 | 3 | a | Portugal cedes an island in the Indian Ocean to the United States. | Singapore | http://trove.nla.gov.au/newspaper/page/24100359 | 24100359 | |
19899 | 19899 | 1908-08-29 | 3 | c | Preparation for the international opium conference in Shanghai sponsored by American government. | Singapore | http://trove.nla.gov.au/newspaper/page/26801858 | 26801858 | |
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 | |
30842 | 30842 | 1915-12-18 | 8 | a-b | Public letter of the Progress Party in Singapore's Transport Department to overseas Chinese declares its opposition to imperial system restoration in China. | Singapore | http://trove.nla.gov.au/newspaper/page/24095100 | 24095100 | |
7753 | 7753 | 1901-05-22 | 3 | a | Qiu Shuyuan replied from Singapore to Tao Mo, governor of Guangdong. | Singapore | http://trove.nla.gov.au/newspaper/page/24100046 | 24100046 | |
23786 | 23786 | 1910-11-12 | 3 | c | Railway in Singapore under British administration. | Singapore | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
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 | |
14832 | 14832 | 1905-09-30 | 2 | b | Report on a graduation ceremony in Cornell University and Chinese graduates including Shi Zhaoxiang, Wu Guiling and Hu Dongchao. | Singapore | http://trove.nla.gov.au/newspaper/page/26800788 | 26800788 | |
4865 | 4865 | 1900-03-28 | 2 | d | Report on the current political situation in China. | Singapore | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
51672 | 51672 | 1932-07-02 | 8 | b | Revolution in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24090862 | 24090862 | |
22355 | 22355 | 1910-02-05 | 2 | c | Revolutionary followers in Nanyang disperse. | Singapore | http://trove.nla.gov.au/newspaper/page/26802488 | 26802488 | |
49682 | 49682 | 1930-11-08 | 8 | c | Rubber factory in Singapore on fire. | Singapore | http://trove.nla.gov.au/newspaper/page/24099843 | 24099843 | |
53263 | 53263 | 1933-09-09 | 3 | e | Rubber prices in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24091357 | 24091357 | |
22225 | 22225 | 1910-01-08 | 2 | a-c | Second and final part of the report, prepared by Chinese revolutionaries in Nanyang, lists crimes committed by Sun Yatsen. | Singapore | http://trove.nla.gov.au/newspaper/page/26802456 | 26802456 | |
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 | |
8574 | 8574 | 1901-09-18 | 3 | b | Singapore is going to issue a new regulation in order to limit the entry of Chinese. | Singapore | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
25027 | 25027 | 1911-09-23 | 3 | a | Famine in Singapore | Singapore suffers a famine due to natural disaster. | Singapore | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
54890 | 54890 | 1935-02-16 | 6 | b | Singaporean air force troops on exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
54825 | 54825 | 1935-01-26 | 6 | a | Singaporean authority has finalised its defence plan. | Singapore | http://trove.nla.gov.au/newspaper/page/24096307 | 24096307 | |
56010 | 56010 | 1936-05-02 | 3 | c | Singaporean authority imposes strict restrictions upon entry of foreigners. | Singapore | http://trove.nla.gov.au/newspaper/page/24096831 | 24096831 | |
56288 | 56288 | 1936-09-26 | 3 | c | Singaporean authority issues new regulations on immigration. | Singapore | http://trove.nla.gov.au/newspaper/page/24097003 | 24097003 | |
54854 | 54854 | 1935-02-09 | 3 | c | Singaporean authority restricts entry of foreign servicemen. | Singapore | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
55029 | 55029 | 1935-04-20 | 8 | b | Singaporean authority seeks to expand its military forces. | Singapore | http://trove.nla.gov.au/newspaper/page/24096404 | 24096404 | |
45005 | 45005 | 1926-07-31 | 5 | b | Singaporean authority seize smuggled opium on a ship from Xiamen. | Singapore | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
44902 | 44902 | 1926-07-03 | 5 | a | Singaporean authority seize smuggled opium. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
45080 | 45080 | 1926-08-21 | 5 | b | Singaporean police raid on rubber smuggling. | Singapore | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
6663 | 6663 | 1900-12-19 | 2 | d | Singing stones in north America. | Singapore | http://trove.nla.gov.au/newspaper/page/24103053 | 24103053 | |
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 | |
56368 | 56368 | 1936-10-31 | 3 | d | Strike in Singapore stops the building of naval port. | Singapore | http://trove.nla.gov.au/newspaper/page/24097043 | 24097043 | |
28493 | 28493 | 1914-02-21 | 8 | b | Sun Yatsen and Huang Xing arrives Nanyang. | Singapore | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 | |
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 | |
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 | |
8236 | 8236 | 1901-07-24 | 3 | d | The Hong Kong -Shanghai Bank in Singapore found the bank notes they lost. | Singapore | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
44900 | 44900 | 1926-07-03 | 5 | a | The Malay government helps to build naval port of Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
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 | |
5621 | 5621 | 1900-07-07 | 2 | e | The building of a Confucian school and temple in Singapore, organised by Chinese businessman Li Lianxi, is to be completed soon. | Singapore | http://trove.nla.gov.au/newspaper/page/24102866 | 24102866 | |
7022 | 7022 | 1901-02-06 | 3 | a | The execution of Xu Tong and the influence upon his family. | Singapore | http://trove.nla.gov.au/newspaper/page/24099941 | 24099941 | |
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 | |
5861 | 5861 | 1900-08-18 | 2 | a-b | The first part of an article arguing that the dynasty will change following the Boxer rebellions. | Singapore | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
44959 | 44959 | 1926-07-17 | 5 | c | The population in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101633 | 24101633 | |
53844 | 53844 | 1934-02-10 | 6 | b | The possibility of a Pacific war. | Singapore | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
5896 | 5896 | 1900-08-22 | 2 | a-b | The second and final part of an article discussing changes to the dynasty in the wake of the Boxer rebellions. | Singapore | http://trove.nla.gov.au/newspaper/page/24102919 | 24102919 | |
4871 | 4871 | 1900-03-28 | 2 | f | The value of China's national debt. | Singapore | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
8271 | 8271 | 1901-07-31 | 2 | d | Three men were arrested for stealing bank notes from the Hong Kong - Shanghai Bank. | Singapore | http://trove.nla.gov.au/newspaper/page/24100126 | 24100126 | |
7023 | 7023 | 1901-02-06 | 3 | a | Tianjin's new administrator Ding Jiali and his policy. | Singapore | http://trove.nla.gov.au/newspaper/page/24099941 | 24099941 | |
45338 | 45338 | 1926-12-04 | 5 | c | Two Chinese passengers fight on board of Japanese mail liner. | Singapore | http://trove.nla.gov.au/newspaper/page/24101801 | 24101801 | |
7746 | 7746 | 1901-05-22 | 2 | e | Why Yuan Chang and Xu Jingcheng were executed. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
10306 | 10306 | 1902-04-12 | 3 | a | Wu Zhihui and Niu Tiesheng talk in Guangzhou about reform and modern education. | Singapore | http://trove.nla.gov.au/newspaper/page/24100387 | 24100387 | |
7721 | 7721 | 1901-05-18 | 3 | b | Xue Jinqin is a female hero. | Singapore | http://trove.nla.gov.au/newspaper/page/24100042 | 24100042 | |
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 | |
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 |
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]);