1 row where file_description = "This collection includes approximately 33000 registered mineral specimens representing the range of minerals found in South Australia. More than 1500 species are represented, providing good coverage of the species and localities from across South Australia. ", licence = "Creative Commons Attribution-NonCommercial", publisher = "South Australian Museum" and source = "data.sa.gov.au"

View and edit SQL

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

source

  • data.sa.gov.au · 1

publisher

  • South Australian Museum · 1

licence

  • Creative Commons Attribution-NonCommercial · 1

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
911 South Australian Museum Minerals Collection South Australian Museum Alexis Tindall 2013-05-25T04:48:34.200039 2016-07-08T02:32:04.460744 This collection includes approximately 33000 registered mineral specimens representing the range of … data.sa.gov.au https://data.sa.gov.au/data/dataset/fe72a51c-def3-4229-b58c-cf9fef5d30ba 1865-2014   SA Museum MInerals Collection - Metadata https://data.sa.gov.au/data/storage/f/2013-05-25T04%3A49%3A50.457Z/metadata-tempate-minerals.doc DOC This collection includes approximately 33000 registered mineral specimens representing the range of … 2013-05-24T23:50:33.091309 2014-10-30T09:00:42 851456.0 Creative Commons Attribution-NonCommercial

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