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 |
---|---|---|---|---|---|---|---|---|---|
37200 | 37200 | 1921-07-02 | 2 | f | Advertisement for The Southern Insurance Association Ltd, Agent Liu Shuqing (Sidney H. Lowe), 18 Mary Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37201 | 37201 | 1921-07-02 | 2 | f | Advertisement for Quan Nock, Chinese Herbalist, 168 Anzac Parade, Kensington. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37202 | 37202 | 1921-07-02 | 2 | f | Advertisement for State Assurance Co Ltd, and the Gibbs Bright & Co agents, 41 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37203 | 37203 | 1921-07-02 | 2 | f | Advertisement for The Eastern House, 50 Dixon Street (near Haymarket), Darling Harbour, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093597 | 24093597 | |
37218 | 37218 | 1921-07-02 | 3 | f | Advertisement for Brunton's Flour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093596 | 24093596 | |
37219 | 37219 | 1921-07-02 | 3 | f | Advertisement for Chung Lun & Co, Manufacturers Soft Goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093596 | 24093596 | |
37246 | 37246 | 1921-07-02 | 4 | f | Advertisement for Arnott's Biscuits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37247 | 37247 | 1921-07-02 | 4 | f | Advertisement for G. Tong, Oriental Herbalist, Treats all internal and external diseases of both males and females, Consultation free, 305a Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37248 | 37248 | 1921-07-02 | 4 | f | Advertisement for Peter Dawson's Whisky. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37249 | 37249 | 1921-07-02 | 4 | f | Advertisement for Lum See Jam, 46 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37250 | 37250 | 1921-07-02 | 4 | f | Advertisement for Ping On Chang & Co, 21 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37272 | 37272 | 1921-07-02 | 6 | f | Sydney market report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37292 | 37292 | 1921-07-02 | 8 | f | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37293 | 37293 | 1921-07-02 | 8 | f | Advertisement for Chinese herbalist Chen Caida, Hing Hi Wah Kee, 309 Thomas Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37294 | 37294 | 1921-07-02 | 8 | f | Advertisement for Weller & Bostock, Drink Silver King Gen and Old Clan Whisky, 17 Grosvenor 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]);