4 rows 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-08-11

View and edit SQL

Suggested facets: dataset_issued (date), dataset_modified (date), file_created (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
1109 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     GeoJSON https://data-downloads.slip.wa.gov.au/WAM-002/GeoJSON GeoJSON This resource provides the latest snapshot of the dataset as GeoJSON. GeoJSON can be opened in many … 2021-08-11T14:42:52 2021-08-11T14:42:52   Creative Commons Attribution 4.0
1110 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     Geopackage https://data-downloads.slip.wa.gov.au/WAM-002/Geopackage GeoPackage This resource provides the latest snapshot of the dataset as a GeoPackage. Note: When accessing this… 2021-08-11T14:42:53 2021-08-11T14:42:53   Creative Commons Attribution 4.0
1111 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     File Geodatabase https://data-downloads.slip.wa.gov.au/WAM-002/File Geodatabase FGDB This resource provides the latest snapshot of the dataset as a File Geodatabase. Note: When accessin… 2021-08-11T14:42:25 2021-08-11T14:42:25   Creative Commons Attribution 4.0
1112 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     Shapefile https://data-downloads.slip.wa.gov.au/WAM-002/Shapefile SHP This resource provides the latest snapshot of the dataset as a shapefile. Shapefiles can be opened i… 2021-08-11T14:42:55 2021-08-11T14:42:55   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]);