glam-datasets

1 row where dataset_description = "A selected and wide range of digitised archival and published materials from the State Library of South Australia’s SA Memory program. SA Memory is an online gateway to South Australian history, heritage and culture. This multimedia website focuses on the South Australian experience – what makes South Australia unique. SA Memory illustrates and interprets themes to highlight South Australia’s people, places, issues and events from the colony’s beginnings to contemporary times: South Australia’s ‘memory’. http://www.samemory.sa.gov.au/site/page.cfm", format = "CSV" and publisher = "State Library of South Australia" sorted by source

✎ View and edit SQL

This data as json, CSV (advanced)

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