glam-datasets
2 rows 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 and format = "JPEG"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 671 | 671 | 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 | South Australians of World War 1 Photographs | https://www.flickr.com/photos/state_library_south_australia/sets/72157632937420680/ | JPEG | A selection (542) of portraits of soliders. | 2014-07-07T04:01:19.707001 | 2014-07-07T05:05:25.579072 | 20.0 | Creative Commons Attribution | |
| 673 | 673 | 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 | Trove | https://trove.nla.gov.au/newspaper?q= | JPEG | This data set can also be used in conjunction with Trove. Trove helps you find and use resources re… | 2014-07-07T04:07:34.508249 | 2014-10-14T22:12:02.413460 | Creative Commons Attribution |
Advanced export
JSON shape: default, array, newline-delimited
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]);