4 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." and end_date = "1885-12-31"

View and edit SQL

Suggested facets: file_description, dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (date), file_modified (date)

format

source

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
687 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 https://data.sa.gov.au/data/dataset/9f1775b6-9c4f-4e27-819b-33c83d0601f9/resource/982e89d4-066c-467d-a078-e8cf39228d7d/download/old_colonists_men.csv CSV 515 photographs **Explanation of fields** - **RECORD #(BIBLIO)** : SLSA unique identifier eg "b312… 2019-06-17T04:26:30.618656 2019-06-17T04:26:30.557168   Creative Commons Attribution
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
689 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 https://data.sa.gov.au/data/dataset/9f1775b6-9c4f-4e27-819b-33c83d0601f9/resource/88b20768-1d58-4879-8ffd-631119c11d1c/download/old_colonists_women.csv CSV 600 photographs **Explanation of fields** - **RECORD #(BIBLIO)** : SLSA unique identifier eg "b207… 2019-06-17T05:19:00.981788 2019-06-17T05:19:00.884090   Creative Commons Attribution
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

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