This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
20664 | 20664 | 1909-02-13 | 8 | b | Letter from Beijing reports on the last days of Empress Dowager. | Singapore | http://trove.nla.gov.au/newspaper/page/26802082 | 26802082 | |
28493 | 28493 | 1914-02-21 | 8 | b | Sun Yatsen and Huang Xing arrives Nanyang. | Singapore | http://trove.nla.gov.au/newspaper/page/24093020 | 24093020 | |
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 | |
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 | |
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 | |
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 | |
56298 | 56298 | 1936-09-26 | 8 | e | Chinese workers on strike in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24097010 | 24097010 |
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]);