glam-datasets

2 rows where dataset_description = "This dataset includes 952 selected oral history transcripts from the J.D. Somerville Oral History Collection, the central repository for unpublished oral history tapes and transcripts in South Australia. The collection is intended to provide an oral record of all aspects of the South Australian experience and particularly of those who are poorly represented in documentary records, such as low income earners, people of non-English speaking background, women, and country people. The collection also provides a representative sample of the various uses of oral history, such as academic, commissioned, local history, community arts, school and family history. The transcripts are in PDF format. ", format = "CSV" and publisher = "State Library of South Australia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (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]);