glam-datasets
5 rows where format = "XLSX" and start_date = "1960-01-01"
This data as json, CSV (advanced)
Suggested facets: dataset_title, dataset_issued, dataset_modified, dataset_description, info_url, file_title, dataset_issued (date), dataset_modified (date), end_date (date), file_created (date), file_modified (date)
file_description ✖
- Compiled 2016. This data set has been superseded by an updated version at the top of this Data and Resources list. This Excel workbook contains the same data as the CSV file but has the advantage that URLs are active hyperlinks. 1
- This Excel workbook contains the same data as the CSV file but has the advantage that URLs are active hyperlinks. 1
- This Excel workbook contains the same data as the CSV file but has the advantage that URLs are active hyperlinks. **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
- This data set was superseded in 2017 by an updated version at the top of this Data and Resources list. This resource was updated in December 2016 to add death dates. This Excel workbook contains the same data as the CSV file but has the advantage that URLs are active hyperlinks. **Explanation of fields** - **RECORD #** : SLSA unique identifier eg "b29335796" - **NAME** : Name of interviewee - **NUMBER** : Number of the recording within the project - **TITLE** : Title of interview - **Dates/publication details** : Date interview recorded (may be year only or exact date) - **Description/Quantity** : Length of recording - **SUMMARY** : Summary description of content of interview - **SUBJECT** : Subject headings assigned by the Library to assist searching - **Series/Collection** : Project name (some oral histories were conducted within a project) - **TRANSCRIPT URL** : URL of location of transcript in PDF format 1
- This resource was created in June 2016. It has been superseded by an updated version in December 2016. This Excel workbook contains the same data as the CSV file but has the advantage that URLs are active hyperlinks. 1
source
publisher
licence
format
- XLSX · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
755 | 755 | Oral Histories | State Library of South Australia | State Library of South Australia | 2016-06-29T05:56:30.682753 | 2019-08-29T04:33:50.156866 | This dataset includes 952 selected oral history transcripts from the J.D. Somerville Oral History Co… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/a1fce9bf-9afe-426f-a4b8-e2661e611436 | 1960-01-01 | 2013-12-31 | Oral Histories - Excel workbook | https://data.sa.gov.au/data/dataset/a1fce9bf-9afe-426f-a4b8-e2661e611436/resource/547be64c-8b9e-4d1e-8319-1fb8f2f8af5f/download/oralhistorieswithtranscript.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2017-07-07T13:08:01.407175 | 2017-07-07T03:08:01.336759 | Creative Commons Attribution | |
757 | 757 | Oral Histories | State Library of South Australia | State Library of South Australia | 2016-06-29T05:56:30.682753 | 2019-08-29T04:33:50.156866 | This dataset includes 952 selected oral history transcripts from the J.D. Somerville Oral History Co… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/a1fce9bf-9afe-426f-a4b8-e2661e611436 | 1960-01-01 | 2013-12-31 | Oral Histories - Excel workbook | https://data.sa.gov.au/data/dataset/a1fce9bf-9afe-426f-a4b8-e2661e611436/resource/632bbc88-e6bf-4f4d-98da-48f27f98d0c1/download/oralhistories.xlsx | XLSX | Compiled 2016. This data set has been superseded by an updated version at the top of this Data and R… | 2016-07-01T11:31:43.771582 | 2016-07-01T01:31:43.629008 | Creative Commons Attribution | |
759 | 759 | 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 - Excel workbook | https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d/resource/9c141a37-1c35-458f-a897-3a7c032a9138/download/saspeaks_oralhistory.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2017-07-06T16:33:48.202152 | 2018-06-20T07:55:45.330981 | Creative Commons Attribution | |
761 | 761 | 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/021cdfdc-b9b1-40f0-8c03-e003172405c8/download/saspeaksoralhistory.xlsx | XLSX | This data set was superseded in 2017 by an updated version at the top of this Data and Resources lis… | 2016-12-01T14:31:37.890626 | 2016-12-01T03:31:37.822111 | Creative Commons Attribution | |
763 | 763 | 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 - Excel workbook | https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d/resource/04931a8a-c47c-4705-bed9-d95e71b41fee/download/saspeaksoralhistory.xlsx | XLSX | This resource was created in June 2016. It has been superseded by an updated version in December 201… | 2016-06-30T15:33:42.271015 | 2016-06-30T05:33:42.142222 | 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]);