glam-datasets

1 row where dataset_description = "The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial South Australia. Duryea was active in South Australia 1855-1875. He and his brother were the first known photographers to work in areas of South Australia outside Adelaide. Duryea is particularly known for his panoramas of Adelaide and portraits of surviving original European colonists of South Australia.", "file_created" is on date 2015-07-02 and format = "CSV"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (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]);