DOI: 10.15468/dl.76hwg4
title: Occurrence Download

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

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