glam-datasets
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." and licence = "Creative Commons Attribution-NonCommercial"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 910 | 910 | 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 | South Australian Museum Minerals Collection | https://data.sa.gov.au/data/dataset/fe72a51c-def3-4229-b58c-cf9fef5d30ba/resource/40db1542-2685-48a9-8a2f-00bfc508a913/download/mineralogy.csv | CSV | This collection includes approximately 33000 registered mineral specimens representing the range of … | 2013-05-24T23:49:27.443768 | 2016-07-08T02:32:04.425155 | 2497710.0 | Creative Commons Attribution-NonCommercial |
Advanced export
JSON shape: default, array, newline-delimited
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]);