glam-datasets

4 rows where dataset_description = "A large collection of photographs taken by photographer, Richard Woldendorp, including a wide variety of images of people, buildings, places, industries, sport and entertainment in Western Australia.The photographs were taken between 1958 - 2006. The images can be accessed via the urls provided in the data. Richard Woldendorp was born in Utrecht, The Netherlands in 1927 and migrated to Perth in 1951. His long association with photography began in 1955 when he purchased a camera for a trip back to The Netherlands. Woldendorp's fascination with photography and skill rapidly grew and in 1961 won first and third prizes in the Craven-A National Photographic competition. As a professional photographer Woldendorp was intrigued by Australia's landscapes with a special passion for aerial photography. In 1991 Woldendorp was made a Fellow of the Australian Institute of Professional Photography, then in 1998 was admitted as a Honorary Life Member to the Australian Commerical and Media Photographers (A.C.M.P.), then to the A.C.M.P. Hall of Fame. In 2004 Richard Woldendorp was named a Western Australian Living Treasure." and publisher = "State Library of Western Australia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (date)

CREATE TABLE [glam-datasets] (
   [dataset_title] TEXT,
   [publisher] TEXT,
   [author] TEXT,
   [dataset_issued] TEXT,
   [dataset_modified] TEXT,
   [dataset_description] TEXT,
   [source] TEXT,
   [info_url] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [file_title] TEXT,
   [download_url] TEXT,
   [format] TEXT,
   [file_description] TEXT,
   [file_created] TEXT,
   [file_modified] TEXT,
   [file_size] TEXT,
   [licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
    ON [glam-datasets] ([source], [publisher], [format], [licence]);