DOI: 10.15468/dl.d9a8ms
title: Occurrence Download

description: A dataset containing 3202007 records in GBIF matching the query:
SELECT PRINTF('%04d-%02d', "year", "month") AS yearMonth, 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 (1538450, 1538431, 4516795, 9879794, 1536559, 5071104, 5071107, 5071133, 1534393, 1534412, 1534411, 1534420, 1534402, 1534371, 1534410, 1534397, 7696939, 1534374, 1534418, 1534395, 1534384, 1534408, 1534396, 1534368, 1534372, 7492614, 1534421, 1534375, 1536399, 1536381, 1536381, 1533005, 5070396, 5070404, 5070411, 5070391, 7438402, 5070407, 1539631, 8929893, 1539719, 4516831, 1533661, 4516833, 1533656, 1533710, 1533732, 1533607, 1533602, 1533639, 1533805, 1533796, 1539969, 1539863, 1540616, 1540020, 4516695, 1540195, 1533120, 1540583, 4516687, 1540488, 1540615, 1540272, 8976836, 1540549, 1540618, 1540517, 1540445, 1539977, 1540401, 4516682, 10889649, 1540362, 1540334, 1540317, 1539956, 1540589, 1540240, 1540502, 1540189, 1540176, 1540113, 1540099, 1540082, 8032552, 1540067, 1540046, 1540028, 1539953, 1540611, 1540259, 1539895, 1539876, 1539854, 1540122, 1540459, 1540362, 1539842, 1540669, 1540302, 1540633, 1540491, 1540135, 1540574, 1540095, 1540122, 1540592, 1540541, 4516701, 1540509, 1540561, 1540076, 1540480, 1540464, 1540513, 1540440, 1540390, 7435418, 1540356, 1540325, 1540308, 1540493, 1540231, 1540212, 1539878, 1540167, 1540138, 1540120, 1540235, 1540006, 1540021, 1540005, 1539961, 1539937, 1539924, 1539907, 1539866, 1540608, 1540597, 1540581, 1540590, 11788810, 1539867, 1540639, 1540533, 1540146, 1540433, 1540374, 4516681, 1540296, 1540379, 1540544, 1539900, 1540064, 1540101, 1540240, 1540086, 1540650, 1540047, 1540012, 1539991, 1539931, 1540580, 1539896, 1536708, 1536758, 1536766, 1536708, 1536752, 1536732, 1536716, 1536725, 4516823, 1535878, 1535990, 1535950, 1535931, 1535954, 4516839, 1535948, 1536030, 1535999, 1535918, 11698239, 1535899, 10561742, 1536004, 1535888, 1536015, 1535909, 1536003, 9393713, 1544120, 5071001, 5071031, 5070983, 5071002, 1536332, 1542111, 1542053, 1542133, 1542118, 1542093, 1542044, 10656114, 1542056, 1542087, 1542077, 1542118, 1542069, 1542093, 1542030, 1542027, 1542026, 1544509, 1544513, 5766578, 5766585, 5766581, 5766577, 5766584, 5071071, 5766576, 5766583, 5766579, 5766586, 5071051, 5071090, 4516846, 1536449, 1543332, 1542830, 1542770, 1542852, 1542714, 1540351, 1541192, 1541146, 1541325, 1541320, 1541238, 1540231, 1541262, 1541245, 6098383, 1541171, 1541140, 1541116, 1541339, 1541301, 1541339, 1541116, 1541285, 1541217, 5070833, 1534757, 11818124, 1534484, 8078114, 10388837, 10814768, 10876171, 1534667, 1534652, 1534534, 10881840, 11491727, 1534477, 1534739, 1534767, 1534760, 1534500, 10773424, 11723957, 1534696, 1534619, 1534600, 1534588, 1534603, 7198254, 10455650, 10060084, 1534700, 1534821, 5070855, 1534796, 11801529, 11586430, 1534497, 1534825, 1534816, 1534640, 9630362, 5070654, 1534491, 11607217, 1534708, 1534562, 1534790, 1534505, 1534770, 1534751, 1534740, 10694647, 1534486, 11954788, 1534723, 1534600, 1534697, 1534683, 1534755, 9332756, 1534581, 1534665, 1534643, 1534722, 1534578, 1534589, 1534545, 1534515, 5070720, 1534478, 1534533, 1534492, 10227794, 9900769, 1534613, 5070756, 1534490, 1534812, 5070691, 1540882, 1540700, 1540742, 1540855, 1540710, 1540889, 1540680, 1540896, 1540885, 1540691, 1540816, 1540706, 1540875, 1540740, 1540726, 1540836, 10957152, 1540820, 1540698, 1540795, 1540875, 1542971, 1542979, 5072147, 1542961, 4516884, 1534401, 5071373, 5071337, 5071329, 5071362, 5071368, 5071323, 5071352, 5071382, 1535169, 1535185, 1537188, 1534465, 1537090, 11186423, 8183385, 1537380, 1537389, 1538420, 1535235, 1535245, 5071167, 5071161, 10966087, 5071172, 1541364, 1541422, 1541455, 1541412, 1541483, 1541431, 1541391, 5070993, 1536664, 1536654, 1536598, 1536643, 1536631, 1536607, 1536675, 1536697, 1536623, 1536689, 1536635, 1536728, 11526439, 1536727, 1536711, 1536722, 1537378, 1536740, 1536750, 8776450, 8643050, 5766557, 5766556, 5070293, 4516815, 1535529, 1535521, 1544156, 1544182, 9305994, 1544270, 1544144, 1544241, 1544360, 11198897, 1544324, 7198274, 11680646, 1544262, 1544292, 1544218, 10455195, 11808667, 1544270, 1544230, 1544300, 1544230, 9251579, 1544263, 1544198, 1544330, 1544214, 11131637, 1544199, 1544190, 11826495, 1544168, 1544369, 1544162, 11786347, 8966290, 8339609, 1544265, 1544181, 4516719, 1544311, 1544323, 1544287, 1544340, 1544312, 11691979, 1544155, 10692337, 1544285, 1544299, 1544270, 1544280, 1544253, 7715775, 1544287, 1544242, 1544387, 11142168, 11835614, 1544185, 11716761, 11152386, 1544391, 1544179, 11174116, 1544160, 11757080, 11444840, 11169623, 10835908, 8840090, 1544190, 1544230, 1544185, 10867829, 10864557, 10151884, 8462513, 1544233, 9344600, 11527899, 1544384, 11811058, 10768930, 11927211, 1544326, 5886291, 10879059, 11564099, 1544327, 1544145, 10826416, 1544386, 11124930, 1544352, 8532226, 9617900, 11207522, 1544296, 1544283, 1544298, 7986894, 1544369, 5886294, 1544369, 1544302, 11902552, 1544259, 1544351, 1544192, 1544175, 1544366, 1544367, 11622490, 11026084, 1544248, 1544274, 1544201, 9559371, 11844457, 1539042, 9153200, 1542409, 9412801, 1542480, 1542226, 1542591, 5979478, 11430972, 5979474, 4516754, 4516752, 1533920, 1533889, 1533888, 1533922, 1533938, 1533887, 4516779, 1536829, 1536834, 1536812, 1536827, 1536817, 1536794, 1536796, 1536778, 1536804, 1536785, 8107056, 9708194, 9743649, 7789394, 8147305, 9759352, 8223744, 11904024, 1537556, 1537538, 1537514, 1537494, 1537459, 1537518, 1537547, 1537479, 1537501, 1537456, 1537521, 1537484, 1537478, 1537490, 1537511, 1539818, 1535849, 1535745, 1535858, 1535770, 1535710, 1535800, 1535821, 1535733, 1535700, 1535774, 1535828, 1535764, 1535846, 1535781, 1535848, 1535772, 1535723, 1535738, 1535866, 1535731, 1535728, 1535841, 1535807, 1535832, 1535794, 1535710, 10734293, 1535751, 1535835, 1533046, 1533055, 1540730, 1533062, 1533073, 1533068, 1533080, 1533040, 1533017, 1533023, 1539281, 1539300, 1539293, 1539269, 1537581, 11459644, 11760400, 12135320, 1537597, 4516741, 4516740, 1537582, 11120721, 11221304, 11189713, 11184283, 1536304, 1536318, 1536308, 1536270, 1536318, 11164664, 1536370, 1536312, 1536360, 1536342, 1536300, 1536289, 1532931, 1532963, 1532966, 1532920, 1532949, 1532966, 1532959, 1532950, 1532924, 1532927, 1532953, 1532923, 1532925, 9799303, 1532956, 1532992, 1532971, 1532968, 1532982, 1532941, 1532976, 1532935, 1543108, 1543275, 4516769, 1543224, 1543250, 1543227, 1543069, 1543207, 1543205, 1543177, 1543094, 1543159, 1543138, 1543153, 1543183, 4516759, 1543134, 4516756, 1543317, 1543170, 1543011, 1543189, 1543036, 1542997, 1543130, 1543300, 4516768, 1543233, 1543090, 1543210, 1543218, 1543066, 1543319, 1543197, 1543249, 1543175, 1543088, 1543246, 1543247, 1543208, 1543089, 1543151, 1543075, 1543031, 1543292, 1543239, 4516757, 1543020, 1543125, 1543099, 1543161, 1543091, 1543029, 1543096, 1543080, 1543060, 1543076, 1543211, 1543106, 1543017, 11193766, 1543194, 1543025, 1544338, 1544267, 1533100, 1536592, 1539515, 5071240, 1539322, 11212967, 10714052, 1534984, 1534988, 9521407, 1534972, 1534966, 5886305, 4294542, 1537436, 1537412, 8170685, 1537578, 1537464, 1537564, 1537559, 1537535, 5070283, 1537703, 1537709, 1537700, 1537719, 1537717, 1538817, 1538843, 1538796, 1538810, 1538793, 1538831, 1538836, 1538798, 1538824, 1538840, 1533142, 1539150, 1539218, 1539189, 1539131, 1539129, 1539215, 1539144, 1539165, 1539225, 1536614, 1539130, 1539145, 1539188, 1539152, 1539234, 1539177, 1539159, 1539123, 1539192, 1539250, 1535579, 1535610, 1535561, 1535644, 1535656, 1535624, 1535607, 1535586, 1535655, 1535666, 1535634, 1535600, 1535565, 1535664, 1535651, 8737170, 8896994, 4516734, 4516732, 1538753, 1538739, 1538772, 1538734, 1538749, 1538756, 1538764, 1544486, 1544431, 1544446, 1534878, 1537252, 1537291, 1537233, 1537300, 1537313, 1537266, 1537259, 1537248, 1537245, 1537212, 5071408, 1538880, 1538889, 5071419, 1538873, 8108323, 1538870, 1538647, 1538678, 1538667, 5072218, 5072223, 1542199, 1542175, 1541763, 1541762, 1541740, 1541819, 1541799, 1541832, 1538973, 1538942, 1538946, 10878032, 1541688, 1541616, 1541629, 4516845, 1541625, 1541562, 1541600, 1541654, 1541612, 1541596, 1541545, 1357747, 1357730, 1357714, 1357283, 1357645, 1358299, 1358064, 1357331, 1357691, 1356889, 1357907, 1358376, 1356870, 1357426, 1358243, 1356996, 1357170, 1357157, 1357285, 1357299, 1357344, 9911520, 1357429, 1357444, 1357490, 1358360, 1357581, 11463831, 1357628, 1357642, 1357709, 1357822, 1357848, 1357876, 1357890, 1358027, 1357951, 1357966, 1357992, 1357871, 10858028, 1358155, 1358165, 1357628, 1358248, 1358296, 11211035, 1357532, 1356887, 1356918, 1356964, 1357005, 1357378, 1357053, 1357067, 1357112, 1357135, 1357209, 1357239, 1357673, 1357708, 1357775, 1357806, 1356873, 1357889, 1358396, 1356917, 1356948, 1357004, 1357096, 1358167, 1358209, 1358259, 1357319, 1358088, 1357484, 1358120, 1357338, 1357759, 1357128, 1357215, 1358261, 1357817, 1358023, 1358177, 1357700, 1356884, 1358134, 9818799, 1357880, 12197249, 1356945, 1358258, 1357632, 1357675, 1357906, 9657828, 1356887, 1358254, 1357072, 1357171, 1357219, 1357234, 1357249, 1357280, 1357294, 1357352, 1358088, 1357379, 1356936, 1357524, 1357548, 1357565, 1357668, 1357703, 1357737, 1357787, 1357858, 1357872, 9738964, 1357884, 1357901, 9786142, 1358014, 1358028, 1358043, 1358380, 1358166, 1358208, 1357540, 1358391, 1356869, 1357476, 1356959, 1358259, 1356971, 1357035, 1357315, 1357107, 1357127, 1357158, 1357184, 9328031, 1357156, 1357290, 1357334, 1357061, 1357362, 1357406, 10765924, 1357434, 11178877, 1357493, 1357520, 1357543, 1358345, 1357602, 1357618, 9805254, 1357646, 1357663, 1357495, 1357732, 1357750, 1358181, 1357782, 1357812, 1357824, 1357838, 1357939, 1357971, 1358024, 12256156, 1358113, 1358144, 1358191, 1357684, 1357636, 1358314, 10703062, 1358357, 1356864, 1356892, 1356981, 1357364, 10886029, 1357073, 1357102, 1357140, 1357179, 1357194, 1357279, 1357424, 1357463, 1357477, 1356872, 1357542, 1357557, 1357573, 1357585, 1357601, 1357617, 1357662, 1358228, 1357766, 1357796, 1357894, 1357970, 12182652, 12232215, 11212271, 1357741, 1357382, 1357371, 1357312, 1357222, 1357207, 1357192, 1357100, 1357084, 1357070, 1357056, 4496442, 1357044, 1357026, 1356935, 1356887, 1358383, 1358354, 1358283, 1358232, 1358218, 11126754, 1358110, 1358095, 1358080, 1358065, 9749369, 1358050, 1358038, 1358020, 1357980, 1357936, 1357779, 1357745, 1357712, 1357678, 1357540, 1357529, 1357461, 1357265, 9717277, 1357417, 1357258, 1357242, 1357181, 1357154, 1357075, 1357013, 1356982, 1356940, 1356909, 1356881, 1358388, 1358344, 1358329, 1358302, 1358237, 1358192, 1358145, 1358115, 1358084, 1358011, 1357997, 1357958, 1357914, 1357855, 1357798, 1357784, 1357734, 1357665, 1357635, 1357721, 1357603, 1357587, 1357560, 1357545, 9511276, 1357495, 1357480, 1357466, 1357421, 10811504, 1357349, 1357319, 1357276, 1357262, 1357737, 1357199, 1357147, 10749530, 9447529, 1357037, 1357018, 1357001, 1356961, 1356930, 12228140, 1358376, 1358376, 1358362, 1358334, 1358293, 1358276, 1358227, 1358211, 1358169, 1358152, 4496407, 1358044, 1358031, 1358016, 1358001, 1357976, 1357203, 12217626, 1357918, 1357886, 1357755, 9934107, 1357721, 1357535, 1357514, 4496409, 1357487, 1358376, 1357456, 1357398, 1357381, 1357872, 1357354, 1357341, 1357043, 1357025, 1357007, 1356951, 1356919, 1358367, 1358353, 1358325, 1358282, 1358231, 1358217, 1358202, 1358174, 1358157, 1358109, 1358094, 9662894, 1358037, 1358019, 1357993, 1357952, 1357877, 1357835, 1357808, 1357793, 1357778, 1357727, 1357659, 1357629, 1357582, 1357554, 1357430, 1357416, 1357402, 1357373, 1357358, 1357286, 1357270, 1357257, 1357950, 1357103, 1357074, 1357059, 1357046, 1357012, 1356955, 1356939, 1358371, 1358270, 1358236, 1358222, 1358083, 1357996, 1357957, 1357895, 1357881, 1357839, 9674506, 1357783, 1357767, 1357751, 1357733, 8221007, 1357479, 1357318, 1357291, 1357261, 1357230, 1357078, 1357050, 1357017, 1356972, 1356944, 1356913, 1358333, 1358320, 1358292, 1358210, 1358103, 1358087, 1358000, 9683851, 1357975, 1357962, 1357930, 1357902, 1357829, 1357802, 1357788, 1357720, 1357704, 1357624, 1357607, 1357534, 1357525, 1357486, 1357439, 1357412, 1357397, 1358297, 1357353, 1357310, 1357295, 1357281, 1357235, 1357220, 1357176, 1357099, 11863371, 1357024, 1356991, 1356976, 1356902, 1356875, 1358128, 1358381, 1355493, 1355519, 1355499, 1355507, 1355827, 12238200, 1355970, 1355966, 1355967, 11084236, 1355964, 1355969, 1358411, 1358406, 1358403, 1358415, 1358409, 1358416, 1355872, 1355858, 1355888, 1355875, 1355862, 1355879, 1355865, 1355848, 1355881, 1355869, 1355874, 1355859, 1355861, 1355863, 1355893, 1355948, 1355949, 1355951, 1355937, 1355953, 1355927, 1355958, 1355929, 1355947, 1355924, 1355936, 1355952, 1355956, 1355798, 1339907, 1339856, 1339861, 1339953, 1339863, 1339875, 1340012, 1340000, 1339840, 1339806, 1339963, 5039503, 5039543, 5039528, 5039507, 5039521, 5039526, 5039538, 5039519, 5039552, 5039508, 5039554, 5039527, 5039539, 5039529, 5040757, 5040754, 5040758, 5040755, 1341589, 1341592, 1341588, 1341591, 1341590, 1344360, 1344352, 1344334, 5040304, 1344229, 5040265, 5040460, 1344443, 1344433, 1344425, 5040397, 1344374, 1344348, 1344282, 1344218, 1344186, 1344164, 5040175, 1344457, 1344449, 5040430, 1344401, 1344380, 1344353, 1344303, 1344293, 1344115, 1344078, 1344366, 1344356, 1344350, 1344341, 1344393, 1344260, 5040294, 1344156, 1344054, 1344373, 1344327, 1344320, 1344294, 5040306, 1344300, 5040399, 1344348, 5040279, 1344203, 1344180, 1344121, 1344087, 1344091, 5040157, 1344258, 1344451, 1344440, 1344430, 1344422, 1344412, 1344393, 1344362, 5040376, 1344337, 1344295, 1344280, 7718337, 1344224, 1344091, 1344143, 1344126, 1344071, 5039601, 5040323, 1344222, 5040178, 1341976, 5039605, 5039602, 5039606, 1340325, 1340531, 1340522, 1340403, 1340434, 1340301, 1340362, 1340537, 1340527, 1340509, 1340477, 1340465, 5870368, 1340407, 1340359, 1340521, 1340484, 1340461, 1340384, 10166429, 1340365, 1340542, 1340523, 1340361, 1340513, 1340424, 1340308, 1340311, 1340301, 1340290, 1340298, 4496017, 1340431, 1340420, 1340389, 1340378, 1340341, 1340297, 1340286, 1340545, 1340506, 1340405, 1340385, 1340327, 1340305, 1340533, 8974167, 1340515, 1340298, 1340394, 1340383, 1340344, 1340335, 1340313, 1340281, 1340500, 1340444, 1340433, 1340422, 1340342, 1340333, 1340503, 1340418, 1340387, 1340358, 9562282, 1340348, 5039866, 5039743, 5040046, 5039954, 5039856, 5039844, 5039777, 5039868, 5039824, 5039759, 5039914, 5040019, 5039874, 5040054, 5039772, 5039974, 5039906, 5040058, 5040045, 5039790, 5039892, 5039818, 5039783, 5039829, 5039792, 5039804, 1340112, 1341850, 1341946, 1341885, 1341876, 1341910, 1341892, 1341883, 1341874, 1341859, 11182008, 1341903, 1341891, 1341933, 1341898, 1341889, 1341879, 1341868, 1341875, 1341940, 1341022, 1340927, 1340987, 1340956, 10747950, 1341011, 1341093, 1342022, 1341089, 1341099, 1340888, 1340961, 1340953, 1340936, 1340913, 1340903, 10293642, 1340898, 1341035, 1341046, 1341015, 1341000, 1340882, 1340905, 1340934, 1340911, 1340877, 1341119, 1341098, 1340992, 1341059, 1341012, 1340988, 10760554, 1340979, 1340957, 1340918, 1340894, 1340884, 1341123, 1341113, 1341103, 1341054, 1341007, 1342021, 1340969, 1340962, 1340954, 1340899, 1340891, 1340881, 1343024, 1341122, 8667690, 1341079, 1341068, 1341049, 1342026, 1341027, 8533375, 1340984, 1340994, 1341088, 1340937, 1340912, 1340902, 1340889, 1341120, 1341100, 9287362, 1341090, 1341077, 1341043, 1341014, 1340942, 1341071, 1340908, 1341114, 1341105, 1342024, 1341040, 1341020, 1340998, 1340976, 1345206, 1345192, 1345196, 1345304, 1345296, 1345353, 1345329, 4495984, 1345312, 1345361, 1345297, 1345354, 1345330, 10680768, 1345299, 1345349, 1345313, 1345362, 1345351, 1345343, 1345327, 1345305, 1345331, 1345319, 1345308, 1345356, 1345350, 4495981, 1345344, 1343901, 1343822, 1343792, 1343718, 1343598, 1343566, 1343551, 1343523, 1343505, 1343400, 1343295, 1343279, 1343988, 1343956, 1343940, 1343892, 1343829, 1343814, 1343798, 1343773, 1343741, 1343728, 1343661, 1343623, 1343573, 1343557, 1343482, 1343436, 1343378, 1343364, 1343331, 1343318, 1343275, 1343231, 1343963, 10734734, 1343950, 1343933, 1343884, 1343852, 1343837, 1343793, 1343766, 1343736, 1343703, 1343686, 1343671, 1343599, 1343584, 1343567, 1343552, 1343524, 1343441, 1343416, 1343401, 1343357, 1343338, 1343309, 1343896, 1343266, 1343239, 1344019, 1344004, 1343989, 1343957, 1343909, 1343893, 1343877, 1343845, 1343831, 1343742, 1343710, 1343694, 1343624, 10801885, 1343606, 1343591, 1343558, 1343512, 12235108, 1343332, 1343302, 1343260, 1343232, 1343964, 1343951, 1343934, 1343920, 1343853, 1343808, 1343782, 1343612, 1343568, 1343476, 9435422, 1343417, 1343402, 1343389, 1343374, 12177610, 1343697, 1343340, 1343311, 1343296, 1343267, 1344020, 1344006, 9523484, 1343878, 1343863, 1343846, 1343832, 1343800, 1343775, 10552103, 8741258, 1343679, 1343663, 1343592, 1343533, 1343514, 1343500, 1343450, 1343410, 1343366, 1343348, 1343333, 1343303, 1343247, 1343233, 1343952, 1343935, 1343921, 1343795, 1343751, 1343704, 9183949, 1343650, 1343526, 1343477) 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 yearMonth, basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, sex, GBIF_EEARGCODE(10000, occurrence.decimallatitude, occurrence.decimallongitude, COALESCE(occurrence.coordinateuncertaintyinmeters, 10000)) ORDER BY yearMonth DESC, countryCode ASC

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