Occurrence Download

A dataset containing 4796 records in GBIF matching the query: SELECT countryCode, CASE WHEN classKey IN ('359') THEN 'Mammals' WHEN classKey IN ('212') THEN 'Birds' WHEN familyKey IN ('1103', '1104', '494', '495', '1105', '496', '497', '1106', '498', '499', '1107', '537', '538', '1153', '547', '1162', '548', '549', '550', '1163', '1164', '1165', '1166', '1167', '1305', '1067', '1306', '1307', '1308', '1068', '1069', '587', '1310', '588', '589', '1311', '1312', '1313', '590', '708', '890', '774', '889', '773', '772', '888', '765', '879') THEN 'Bony Fish' WHEN classKey IN ('131') THEN 'Amphibians' WHEN classKey IN ('216') THEN 'Insects' WHEN classKey IN ('11418114', '11569602', '11592253', '11493978') THEN 'Reptiles' WHEN phylumKey IN ('52') THEN 'Molluscs' WHEN classKey IN ('367') THEN 'Arachnids' WHEN classKey IN ('220', '196') THEN 'Flowering Plants' WHEN classKey IN ('194', '244', '228', '282') THEN 'Gymnosperms' WHEN orderKey IN ('392') THEN 'Ferns' WHEN phylumKey IN ('35') THEN 'Mosses' WHEN phylumKey IN ('95') THEN 'Sac Fungi' WHEN phylumKey IN ('34') THEN 'Basidiomycota' ELSE 'Other' END AS taxon_group, kingdom, COUNT(DISTINCT speciesKey) AS species_count FROM occurrence WHERE hasCoordinate = TRUE AND hasgeospatialissues = FALSE AND speciesKey IS NOT NULL AND basisOfRecord != 'FOSSIL_SPECIMEN' AND taxonrank = 'SPECIES' AND countryCode IS NOT NULL GROUP BY countryCode, kingdom, CASE WHEN classKey IN ('359') THEN 'Mammals' WHEN classKey IN ('212') THEN 'Birds' WHEN familyKey IN ('1103', '1104', '494', '495', '1105', '496', '497', '1106', '498', '499', '1107', '537', '538', '1153', '547', '1162', '548', '549', '550', '1163', '1164', '1165', '1166', '1167', '1305', '1067', '1306', '1307', '1308', '1068', '1069', '587', '1310', '588', '589', '1311', '1312', '1313', '590', '708', '890', '774', '889', '773', '772', '888', '765', '879') THEN 'Bony Fish' WHEN classKey IN ('131') THEN 'Amphibians' WHEN classKey IN ('216') THEN 'Insects' WHEN classKey IN ('11418114', '11569602', '11592253', '11493978') THEN 'Reptiles' WHEN phylumKey IN ('52') THEN 'Molluscs' WHEN classKey IN ('367') THEN 'Arachnids' WHEN classKey IN ('220', '196') THEN 'Flowering Plants' WHEN classKey IN ('194', '244', '228', '282') THEN 'Gymnosperms' WHEN orderKey IN ('392') THEN 'Ferns' WHEN phylumKey IN ('35') THEN 'Mosses' WHEN phylumKey IN ('95') THEN 'Sac Fungi' WHEN phylumKey IN ('34') THEN 'Basidiomycota' ELSE 'Other' END ORDER BY countryCode, taxon_group, kingdom The dataset's 4796 records were derived from 64542 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0076918-251120083545085/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.