glam-datasets

2 rows where dataset_description = "Music Queensland is the State Library of Queensland's digital music collection, and contains digitised copies of historically significant music scores about Queensland. Queensland places, people, events and pastimes are highlighted in this collection. There are around 90 digitised scores, many of which have stunning or quirky illustrated covers. Songs about places are also featured. The scores are out of copyright and date up to around 1930.", "dataset_issued" is on date 2012-12-07 and source = "data.qld.gov.au"

✎ View and edit SQL

This data as json, CSV (advanced)

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