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 |
---|---|---|---|---|---|---|---|---|---|
37186 | 37186 | 1921-07-02 | 1 | d | Advertisement for Gibbs Bright & Co, 37 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093594 | 24093594 | |
37189 | 37189 | 1921-07-02 | 1 | d | Advertisement for War Hing Tiy & Co, Botany Road, Alexandria, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093594 | 24093594 | |
37214 | 37214 | 1921-07-02 | 3 | d | Advertisement for Woods' Great Peppermint Cure. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093596 | 24093596 | |
37215 | 37215 | 1921-07-02 | 3 | d | A notice by Liu Yufang, on behalf of an iron company in America, to its Chinese shareholders in Australia in regards to the company bankruptcy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093596 | 24093596 | |
37239 | 37239 | 1921-07-02 | 4 | d | Advertisement for King Young, Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093599 | 24093599 | |
37265 | 37265 | 1921-07-02 | 6 | d | Advertisement for Dr Williams' Pink Pill for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37266 | 37266 | 1921-07-02 | 6 | d | Advertisement for Chinese doctor Sue Fong, Emmaville, specialist for sexually transmitted diseases. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37267 | 37267 | 1921-07-02 | 6 | d | Advertisement for The Commonwealth Studio, 337 Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37268 | 37268 | 1921-07-02 | 6 | d | Advertisement for Tillook & Co Ltd, Merchants and Manufacturers, Kent and Liverpool Streets, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37283 | 37283 | 1921-07-02 | 7 | d | Advertisement for Dr Sheldon's new medicine for coughs and colds. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093600 | 24093600 | |
37284 | 37284 | 1921-07-02 | 7 | d | Advertisement for China Trading Co Ltd, Importers and Exporters, Eastern Merchants and Indent Agents, 54 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093600 | 24093600 | |
37288 | 37288 | 1921-07-02 | 8 | d | Advertisement for Goldsbrough Optical Pariors, Jewellers & Opticians, 762 George Street, Haymarket, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37289 | 37289 | 1921-07-02 | 8 | d | Advertisement for Lennon, pharmacy on 216 Pitt 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]);