This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33014 | 33014 | 1918-02-16 | 16 | a | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33015 | 33015 | 1918-02-16 | 16 | a | Advertisement for S. Jueyow & Sons, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33016 | 33016 | 1918-02-16 | 16 | a | Advertisement for Sun Suey War & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33017 | 33017 | 1918-02-16 | 16 | a | Advertisement for Fong Lee Jang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33018 | 33018 | 1918-02-16 | 16 | a | Advertisement for Thorne's Whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33019 | 33019 | 1918-02-16 | 16 | b | Advertisement for Tiy Loy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33020 | 33020 | 1918-02-16 | 16 | b | Advertisement for G. Tong, oriental herbalist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33021 | 33021 | 1918-02-16 | 16 | b | Advertisement for Goon Lee Shing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33022 | 33022 | 1918-02-16 | 16 | c | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33023 | 33023 | 1918-02-16 | 16 | c | Advertisement for On War Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33024 | 33024 | 1918-02-16 | 16 | c | Advertisement for Peter Dawson's Whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33025 | 33025 | 1918-02-16 | 16 | d | Advertisement for Tim Young & Co, wholesale fruit merchants and commissioning agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33026 | 33026 | 1918-02-16 | 16 | d | Advertisement for The New South Wales Chinese Merchants Society, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33027 | 33027 | 1918-02-16 | 16 | d | Advertisement for Yuen Tiy Tong Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33028 | 33028 | 1918-02-16 | 16 | d | Advertisement for Wing War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33029 | 33029 | 1918-02-16 | 16 | d | Advertisement for Chong Bing Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33030 | 33030 | 1918-02-16 | 16 | d | Advertisement for Edward Hill & Co, Chair Maker and French Polisher, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 |
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]);