This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45807 | 45807 | 1927-06-18 | 2 | b | Tung Wah Times comments on the war in the Balkan peninsula. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102027 | 24102027 | |
45825 | 45825 | 1927-06-18 | 7 | a | Australia news/ A Sydney studio is penalised for printing phonographic pictures. A man is detained in Surrey Hills, Sydney, for sexual harassment. Chinese restaurants are advised to pay attention to hygiene issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45831 | 45831 | 1927-06-18 | 7 | b | A letter from the Chinese National Chamber of Commerce to its Sydney counterpart. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45832 | 45832 | 1927-06-18 | 7 | c | A letter from Wu Elou (Xiuguang) in Hong Kong reporting his meeting with Ye Tonggui, Huang Huannan, Xia Congzhou and other Chinese businessmen returned from Australia, and the change in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 |
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]);