This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41055 | 41055 | 1924-02-09 | 4 | d | Advertisement for Kee Heung & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41056 | 41056 | 1924-02-09 | 4 | d | Advertisement for herbalist Chan York Chee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41070 | 41070 | 1924-02-09 | 5 | d | Advertisement for Holdsworth McPherson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41071 | 41071 | 1924-02-09 | 5 | d | Advertisement for Doctor Sue Fong in Emmaville. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41072 | 41072 | 1924-02-09 | 5 | d | Advertisement for Dr Wu Yiluan by Chen Lin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41073 | 41073 | 1924-02-09 | 5 | d | Advertisement for Dockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41083 | 41083 | 1924-02-09 | 6 | d | Advertisement for Hong Kong Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41088 | 41088 | 1924-02-09 | 6 | d | Advertisement for King Young, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41089 | 41089 | 1924-02-09 | 6 | d | Advertisement for Tiy Loy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41095 | 41095 | 1924-02-09 | 10 | d | Advertisement for Chinese herbalist Huang Liangnan by Li Xianchou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100608 | 24100608 | |
41150 | 41150 | 1924-02-09 | 22 | d | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 |
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]);