Occurrence Download

A dataset containing 40169 records in GBIF matching the query: SELECT countryCode, "year", 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 'bonyfish' 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 'floweringplants' 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 'sacfungi' WHEN phylumKey IN ('34') THEN 'basidiomycota' ELSE 'other' END AS taxon_group, COUNT(*) AS occurrence_count FROM occurrence WHERE "year" >= 2010 AND "year"