data

Custom SQL query returning 7 rows (hide)

Query parameters

This data as json, CSV

rowiddataset_titlepublisherauthordataset_issueddataset_modifieddataset_descriptionsourceinfo_urlstart_dateend_datefile_titledownload_urlformatfile_descriptionfile_createdfile_modifiedfile_sizelicence
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 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/) 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
775 19th Century Photographs by Ernest Gall State Library of South Australia State Library of South Australia 2014-06-10T13:32:58.334603 2017-07-06T06:11:06.592081 The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer active from the 1880s to the 1920s. In 1899 he was described as a ‘distinctly modern professional photographer’. Gall is noted for his photographs of civic events, portraits and photographs showing Adelaide’s development into a growing modern city. data.sa.gov.au https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb 1850-01-01 1920-12-31 19th Century Photographs by Ernest Gall https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/ff7198a2-fb79-4858-9a4e-1bc9b9250f79/download/gallphotographs.csv CSV **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20223389" - **URL** : URL to the catalogue record in our database - **XML** : URL to the XML version of the catalogue record - **NAME** : Name of photographer - **TITLE** : Title of photograph - **Dates/publication details** : Date of the photograph - **Description/Quantity** : Format and dimensions of the original image - **SUMMARY** : Summary information about the image, its content and context - **SUBJECT** : Subject headings assigned by the Library to assist searching - **Series/Collection** : Images may be aggregated as a collection - **IMAGE** : URL of the location of the web image 2017-07-06T16:07:57.922939 2017-07-06T06:07:57.838055   Creative Commons Attribution
776 19th Century Photographs by Ernest Gall State Library of South Australia State Library of South Australia 2014-06-10T13:32:58.334603 2017-07-06T06:11:06.592081 The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer active from the 1880s to the 1920s. In 1899 he was described as a ‘distinctly modern professional photographer’. Gall is noted for his photographs of civic events, portraits and photographs showing Adelaide’s development into a growing modern city. data.sa.gov.au https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb 1850-01-01 1920-12-31 19th Century Photographs by Ernest Gall - Excel workbook https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/847a664d-cfff-4cda-ab74-17221c46fd78/download/gallphotographs.xlsx XLSX This Excel workbook contains the same data as the CSV file but has the advantage that URLs are active hyperlinks. 2017-07-06T16:10:00.215806 2017-07-06T06:10:00.128339   Creative Commons Attribution
777 19th Century Photographs by Ernest Gall State Library of South Australia State Library of South Australia 2014-06-10T13:32:58.334603 2017-07-06T06:11:06.592081 The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer active from the 1880s to the 1920s. In 1899 he was described as a ‘distinctly modern professional photographer’. Gall is noted for his photographs of civic events, portraits and photographs showing Adelaide’s development into a growing modern city. data.sa.gov.au https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb 1850-01-01 1920-12-31 19th Century Photographs by Ernest Gall https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/201ee805-a8ff-4fa7-9856-9625b3532b35/download/gallphotographs.csv CSV Compiled 2016. This data set has been superseded by an updated version at the top of this Data and Resources list. 2016-07-01T14:20:36.682741 2016-07-01T04:20:36.441339   Creative Commons Attribution
778 19th Century Photographs by Ernest Gall State Library of South Australia State Library of South Australia 2014-06-10T13:32:58.334603 2017-07-06T06:11:06.592081 The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer active from the 1880s to the 1920s. In 1899 he was described as a ‘distinctly modern professional photographer’. Gall is noted for his photographs of civic events, portraits and photographs showing Adelaide’s development into a growing modern city. data.sa.gov.au https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb 1850-01-01 1920-12-31 19th Century Photographs by Ernest Gall - Excel workbook https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/2a2e9a1b-3101-4e07-b120-9c8520127192/download/gallphotographs.xlsx XLSX Compiled 2016. This data set has been superseded by an updated version at the top of this Data and Resources list. 2016-07-01T14:21:56.713177 2016-07-01T04:21:56.589108   Creative Commons Attribution
779 19th Century Photographs by Ernest Gall State Library of South Australia State Library of South Australia 2014-06-10T13:32:58.334603 2017-07-06T06:11:06.592081 The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer active from the 1880s to the 1920s. In 1899 he was described as a ‘distinctly modern professional photographer’. Gall is noted for his photographs of civic events, portraits and photographs showing Adelaide’s development into a growing modern city. data.sa.gov.au https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb 1850-01-01 1920-12-31 19th Century Photographs by Ernest Gall https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb/resource/172c782e-5939-4db3-808f-77c9a6a5e238/download/gallphotos.csv CSV Compiled 2015. This data set has been superseded by an updated version at the top of this Data and Resources list. 2015-07-02T15:03:04.999138     Creative Commons Attribution
780 19th Century Photographs by Ernest Gall State Library of South Australia State Library of South Australia 2014-06-10T13:32:58.334603 2017-07-06T06:11:06.592081 The photographs (approximately 660) were taken by Ernest Gall, a South Australian born photographer active from the 1880s to the 1920s. In 1899 he was described as a ‘distinctly modern professional photographer’. Gall is noted for his photographs of civic events, portraits and photographs showing Adelaide’s development into a growing modern city. data.sa.gov.au https://data.sa.gov.au/data/dataset/54c50844-6653-4704-8dc8-5f5c8f5f14eb 1850-01-01 1920-12-31 19th Century Photographs by Ernest Gall https://data.sa.gov.au/data/storage/f/2014-06-10T13%3A33%3A42.402Z/2014gall.csv CSV Compiled 2014. This data set has been superseded by an updated version at the top of this Data and Resources list. 2014-06-10T13:36:58.898503 2014-10-30T09:01:20 392612.0 Creative Commons Attribution