glam-datasets
1 row where file_description = "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" and format = "XLSX"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (date), file_modified (date)
source
publisher
licence
format
- XLSX · 1 ✖
file_description ✖
- 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 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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]);