This data as json, CSV (advanced)
Suggested facets: page, description, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34074 | 34074 | 1919-02-08 | 3 | c | Advertisement for Thomas Hardy & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34075 | 34075 | 1919-02-08 | 3 | c | Advertisement for Ford Adams & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34076 | 34076 | 1919-02-08 | 3 | c | Advertisement for The Commonwealth Studio, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34077 | 34077 | 1919-02-08 | 3 | c | Advertisement for W. Schofield & Co, builders and contractors, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34078 | 34078 | 1919-02-08 | 3 | c | Advertisement for Stanton, Cook & Co, electrical light engineers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34088 | 34088 | 1919-02-08 | 7 | c | Advertisement for Lea & Perrins' sauce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097602 | 24097602 | |
34092 | 34092 | 1919-02-08 | 8 | c | Advertisement for the Black & White Whisky. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097605 | 24097605 | |
34095 | 34095 | 1919-02-08 | 9 | c | Advertisement for Lindeman's Ltd, Queen Victoria Markets, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097604 | 24097604 | |
34099 | 34099 | 1919-02-08 | 10 | c | Advertisement for the Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097607 | 24097607 | |
34102 | 34102 | 1919-02-08 | 11 | c | Advertisement for David Cohen & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097606 | 24097606 | |
34112 | 34112 | 1919-02-08 | 12 | c | Advertisement for Arnott's biscuits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097609 | 24097609 | |
34122 | 34122 | 1919-02-08 | 14 | c | Advertisement for Geo Helcombe, Jun, Sydne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34123 | 34123 | 1919-02-08 | 14 | c | Advertisement for W. Schofield & Co, builders and contractors, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34124 | 34124 | 1919-02-08 | 14 | c | Advertisement for Hebley & Tom, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34125 | 34125 | 1919-02-08 | 14 | c | Advertisement for Wing Tiy & Co, fruit merchants and commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34137 | 34137 | 1919-02-08 | 15 | c | Advertisement for Wing On & Co, fruit merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34138 | 34138 | 1919-02-08 | 15 | c | Advertisement for Sun Suey Wah & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34139 | 34139 | 1919-02-08 | 15 | c | Advertisement for Fong Lee Jang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34140 | 34140 | 1919-02-08 | 15 | c | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34141 | 34141 | 1919-02-08 | 15 | c | Advertisement for Clements Tonic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34154 | 34154 | 1919-02-08 | 16 | c | Advertisement for William J. L. Liu (Liu Guangfu) and the China-Australia Steamship Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34155 | 34155 | 1919-02-08 | 16 | c | Advertisement for Louey Way Shung, c/o Sing Lee Lung, Chinese medicine practitioner, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34156 | 34156 | 1919-02-08 | 16 | c | Advertisement for Chong Sing Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34157 | 34157 | 1919-02-08 | 16 | c | Advertisement for On War Chong & Co, storekeepers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34158 | 34158 | 1919-02-08 | 16 | c | Advertisement for Peter Dawson's whisky. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34174 | 34174 | 1919-02-08 | 17 | c | Advertisement for The Biff Manufacturing Co. Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 |
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]);