This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35187 | 35187 | 1919-12-27 | 7 | a-c | Australia news/ New coal mine found near Rockhampton, Queensland. Passenger liner St Albion delays its departure for Hong Kong. British pilot is arriving Sydney. Tung Wah editor condemns Chen Renyi for whose support to Huang Yougong and the Republic News. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097987 | 24097987 | |
35188 | 35188 | 1919-12-27 | 7 | c | Advertisement for The Sun Company in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097987 | 24097987 | |
35189 | 35189 | 1919-12-27 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097987 | 24097987 |
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]);