glam-datasets

2 rows where dataset_description = "The meteorite collection contains representative material from over 150 Australian and overseas meteorites, with the focus mainly on those that have been found in South Australia. The collection includes pieces from significant international meteorites, such as the Indian Shergotty and Egyptian Nakhla falls, since determined to have originated from Mars. The data includes the locality and date of finds, weight and other descriptive information, and information about their acquisition. The South Australian Museum manages this dataset using the KE EMu collection management system. The full dataset is published on data.sa.gov.au as a .csv file. " and licence = "Creative Commons Attribution-NonCommercial"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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]);