glam-datasets

5 rows where dataset_description = "50,000 digital photographs in which copyright has expired with bibliographic data and links to persistent URL of the digital image from the State Library of Western Australia Catalogue. We're delighted to announce this dataset was used in the prize winning GovHack 2016 competition entry, Colourful Past. https://2016.hackerspace.govhack.org/content/colourful-past The team summarized their entry thus: Colourful Past aims to create an immediate and lasting connection to our shared past, by giving you a channel to browse recorded in library or archive imagery. You’ll be directed to a set of monochrome or faded photos with a click your sense can feast on an enhanced colour version." and publisher = "State Library of Western Australia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_modified (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]);