glam-datasets

1 row where dataset_description = "Known as the city of churches, Adelaide has also been described as the city of pubs. This dataset contains 160 selected images of hotels that have been put to other, more sober, uses or have been demolished. Use in conjunction with the Flickr API [https://www.flickr.com/services/api/](https://www.flickr.com/services/api/)", format = "JPEG" and licence = "Creative Commons Attribution"

✎ View and edit SQL

This data as json, CSV (advanced)

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

source

licence

  • Creative Commons Attribution · 1 ✖

format

  • JPEG · 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
677 677 Departed spirits: Lost pubs of Adelaide State Library of South Australia State Library of South Australia 2016-06-29T04:35:15.964399 2020-01-15T06:47:38.894121 Known as the city of churches, Adelaide has also been described as the city of pubs. This dataset co… data.sa.gov.au https://data.sa.gov.au/data/dataset/e91c7cfa-341a-49d3-b7d9-074c0b138dd6 1850-01-01 1966-12-31 Departed spirits: Lost pubs of Adelaide Flickr album https://www.flickr.com/photos/state_library_south_australia/sets/72157648540426502 JPEG Link to Flickr album 2016-06-29T14:36:02.969926     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]);