This data as json, CSV (advanced)
Suggested facets: date, page, title, page_url, trove_id, 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 | |
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]);