This data as json, CSV (advanced)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34079 | 34079 | 1919-02-08 | 3 | d | Advertisement for The International Rubber Stamp Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34078 | 34078 | 1919-02-08 | 3 | c | Advertisement for Stanton, Cook & Co, electrical light engineers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34077 | 34077 | 1919-02-08 | 3 | c | Advertisement for W. Schofield & Co, builders and contractors, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34076 | 34076 | 1919-02-08 | 3 | c | Advertisement for The Commonwealth Studio, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34075 | 34075 | 1919-02-08 | 3 | c | Advertisement for Ford Adams & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34074 | 34074 | 1919-02-08 | 3 | c | Advertisement for Thomas Hardy & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34073 | 34073 | 1919-02-08 | 3 | b | Advertisement for Crawford & Co, cash produce store, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34072 | 34072 | 1919-02-08 | 3 | b | Advertisement for Gibbs Bright & Co, Insurance Department, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34071 | 34071 | 1919-02-08 | 3 | a | Advertisement for Tillock & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34070 | 34070 | 1919-02-08 | 3 | a | Advertisement for Althouse & Geiger, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34069 | 34069 | 1919-02-08 | 3 | a | Advertisement for Chateau-Tanunda, special 3 star hospital brandy with Blue Label. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34068 | 34068 | 1919-02-08 | 3 | a | Advertisement for James Stedman Ltd, manufacturing confectioners, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097598 | 24097598 | |
34067 | 34067 | 1919-02-08 | 2 | a | Advertisement for Nippon Yusen Kaisha, Japan Mail Steamship Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097599 | 24097599 | |
34066 | 34066 | 1919-02-08 | 1 | a | Advertisement for the On Chong & Company, importers and exporters, shipping merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097597 | 24097597 |
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]);