This data as json, CSV (advanced)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41116 | 41116 | 1924-02-09 | 16 | c | Advertisement for Sargents Ltd, high-class pastrycooks and caterers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100614 | 24100614 | |
41117 | 41117 | 1924-02-09 | 17 | c | Advertisement for Bert Jacobson, tailor, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100613 | 24100613 | |
41121 | 41121 | 1924-02-09 | 18 | c | Advertisement for John Bull & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100616 | 24100616 | |
41135 | 41135 | 1924-02-09 | 20 | c | Advertisement for Mr Alexander, inspector of the Commonwealth General Insurance, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100618 | 24100618 | |
41141 | 41141 | 1924-02-09 | 21 | c | Advertisement for Broomfield Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100617 | 24100617 | |
41148 | 41148 | 1924-02-09 | 22 | c | Advertisement for Pinkettes, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41149 | 41149 | 1924-02-09 | 22 | c | Advertisement for L. & P. sauce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41074 | 41074 | 1924-02-09 | 5 | c-d | Advertisement for George Austen & Co, seedsmen, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41084 | 41084 | 1924-02-09 | 6 | c-d | Advertisement for War Loong & Co, produce merchant, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41085 | 41085 | 1924-02-09 | 6 | c-d | Advertisement for Lee Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
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]);