This data as json, CSV (advanced)
Suggested facets: date, page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
6660 | 6660 | 1900-12-19 | 2 | c | International troops share the gold and treasures they looted in Baoding; American government is not satisfied with performance of the commander of international troops in China; all family members of Nie Gongting was killed except for one of his sons. | Singapore | http://trove.nla.gov.au/newspaper/page/24103053 | 24103053 | |
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 | |
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 | |
7088 | 7088 | 1901-02-13 | 3 | c | People in Singapore shot and killed crocodiles. | Singapore | http://trove.nla.gov.au/newspaper/page/24099949 | 24099949 | |
8847 | 8847 | 1901-10-16 | 3 | c | Chinese community in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100196 | 24100196 | |
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 | |
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 | |
22355 | 22355 | 1910-02-05 | 2 | c | Revolutionary followers in Nanyang disperse. | Singapore | http://trove.nla.gov.au/newspaper/page/26802488 | 26802488 | |
23786 | 23786 | 1910-11-12 | 3 | c | Railway in Singapore under British administration. | Singapore | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
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 | |
44938 | 44938 | 1926-07-10 | 7 | c | Class strike in a Chinese school in Singapore and the report. | Singapore | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
44959 | 44959 | 1926-07-17 | 5 | c | The population in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101633 | 24101633 | |
45009 | 45009 | 1926-07-31 | 5 | c | Building of naval port in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
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 | |
49003 | 49003 | 1930-03-22 | 8 | c | Opium smuggling in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24099575 | 24099575 | |
49682 | 49682 | 1930-11-08 | 8 | c | Rubber factory in Singapore on fire. | Singapore | http://trove.nla.gov.au/newspaper/page/24099843 | 24099843 | |
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 | |
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 | |
54441 | 54441 | 1934-08-18 | 6 | c | Fire in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54854 | 54854 | 1935-02-09 | 3 | c | Singaporean authority restricts entry of foreign servicemen. | Singapore | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
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 |
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]);