DOI: 10.15468/dl.j4m6d6
title: Occurrence Download

description: A dataset containing 2487298 records in GBIF matching the query:
SELECT "year", GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 10000)) AS eeacellcode, countryCode AS countryCode, datasetKey, basisOfRecord, speciesKey, species, family, class, sex, COUNT(*) AS occurrences FROM occurrence WHERE occurrence.occurrencestatus = 'PRESENT' AND continent = 'EUROPE' AND "year" &gt;= 2000 AND speciesKey IN (2402168, 5604715, 1425187, 2363021, 4562143, 3921499, 5405976, 3120878, 3120923, 3121387, 5851603, 2650652, 2226998, 4312658, 4417555, 2432582, 5739539, 5739554, 1085533, 2423443, 2423435, 2650180, 9529916, 5744642, 2682851, 3168046, 5219219, 5219173, 2441055, 1036775, 4471132, 4470447, 4409131, 5820507, 3113465, 7246637, 2368212, 2368185, 1421988, 1422012, 1422002, 1911168, 1911093, 2706035, 5137708, 1421199, 2351211, 7807208, 5373485, 2438704, 4451511, 2820517, 7489951, 2675421, 12182921, 3903269, 2439688, 2717871, 8909809, 2422507, 7261816, 2432359, 4525268, 3633778, 2421315, 2421304, 4535809, 4535817, 4532532, 2855356, 3170040, 3840751, 2750279, 4470279, 2382142, 2382143, 2681714, 10152438, 2294287, 7456091, 5324944, 2308887, 2351413, 2427573, 7261861, 2468506, 5298814, 1684375, 3091224, 6159223, 6159273, 2421402, 5137908, 2436756, 2675719, 1429199, 1429178, 1429194, 1963232, 6445722, 4428477, 8602699, 4535614, 5743122, 2433753, 1929270, 1925962, 2435240, 1922311, 1922343, 1922406, 5286287, 7911174, 5274875, 5218878, 5282427, 4409202, 9796816, 2367936, 2439658, 5219057, 5218911, 7930390, 4266346, 2432427, 2432414, 7261875, 2432439, 4266349, 2432470, 2432416, 9754263, 5329315, 6161327, 8078388, 5218522, 5218524, 5129378, 1426058, 2672681, 8385026, 1079588, 1702607, 1938810, 1938520, 2367038, 2430567, 2426654, 2426654, 2426661, 4453682, 3161912, 5218464, 5218471, 5218465, 5707150, 5218507, 5739437, 5787719, 2469188, 1864161, 7277986, 2426789, 2426760, 2426805, 2432655, 2432614, 2360842, 7135755, 5007652, 7465957, 2360785, 9741819, 2360759, 2360771, 7569075, 5220170, 2359699, 2359692, 2367872, 4560905, 1683952, 2431781, 4277148, 2439449, 2437304, 2805343, 1710932, 4427599, 4427602, 6432155, 5051901, 1424202, 5281501, 2360687, 4561959, 4562023, 7774938, 5203999, 5359144, 2431887, 2431885, 2431891, 5203115, 4559558, 2433433, 4567182, 4567251, 4567215, 2432564, 2444308, 2458538, 5141262, 2382111, 2382114, 2412623, 2426612, 2703659, 2334088, 2334183, 7964291, 2434806, 5220081, 2421365, 2864775, 2432452, 2432389, 7951391, 2434793, 2440669, 7595433, 2440447, 3606863, 8120403, 2402129, 2402154, 2402159, 2402203, 2363028, 2363020, 2363022, 3190715, 2412637, 2412669, 6229899, 4229609, 1777695, 5206749, 5205676, 5739556, 5206716, 5206992, 5329163, 4470538, 3127717, 3128022, 2368253, 2368221, 2368204, 2334108, 10939543, 8324617, 4534360, 2457224, 9099408, 2458386, 1956627, 9595248, 5300375, 5300376, 12222508, 8845441, 2402105, 1862774, 6159197, 5051794, 2443384, 2447858, 2438483, 3810415, 2434779, 4459448, 2439663, 2432430, 5218525, 2469702, 2430566, 2426640, 2426650, 8211086, 5223135, 2469075, 2469065, 5772691, 7294764, 5369241, 4454238, 4535092, 2468350, 6365085, 2426795, 2432666, 2432621, 2432667, 5706429, 2769766, 2367894, 2439439, 2433009, 2457466, 2441461, 2441454, 7657198, 2431888, 5664585, 9807306, 2433709, 2458374, 8011236, 2348104, 5375066, 5629532, 3042748, 10677799, 8894817, 3127662, 5225137, 2449051, 2442225, 5403341, 2747796, 2747562, 3920959, 2457223, 2457232, 5787592, 2459015, 2427599, 5341748, 6161355, 2793061, 6165156, 3888448, 7307289, 8058554, 5739445, 3924925, 2432953, 3884303, 2767355, 2767291, 3891669, 5299588, 3925422, 3637114, 2127372, 5410654, 5410656, 7267859, 2334116, 6710541, 7489951, 2915084, 5392633, 9404888, 3171733, 4112245, 3033623, 2360795, 6432021, 4218630, 5218409, 4287132, 2412685, 2440728, 2441184, 2351027, 2351193, 2351208, 2351234, 2678770, 4470292, 6199932, 6159243, 5219007, 7443268, 8236498, 2367870, 3032811, 4144397, 4567211, 2440718, 2440596, 5220086, 2440483, 3002003, 4456155, 2704845, 2334093, 7267942, 5280170, 3085371, 7516178, 2437258, 5219373, 7389318, 8252814, 2671366, 4426238, 1772458, 2402193, 2362914, 2363032, 2469367, 2469363, 2412619, 2412683, 5789536, 9565497, 2740522, 3122645, 2348137, 3168262, 2364698, 5739534, 5206966, 5206714, 5207176, 5739562, 5207064, 3639640, 3638275, 4262706, 4206359, 3128049, 3127554, 3128480, 3128612, 3127473, 3128211, 3128679, 2279029, 2795928, 3885512, 2368261, 2368189, 2368173, 2368235, 9227457, 2368219, 2368194, 2368176, 4286856, 9680003, 5185014, 9789983, 2375330, 2375336, 2455751, 5962957, 5962956, 5300841, 5300571, 5300607, 5578459, 5220027, 3131630, 5789567, 2458928, 2458916, 3711466, 5377151, 8088138, 2375696, 2375686, 11146847, 7193633, 7504253, 7376915, 4374632, 2363082, 2431829, 2431833, 2444698, 11172225, 11199676, 11153404, 4820419, 5610773, 5609657, 10733394, 2462191, 7227883, 3894972, 1079611, 3614259, 3614186, 1938131, 2359842, 2359834, 2359831, 2359846, 2359836, 2360990, 2426670, 2426672, 3143056, 5293186, 8123917, 4374731, 5787632, 5789532, 2468994, 5789530, 2469118, 5652611, 2440440, 2360811, 2360747, 8478641, 2359671, 8536369, 4284018, 2351627, 2351647, 2351546, 2362671, 8243249, 2221735, 7662000, 5585543, 8115991, 4058159, 2365745, 5220055, 2440433, 4067409, 2360998, 2363548, 2441502, 2363389, 9685146, 4559608, 5203912, 8310027, 3728644, 5663312, 9012191, 5275359, 4159329, 2382121, 2440369, 2361439, 2361438, 4198135, 4197651, 2469356, 2855945, 2426610, 2426613, 2426609, 2360380, 3965840, 2740597, 2740588, 7290761, 4005170, 5352343, 3741143, 3740165, 2348094, 2348049, 5831893, 1405466, 6710361, 5586437, 5585118, 3104499, 3104470, 5668182, 5668162, 3121429, 7310665, 8137610, 5346662, 5398267, 5398244, 3802666, 1692648, 2440709, 2440714, 2440735, 5207307, 5739559, 3032182, 3032179, 2754399, 5281823, 10779794, 3638501, 2431827, 2431824, 2441054, 2441054, 9296604, 8088443, 3114589, 3128787, 3127794, 3128138, 3127672, 3128734, 7570714, 3575531, 8974077, 8247946, 5225153, 5225149, 5225148, 3097073, 3097051, 2431938, 7331358, 2368179, 2368245, 2368265, 3040701, 3681152, 5376452, 2334100, 2334173, 5373530, 5373461, 5373522, 5403502, 2435551, 8349980, 5524064, 10800268, 7267156, 5376382, 5376403, 2426616, 2426617, 5356950, 5304469, 5654715, 2675958, 4067595, 5782993, 5787585, 8841716, 7444427, 2437136, 3828671, 3826450, 3826194, 3641026, 2440339, 3064110, 3067114, 3065201, 3066236, 3068150, 3637808, 4127331, 4124641, 4123458, 4113010, 5219516, 2913980, 2468656, 2468672, 8682680, 6159132, 2468651, 5672463, 5219362, 5347679, 4564441, 4059956, 2440605, 5578445, 5578495, 5051921, 5124512, 3595627, 3596509, 7331423, 7379976, 3131776, 2459023, 2434255, 4150489, 2427555, 2427580, 3132537, 5220013, 3093880, 2367622, 2367630, 7837038, 2468520, 2468525, 2468503, 2468522, 2468518, 2468511, 8132370, 5298488, 11213603, 8013319, 5559164, 5694634, 2440694, 2440691, 4939647, 7720261, 6159196, 2440493, 3630000, 3137527, 2442165, 3142180, 7875825, 4090542, 7298058, 4089510, 4089302, 7759323, 8014330, 2655341, 5356840, 5356836, 2364815, 2363069, 2363097, 2365350, 2363080, 2363094, 2365155, 2435261, 3988992, 1429876, 2145078, 5782525, 5613441, 5613324, 2443341, 2440412, 2440403, 2440397, 2440417, 11098873, 2438668, 4197353, 3745163, 8181305, 2859233, 2858431, 2858846, 2858644, 2858209, 2858654, 2858924, 2858662, 10671015, 4928424, 2858501, 2858201, 5539675, 7639090, 9600694, 3094889, 3094899, 3659152, 9254095, 10926869, 3614311, 2359302, 2359297, 5962764, 5377797, 5728503, 2430565, 2426658, 3087419, 7579898, 3808482, 7267092, 3808387, 2654944, 3093358, 5667895, 5218476, 4155899, 5218519, 2469155, 2469028, 1932517, 2360371, 2360367, 2360363, 2704720, 2426774, 2426793, 3921209, 7914972, 2688657, 10836683, 4036610, 5220171, 3857544, 3125943, 3125941, 3754220, 3133531, 3737600, 3735647, 3108888, 3630865, 3891662, 8117625, 3891077, 3890500, 7307469, 3889964, 3888771, 4014440, 5587262, 8012009, 3046747, 2929993, 4004972, 2669149, 2363396, 2365679, 5220045, 3105709, 4218280, 2445033, 2445052, 8994891, 2445039, 5611691, 3968896, 3130994, 3897704, 4931003, 3892603, 5523670, 5607503, 2431886, 2431889, 5782503, 6548059, 5203914, 5375681, 7997882, 2974799, 5663812, 5663499, 5960884, 5747828, 2865134, 4485547, 2706312, 5384492, 7625618, 5323572, 11070341, 2722344, 4276636, 5882039, 4450854, 5403461, 2675182, 8668880, 3049489, 5275131, 12261023, 5219073, 9213010, 2681914, 7435160, 7939048, 8086854, 8071351, 5329466, 5283624, 4035833, 7601246, 2798444, 5414318, 2704674, 5219371, 4457579, 5706310, 5384797, 12247120, 6711842, 5219303, 7727533, 8688267, 5326577, 3921843, 2469361, 8257208, 5928331, 3921309, 9107061, 5584607, 8333551, 8034974, 5344299, 3041767, 3042880, 9529916, 3128595, 4095830, 4262370, 2739652, 2334176, 2334155, 2334119, 2334125, 2426621, 2426615, 2446608, 7958564, 2431940, 6228548, 3838874, 3594336, 3050689, 2427563, 7313107, 5220073, 7976992, 4089439, 7612469, 4266337, 4928420, 6161349, 6165157, 1938050, 2359289, 2469126, 5366702, 9348906, 2431780, 3754238, 3754286, 7538949, 2431453, 5663414, 2382117, 9302387, 3930521, 5374899, 2367048, 5207310, 7267578, 2360594, 2360565, 2368222, 2368230, 2368190, 2368171, 2368233, 9058300, 5855853, 5789555, 3043200, 2367516, 2367522, 2367520, 2367514, 5789566, 2438502, 5347723, 2375683, 2375697, 9702100, 4445665, 2421217, 7374133, 3810117, 2361325, 2361328, 2468999, 9185677, 2379274, 2432042, 2426788, 2351630, 2351604, 2767252, 2360733, 2360610, 2363539, 2363545, 7193649, 6157236, 4470822, 4470816, 2739933, 5109677, 8364235, 8295936, 4477514, 4477266, 2421307, 3636648, 1829987, 4564570, 5298613, 1684312, 4048500, 1710221, 4067320, 4930561, 5784455, 1695277, 1985561, 4533311, 7723626, 7271631, 3630648, 3045253, 5525462, 6157238, 2412705, 2351002, 5220003, 2685577, 5616499, 2362920, 2412712, 4005922, 3921309, 8376325, 5668095, 4256882, 5345691, 5343495, 5346856, 3633974, 5206720, 5206782, 2423436, 1716482, 3042605, 3042797, 10400305, 10722555, 5410431, 5409803, 4470646, 2722101, 7468889, 3128353, 4096157, 2360575, 2368208, 1421207, 2435553, 2747813, 7555690, 5354605, 5524243, 7550532, 5220531, 8337357, 5134777, 5375519, 3737855, 2431941, 2914154, 5586222, 2427598, 5219888, 5298940, 7355662, 5695386, 3132517, 8350816, 8171325, 4088622, 4090766, 7446038, 7790128, 4048390, 5218406, 1916347, 5100580, 5223509, 2793844, 1079594, 4424851, 2375443, 2430567, 3633804, 10893276, 5739436, 2469148, 2469122, 8145436, 5640973, 5640340, 5641574, 7842450, 2360199, 2426815, 4194757, 5706425, 2359686, 8171391, 2367885, 2431781, 2431781, 2431852, 12191190, 2351640, 3753004, 3752513, 3754891, 5587273, 2431455, 2431457, 2431672, 2431452, 2431454, 2431451, 2365749, 4144609, 6432155, 2363553, 3098613, 2458382, 5802625, 8384512, 2365586, 9630426, 4416689, 7515774, 9326566, 3131272, 8575922, 8724265, 5783180, 2792725, 3097098, 4455199, 5219378, 2438635, 5220008, 2434801, 5219369, 5411208, 8529147, 5373247, 5373286, 3048474, 2914482, 4263721, 2438637, 1115612, 7433759, 5706423, 2437323, 2361436, 2361445, 4197241, 11139198, 3631681, 3742430, 3105531, 5537662, 5352359, 7545328, 5375135, 4069218, 4235471, 3104525, 4090794, 5668281, 7480175, 5668199, 2778450, 5345902, 9622301, 9310110, 8358373, 5413099, 5304200, 3982110, 5383924, 10793528, 2670513, 7992416, 5694235, 2728098, 4565665, 4565683, 4565667, 9401685, 3128141, 3732560, 3642488, 3031018, 3097055, 3112721, 3595098, 3679523, 9258180, 9599733, 7267749, 8269813, 5376325, 5780146, 8340385, 5632022, 7551118, 5682827, 3069679, 3740173, 3738598, 7332902, 4125030, 5941045, 7930611, 9380838, 2890983, 2840691, 3595820, 10723010, 3594304, 8095200, 8228636, 5304273, 5377206, 2367627, 2367632, 4564225, 10957950, 3165744, 3165764, 3172271, 3040944, 2701520, 4210368, 7801421, 8012324, 7492359, 4566639, 4566633, 4566645, 4566576, 4566572, 3142177, 4089687, 7776721, 7664498, 8010088, 5357009, 10998169, 3024897, 5274865, 5793132, 3791289, 9244277, 2971032, 9393490, 3048759, 3048748, 3164483, 3164489, 8405185, 5660582, 5660980, 5660582, 2858572, 5218523, 5540468, 9479684, 2977270, 2849506, 3150065, 5678643, 5549939, 8350478, 4155899, 4156295, 4039363, 3023426, 4120732, 3127926, 4036062, 3639728, 4252829, 3754087, 3752577, 4103685, 2767362, 2767362, 7332908, 7670884, 5303772, 3108080, 3732619, 8429165, 5584524, 7267697, 5584478, 3047767, 7470443, 3813164, 2468700, 10685454, 3901655, 3898359, 7700234, 7307674, 7307657, 5606426, 7306548, 3595738, 2951999, 9644635, 2975004, 8063597, 10582104, 10404024, 5345142, 10465025, 5411146, 3128839, 2368187, 2334172, 3050158, 2913153, 1684370, 2382017, 2367888, 6432155, 7636833, 5218405, 5299388, 7529713, 8161498, 4279500, 5373826, 4124964, 2350963, 5531607, 2688412, 3050152, 2840551, 10005599, 10342767, 9502874, 9502874, 8305255, 2688345, 2688382, 3601124, 7226671, 7933553, 7450707, 3753813, 2334074, 5540289, 3810093, 5640361, 3169315, 7311463, 7267339, 10693380, 7433759) AND occurrence.hasgeospatialissues = FALSE AND occurrence.hascoordinate = TRUE AND (coordinateUncertaintyInMeters &lt;= 10000 OR coordinateUncertaintyInMeters IS NULL) AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_INVALID') AND NOT ARRAY_CONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH') AND "month" IS NOT NULL AND (occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE) AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE) AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN') AND (identificationVerificationStatus IS NULL OR NOT (LOWER(identificationVerificationStatus) LIKE '%unverified%' OR LOWER(identificationVerificationStatus) LIKE '%unvalidated%' OR LOWER(identificationVerificationStatus) LIKE '%not able to validate%' OR LOWER(identificationVerificationStatus) LIKE '%control could not be conclusive due to Insufficient knowledge%' OR LOWER(identificationVerificationStatus) LIKE '%unconfirmed%' OR LOWER(identificationVerificationStatus) LIKE '%unconfirmed - not reviewed%' OR LOWER(identificationVerificationStatus) LIKE '%validation requested%')) GROUP BY "year", basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, sex, GBIF_EEARGCODE(10000, occurrence.decimallatitude, occurrence.decimallongitude, COALESCE(occurrence.coordinateuncertaintyinmeters, 10000)) ORDER BY "year" DESC, countryCode ASC

 The dataset's 2487298 records were derived from 13230 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0001765-250525065834625/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.