glam-datasets

4 rows where dataset_description = "Portrait photographs of 'Old Colonists' – settlers who arrived in the colony of South Australia before 1841. The men Old Colonists were invited to attend a banquet held by businessman Emanuel Solomon on 28 December 1871 to commemorate 35 years since European colonisation. Photographs are sourced from two composite or 'mosaic' photographs, one of men and one of women." and end_date = "1885-12-31"

✎ View and edit SQL

This data as json, CSV (advanced)

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