glam-datasets
9 rows where "file_created" is on date 2017-07-06 and format = "CSV"
This data as json, CSV (advanced)
Suggested facets: dataset_title, author, dataset_issued, dataset_modified, info_url, start_date, end_date, file_description, dataset_issued (date), dataset_modified (date), start_date (date), file_modified (date)
end_date (date) ✖
- 2019-05-20 4
- 1887-12-31 1
- 1902-12-31 1
- 1920-12-31 1
- 2013-12-31 1
- 2014-12-31 1
dataset_description ✖
- Photographs relating to South Australia feature localities across the state, houses and buildings, portraits, social and historical events, industry, farming, transport and more. Divided into four time periods: - pre 1900 - 1900 - 1919 - 1920 - 1949 - 1950 onwards 4
- The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial South Australia. Duryea was active in South Australia 1855-1875. He and his brother were the first known photographers to work in areas of South Australia outside Adelaide. Duryea is particularly known for his panoramas of Adelaide and portraits of surviving original European colonists of South Australia. 1
- 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. 1
- These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photographer of colonial South Australia. Sweet began working as a photographer in Adelaide in 1867. In 1875 he retired from the sea and established his own photographic studio in Adelaide. He took photographs around South Australia, developing them in a horse-drawn darkroom. Sweet is known as the colony's foremost landscape photographer of the 1870s. 1
- This dataset includes 45 oral histories from the project S. A. Speaks': An Oral History of Life in South Australia before 1930. The interviewees were broadly representative of the population of South Australia as it was in the first three decades of the twentieth century. 'S. A. Speaks' was a Jubilee 150 project conducted by Beth M. Robertson under the auspices of the History Trust of South Australia for two years and two months ending December 1986. The sound files are in MP3 format. The transcripts are in PDF format. 1
- This dataset includes 5,799 selected photographs related to ships and shipping. Note that images in copyright might not be viewable outside the State Library of South Australia. 1
source
publisher
licence
format
- CSV · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
660 | 660 | 19th Century Photographs by Captain Samuel Sweet | State Library of South Australia | State Library of South Australia | 2014-06-10T13:51:09.849031 | 2022-01-24T04:24:02.651995 | These photographs (approximately 920) were taken by Captain Samuel Sweet, sea captain and photograph… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1 | 1865-01-01 | 1902-12-31 | 19th Century Photographs by Captain Samuel Sweet | https://data.sa.gov.au/data/dataset/28baf505-4c5f-4e45-9fae-2605ee1cf7c1/resource/63aaa2e1-b689-4cc9-8835-95d76dd19e74/download/sweetphotographs.csv | CSV | **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20223389" - **URL** : URL to… | 2017-07-06T15:53:39.871109 | 2017-07-06T05:53:39.717475 | Creative Commons Attribution | |
697 | 697 | 19th Century Photographs by Townsend Duryea | State Library of South Australia | State Library of South Australia | 2014-06-10T12:57:32.375370 | 2019-08-29T04:40:29.655895 | The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial … | data.sa.gov.au | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51 | 1856-01-01 | 1887-12-31 | 19th Century Photographs by Townsend Duryea | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51/resource/f9c75608-0939-4439-ae4d-15e28476bb74/download/duryeaphotographs.csv | CSV | **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20223389" - **URL** : URL to… | 2017-07-06T16:15:59.980827 | 2017-07-06T06:15:59.875068 | Creative Commons Attribution | |
726 | 726 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: pre 1900 | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/2f9d49ec-69c2-4895-97f9-a08f374e32fe/download/saphotographspre-1900.csv | CSV | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:17:00.560194 | 2017-07-06T07:17:00.449342 | Creative Commons Attribution | |
727 | 727 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: 1900 - 1919 | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/3089639f-dd73-4b55-8599-37859b67e161/download/saphotographs1900-1919.csv | CSV | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:18:07.314244 | 2017-07-06T07:18:07.064681 | Creative Commons Attribution | |
728 | 728 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: 1920 - 1949 | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/f215310f-e88c-41fc-9534-9930d493f13b/download/saphotographs1920-1949.csv | CSV | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:19:02.654659 | 2017-07-06T07:19:02.409997 | Creative Commons Attribution | |
729 | 729 | South Australian Photographs | State Library of South Australia | Andrew Piper | 2013-03-07T14:40:31.091907 | 2019-08-29T04:36:26.010768 | Photographs relating to South Australia feature localities across the state, houses and buildings, p… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455 | 1800-01-01 | 2019-05-20 | South Australian Photographs: 1950 onwards | https://data.sa.gov.au/data/dataset/62c4e993-8d5b-48a4-9d11-9e9dd4708455/resource/6047b3d8-51b2-4720-9134-229eca06e0b2/download/saphotographs1950onwards.csv | CSV | Compiled 2017. This data set has been superseded by an updated version above in this Data and Resour… | 2017-07-06T17:19:49.720416 | 2017-07-06T07:19:49.596738 | Creative Commons Attribution | |
748 | 748 | Ship Photographs | State Library of South Australia | State Library of South Australia | 2016-06-29T06:44:18.959542 | 2019-08-29T04:35:07.834064 | This dataset includes 5,799 selected photographs related to ships and shipping. Note that images in… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/e52b0259-2b57-4121-8e04-be333025fb3b | 1802-01-01 | 2014-12-31 | Ship Photographs | https://data.sa.gov.au/data/dataset/e52b0259-2b57-4121-8e04-be333025fb3b/resource/ab6cb1a4-44cc-4514-a38f-eac5c50d5aa1/download/shipphotographs.csv | CSV | Compiled 2017. This data set of 5672 photographs has been superseded by an updated version at the to… | 2017-07-06T16:46:20.810689 | 2017-07-06T06:46:20.707799 | Creative Commons Attribution | |
758 | 758 | S. A. Speaks: An Oral History of Life in South Australia before 1930 | State Library of South Australia | State Library of South Australia | 2016-06-29T07:00:04.358496 | 2019-08-29T04:32:01.228089 | This dataset includes 45 oral histories from the project S. A. Speaks': An Oral History of Life in S… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d | 1960-01-01 | 2013-12-31 | S. A. Speaks: An Oral History of Life in South Australia before 1930 | https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d/resource/36eb6481-5290-4edb-8392-b6b65478035e/download/saspeaks_oralhistory.csv | CSV | **Explanation of fields** - **URL** : URL of location of item online; audio file included in MP3 an… | 2017-07-06T16:29:33.848862 | 2018-06-20T07:54:20.141244 | Creative Commons Attribution | |
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 |
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]);