This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35421 | 35421 | 1920-02-21 | 21 | a | Advertisement for Ping On Chahn & Co, 21 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35422 | 35422 | 1920-02-21 | 21 | a | Advertisement for A. C. Baxter & Challfield, 27 Bond Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35423 | 35423 | 1920-02-21 | 21 | a | Advertisement for Messrs. Anderson & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35424 | 35424 | 1920-02-21 | 21 | a | Advertisement for Tie Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35425 | 35425 | 1920-02-21 | 21 | a | Advertisement for The Commonwealth Studio, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35426 | 35426 | 1920-02-21 | 21 | b | Advertisement for Shanghai Case, Chinese Chop Suey House, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35427 | 35427 | 1920-02-21 | 21 | b | Advertisement for Tattersall's consultations, Hobart, Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35428 | 35428 | 1920-02-21 | 21 | b | Advertisement for Lewis & Whitty, 158 Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35429 | 35429 | 1920-02-21 | 21 | b | Advertisement for The State Assurance Co Ltd, and the Law Union and Rock Insurance Co Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35430 | 35430 | 1920-02-21 | 21 | b | Advertisement for Ophir Tea, John Barlow & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35431 | 35431 | 1920-02-21 | 21 | c | Advertisement for Sun Suey Wah & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35432 | 35432 | 1920-02-21 | 21 | c | Advertisement for Kwong Wing Chong, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35433 | 35433 | 1920-02-21 | 21 | c | Advertisement for Kwock Kee, 434 Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35434 | 35434 | 1920-02-21 | 21 | c | Advertisement for Chong Bing Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35435 | 35435 | 1920-02-21 | 21 | c | Advertisement for John Hoe, cabinet maker and furniture manufacturer, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35436 | 35436 | 1920-02-21 | 21 | c | Advertisement for Alliance Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 |
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]);