glam-datasets

1 row where file_description = "Photographs of Lost Adelaide architecture from Adelaide’s West End (70 photographs). These photographs have been used in two of the State Library’s walking tours for hand held devices, Lost Adelaide and Lost Adelaide: West End.", publisher = "State Library of South Australia" and source = "data.sa.gov.au"

✎ View and edit SQL

This data as json, CSV (advanced)

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

source

  • data.sa.gov.au · 1 ✖

publisher

  • State Library of South Australia · 1 ✖

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
683 683 Lost Adelaide Architecture Photographs State Library of South Australia Online Projects, State Library of South Australia 2013-05-21T07:06:04.920232 2020-01-15T06:43:11.152721 Two photo sets on Flickr containing photographs of Lost Adelaide architecture from Central Adelaide … data.sa.gov.au https://data.sa.gov.au/data/dataset/2b0e3d83-159f-4118-a7e2-9612367372ed 1846-1966   Lost Adelaide - West End Photographs https://www.flickr.com/photos/state_library_south_australia/sets/72157632985933882/ JPEG Photographs of Lost Adelaide architecture from Adelaide’s West End (70 photographs). These photogra… 2013-05-21T02:08:51.061745 2013-05-21T03:00:09.678618 20.0 Creative Commons Attribution

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