This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45468 | 45468 | 1927-02-05 | 10 | a | Photograph of Ye Gengmiao (Dulcey Quoy), Ye Lijiao (Greta Quoy) and Ye Genghao (Essie Quoy), three daughters of Ye Tonggui (T. G. Quoy) in Sydney, and English introduction to this family. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101880 | 24101880 | |
45469 | 45469 | 1927-02-05 | 10 | a | English message from the New South Wales Chinese Chamber of Commerce acknowledges receipt of donations to the Cancer Research Fund. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101880 | 24101880 | |
45470 | 45470 | 1927-02-05 | 10 | b | Photographs of Li Qiongfang (Miss Ivy Towe), Mrs Wu Yangshou (Young Show), and Miss Luo Yanxia (Ida Yum). English article for sale of badges in aid of Cancer Research Fund. The Sydney Chinese Tennis Club Dance. Picnic to Commemorate the anniversary of the Birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101880 | 24101880 | |
45471 | 45471 | 1927-02-05 | 10 | c | Photograph of the busy town in Qingdao (Tsing-tao). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101880 | 24101880 | |
45472 | 45472 | 1927-02-05 | 10 | c | Liberation of women should first be encouraged. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101880 | 24101880 | |
45473 | 45473 | 1927-02-05 | 10 | d | Wife of Hong Kong governor visits the haircut show. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101880 | 24101880 |
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]);