This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34116 | 34116 | 1919-02-08 | 14 | a | Advertisement for Dr Williams' pink pills for all people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34117 | 34117 | 1919-02-08 | 14 | a | Advertisement for Sandeman Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34118 | 34118 | 1919-02-08 | 14 | a | Advertisement for L. & P. Sauce, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34119 | 34119 | 1919-02-08 | 14 | a | Advertisement for John Hoe, cabinet makers and furniture manufacturers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34120 | 34120 | 1919-02-08 | 14 | b | Advertisement for F. H. Powell, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34121 | 34121 | 1919-02-08 | 14 | b | Advertisement for Anthony Hordern & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34122 | 34122 | 1919-02-08 | 14 | c | Advertisement for Geo Helcombe, Jun, Sydne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34123 | 34123 | 1919-02-08 | 14 | c | Advertisement for W. Schofield & Co, builders and contractors, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34124 | 34124 | 1919-02-08 | 14 | c | Advertisement for Hebley & Tom, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34125 | 34125 | 1919-02-08 | 14 | c | Advertisement for Wing Tiy & Co, fruit merchants and commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34126 | 34126 | 1919-02-08 | 14 | d | Advertisement for Chinese herbalist Tan Liangnan by Li Xiantao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 | |
34127 | 34127 | 1919-02-08 | 14 | d | Advertisement for Tiy Hing & Co, Newcastle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097611 | 24097611 |
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]);