glam-datasets

1 row where file_description = "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." and format = "XLSX"

✎ View and edit SQL

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

format

  • XLSX · 1 ✖

file_description ✖

  • 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 ✖
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
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

CSV options: 

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]);