glam-datasets
2 rows where dataset_description = "Portrait photographs of 'Old Colonists' – settlers who arrived in the colony of South Australia before 1841. The men Old Colonists were invited to attend a banquet held by businessman Emanuel Solomon on 28 December 1871 to commemorate 35 years since European colonisation. Photographs are sourced from two composite or 'mosaic' photographs, one of men and one of women.", 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
688 | 688 | Old Colonists photographs | State Library of South Australia | State Library of South Australia | 2019-06-17T04:23:32.034128 | 2019-08-29T04:44:14.837878 | Portrait photographs of 'Old Colonists' – settlers who arrived in the colony of South Australia befo… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/9f1775b6-9c4f-4e27-819b-33c83d0601f9 | 1856-01-01 | 1885-12-31 | Old Colonists Men - Excel workbook | https://data.sa.gov.au/data/dataset/9f1775b6-9c4f-4e27-819b-33c83d0601f9/resource/d2c7f711-a6d5-467e-86f3-cd0c10edd483/download/old_colonists_men.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2019-06-17T05:17:29.039183 | 2019-06-17T05:17:28.980182 | Creative Commons Attribution | |
690 | 690 | Old Colonists photographs | State Library of South Australia | State Library of South Australia | 2019-06-17T04:23:32.034128 | 2019-08-29T04:44:14.837878 | Portrait photographs of 'Old Colonists' – settlers who arrived in the colony of South Australia befo… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/9f1775b6-9c4f-4e27-819b-33c83d0601f9 | 1856-01-01 | 1885-12-31 | Old Colonists Women - Excel workbook | https://data.sa.gov.au/data/dataset/9f1775b6-9c4f-4e27-819b-33c83d0601f9/resource/ac6a6aff-f263-42b2-a20d-b0ec3a803ee0/download/old_colonists_women.xlsx | XLSX | This Excel workbook contains the same data as the CSV file but has the advantage that URLs are activ… | 2019-06-17T05:20:15.622877 | 2019-06-17T05:20:15.558765 | 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]);