Occurrence Download

A dataset containing 994912 records in GBIF matching the query:
SELECT
"year",
GBIF_EEARGCode(
10000,
decimalLatitude,
decimalLongitude,
COALESCE(coordinateUncertaintyInMeters, 1000)
) AS eeaCellCode,
classKey,
class,
speciesKey,
species,
COUNT(*) AS occurrences,
MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters,
MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) AS minTemporalUncertainty,
IF(ISNULL(classKey), NULL, SUM(COUNT(*)) OVER (PARTITION BY classKey)) AS classCount
FROM
occurrence
WHERE
occurrenceStatus = 'PRESENT'
AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
AND speciesKey IN (2369165, 2398623, 2398675, 2398623, 2398669, 2398682, 2398664, 2398634, 4309455, 2271208, 2392311, 5277297, 5209181, 5209174, 5209188, 5209173, 5209184, 5209181, 5209252, 4373187, 4333247, 4333235, 2118435, 4287131, 2402129, 2402168, 2402159, 2402122, 2114252, 2663953, 10825178, 2663971, 8280204, 9238897, 5209531, 2658484, 3199341, 5969672, 4359671, 4359672, 4377664, 6536185, 2267503, 2267504, 2267500, 1004581, 1004589, 1004580, 1010422, 4372407, 5279568, 5718569, 5718570, 8249226, 7470812, 2656879, 2656914, 2656908, 2337248, 2667162, 10638056, 8187634, 1005501, 2362920, 4595294, 2390581, 7719368, 7646080, 7974238, 8202590, 8110888, 7910173, 7632200, 8234615, 4599728, 2315382, 2315395, 2325846, 2332269, 8053133, 4309906, 2226103, 4309912, 8416593, 4309900, 2226174, 8137643, 2406708, 2406721, 6526124, 7552441, 7910118, 7818107, 7446481, 4359135, 2387309, 5166760, 2219451, 2219490, 5862470, 6128436, 4805565, 7727539, 2328853, 5197001, 5856036, 2277692, 2277536, 7441080, 7909442, 7818074, 7804271, 7629910, 8038632, 5177561, 5855397, 6529629, 5729462, 5188945, 5213022, 4346612, 2284450, 2210206, 4346647, 1030510, 5166357, 5188926, 2117379, 9490730, 2656854, 8183323, 5729397, 4360191, 2657504, 2657449, 2657472, 2657657, 2657664, 2657641, 6460811, 6460808, 6460818, 2212718, 2212761, 3195275, 2348104, 2323931, 2510205, 2510183, 4355609, 2330843, 2330928, 2330832, 8876519, 9025372, 5853511, 4361146, 2481660, 2272084, 4985448, 1010410, 8472121, 5968806, 7774029, 2269489, 6531334, 6531311, 2285862, 5211031, 2508973, 2318573, 2114793, 7533797, 9558299, 2407378, 5180090, 3121258, 7579869, 7463403, 8088608, 6486731, 2330592, 2330587, 5200467, 2318324, 3196524, 4382606, 5279840, 5279834, 2510275, 2510310, 7566891, 5187508, 7765831, 3192611, 2332123, 3193854, 4371524, 2227756, 7999925, 3193079, 6075968, 6075969, 5188832, 5185431, 5185429, 2115769, 2643471, 4379029, 5212222, 8205774, 3192919, 8172198, 8970635, 2115719, 2115706, 2115724, 2407121, 2407129, 5189518, 4373229, 5188774, 4554041, 2377057, 2300712, 7670473, 6487091, 4314645, 2378864, 5233152, 2302627, 3193674, 1007721, 2329515, 7577557, 9746127, 5725688, 2320813, 2320810, 2320817, 2320998, 5209660, 2501237, 4366020, 7876352, 7734137, 8050384, 5721772, 2668884, 7577086, 4963768, 5856482, 2332104, 4354937, 4354950, 2332084, 2332084, 10739063, 2663181, 10889612, 3198843, 2266597, 2266586, 2266593, 2285737, 4374596, 2225797, 5854272, 5200325, 9817665, 5200315, 5200302, 2309685, 9442679, 2417299, 6520353, 9680062, 4309816, 5192917, 2374775, 4334330, 2114201, 4334328, 4334322, 5178365, 5730505, 2224434, 4330560, 2225650, 2225643, 4307357, 2225646, 2386919, 2293333, 5729391, 4360210, 2114223, 2114225, 2114230, 2114236, 4360289, 2266546, 2301629, 5856069, 2222075, 2406961, 2407087, 5178057, 5178082, 2390762, 2564485, 5178595, 4283812, 11652031, 2225568, 8260577, 2264603, 1008558, 2666539, 2666536, 2643120, 2643131, 2643072, 2643011, 2643093, 2643172, 2642947, 1006197, 4369982, 1004629, 1004642, 1004649, 1004623, 1004634, 1004698, 1004650, 1005938, 7940754, 5963673, 6528791, 2383720, 2114733, 2388914, 2388954, 2388910, 5276982, 5276936, 10708694, 5277182, 12141117, 2315832, 2505815, 2234642, 5184341, 2299122, 4362829, 4363108, 4363120, 9487869, 4362898, 2299100, 4362872, 4362895, 4275372, 4275413, 4376592, 9501293, 4275413, 3193042, 8054640, 3193040, 4275399, 2394320, 2385390, 2385336, 2385342, 2385353, 2385345, 2396591, 4315713, 2306710, 4372055, 8067099, 4372070, 2387155, 2387143, 2387157, 2406374, 5270682, 4647366, 2225629, 4307421, 4307415, 2225631, 2225632, 2397527, 4314683, 8439213, 2336774, 2400863, 2406485, 2226639, 2306165, 4584916, 5211121, 5279755, 5279751, 5279753, 5279795, 3195749, 1006372, 5855356, 6065820, 4360023, 2375934, 5185418, 10894642, 2399295, 2399258, 3195298, 2115620, 8383011, 5724275, 2329622, 6524257, 10185207, 9941550, 2213484, 2213524, 2564494, 2375097, 2267186, 5272690, 4375452, 10058837, 2330170, 2330172, 4329474, 8081031, 7734180, 7734180, 4372695, 5717425, 6465506, 5197206, 4609086, 11553363, 5186036, 5186058, 6132425, 7348337, 7812596, 5272096, 5839323, 5272185, 5278525, 5278375, 4382675, 3197970, 6489949, 1007739, 10055245, 8045637, 5728241, 5728171, 2291865, 5189032, 8190231, 8140432, 5794018, 2266009, 2351174, 5200463, 10826904, 4309237, 7893775, 2110709, 3201736, 5185697, 5279459, 3198873, 3198882, 6539249, 5962076, 6518477, 2395367, 5421557, 6524775, 2264581, 7844959, 4408321, 2286073, 7394977, 8016550, 2286079, 5362054, 2264633, 2392500, 5192789, 5192786, 4360387, 4288621, 7680807, 2228958, 7811641, 8373396, 6498827, 2225637, 5209043, 2656674, 7563173, 5730513, 2376212, 2114911, 6456766, 7849018, 5793674, 4520506, 2589233, 7767532, 6537484, 2292317, 2406520, 8308248, 5962255, 5899940, 4362606, 7814219, 2216329, 8052076, 5727801, 5176737, 2210279, 2409598, 2399985, 2715443, 4286975, 2227465, 2659108, 2659095, 7682935, 2391050, 4320356, 4320346, 4595289, 9490826, 4359824, 2392664, 2643248, 2643247, 5200151, 2242928, 3193390, 10656713, 5721108, 2257920, 4283395, 10609794, 2220424, 2220434, 7993897, 5423588, 8018048, 5423480, 2329732, 2329725, 7707408, 4315703, 4315705, 3194973, 7957037, 8099027, 3205241, 8208307, 7829478, 8175358, 4268107, 7708032, 4357872, 4357847, 2116689, 2323543, 2323552, 5186291, 5210979, 5209950, 2657801, 2321463, 2321466, 4810589, 2374804, 2321098, 2321094, 2331256, 2331276, 2331267, 4372949, 2324127, 5730193, 5198034, 4372861, 6489837, 2287072, 4371623, 4984515, 2412966, 5186319, 2227670, 2227665, 2330739, 2330731, 2265658, 8298912, 5711881, 1006399, 5423038, 5973976, 2216045, 2335806, 4984866, 4374760, 2717522, 7701320, 7705954, 5724665, 6520752, 5192089, 5724656, 9150366, 5166723, 5727962, 2112133, 4589737, 8485639, 2215190, 4312751, 2215201, 2388519, 2388152, 2388133, 2388167, 2388213, 2388344, 2388220, 2388193, 8218126, 6494071, 2396355, 2396338, 6126011, 4359698, 4363935, 4363957, 8000329, 2310995, 5863367, 2225776, 9666160, 4316681, 5729088, 2578507, 1007545, 3193505, 8365316, 2413189, 2114345, 7581174, 2267679, 2267687, 2328792, 2328758, 2278811, 4375326, 2266151, 2266125, 2266154, 2266145, 4612921, 5198176, 2503215, 2501171, 10444424, 4377555, 2227699, 2114326, 6467132, 2114314, 2114320, 2317583, 1030608, 2310374, 2112052, 6496518, 8375830, 7806299, 12191284, 7531092, 7915855, 5716488, 9492550, 10638056, 5194517, 5815526, 5194448, 11088660, 2110687, 2323776, 8278823, 2377668, 4360288, 1008955, 2306992, 3194429, 2327735, 2301884, 5200938, 5200931, 5862473, 2115753, 6518477, 3196454, 3196387, 3196437, 3196369, 9818238, 5729175, 5712056, 6505054, 10951687, 6525332, 2665285, 11154347, 2219863, 2377493, 2662697, 2662823, 5189289, 7856998, 5423960, 11207244, 7403107, 5724049, 5972481, 2418919, 3526577, 5195516, 5195549, 2316511, 4373140, 8236575, 8918476, 2378717, 5208832, 2376538, 8187685, 2376555, 4360294, 2316488, 6519803, 6519721, 9265672, 5974552, 2266754, 2654009, 6525360, 5278866, 2665567, 5278813, 5278964, 2219152, 2219149, 4382861, 4375639, 5729905, 4375643, 5729926, 2658866, 2658889, 2657564, 9799014, 7387168, 8106934, 7731329, 7591949, 7484805, 7380778, 2404380, 2404006, 5233577, 5740305, 5233598, 5721680, 8161087, 8091601, 5165975, 4360013, 2480445, 5182251, 5182309, 5182166, 5182391, 5182166, 5182391, 5182309, 2264670, 2264668, 2564481, 2643288, 5971009, 5971015, 4357756, 2293076, 6485909, 2269539, 2266640, 6126571, 5329611, 5329631, 3448184, 3196171, 6463086, 10246866, 10906181, 6126571, 5425554, 8214983, 10069599, 8059430, 4358638, 5187692, 2225772, 4382841, 10759843, 2220312, 2368968, 2385730, 2385717, 5970627, 5200658, 2413065, 2659356, 2309075, 2312372, 4335587, 7977105, 4335486, 7930726, 6180433, 2228598, 4366460, 7681743, 2665384, 2665391, 3202412, 5215903, 9775198, 5201057, 5201040, 5201037, 1005471, 1005479, 7637257, 10559499, 5211464, 5211460, 5211452, 5204778, 5970107, 5972004, 2226742, 2318291, 2328332, 2328320, 2328293, 8400812, 2328291, 2328346, 8303052, 2328407, 9940244, 4583076, 2250096, 4373393, 7783760, 2312404, 2395702, 2395696, 2668382, 2668348, 2668380, 2668329, 2661596, 2368900, 4360080, 4589994, 2211599, 2113644, 5177825, 7655863, 7718500, 4358943, 2315035, 2219248, 6532438, 4374562, 2285356, 2325694, 2395240, 4285896, 4382698, 5177112, 2219218, 5178282, 2397204, 2397095, 1007790, 10797180, 2264731, 2668059, 8232388, 7599137, 5185840, 9088686, 2375696, 2375697, 6480081, 5166362, 5166368, 5720174, 5166370, 3202673, 2775410, 2408093, 5199488, 4373562, 2407748, 4284320, 2407758, 2407741, 2407780, 10906181, 2320761, 7009279, 2329019, 2329013, 2392025, 4370923, 11154347, 5972288, 2661081, 2660959, 2660969, 2661140, 4375969, 7627628, 7611482, 2317981, 2318138, 5211426, 4374637, 3193833, 5198234, 2316238, 2316227, 2316240, 2411424, 7608251, 2314184, 7429036, 5716546, 5716545, 6466809, 3202466, 7639231, 7596218, 4359131, 8144362, 2226734, 8121830, 2305479, 5175631, 4343694, 4343685, 4343698, 2308541, 2308557, 5175936, 1010610, 2317532, 6531731, 8241374, 2392647, 5276411, 2301117, 2301066, 8116657, 2400787, 10185207, 2663583, 2663587, 2659725, 5185859, 7845304, 8041561, 8952606, 5420992, 2270624, 2565841, 6453753, 2322820, 2322975, 2323066, 2322929, 2385069, 2384777, 2385090, 2384986, 2384948, 2384899, 5198157, 6455608, 2226404, 7808450, 2266916, 4371482, 4371493, 2266741, 9493483, 7820753, 4374719, 2329451, 3060710, 2321011, 2321010, 2321012, 5727495, 4859796, 7495282, 2322248, 9271069, 4382171, 5799065, 5166440, 4378628, 5166489, 5166487, 1336005, 1335213, 9238897, 10864058, 9738520, 11453075, 10433923, 4360148, 2215949, 7403639, 2226687, 2287668, 2212511, 2114953, 5854375, 4334937, 2213325, 2223595, 2223757, 2223754, 2223738, 2319527, 4363162, 4375150, 5723353, 5200684, 5200696, 8767949, 7475427, 2415777, 2399874, 8412232, 1009018, 1009044, 7428590, 1009026, 4312554, 2111273, 8245330, 7399878, 2265089, 2376481, 2285868, 7526780, 3192976, 2368319, 2116649, 4328522, 5728015, 2267658, 4373871, 2501248, 4593370, 7756875, 2265573, 2331573, 2331602, 12201174, 9583544, 2217353, 2217349, 5211115, 2657028, 5208715, 8459439, 2394612, 4364048, 1009853, 2286388, 2404322, 2405369, 5795619, 6531872, 6531912, 7791733, 2242200, 2242011, 2242200, 2389030, 2389021, 4324852, 4382701, 3198195, 2309526, 2309500, 5423180, 2357064, 2110813, 2287076, 5189109, 8288896, 2285681, 2076237, 2320012, 2320028, 2316212, 10847326, 2863943, 9666160, 5725840, 4368254, 8188564, 8282687, 5196692, 5196625, 5196660, 2664926, 2379964, 2266561, 7480649, 2114962, 2327326, 4811221, 6452738, 2379089, 8291154, 5273006, 2220417, 2220404, 2220407, 5204751, 2318164, 12213328, 2509612, 2316942, 4368600, 5196434, 5196151, 5196384, 5728468, 4310270, 2215522, 7635093, 6126908, 2662093, 8315657, 7677769, 7445127, 7652521, 9138660, 4324115, 4324118, 7734348, 6466453, 2300285, 2318080, 7930958, 5731493, 2328734, 5193449, 5189093, 5721963, 4315742, 4373115, 2508901, 4601972, 5422283, 10478115, 2289535, 3193658, 4316608, 12220649, 2400921, 5197940, 6456325, 5166638, 5166646, 5166649, 9605446, 2266806, 2396119, 5165807, 5204034, 5822530, 2276189, 2276151, 2395284, 2275475, 2321919, 2321945, 2392240, 5620016, 5384113, 3952236, 2372396, 4285694, 2382797, 7815263, 4359026, 10822612, 4283983, 7193045, 5213766, 4373348, 4373340, 4373349, 2286060, 2286063, 4373341, 5855429, 3206034, 7547545, 2260059, 7923023, 7968857, 4359720, 7530747, 7838638, 2258604, 6180498, 6180498, 2225810, 2658925, 1007512, 3200167, 3200195, 3200174, 5210935, 2224197, 4312055, 2224979, 2225032, 2224970, 2225259, 6452870, 5823941, 4360697, 8082159, 2397682, 9162577, 2222364, 2227715, 2221643, 2221637, 2335818, 2395769, 2395735, 2395792, 2114243, 2114246, 2379534, 2220092, 4333281, 2206602, 2265174, 5176612, 2314107, 2237923, 2408881, 2224359, 2113311, 2220149, 2220142, 2220146, 2220136, 2308113, 2208629, 8411851, 8121376, 8168502, 6487309, 1006705, 8796256, 1006752, 1006800, 1006698, 6536517, 8385517, 8022560, 2368598, 10755561, 9553526, 2396749, 2114232, 4333315, 4333313, 4369961, 2285980, 8234981, 6788466, 9237565, 5208652, 2374391, 2223840, 4309319, 2223429, 2223441, 2223715, 4645934, 2223416, 2223844, 2234729, 5185730, 2225783, 9802456, 8270004, 8108244, 9783517, 9783517, 4811835, 2316069, 2316143, 9799014, 8866712, 7962277, 5729682, 5200488, 3197869, 6524162, 2287615, 2395422, 8216761, 2330609, 2330558, 2509438, 2509985, 9302212, 4360357, 4599826, 2481104, 7992320, 7827743, 5186396, 4314548, 4382367, 2504515, 5194994, 2264530, 5279303, 5199488, 11012692, 4377564, 4644973, 2227605, 4377549, 2227612, 2227619, 4374765, 4374764, 2285337, 2387109, 2311570, 2324609, 7957916, 2225791, 5725590, 7450084, 7821815, 4373387, 2394312, 5201390, 5177754, 2306037, 6454095, 4359278, 8041570, 4373289, 5278569, 4359778, 4596949, 7965247, 2309037, 2482062, 4340092, 2409120, 2332062, 2291759, 2291791, 2324677, 5200501, 5200503, 5197689, 5197715, 5197747, 5197741, 5197698, 2656507, 2320257, 5277654, 5277906, 12194263, 5277734, 5277838, 5277987, 6452846, 2396426, 2396444, 2396447, 2382461, 2382872, 2379294, 2379274, 2379295, 2327975, 2114214, 4315140, 6457426, 8200040, 6452163, 5275705, 5863622, 2328810, 2288926, 5192470, 2308604, 2308608, 4307880, 1009633, 2375011, 2375041, 2320671, 2320641, 2320707, 2320696, 2320659, 2320617, 2320664, 2321218, 2111904, 2227300, 2309924, 8294166, 4310281, 7768737, 3207735, 7549700, 7432991, 8816835, 2310982, 2251051, 2379243, 2319999, 11780015, 5187269, 8770976, 2387652, 8337656, 8318878, 4377087, 4345755, 4859874, 2114921, 2207127, 10432842, 6525922, 5824749, 5729850, 2214308, 4333877, 4343706, 4343705, 2114769, 4331816, 8214983, 7417219, 8271018, 7565656, 7998132, 4358028, 2110604, 2315466, 2320993, 2329268, 6507885, 3194102, 2639461, 7348462, 2383590, 8363171, 2285332, 2285333, 2334433, 2419426, 10970216, 2688129, 6452299, 6461590, 3199244, 4355930, 4267682, 7416940, 7510386, 5192056, 5724272, 7361172, 7548918, 2226702, 9102142, 8240018, 4359506, 2331841, 2331816, 7732079, 7445427, 7420601, 2391729, 2426760, 5188971, 4363583, 2374317, 2265079, 1009964, 4359529, 2392343, 5177750, 2407230, 4362907, 4362900, 2227663, 7525773, 5421948, 5421984, 2668465, 5200456, 2663288, 6459496, 2264597, 2403428, 1005022, 2223453, 10319298, 4361753, 4361747, 4361729, 2113405, 4372687, 4372686, 10822519, 5824863, 2328603, 5199282, 5422368, 2286098, 4595317, 5175681, 7353993, 2382172, 2668224, 5279582, 5279581, 2412864, 2412787, 3197314, 2356802, 2226385, 2392628, 7391117, 4417705, 5962529, 8456531, 2401167, 2395157, 2393577, 2394736, 2215008, 2322021, 1010024, 1010071, 1005099, 7794651, 2400222, 6453133, 4359808, 2321199, 2321152, 5185790, 2374255, 6487294, 2110914, 9338680, 1005581, 2221687, 5422829, 5201244, 2335435, 2335355, 2390703, 9465468, 2290846, 12186722, 8920970, 9450610, 7478591, 7635722, 7863555, 6461663, 5961709, 4282894, 11063985, 4309282, 2316670, 2316672, 2390180, 2390191, 2390262, 2390185, 2390240, 8273706, 8035002, 2378247, 8052612, 4615178, 3205259, 8120660, 8227928, 5724455, 5715613, 4307471, 8367903, 4369932, 1006917, 1006667, 2929230, 2223384, 5389058, 5279603, 5279613, 7630125, 7869399, 2335798, 2440506, 2393905, 9478836, 2392508, 3200474, 2657353, 5185718, 5798767, 5176589, 3199115, 2227651, 2394252, 2394248, 2394230, 2394271, 7190107, 5199674, 8076371, 8372190, 8294562, 8176520, 5199417, 5729643, 5729648, 6452772, 2412987, 1048487, 2398885, 4315595, 2216565, 2216566, 5213449, 8059383, 4377904, 9517779, 9280149, 10673702, 9514986, 9471950, 2414203, 2414187, 4357948, 2264558, 2304357, 2325283, 2321343, 2321339, 1189705, 2331936, 2331942, 2331954, 6785145, 3200580, 2251202, 2115567, 2264808, 11464313, 2308987, 5194732, 5194608, 5194622, 5194707, 5194682, 5194683, 8357929, 2661325, 10970216, 2332243, 2332244, 2332248, 5201174, 4341995, 2386659, 8056718, 2204831, 2204782, 4359300, 3201873, 4358768, 4358765, 4358769, 2110423, 7400978, 1450317, 2292354, 2374521, 2374540, 2374535, 2325189, 4369880, 4587510, 1373130, 8177904, 8428059, 7908241, 5842764, 2269532, 2408161, 2225584, 5974364, 4307290, 1005386, 3193450, 3193507, 3193498, 9355965, 3193569, 2324159, 2325276, 5189038, 6104442, 5185846, 8070994, 2324091, 7737338, 4372832, 7888344, 7745704, 2306080, 2300444, 5215548, 2407271, 5210485, 2223511, 7718373, 4596691, 5729439, 4357214, 8272265, 4985072, 2265163, 4322157, 4322159, 9483153, 4322154, 4322178, 2376464, 2376462, 2329923, 7644219, 8243780, 8032382, 2408252, 7921839, 8158209, 8492140, 8608139, 6492467, 9512405, 5192721, 2375465, 2259549, 2259547, 2308668, 2308676, 5185603, 4358546, 7812829, 5724358, 2407916, 2369226, 4286150, 3199159, 5273420, 5273393, 5273451, 5273309, 5273336, 7716234, 5422556, 7760426, 2396768, 2396797, 4310260, 4324572, 2639786, 2304415, 7724268, 2501277, 2378753, 5229142, 2377215, 4609349, 7913434, 2389100, 5423840, 9299496, 4086523, 12194263, 5727231, 3222442, 3222430, 4361452, 1005671, 1005675, 7855364, 2653705, 5277463, 2227723, 9769667, 5188827, 2223881, 2660290, 2285504, 6505995, 6506000, 7923205, 4368896, 2379869, 2379882, 2376059, 5178850, 3193675, 4373710, 5277294, 2114446, 7812075, 2267509, 2306982, 3205121, 7705294, 3205098, 5725191, 7660502, 4805564, 6467647, 7374940, 2269521, 5212973, 2657432, 2657657, 2657651, 5191262, 5191257, 2661768, 4313341, 2411944, 10513850, 4366603, 2268682, 2321001, 4354941, 5200757, 4984851, 7665662, 7668385, 8428595, 4330389, 9281072, 2114731, 5855054, 2882404, 4275438, 2324001, 2246541, 2663437, 4356092, 3198548, 2330198, 8357953, 2653941, 8390568, 2318655, 5181275, 4322512, 11916008, 5422862, 4327704, 4355900, 6518773, 5423348, 2257924, 3208017, 2644845, 2329727, 5213374, 5200414, 6785175, 2330725, 3199521, 1005709, 2317572, 2267976, 3196387, 4416986, 5278659, 2657615, 8301674, 7835170, 7858348, 7834238, 7820300, 7982246, 10933479, 3198401, 2317552, 2110505, 2112881, 3194420, 2328201, 2328302, 2328383, 3202307, 2219222, 5424504, 7454879, 2651922, 2645393, 2381337, 3205951, 4359130, 8067701, 2323495, 2288831, 2688081, 10344972, 2288752, 5233166, 3198332, 2331498, 4314702, 4358938, 4358939, 2110839, 7498818, 4374605, 2110811, 9736038, 8024245, 8071102, 4371597, 4328220, 2266348, 5184825, 10419462, 4285689, 2327457, 2321419, 7458066, 5200487, 5200484, 9150298, 1010300, 5199470, 4377566, 8304706, 6480320, 7371308, 2218560, 10815835, 5197686, 4343463, 8381259, 2308605, 5421938, 2385608, 8368630, 8240249, 5824752, 2288859, 2660290, 3199757, 7456173, 12238937, 7929792, 7713874, 2265824, 11464313, 3457717, 7528087, 1010034, 8082735, 2228667, 3193373, 3207190, 5279276, 2114888, 4333653, 4333649, 9795553, 4362384, 2310244, 4344045, 6519254, 2288844, 2288847, 1005379, 2291814, 2115556, 7698949, 7514768, 2308528, 2581885, 7378644, 4985433, 7856206, 8155634, 1005677, 5716906, 2573153, 2264928, 5193729, 4333206, 8219929, 2245357, 10973055, 5212956, 5188922, 2266574, 5186124, 2110920, 2318168, 1004661, 5276850, 7831843, 2413687, 2248916, 2323843, 12170878, 2114928, 2265741, 2265733, 1007520, 2317969, 4595288, 2433462, 2264726, 10055245, 2247633, 6532018, 6532018, 2434806, 10616299, 1005277, 2318296, 2238692, 5722023, 6480226, 5166371, 2267855, 8374394, 8178234, 2314157, 2239724, 2325250, 5165917, 5198172, 2318054, 5724966, 7189273, 2320039, 8226612, 2317620, 2266483, 2114241, 2117982, 5197736, 2375043, 2322087, 2322091, 2334438, 6525142, 4984629, 2113397, 5166315, 2300732, 9140340, 2322852, 5199627, 2316677, 2390192, 7547256, 5959034, 5729633, 5194562, 5194583, 5194599, 2316765, 8019265, 2324085, 6490371, 7855956, 6496637, 4363251, 7554266)
AND speciesKey IS NOT NULL
AND GBIF_Within('POLYGON ((-14.31175 30.26388, 68.13666 30.26388, 68.13666 82.96604, -14.31175 82.96604, -14.31175 30.26388))
', decimalLatitude, decimalLongitude) = TRUE
AND "year" >= 1950
AND "year" IS NOT NULL
AND hasCoordinate = TRUE
AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'ZERO_COORDINATE', TRUE)
AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COORDINATE_OUT_OF_RANGE', TRUE)
AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COORDINATE_INVALID', TRUE)
AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH', TRUE)
AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'TAXON_MATCH_FUZZY', TRUE)
AND (
LOWER(identificationVerificationStatus) NOT IN (
'unverified',
'unvalidated',
'not validated',
'under validation',
'not able to validate',
'control could not be conclusive due to insufficient knowledge',
'uncertain',
'unconfirmed',
'unconfirmed - not reviewed',
'validation requested'
)
OR identificationVerificationStatus IS NULL
)
GROUP BY
"year",
eeaCellCode,
speciesKey,
species,
classKey,
class
ORDER BY
"year" DESC,
eeaCellCode ASC,
speciesKey ASC;

The dataset's 994912 records were derived from 5002 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023343-260507073636908/datasets/export for details.

Data from some individual datasets included in this download may be licensed under less restrictive terms.