glam-datasets
1 row where "dataset_issued" is on date 2013-03-21, 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." and publisher = "South Australian Museum"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);