1 row where dataset_description = "Selected sheet music (100 individual songs) related to or published in South Australia. The collection is particularly strong on the genre of patriotic songs from World War One and sentimental ballads. Includes full colour scan of the sheet music and additional contextual research. ", format = "CSV" and publisher = "State Library of South Australia"

View and edit SQL

Suggested facets: dataset_issued (date), dataset_modified (date), file_modified (date)

source

publisher

  • State Library of South Australia · 1

format

dataset_description

  • Selected sheet music (100 individual songs) related to or published in South Australia. The collection is particularly strong on the genre of patriotic songs from World War One and sentimental ballads. Includes full colour scan of the sheet music and additional contextual research. · 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
764 South Australian Sheet Music 1852-1927 State Library of South Australia Online Projects, State Library of South Australia 2013-03-07T14:38:12.818813 2019-08-29T02:33:15.378498 Selected sheet music (100 individual songs) related to or published in South Australia. The collecti… data.sa.gov.au https://data.sa.gov.au/data/dataset/02f2e8e0-f843-4a37-9e0a-eeb4d366991c 1852-1927   South Australian Sheet Music 1852-1927 https://data.sa.gov.au/data/dataset/02f2e8e0-f843-4a37-9e0a-eeb4d366991c/resource/62c7cae5-3052-4cef-9286-e05d57e0f5ed/download/sasheetmusic_2011.csv CSV Selected sheet music (101 individual songs) related to or published in South Australia. The collecti… 2013-03-20T22:55:14.341001 2019-08-29T02:32:54.388330 226256.0 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]);