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 |
---|---|---|---|---|---|---|---|---|---|
39424 | 39424 | 1923-02-17 | 3 | d | Advertisement for Gibbs Bright & Co, Insurance Department, 41 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39437 | 39437 | 1923-02-17 | 4 | d | Advertisement for Tiy Loy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39438 | 39438 | 1923-02-17 | 4 | d | Advertisement for War Hing Tiy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39439 | 39439 | 1923-02-17 | 4 | d | Advertisement for Tillook & Co Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39453 | 39453 | 1923-02-17 | 5 | d | Advertisement for Peter Dawson's Whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39454 | 39454 | 1923-02-17 | 5 | d | Advertisement fro Ping Hong Lowe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39455 | 39455 | 1923-02-17 | 5 | d | Advertisement for W. Mow Sang & Co, fruit and vegetable merchants & commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39528 | 39528 | 1923-02-17 | 21 | d | Advertisement for Althouse & Geiger, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39529 | 39529 | 1923-02-17 | 21 | d | Advertisement for Dr Williams' Pink Pills for Pale People. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 |
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]);