glam-datasets
1 row where dataset_description = "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.", "file_created" is on date 2017-07-06 and format = "CSV"
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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]);