glam-datasets

1 row where dataset_description = "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." and "file_created" is on date 2021-03-21

✎ View and edit SQL

This data as json, CSV (advanced)

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

source

format

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
1108 1108 Shipwrecks (WAM-002) Western Australian Museum Jeremy Green 2015-11-25T06:35:52.926878 2022-08-13T22:00:49.262822 The Maritime Archaeology shipwreck database contains information and details on Western Australian s… data.wa.gov.au https://catalogue.data.wa.gov.au/dataset/bf006416-589e-4d9f-bc46-566ac564c405     Web Mapping Service https://services.slip.wa.gov.au/public/services/SLIP_Public_Services/People_and_Society/MapServer/WMSServer WMS Web Map Service (WMS) is a standard protocol for serving georeferenced map images over the internet … 2021-03-21T00:04:58.919754 2018-01-10T00:00:00   Creative Commons Attribution 4.0

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