glam-datasets

1 row where file_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. The CSV contains limited bibliographic data from this collection including title of image; subject; description of resource and a link to the image on the SLWA website. Tools used to create this dataset: <ul> <li>[MarcEdit](http://marcedit.reeset.net/about-marcedit)</li> <li>[AACR2 - Anglo American Cataloguing Rules](http://www.aacr2.org/)</li> <li>[RDA - Resource Description and Access](www.rdatoolkit.org/about)</li> <li>[LCSH - Library of Congress Subject Headings](http://www.loc.gov/aba/cataloging/subject/)</li> </ul> ", format = "CSV" and source = "data.wa.gov.au"

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