This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17841 | 17841 | 1907-07-27 | 2 | b-d | Wang Daxie, Chinese ambassador to London, talks to Hong Kong journalist on his way back to China on opium ban, overseas Chinese, proposed setup of Chinese consulate in Australia and Canada, China's treaty with Western countries and indemnity, treaty between France and Japan and its possible influence upon China, Chinese community in Singapore, and many others. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26801412 | 26801412 | |
34504 | 34504 | 1919-05-24 | 2 | b-d | Third part of the report on the independence movement in Korea. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24097726 | 24097726 | |
41858 | 41858 | 1924-07-26 | 3 | b-d | Shipping industry and their competition in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100800 | 24100800 |
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]);