This data as json, CSV (advanced)
Link | rowid | date | page | column ▲ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28493 | 28493 | 1914-02-21 | 8 | b | Sun Yatsen and Huang Xing arrives Nanyang. | Singapore | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 | |
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 | |
45079 | 45079 | 1926-08-21 | 5 | b | Bandits and robbery in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
45080 | 45080 | 1926-08-21 | 5 | b | Singaporean police raid on rubber smuggling. | Singapore | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
51292 | 51292 | 1932-03-12 | 8 | b | Fighting of the Chinese communities in Penang, Malaysia. | Singapore | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51672 | 51672 | 1932-07-02 | 8 | b | Revolution in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24090862 | 24090862 | |
51783 | 51783 | 1932-08-06 | 8 | b | Chinese community in Singapore and a church chaos. | Singapore | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
53467 | 53467 | 1933-10-28 | 6 | b | Failed revolution in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24091418 | 24091418 | |
53844 | 53844 | 1934-02-10 | 6 | b | The possibility of a Pacific war. | Singapore | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
54744 | 54744 | 1934-12-15 | 6 | b | Japanese seek to take over Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096267 | 24096267 | |
54890 | 54890 | 1935-02-16 | 6 | b | Singaporean air force troops on exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
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 | |
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 | |
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 | |
5114 | 5114 | 1900-05-02 | 2 | a-b | A report on the Empress published in a Singaporean English newspaper. | Singapore | http://trove.nla.gov.au/newspaper/page/24102787 | 24102787 | |
5691 | 5691 | 1900-07-18 | 2 | a-b | An introduction to small but democratic countries. | Singapore | http://trove.nla.gov.au/newspaper/page/24102878 | 24102878 | |
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 | |
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 | |
7007 | 7007 | 1901-02-06 | 2 | a-b | An article describes the prosperity and decline of Manchuria. | Singapore | http://trove.nla.gov.au/newspaper/page/24099942 | 24099942 | |
7894 | 7894 | 1901-06-08 | 3 | a-b | Duan Wang is plotting a rebellion. | Singapore | http://trove.nla.gov.au/newspaper/page/24100066 | 24100066 | |
16550 | 16550 | 1906-12-08 | 5 | a-b | An essay on theocracy, selected from Chinese newspaper in Singapore wen xing bao. | Singapore | http://trove.nla.gov.au/newspaper/page/26801156 | 26801156 | |
16815 | 16815 | 1907-01-19 | 8 | a-b | An article selected from Nanyang zong hui bao on reform of superstition in the Chinese community in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/26801205 | 26801205 | |
21997 | 21997 | 1909-11-20 | 6 | a-b | First part of a report, prepared by Wu Xianzi, says that the Chinese communities in Nanyang mourn over the national doom of China. | Singapore | http://trove.nla.gov.au/newspaper/page/26802404 | 26802404 | |
22188 | 22188 | 1910-01-01 | 2 | a-b | First part of a report, prepared by Chinese revolutionaries in Nanyang, lists crimes committed by Sun Yatsen. | Singapore | http://trove.nla.gov.au/newspaper/page/26802448 | 26802448 | |
23275 | 23275 | 1910-08-06 | 6 | a-b | Chinese ambassador to Germany Liang Cheng is recalled and now in Singapore on his way back. Kang Youwei in Singapore tries to meet Liang Cheng. | Singapore | http://trove.nla.gov.au/newspaper/page/26802726 | 26802726 | |
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 | |
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 | |
6265 | 6265 | 1900-10-10 | 3 | a | Various efforts to save the Emperor. | Singapore | http://trove.nla.gov.au/newspaper/page/24102978 | 24102978 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12419 | 12419 | 1903-11-14 | 2 | a | Chinese communities in Nanyang sent telegrams to Beijing asking for power to be returned to the Emperor. However, all these telegrams are withheld by the foreign affairs office. | Singapore | http://trove.nla.gov.au/newspaper/page/26800325 | 26800325 | |
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 |
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 |
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 | |
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 | |
44902 | 44902 | 1926-07-03 | 5 | a | Singaporean authority seize smuggled opium. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44903 | 44903 | 1926-07-03 | 5 | a | Epidemic in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
51473 | 51473 | 1932-04-30 | 5 | a | A report on floating in the Indian Ocean for 49 days. | Singapore | http://trove.nla.gov.au/newspaper/page/24090785 | 24090785 | |
53949 | 53949 | 1934-03-10 | 6 | a | Air defence in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24091561 | 24091561 | |
54002 | 54002 | 1934-03-24 | 6 | a | Chinese man in Singapore shoots dead police officer. | Singapore | http://trove.nla.gov.au/newspaper/page/24091577 | 24091577 | |
54825 | 54825 | 1935-01-26 | 6 | a | Singaporean authority has finalised its defence plan. | Singapore | http://trove.nla.gov.au/newspaper/page/24096307 | 24096307 | |
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 | |
55317 | 55317 | 1935-08-03 | 8 | a | A blast in Singapore and the investigation. | Singapore | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 | |
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 | |
55815 | 55815 | 1936-02-22 | 3 | a | Hu Hanmin arrives in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 |
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]);