glam-datasets

1 row where dataset_description = "Hot days, warm nights, beaches, backyard cricket and Christmas celebrations are all part of summer in the Southern Hemisphere. This dataset contains 53 selected images that portray the essence of summer in South Australia. Use in conjunction with the Flickr API [https://www.flickr.com/services/api/](https://www.flickr.com/services/api/) " and format = "JPEG"

✎ View and edit SQL

This data as json, CSV (advanced)

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

source

format

  • JPEG · 1 ✖

dataset_description ✖

  • Hot days, warm nights, beaches, backyard cricket and Christmas celebrations are all part of summer in the Southern Hemisphere. This dataset contains 53 selected images that portray the essence of summer in South Australia. Use in conjunction with the Flickr API [https://www.flickr.com/services/api/](https://www.flickr.com/services/api/) · 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
675 675 Summer Under Southern Skies State Library of South Australia State Library of South Australia 2016-06-29T06:54:44.177674 2020-01-15T06:49:53.914979 Hot days, warm nights, beaches, backyard cricket and Christmas celebrations are all part of summer i… data.sa.gov.au https://data.sa.gov.au/data/dataset/dcd4c4f3-d492-433e-81f1-67be77b97cea 1894-01-01 1975-12-31 Summer under Southern Skies Flickr album https://www.flickr.com/photos/state_library_south_australia/albums/72157637332377514 JPEG Link to Flickr album 2016-06-29T16:55:18.576610     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]);