This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description ▲ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
53564 | 53564 | 1933-11-18 | 6 | e | Chinese in Thailand on riots in protest against heavy taxes. | Singapore | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
55898 | 55898 | 1936-03-21 | 3 | c | Chinese in Singapore demonstrate against Japanese immigrants. | Singapore | http://trove.nla.gov.au/newspaper/page/24096783 | 24096783 | |
5204 | 5204 | 1900-05-12 | 2 | e | Chinese gunboats are yet to leave for Singapore. Plans still being put in place. | Singapore | http://trove.nla.gov.au/newspaper/page/24102800 | 24102800 | |
8847 | 8847 | 1901-10-16 | 3 | c | Chinese community in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100196 | 24100196 | |
4742 | 4742 | 1900-03-14 | 2 | c | Chinese community in Singapore organised Chinese Empire Reform Association and sent telegram to Beijing. | Singapore | http://trove.nla.gov.au/newspaper/page/24102731 | 24102731 | |
45712 | 45712 | 1927-05-14 | 2 | f | Chinese community in Singapore and its declaration. | Singapore | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
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 | |
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 | |
55687 | 55687 | 1935-12-28 | 3 | e | Chinese communities in Singapore destroy Japanese hospital. | Singapore | http://trove.nla.gov.au/newspaper/page/24096695 | 24096695 | |
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 | |
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 | |
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 | |
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 | |
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 | |
27873 | 27873 | 1913-09-13 | 7 | c | Chen Jiongming flees to Singapore and the report. | Singapore | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 | |
45009 | 45009 | 1926-07-31 | 5 | c | Building of naval port in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
42100 | 42100 | 1924-09-20 | 6 | d-e | British scholar talks in Singapore the Oriental civilisation, Tagore and others. | Singapore | http://trove.nla.gov.au/newspaper/page/24100869 | 24100869 | |
55832 | 55832 | 1936-02-29 | 3 | b | British navy have an exercise in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
54760 | 54760 | 1934-12-22 | 6 | d | British army in Singapore and their exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
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 | |
54063 | 54063 | 1934-04-14 | 3 | f | Britain dispatches more troops to Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
45079 | 45079 | 1926-08-21 | 5 | b | Bandits and robbery in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101673 | 24101673 | |
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 | |
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 | |
10777 | 10777 | 1902-06-04 | 2 | b-d | An article, written by Huang Zhaoyuan and published in a Singapore newspaper, comments on pigtail-cutting. | Singapore | http://trove.nla.gov.au/newspaper/page/24100448 | 24100448 | |
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 | |
10348 | 10348 | 1902-04-19 | 2 | b-d | An article on the marriage and communication between the Manchurian and Han people. | Singapore | http://trove.nla.gov.au/newspaper/page/24100396 | 24100396 | |
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 | |
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 | |
5776 | 5776 | 1900-08-01 | 2 | c | An appeal, prepared by Wang Yijian, for donations to build a Confucian school in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24102894 | 24102894 | |
50506 | 50506 | 1931-07-11 | 8 | c | An English man is murdered in Singapore while walking on the street with his Chinese wife. | Singapore | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
53949 | 53949 | 1934-03-10 | 6 | a | Air defence in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24091561 | 24091561 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
8792 | 8792 | 1901-10-09 | 3 | d | A love story from Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100188 | 24100188 | |
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 | |
5203 | 5203 | 1900-05-12 | 2 | d | A high-level official in Beijing says the newspaper would be rewarded if they published article criticising reform efforts. | Singapore | http://trove.nla.gov.au/newspaper/page/24102800 | 24102800 | |
5147 | 5147 | 1900-05-05 | 2 | e | A fish-like animal lives in the tree. | Singapore | http://trove.nla.gov.au/newspaper/page/24102792 | 24102792 | |
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 |
55317 | 55317 | 1935-08-03 | 8 | a | A blast in Singapore and the investigation. | Singapore | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 | |
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 |
7066 | 7066 | 1901-02-13 | 2 | c | A Nagasaki newspaper reports on the amount of compensation China would be able to pay. | Singapore | http://trove.nla.gov.au/newspaper/page/24099950 | 24099950 | |
8597 | 8597 | 1901-09-21 | 2 | d | A Chinese student was the first in an examination and would be sent to study in Britain. | Singapore | http://trove.nla.gov.au/newspaper/page/24100169 | 24100169 | |
5926 | 5926 | 1900-08-25 | 2 | d | A Chinese in Singapore collects signatures and volunteers to help Britain to put down Boxers in China and to overthrow Manchurian dynasty. | Singapore | http://trove.nla.gov.au/newspaper/page/24102923 | 24102923 | |
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 |
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]);