glam-datasets
1 row where "dataset_issued" is on date 2013-03-21 and file_description = "This section houses over 55,000 registered and 6,000 unregistered specimens including skins, eggs, skeletons, nests and spirit collections. It has an excellent collection of South Australian species, both historical and recent, a large collection of stomach contents, which is used to determine diets, and an Australia wide collection of eggs."
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (date)
source
publisher
licence
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
853 | 853 | South Australian Museum Ornithology Collection | South Australian Museum | Alexis Tindall | 2013-03-21T05:59:59.088745 | 2020-02-18T01:29:42.117037 | This section houses over 55,000 registered and 6,000 unregistered specimens including skins, eggs, s… | data.sa.gov.au | https://data.sa.gov.au/data/dataset/a4fbf1a3-bb6f-4b59-860a-3283200e7a90 | 1860-2014 | SA Museum Ornithology Collection | https://collections.ala.org.au/public/show/co127 | Mixed Formats | This section houses over 55,000 registered and 6,000 unregistered specimens including skins, eggs, s… | 2013-03-21T06:00:49.912951 | 2013-04-09T13:48:29.368728 | 32768.0 | Creative Commons Attribution |
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]);