This data as json, CSV (advanced)
Link | rowid | date | page | column | title ▼ | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44903 | 44903 | 1926-07-03 | 5 | a | Epidemic in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
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 | |
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 | |
45009 | 45009 | 1926-07-31 | 5 | c | Building of naval port in Singapore. | 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 | |
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 | |
45712 | 45712 | 1927-05-14 | 2 | f | Chinese community in Singapore and its declaration. | Singapore | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53467 | 53467 | 1933-10-28 | 6 | b | Failed revolution in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24091418 | 24091418 | |
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 | |
53844 | 53844 | 1934-02-10 | 6 | b | The possibility of a Pacific war. | Singapore | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53949 | 53949 | 1934-03-10 | 6 | a | Air defence in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24091561 | 24091561 | |
53977 | 53977 | 1934-03-17 | 6 | d | Chinese man in Singapore shoots dead police officer. | Singapore | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
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 | |
54063 | 54063 | 1934-04-14 | 3 | f | Britain dispatches more troops to Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54073 | 54073 | 1934-04-14 | 6 | d | Chinese man arrested in Singapore for shooting dead a police officer. | Singapore | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
54441 | 54441 | 1934-08-18 | 6 | c | Fire in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54744 | 54744 | 1934-12-15 | 6 | b | Japanese seek to take over Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096267 | 24096267 | |
54760 | 54760 | 1934-12-22 | 6 | d | British army in Singapore and their exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54825 | 54825 | 1935-01-26 | 6 | a | Singaporean authority has finalised its defence plan. | Singapore | http://trove.nla.gov.au/newspaper/page/24096307 | 24096307 | |
54854 | 54854 | 1935-02-09 | 3 | c | Singaporean authority restricts entry of foreign servicemen. | Singapore | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54890 | 54890 | 1935-02-16 | 6 | b | Singaporean air force troops on exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
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 | |
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 | |
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 | |
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 | |
56298 | 56298 | 1936-09-26 | 8 | e | Chinese workers on strike in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24097010 | 24097010 | |
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 | |
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 |
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 |
24628 | 24628 | 1911-06-03 | 6 | b | Sighseeing the Haishen warship | Many people went to visit Haishen warship when it arrived Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24091799 | 24091799 |
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 |
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]);