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