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 2022-07-28

✎ 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
1113 1113 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 Feature Service https://services.slip.wa.gov.au/public/services/SLIP_Public_Services/People_and_Society_WFS/MapServer/WFSServer WFS Web Feature Service (WFS) provides an interface that allows requests for geographical features acros… 2022-07-28T21:58:42.796287 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]);