This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7130 | 7130 | 1901-02-27 | 2 | d | New governor of Guangdong and Guangxi provinces is now on the way. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099958 | 24099958 | |
7131 | 7131 | 1901-02-27 | 2 | d | The magistrate of Nanhai county was robbed when travelling by a boat to collect tax. | China | http://trove.nla.gov.au/newspaper/page/24099958 | 24099958 | |
7132 | 7132 | 1901-02-27 | 2 | d | A thief in Guangzhou disguised as a ghost. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099958 | 24099958 | |
7133 | 7133 | 1901-02-27 | 2 | d | Government forces, local gentry and others in Xiangshan county are joining forces to suppress bandits. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099958 | 24099958 | |
7154 | 7154 | 1901-02-27 | 3 | d | Selections from an English newspaper's comments on the draft peace agreement China is to sign with foreign governments. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099957 | 24099957 | |
7155 | 7155 | 1901-02-27 | 3 | d | Health authority in San Diego, of the United States, charges a fee for moving the bones of dead Chinese back to China. | America | http://trove.nla.gov.au/newspaper/page/24099957 | 24099957 | |
7156 | 7156 | 1901-02-27 | 3 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099957 | 24099957 | |
7157 | 7157 | 1901-02-27 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099957 | 24099957 |
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]);