2 rows where 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." and format = "XLSX"

View and edit SQL

Suggested facets: dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (date), file_modified (date)

source

format

  • XLSX · 2

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. · 2
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
708 South Australian Photographs World War 1 1914-1929 State Library of South Australia Andrew Piper 2013-05-31T07:08:43.848160 2019-08-29T04:37:07.788643 This dataset is an extract from the photographic collections of the State Library of South Australia… data.sa.gov.au https://data.sa.gov.au/data/dataset/49266c9b-ae27-47bc-8e23-866a2d027403     South Australian Photographs World War 1 - 1914-1929 (Excel workbook) https://data.sa.gov.au/data/dataset/49266c9b-ae27-47bc-8e23-866a2d027403/resource/aa9c5e66-23db-4519-924a-0ae71ca2f9b7/download/unleashed2016sawwiphotographs.xlsx XLSX Compiled 2016. This data set has been superseded by an updated version at the top of this Data and R… 2016-07-01T17:37:43.280616 2016-07-01T07:37:43.164618   Creative Commons Attribution
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

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