This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32018 | 32018 | 1917-01-27 | 19 | a | Advertisement for Dr. Waugh's baking powder, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32019 | 32019 | 1917-01-27 | 19 | a | Advertisement for R. E. Blackwell, merchant tailor, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32020 | 32020 | 1917-01-27 | 19 | a | Advertisement for Tucker & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32021 | 32021 | 1917-01-27 | 19 | a | Advertisement for Anthony Hordern & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32022 | 32022 | 1917-01-27 | 19 | a | Advertisement for Harry Walters, Prince of Wales Hotel, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32023 | 32023 | 1917-01-27 | 19 | b | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32024 | 32024 | 1917-01-27 | 19 | b | Advertisement for Thorne's whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32025 | 32025 | 1917-01-27 | 19 | b | Advertisement for Dr Williams' pink pills for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32026 | 32026 | 1917-01-27 | 19 | c | Advertisement for Rowan's Bond, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32027 | 32027 | 1917-01-27 | 19 | c | Advertisement for War Hing Tiy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32028 | 32028 | 1917-01-27 | 19 | c | Advertisement for Chong Wah Jang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32029 | 32029 | 1917-01-27 | 19 | d | Advertisement for Hop Tel, Bokhara Gardener, Goodooga, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32030 | 32030 | 1917-01-27 | 19 | d | Advertisement for Peter Dawson's whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32031 | 32031 | 1917-01-27 | 19 | d | Advertisement for On War Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 |
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]);