This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 32018 | 32018 | 1917-01-27 | 19 | a | Advertisement for Dr. Waugh's baking powder, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32019 | 32019 | 1917-01-27 | 19 | a | Advertisement for R. E. Blackwell, merchant tailor, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32020 | 32020 | 1917-01-27 | 19 | a | Advertisement for Tucker & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32021 | 32021 | 1917-01-27 | 19 | a | Advertisement for Anthony Hordern & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32022 | 32022 | 1917-01-27 | 19 | a | Advertisement for Harry Walters, Prince of Wales Hotel, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32023 | 32023 | 1917-01-27 | 19 | b | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32024 | 32024 | 1917-01-27 | 19 | b | Advertisement for Thorne's whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32025 | 32025 | 1917-01-27 | 19 | b | Advertisement for Dr Williams' pink pills for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32026 | 32026 | 1917-01-27 | 19 | c | Advertisement for Rowan's Bond, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32027 | 32027 | 1917-01-27 | 19 | c | Advertisement for War Hing Tiy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32028 | 32028 | 1917-01-27 | 19 | c | Advertisement for Chong Wah Jang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32029 | 32029 | 1917-01-27 | 19 | d | Advertisement for Hop Tel, Bokhara Gardener, Goodooga, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32030 | 32030 | 1917-01-27 | 19 | d | Advertisement for Peter Dawson's whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
| 32031 | 32031 | 1917-01-27 | 19 | d | Advertisement for On War Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 |
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]);