1 row 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.", format = "CSV" and source = "data.wa.gov.au"

View and edit SQL

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

source

  • data.wa.gov.au · 1

format

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. · 1
Link rowid ▼ dataset_title publisher author dataset_issued dataset_modified dataset_description source info_url start_date end_date file_title download_url format file_description file_created file_modified file_size licence
982 Digital Photographic Collection State Library of Western Australia Author Not Specified 2016-07-25T03:53:22.224986 2022-05-25T18:46:16.346659 50,000 digital photographs in which copyright has expired with bibliographic data and links to persi… data.wa.gov.au https://catalogue.data.wa.gov.au/dataset/7faa2336-7601-447c-91b0-4b771ee26b6f     Pictorial collection_csv https://catalogue.data.wa.gov.au/dataset/7faa2336-7601-447c-91b0-4b771ee26b6f/resource/9117bf08-bd54-4b19-89f8-ca86ae799875/download/slwapictorial.csv CSV The CSV contains limited bibliographic data from this collection including title of image; subject; … 2016-07-25T03:56:04.933099 2016-07-25T03:56:04.885661   Creative Commons Attribution 4.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);