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 |
---|---|---|---|---|---|---|---|---|---|
41043 | 41043 | 1924-02-09 | 3 | c | Advertisement for Gibbs Bright & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100599 | 24100599 | |
41054 | 41054 | 1924-02-09 | 4 | c | Advertisement for War Loong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41066 | 41066 | 1924-02-09 | 5 | c | Advertisement for Gibbs Bright & Co, insurance department, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41067 | 41067 | 1924-02-09 | 5 | c | Advertisement for Kwong War Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41068 | 41068 | 1924-02-09 | 5 | c | Advertisement for Ping Hong Lowe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41069 | 41069 | 1924-02-09 | 5 | c | Advertisement for Sun Tuey Wah Chockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41082 | 41082 | 1924-02-09 | 6 | c | Advertisement for Kwong Ring Chong, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41086 | 41086 | 1924-02-09 | 6 | c | Advertisement for Goon Lee Shing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41087 | 41087 | 1924-02-09 | 6 | c | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41093 | 41093 | 1924-02-09 | 10 | c | Advertisement for On Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100608 | 24100608 | |
41094 | 41094 | 1924-02-09 | 10 | c | Advertisement for W. Mow Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100608 | 24100608 | |
41098 | 41098 | 1924-02-09 | 11 | c | Advertisement for Mick Simmons Ltd, the leading tobacco warehouse in the Commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100607 | 24100607 | |
41100 | 41100 | 1924-02-09 | 12 | c | Advertisement for the Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100610 | 24100610 | |
41103 | 41103 | 1924-02-09 | 13 | c | Advertisement for Brunton's flour, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100609 | 24100609 | |
41104 | 41104 | 1924-02-09 | 13 | c | Advertisement for Anderson & Co Ltd, seedsmen, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100609 | 24100609 | |
41108 | 41108 | 1924-02-09 | 14 | c | Advertisement for Lindeman's Ltd, Queen Victoria Market, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100612 | 24100612 | |
41112 | 41112 | 1924-02-09 | 15 | c | Advertisement for Lea & Perrin's sauce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100611 | 24100611 | |
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 |
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]);