glam-datasets

6 rows where dataset_description = "Beta version of the data, testing live sync with our internal database. Not for use in planning. The Maritime Archaeology shipwreck database contains information and details on Western Australian shipwrecks recorded by the Western Australian Museum. Within the shipwreck database there are records and details for over 1650 Western Australian shipwrecks, including the Batavia, SS Xantho and Zuytdorp.", licence = "Creative Commons Attribution 4.0" and publisher = "Western Australian Museum"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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