Occurrence Download

A dataset containing 914826 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, 2408186, 5209181, 5209174, 5209188, 5209173, 5209184, 5209252, 4373187, 4333247, 4333235, 2118435, 4287131, 2402129, 2402168, 2402159, 2402122, 2114252, 2663953, 2663971, 8280204, 9238897, 5209531, 2658484, 3199341, 5969672, 4359671, 4359672, 4377664, 2267503, 2267504, 2267500, 1004581, 1004589, 1004580, 1010422, 4372407, 5279568, 5718569, 5718570, 8249226, 7470812, 2656879, 2656914, 2656908, 2337248, 2667162, 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, 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, 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, 4360202, 9558299, 2407378, 3121258, 7579869, 7463403, 8088608, 6486731, 2330592, 2330587, 5200467, 2318324, 3196524, 4382606, 5279840, 5279834, 2510275, 2510310, 7566891, 5187508, 7765831, 2332123, 3193854, 4371524, 2227756, 7999925, 3193079, 6075968, 6075969, 5188832, 5185431, 5185429, 2115769, 2643471, 4379029, 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, 6486710, 4354950, 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, 2264603, 1008558, 2666539, 2666536, 2643120, 2643131, 2643072, 2643011, 2643172, 2642947, 1006197, 4369982, 1004629, 1004642, 1004649, 1004623, 1004634, 1004698, 1004650, 1005938, 7940754, 5963673, 6528791, 2383720, 2114733, 2388914, 2388954, 2388910, 5276982, 5276936, 10708694, 5277182, 2315832, 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, 4372070, 2387155, 2387143, 2387157, 2406374, 5270682, 4647366, 2225629, 4307421, 4307415, 2225631, 2225632, 2397527, 4314683, 8439213, 2336774, 2400863, 2406485, 2226639, 2306165, 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, 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, 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, 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, 4359824, 2392664, 2643248, 2643247, 5200151, 2242928, 10656713, 5721108, 2257920, 4283395, 10609794, 2220424, 2220434, 7993897, 5423588, 8018048, 5423480, 2329732, 2329725, 7707408, 4315703, 4315705, 10696614, 3194973, 7957037, 8099027, 3205241, 8208307, 7829478, 8175358, 4268107, 7708032, 4357872, 4357847, 2116689, 2323543, 2323552, 5186291, 5210979, 5209950, 2657801, 2321463, 2321466, 4810589, 2374804, 2321098, 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, 4316681, 5729088, 2578507, 1007545, 8016745, 3193505, 8365316, 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, 7531092, 7915855, 5716488, 9492550, 10638056, 5194517, 5815526, 5194448, 2110687, 2323776, 8278823, 2377668, 4360288, 1008955, 2306992, 3194429, 2327735, 2301884, 5200938, 5200931, 5862473, 2115753, 3196454, 3196437, 3196369, 9818238, 5729175, 5712056, 6525332, 2665285, 2219863, 2377493, 2662697, 2662823, 5189289, 7856998, 7403107, 5724049, 5972481, 2418919, 3526577, 5195516, 5195549, 2316511, 4373140, 8236575, 8918476, 2378717, 5208832, 2376538, 8187685, 2376555, 4360294, 2316488, 6519803, 6519721, 9265672, 5974552, 2266754, 2654009, 5278866, 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, 2293076, 6485909, 2269539, 2266640, 6126571, 5329611, 5329631, 3448184, 3196171, 6463086, 10246866, 5425554, 10069599, 8059430, 4358638, 5187692, 2225772, 4382841, 10759843, 2220312, 2368968, 2385730, 2385717, 5970627, 5200658, 2413065, 2659356, 2309075, 2312372, 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, 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, 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, 2663583, 2663587, 2659725, 5185859, 7845304, 8041561, 5420992, 2270624, 2565841, 6453753, 2322820, 2322975, 2323066, 2322929, 2385069, 2384777, 2385090, 2384986, 2384948, 2384899, 5198157, 6455608, 2226404, 4377821, 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, 10864058, 9738520, 11453075, 10433923, 4360148, 2215949, 7403639, 2226687, 2287668, 2212511, 2114953, 5854375, 4334937, 2213325, 2223595, 2223757, 2223754, 2223738, 2319527, 4363162, 4375150, 5723353, 520068