glam-datasets
2 rows where "file_created" is on date 2017-07-06, info_url = "https://data.sa.gov.au/data/dataset/387e2e32-f30c-4f9b-9d8f-848d06dfe18d" and licence = "Creative Commons Attribution"
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 | |
| 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 |
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]);