glam-datasets

4 rows where dataset_description = "This dataset is an extract from the photographic collections of the State Library of South Australia and is related to World War 1.The set includes individual photographs and those that were collected in albums. Content includes portraits of soldiers, marches, camps, group shots, on location in the Dardanelles, and Western front, activities on the home front eg Cheer Up Societies, memorial dedications, captured albums eg captured German and Turkish images. ", format = "CSV" and publisher = "State Library of South Australia"

✎ View and edit SQL

This data as json, CSV (advanced)

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