glam-datasets

1 row where dataset_description = "Selection of images (60) from the State Library of South Australia collections of Significant South Australians featuring selected men and women of Adelaide's North Terrace plaques. These are a selection of images from a range of subjects and other State library photo sets on Flickr and range from 1815-1951, and includes: Dervish Bejah, Cameleer and explorer Sir Donald Bradman, Cricketer Kate Boadicea Cocks, first female police constable in the British Empire Matthew Flinders, Navigator and explorer Donald Dunstan, Lawyer, reformist, social progressive and Premier of South Australia Rev John Flynn, Founded what became the Royal Flying Doctor Service Sir Robert Helpmann Dancer, choreographer, actor and director Sir Hans Heysen artist and conservationist Colonel William Light Surveyor General, South Australia Mother Mary Mackillop (now Saint Mary of the Cross), Catholic sister, educator and Australia’s first saint Sir Douglas Mawson, Geologist and Antarctic explorer Dame Roma Mitchell, Australia’s first female judge Catherine Helen Spence, Author, journalist, teacher, suffragist, political candidate John McDouall Stuart, Explorer Mary Lee, Suffragist and social reformer Mark Oliphant, Physicist, humanitarian, Governor of South Australia Thomas Playford, Longest serving Premier of South Australia Sir Ross and Sir Keith Smith, piloted first aeroplane from England to Australia Charles Sturt, Soldier and explorer David Unaipon, Aboriginal leader, preacher, inventor and writer " and format = "JPEG"

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