glam-datasets

3 rows 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." 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)

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