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, dataset_description, info_url, start_date, end_date, dataset_issued (date), dataset_modified (date), start_date (date), file_modified (date)
file_description ✖
- **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 3
- **Explanation of fields** - **URL** : URL of location of item online; audio file included in MP3 and WAV formats - **Bibliographic record number** : SLSA unique identifier eg "b2933579" - **SLSA reference** : Number of the recording within the project - **Creator** : Name of interviewee - **Additional Creator** : Name of interviewer - **Title** : Title of interview - **Date (year)** : Date interview recorded - **Description** : Summary description of content of interview - **Recording length** : Length of recording - **Subject** : Subject headings assigned by the Library to assist searching - **Collection** : Project name (some oral histories were conducted within a project) **How to listen to or download the audio files** 1. Follow the hyperlink in the field labelled URL. The interview web page will open. 2. Click the Download icon in the TOOLS column on the left of the web page. A Download dialog opens. 3. To listen, click either the [MP3] or [WAV] link under 'Alternate Formats'. To download, right-click either the [MP3] or [WAV] link under 'Alternate Formats' and select from the contextual menu 'Save Link As...' or 'Save target as' or 'Download Linked File' or similar. 1
- Compiled 2017. This data set has been superseded by an updated version above in this Data and Resources list. 11797 images. **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20691051" - **RECORD URL** : URL to the catalogue record in our database - **XML** : URL to the XML version of the catalogue record - **NAME** : Name of photographer if known - **TITLE** : Title of photograph - **Dates/Publication Details** : Includes the 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 1
- Compiled 2017. This data set has been superseded by an updated version above in this Data and Resources list. 18469 images. **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20691051" - **RECORD URL** : URL to the catalogue record in our database - **XML** : URL to the XML version of the catalogue record - **NAME** : Name of photographer if known - **TITLE** : Title of photograph - **Dates/Publication Details** : Includes the 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 1
- Compiled 2017. This data set has been superseded by an updated version above in this Data and Resources list. 33146 images. **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20691051" - **RECORD URL** : URL to the catalogue record in our database - **XML** : URL to the XML version of the catalogue record - **NAME** : Name of photographer if known - **TITLE** : Title of photograph - **Dates/Publication Details** : Includes the 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 1
- Compiled 2017. This data set has been superseded by an updated version above in this Data and Resources list. 37953 images. **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b20691051" - **RECORD URL** : URL to the catalogue record in our database - **XML** : URL to the XML version of the catalogue record - **NAME** : Name of photographer if known - **TITLE** : Title of photograph - **Dates/Publication Details** : Includes the 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 1
- Compiled 2017. This data set of 5672 photographs has been superseded by an updated version at the top of this Data and Resources list. **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 1
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
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]);