1 row where dataset_description = "A selection (542) of portraits of soldiers. This set of portraits comes from our Chamberlain Collection and includes portraits of Soldiers prior to embarkation in studios and at various military camps in South Australia including Morphettville and Jubilee Oval. ", "dataset_modified" is on date 2020-02-24, format = "API" and licence = "Creative Commons Attribution"

View and edit SQL

Suggested facets: dataset_modified (date), file_created (date), file_modified (date)

source

licence

  • Creative Commons Attribution · 1

format

Link rowid ▼ dataset_title publisher author dataset_issued dataset_modified dataset_description source info_url start_date end_date file_title download_url format file_description file_created file_modified file_size licence
672 South Australians of World War 1 Photographs Flickr set State Library of South Australia Andrew Piper 2013-05-21T09:06:33.212603 2020-02-24T02:07:29.790770 A selection (542) of portraits of soldiers. This set of portraits comes from our Chamberlain Collect… data.sa.gov.au https://data.sa.gov.au/data/dataset/0384a465-903c-4b2b-93ec-826acbe2c66b 1914-1916   Flickr API https://www.flickr.com/services/api/ API This dataset can be used in conjunction with the Flickr API. 2014-07-07T04:03:42.373664 2014-07-07T05:05:26.071019 20.0 Creative Commons Attribution

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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