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 |
---|---|---|---|---|---|---|---|---|---|
37194 | 37194 | 1921-07-02 | 2 | e | Advertisement for John George White, Shipping Mercantile Agent, 35 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37195 | 37195 | 1921-07-02 | 2 | e | Advertisement for Kwock Kee, 404 Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37196 | 37196 | 1921-07-02 | 2 | e | Advertisement for Shanghai Cafe, Chinese Chop Suey House, 65-67 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37197 | 37197 | 1921-07-02 | 2 | e | Advertisement for Rowan's Bond, York Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37198 | 37198 | 1921-07-02 | 2 | e | Advertisement for S. Freeman & Sons Ltd, 350 Harris Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37199 | 37199 | 1921-07-02 | 2 | e | Advertisement for The Australian Provincial Assurance Association Ltd, A. P. A. Building, 77 King Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37216 | 37216 | 1921-07-02 | 3 | e | Advertisement for Gibbs Bright & Co, 37 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093596 | 24093596 | |
37217 | 37217 | 1921-07-02 | 3 | e | Advertisement for Tientsin (Tianjin) Cafe Ltd, 70 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093596 | 24093596 | |
37240 | 37240 | 1921-07-02 | 4 | e | Advertisement for Yuen Tiy Tong Kee, 54 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37241 | 37241 | 1921-07-02 | 4 | e | Advertisement for Harry Walters, Prince of Wales Hotel, Haymarket, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37242 | 37242 | 1921-07-02 | 4 | e | Advertisement for Alliance Assurance Co Ltd, Fire, Marine and Accident, 97 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37243 | 37243 | 1921-07-02 | 4 | e | Advertisement for John Hoe, Cabinet Maker and Furniture Manufacturer, James Street, Waterloo, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37244 | 37244 | 1921-07-02 | 4 | e | Advertisement for Kwong Wing Chong, 307 Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37245 | 37245 | 1921-07-02 | 4 | e | Advertisement for W. Mow Sang & Co, Fruit and Vegetable Warehouse and Commission Agents, Ultimo Road, Haymarket, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37269 | 37269 | 1921-07-02 | 6 | e | Advertisement for Sun Man Lee & Co, 16 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37270 | 37270 | 1921-07-02 | 6 | e | Advertisement for Tiy Loy & Co, Botany Road, Alexandria, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37271 | 37271 | 1921-07-02 | 6 | e | Advertisement for Gibbs Brights & Co, Insurance Department, 41 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37290 | 37290 | 1921-07-02 | 8 | e | Advertisement for Hop Lee & Co, Wholesale Fruit and Produces, Merchants and General Commission Agents, 9 Municipal Buildings, Ultimo Road, Haymarket, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37291 | 37291 | 1921-07-02 | 8 | e | Advertisement for David Dudley, Men's Boots, 474 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 |
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]);