glam-datasets
2 rows where dataset_description = "The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial South Australia. Duryea was active in South Australia 1855-1875. He and his brother were the first known photographers to work in areas of South Australia outside Adelaide. Duryea is particularly known for his panoramas of Adelaide and portraits of surviving original European colonists of South Australia.", format = "XLSX" and source = "data.sa.gov.au"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), start_date (date), end_date (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
698 | 698 | 19th Century Photographs by Townsend Duryea | State Library of South Australia | State Library of South Australia | 2014-06-10T12:57:32.375370 | 2019-08-29T04:40:29.655895 | The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial … | data.sa.gov.au | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51 | 1856-01-01 | 1887-12-31 | 19th Century Photographs by Townsend Duryea - Excel workbook | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51/resource/f1c626b4-17e7-49ce-9cea-ae4b3b02407a/download/duryeaphotographs.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2017-07-06T16:16:57.988010 | 2017-07-06T06:16:57.906869 | Creative Commons Attribution | |
700 | 700 | 19th Century Photographs by Townsend Duryea | State Library of South Australia | State Library of South Australia | 2014-06-10T12:57:32.375370 | 2019-08-29T04:40:29.655895 | The photographs (approximately 165) were taken by Townsend Duryea, a noted photographer of colonial … | data.sa.gov.au | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51 | 1856-01-01 | 1887-12-31 | 19th Century Photographs by Townsend Duryea - Excel workbook | https://data.sa.gov.au/data/dataset/97f60b3e-9b50-4cc2-9960-73288d076c51/resource/90c43e33-d6ca-42fc-a66e-aa63d5f60358/download/duryeaphotographs.xlsx | XLSX | Compiled 2016. This data set has been superseded by an updated version at the top of this Data and R… | 2016-07-01T14:32:13.496386 | 2016-07-01T04:32:13.372187 | 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]);