This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4865 | 4865 | 1900-03-28 | 2 | d | Report on the current political situation in China. | Singapore | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
5203 | 5203 | 1900-05-12 | 2 | d | A high-level official in Beijing says the newspaper would be rewarded if they published article criticising reform efforts. | Singapore | http://trove.nla.gov.au/newspaper/page/24102800 | 24102800 | |
5926 | 5926 | 1900-08-25 | 2 | d | A Chinese in Singapore collects signatures and volunteers to help Britain to put down Boxers in China and to overthrow Manchurian dynasty. | Singapore | http://trove.nla.gov.au/newspaper/page/24102923 | 24102923 | |
6595 | 6595 | 1900-12-08 | 2 | d | Li Hongzhang talkes about the difficulties he faces in negotiating with foreign countries. | Singapore | http://trove.nla.gov.au/newspaper/page/24103041 | 24103041 | |
6663 | 6663 | 1900-12-19 | 2 | d | Singing stones in north America. | Singapore | http://trove.nla.gov.au/newspaper/page/24103053 | 24103053 | |
8236 | 8236 | 1901-07-24 | 3 | d | The Hong Kong -Shanghai Bank in Singapore found the bank notes they lost. | Singapore | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8271 | 8271 | 1901-07-31 | 2 | d | Three men were arrested for stealing bank notes from the Hong Kong - Shanghai Bank. | Singapore | http://trove.nla.gov.au/newspaper/page/24100126 | 24100126 | |
8597 | 8597 | 1901-09-21 | 2 | d | A Chinese student was the first in an examination and would be sent to study in Britain. | Singapore | http://trove.nla.gov.au/newspaper/page/24100169 | 24100169 | |
8792 | 8792 | 1901-10-09 | 3 | d | A love story from Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100188 | 24100188 | |
9771 | 9771 | 1902-02-05 | 3 | d | Chinese businessmen in Singapore took the government to court. | Singapore | http://trove.nla.gov.au/newspaper/page/24100319 | 24100319 | |
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 | |
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 | |
54760 | 54760 | 1934-12-22 | 6 | d | British army in Singapore and their exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
55468 | 55468 | 1935-09-28 | 3 | d | Coup under the way in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
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 |
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]);