This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32997 | 32997 | 1918-02-16 | 15 | a | Advertisement for Lee Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
32998 | 32998 | 1918-02-16 | 15 | a | Advertisement for Gee Ick & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
32999 | 32999 | 1918-02-16 | 15 | a | Advertisement for On War Tai & Co, 146-148 Wickham Street, Valley, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33000 | 33000 | 1918-02-16 | 15 | a | Advertisement for See War & Co, merchants, 225-227 Brunswick Street, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33001 | 33001 | 1918-02-16 | 15 | a | Advertisement for A. G. Baxter & Chatfield, Late of Burns Philip & Co, Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33002 | 33002 | 1918-02-16 | 15 | b | Advertisement for Dockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33003 | 33003 | 1918-02-16 | 15 | b | Advertisement for Lum See Jan, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33004 | 33004 | 1918-02-16 | 15 | b | Advertisement for Sam War, 319 Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33005 | 33005 | 1918-02-16 | 15 | b | Advertisement for S. Hoffnung & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33006 | 33006 | 1918-02-16 | 15 | c | Advertisement for Wing On & Co, fruit merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33007 | 33007 | 1918-02-16 | 15 | c | Advertisement for Kwong War Chong & Co, storekeepers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33008 | 33008 | 1918-02-16 | 15 | c | Advertisement for The Commonwealth Studio, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33009 | 33009 | 1918-02-16 | 15 | c | Advertisement for Sun Fong, Chinese expert for venereal diseases in Emmaville, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33010 | 33010 | 1918-02-16 | 15 | c | Advertisement for W. Schofield & Co, builders and contractors, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33011 | 33011 | 1918-02-16 | 15 | d | Advertisement for Kwong Wing Chong, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33012 | 33012 | 1918-02-16 | 15 | d | Advertisement for King Young, general merchants and commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33013 | 33013 | 1918-02-16 | 15 | d | Advertisement for Alliance Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 |
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]);