1 row where "file_created" is on date 2016-07-25 and file_description = "This csv file contains the only the urls and captions for the photographic images in the collection and the bibliographic record number for each image."

View and edit SQL

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

source

format

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
986 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 urls and captions https://catalogue.data.wa.gov.au/dataset/7faa2336-7601-447c-91b0-4b771ee26b6f/resource/270e6f40-8d78-497f-a67f-6ea5d3678590/download/pictorial-collection-brn-caption-image-url.xlsx XLSX This csv file contains the only the urls and captions for the photographic images in the collection … 2016-07-25T07:13:06.648045 2016-07-25T07:13:06.603082   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]);