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/) ", "dataset_modified" is on date 2020-01-15 and licence = "Creative Commons Attribution"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), end_date (date), file_created (date)
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
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]);