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"

View and edit SQL

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

source

  • data.sa.gov.au · 2

format

  • XLSX · 2
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 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 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]);