glam-datasets

3 rows where dataset_description = "A collection of more than 700 photographs of World War I soldiers was digitised in 1999 as part of the Adopt-A-Soldier project. We're delighted to announce that this set was recently used in GovHack 2016 for the iHero Application entry https://2016.hackerspace.govhack.org/content/ihero . Summary from the Entry: Our project ''iHero" is a web application that uses facial recognition to search Australian service photos across various conflicts as captured by the State Library of Western Australia, Australian War Memorial, National Archives of Australia and the State Library of Queensland." and publisher = "State Library of Western Australia" sorted by download_url

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