Abstract
A dataset containing 39008355 records in GBIF matching the query: SELECT countryCode, "year", speciesKey, 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"