This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4506 | 4506 | 1900-01-24 | 3 | a | A Chinese in Singapore boasts that he knows everything. | Singapore | http://trove.nla.gov.au/newspaper/page/24102682 | 24102682 | |
4630 | 4630 | 1900-02-24 | 3 | b | Chinese man Li Mingchun was saved by an ape in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24102709 | 24102709 | |
5941 | 5941 | 1900-08-25 | 3 | b | Kang Youwei escapes an assassination attempt in Singapore by two Japanese; he is now safe although injured. | Singapore | http://trove.nla.gov.au/newspaper/page/24102922 | 24102922 | |
5958 | 5958 | 1900-08-29 | 3 | b | Kang Youwei was actually not the target of an attempted assassination. | Singapore | http://trove.nla.gov.au/newspaper/page/24102926 | 24102926 | |
6265 | 6265 | 1900-10-10 | 3 | a | Various efforts to save the Emperor. | Singapore | http://trove.nla.gov.au/newspaper/page/24102978 | 24102978 | |
6483 | 6483 | 1900-11-21 | 3 | b | China's envoys to Britain, France, Russia and America write a joint letter to the Empress calling for the impeachment of Li Bingheng and several others for their collusion with Boxers. | Singapore | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6484 | 6484 | 1900-11-21 | 3 | b | A man tried to assassinate the Empress Dowager when she was leaving Beijing for Shanxi but failed. | Singapore | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6729 | 6729 | 1900-12-26 | 3 | c | New tax will be imposed in order to raise revenue for the imperial palace refurbishment. | Singapore | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6780 | 6780 | 1901-01-02 | 3 | c | Duel in France. | Singapore | http://trove.nla.gov.au/newspaper/page/24099901 | 24099901 | |
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 | |
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 | |
7088 | 7088 | 1901-02-13 | 3 | c | People in Singapore shot and killed crocodiles. | Singapore | http://trove.nla.gov.au/newspaper/page/24099949 | 24099949 | |
7506 | 7506 | 1901-04-20 | 3 | a | A welcome ceremony is being prepared in Singapore for the visit of a British prince. | Singapore | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7721 | 7721 | 1901-05-18 | 3 | b | Xue Jinqin is a female hero. | Singapore | http://trove.nla.gov.au/newspaper/page/24100042 | 24100042 | |
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 | |
7894 | 7894 | 1901-06-08 | 3 | a-b | Duan Wang is plotting a rebellion. | Singapore | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
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 | |
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 | |
8792 | 8792 | 1901-10-09 | 3 | d | A love story from Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100188 | 24100188 | |
8847 | 8847 | 1901-10-16 | 3 | c | Chinese community in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100196 | 24100196 | |
9771 | 9771 | 1902-02-05 | 3 | d | Chinese businessmen in Singapore took the government to court. | Singapore | http://trove.nla.gov.au/newspaper/page/24100319 | 24100319 | |
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 | |
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 | |
11078 | 11078 | 1902-10-11 | 3 | a | Drought in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
11207 | 11207 | 1902-11-22 | 3 | c | Flooding causes damage in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100535 | 24100535 | |
11386 | 11386 | 1903-01-10 | 3 | c | More than a thousand Chinese fought each other in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/26800150 | 26800150 | |
12313 | 12313 | 1903-10-10 | 3 | a | Chinese businessmen in Singapore Chen Chunan, Zhang Yongfu and others sent a telegram to Beijing to defend the chief-editor of subao. | Singapore | http://trove.nla.gov.au/newspaper/page/26800304 | 26800304 | |
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 | |
21774 | 21774 | 1909-10-09 | 3 | c | Chinese students in Singapore burn Japanese products in protest against their occupation of Manchuria. | Singapore | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
23786 | 23786 | 1910-11-12 | 3 | c | Railway in Singapore under British administration. | Singapore | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
24163 | 24163 | 1911-01-14 | 3 | b | The end of queue | Cutting queue becomes common among the Chinese in Singapore; celebration rituals for cutting queue; Huang Juntian from Ninyang House suggests that one should have freedom to decide whether to keep his traditional dress or not as long as it is made in China. | Singapore | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
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 |
25653 | 25653 | 1912-01-27 | 3 | b | Record of welcoming overseas students | A ceremony held in Singapore to welcome overseas students from Britain returning to China. | Singapore | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
26250 | 26250 | 1912-06-08 | 3 | a | A Thailand official steals | A Thailand official who stole many jewlries from the Queen was sentenced for two-year jail. | Singapore | http://trove.nla.gov.au/newspaper/page/24092263 | 24092263 |
27819 | 27819 | 1913-09-06 | 3 | b | New dockyard opened in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24092808 | 24092808 | |
30907 | 30907 | 1916-01-22 | 3 | a | Overseas Chinese in Singapore cables to ask consul general Tang Caizhi to remain in office. | Singapore | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
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 | |
52421 | 52421 | 1933-01-14 | 3 | c | Chinese communities in Singapore request to punish Chen Guohui and the report. | Singapore | http://trove.nla.gov.au/newspaper/page/24091085 | 24091085 | |
53263 | 53263 | 1933-09-09 | 3 | e | Rubber prices in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24091357 | 24091357 | |
54063 | 54063 | 1934-04-14 | 3 | f | Britain dispatches more troops to Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54854 | 54854 | 1935-02-09 | 3 | c | Singaporean authority restricts entry of foreign servicemen. | Singapore | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54915 | 54915 | 1935-03-02 | 3 | a | Chinese woman Wan Zhongqi and her successful flight. | Singapore | http://trove.nla.gov.au/newspaper/page/24096342 | 24096342 | |
55431 | 55431 | 1935-09-14 | 3 | a | British airforce troops to have an exercise in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096570 | 24096570 | |
55468 | 55468 | 1935-09-28 | 3 | d | Coup under the way in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
55687 | 55687 | 1935-12-28 | 3 | e | Chinese communities in Singapore destroy Japanese hospital. | Singapore | http://trove.nla.gov.au/newspaper/page/24096695 | 24096695 | |
55815 | 55815 | 1936-02-22 | 3 | a | Hu Hanmin arrives in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55832 | 55832 | 1936-02-29 | 3 | b | British navy have an exercise in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55856 | 55856 | 1936-03-07 | 3 | b | New health policy of the Singaporean authority and the influence upon the Chinese fishing ponds. | Singapore | http://trove.nla.gov.au/newspaper/page/24096767 | 24096767 | |
55898 | 55898 | 1936-03-21 | 3 | c | Chinese in Singapore demonstrate against Japanese immigrants. | Singapore | http://trove.nla.gov.au/newspaper/page/24096783 | 24096783 | |
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 | |
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 | |
56471 | 56471 | 1936-12-05 | 3 | d | Japanese goods in the Nanyang area are replacing British goods. | Singapore | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 |
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]);