glam-datasets
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. " and format = "API"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 672 | 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
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]);