glam-datasets
7 rows where "start_date" is on date 1850-01-01 sorted by file_title
This data as json, CSV (advanced)
Suggested facets: dataset_issued, dataset_modified, info_url, end_date, file_title, file_description, file_modified, file_size, dataset_issued (date), dataset_modified (date), end_date (date), file_created (date), file_modified (date)
dataset_description ✖
- 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. 6
- 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/) 1
source
publisher
licence
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
775 | 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 … | 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… | 2017-07-06T16:07:57.922939 | 2017-07-06T06:07:57.838055 | Creative Commons Attribution | |
777 | 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 … | 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 R… | 2016-07-01T14:20:36.682741 | 2016-07-01T04:20:36.441339 | Creative Commons Attribution | |
779 | 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 … | 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 R… | 2015-07-02T15:03:04.999138 | Creative Commons Attribution | ||
780 | 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 … | 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 R… | 2014-06-10T13:36:58.898503 | 2014-10-30T09:01:20 | 392612.0 | Creative Commons Attribution |
776 | 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 … | 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 activ… | 2017-07-06T16:10:00.215806 | 2017-07-06T06:10:00.128339 | Creative Commons Attribution | |
778 | 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 … | 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 R… | 2016-07-01T14:21:56.713177 | 2016-07-01T04:21:56.589108 | Creative Commons Attribution | |
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
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]);