DOI: 10.15468/dl.3bautf
title: Occurrence Download

description: A dataset containing 12297101 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 (2426613, 2426609, 2423436, 2426670, 2426672, 2426648, 2426788, 2426793, 2431672, 2431457, 2431454, 2431451, 2432042, 2431827, 2431938, 2431941, 2431829, 2431780, 2457223, 5226767, 2469356, 2468945, 2468672, 7872185, 2468688, 2468673, 7837038, 2468520, 2468503, 2468518, 2468511, 2469141, 5789532, 2468994, 5789530, 2469155, 2469118, 2469122, 5225149, 2444698, 5960896, 9807306, 1356884, 1357192, 1357712, 1357997, 1357767, 1358000, 1357975, 1355966, 5039528, 5039521, 5040757, 5039606, 1340325, 1340522, 1340537, 1340477, 1340407, 1340521, 1340461, 1340384, 1340361, 1340424, 1340311, 1340286, 1340367, 1340327, 10744411, 1340348, 1343782, 1343348, 1343973, 1343291, 1339370, 1348560, 1348979, 1348947, 1348796, 1349010, 1348742, 1348658, 1349006, 1348624, 1348753, 1348716, 1349007, 1348940, 1348634, 1348921, 1348901, 1348957, 1348794, 1353204, 1353181, 1353331, 1353366, 1354798, 1354307, 1354598, 1354982, 1354973, 1354498, 1354039, 1354032, 1351648, 1336648, 1336006, 5039338, 5038598, 1345860, 1345892, 1345865, 1345875, 5040892, 5040894, 5040855, 2480510, 2480524, 2480491, 2480509, 2480649, 2480696, 2498112, 2498026, 2498255, 2498265, 2498273, 2498338, 8000602, 2498390, 2498238, 2498375, 2498302, 5232431, 2498352, 9274012, 5228662, 2481312, 5229273, 2480297, 5229142, 2480242, 2480758, 2480267, 7788295, 2481139, 2481205, 2481776, 2481741, 8250742, 2481831, 2481685, 2481792, 2481789, 2481719, 2481714, 2481703, 2481621, 2475001, 2475532, 8014966, 2481034, 8069880, 2481062, 2474055, 2473421, 5227679, 2481962, 2474381, 5228228, 2490674, 2490613, 2491518, 2491469, 2491582, 7668711, 2494459, 2494441, 4408970, 9444556, 2490266, 5231236, 2487862, 4409010, 2484886, 2493114, 2493549, 2493071, 2490781, 2490737, 2482059, 2482012, 10884686, 2481991, 2481433, 5788464, 2481463, 5229360, 2480193, 5959143, 6202897, 1922311, 4535172, 1926102, 5772751, 1932517, 1921521, 5772741, 9088852, 6237479, 5882039, 1894164, 1911168, 5134777, 6231302, 4535537, 4535614, 5129378, 6229837, 4535585, 5137677, 5137708, 4535288, 4535271, 4535270, 5137908, 1920509, 4535297, 5051736, 1425142, 1423211, 1421988, 1422033, 1423329, 4302729, 1423114, 1423539, 6242434, 7215843, 1421209, 1421179, 1421159, 5791726, 5051794, 1426284, 1423981, 1428642, 1428235, 8310300, 1429876, 2402129, 2402193, 2402154, 2402168, 2402159, 2402203, 2402105, 5212973, 2412637, 2412705, 2412619, 2412683, 2357181, 2357184, 2368261, 2368179, 2368189, 2368173, 2368245, 2368221, 9227457, 2368219, 2368194, 2368176, 2368265, 2368208, 2361439, 2361436, 2361438, 2360283, 2362920, 2363007, 2363026, 2363028, 2363020, 2363022, 2362914, 2363032, 2360380, 5206720, 5739534, 5207307, 5207176, 5739562, 2360544, 2360575, 4286975, 4409624, 4409625, 2367627, 2367622, 2367630, 2363396, 2365679, 7193633, 2363069, 2363082, 2365350, 2363080, 2365155, 2359302, 2359289, 5962764, 2359842, 2359834, 2359846, 2362504, 5207374, 5207389, 2360371, 2360363, 2360772, 2360778, 2359699, 8478641, 2359671, 8536369, 2362671, 2362661, 2362646, 2365762, 2365754, 2365769, 5962666, 2365745, 2365749, 2365777, 2365757, 2365683, 2365753, 2360998, 9685146, 2348137, 2348094, 2348049, 5203914, 5203912, 5203115, 2356542, 5204683, 4409524, 2375336, 2375679, 2375686, 2375680, 2375443, 5962184, 2382024, 2382017, 2382117, 2351152, 2350984, 2351193, 2351227, 2351128, 2351049, 2351236, 2351076, 2351066, 2351169, 2351198, 2350945, 2351211, 2351234, 2351174, 2351155, 2351188, 2351002, 2350956, 2351220, 2350963, 2351116, 2351413, 2351648, 2351640, 2351622, 2351647, 2351546, 2351551, 2351321, 2351335, 2351318, 2351255, 2351322, 2351280, 2351243, 2351283, 2351291, 2351281, 2351304, 2351316, 2351301, 2351285, 2351311, 2334155, 2334119, 2334090, 5962956, 5782525, 7911174, 7374133, 4559558, 4559582, 6548059, 6525764, 10588060, 10091239, 9866931, 4571435, 4571430, 4562017, 4561959, 4562023, 4561962, 4562236, 10448461, 4562184, 5778409, 5778072, 5778065, 5778057, 5778051, 5778068, 4561354, 4561367, 4561357, 4561352, 4561355, 11081502, 10950391, 11049859, 10742385, 11657057, 4560669, 4560675, 4560659, 4560697, 4571454, 4560679, 4560662, 4560700, 4560687, 4560664, 4560689, 4560665, 4560690, 4560691, 4560668, 4560657, 4560671, 4560663, 11149728, 4560584, 4560606, 4560609, 4560596, 4560613, 4560614, 4560598, 4560580, 4560603, 4560620, 4560607, 9435016, 4560464, 4560445, 9332537, 4560466, 9404607, 9555170, 4560450, 4560428, 9317931, 4560473, 4560458, 4560437, 4560476, 9480619, 4560478, 4560463, 4560444, 4560467, 4560449, 4560431, 4560472, 4560456, 4560436, 4560459, 9599069, 4560027, 4560028, 4560479, 4560989, 4560946, 4560897, 4560909, 4560892, 4561033, 4560993, 4561032, 4561070, 4561039, 4561014, 4560961, 9521075, 4560904, 4560939, 4561015, 4560943, 4560928, 4560963, 4560944, 4560924, 4561053, 4560925, 4560897, 4560991, 4560952, 4560239, 4560258, 4560195, 4560243, 4560231, 4560197, 4560158, 4560105, 4560149, 4560131, 4560112, 4560259, 4560221, 11698349, 4560154, 4560141, 4560119, 4560262, 4560147, 4560125, 4560107, 4560256, 4560211, 4560114, 4560031, 4560202, 4560213, 4560133, 4560223, 4560193, 4560121, 4560103, 4560204, 4560166, 4560412, 5777975, 5777974, 9200750, 7528515, 4560080, 4560078, 4560739, 4560085, 4560081, 4560086, 4560092, 4560101, 4560637, 4560553, 4560551, 4560552, 7969414, 7700576, 4560775, 4560872, 4560777, 4560801, 4560779, 4560783, 4560797, 4560398, 7680271, 4561131, 4561130, 4560299, 4560303, 4560278, 4560305, 4560280, 8257495, 4560296, 4560307, 4560298, 5784242, 4560851, 10122246, 4560864, 4560854, 4560857, 4560838, 4560845, 8296120, 8340990, 7602356, 7353867, 4560855, 4560834, 4560308, 4560319, 4560320, 4560421, 4560889, 4560887, 4560000, 4560004, 4559994, 9234020, 4560418, 4560416, 4560368, 4560370, 4560381, 4560396, 4560377, 8411564, 9183710, 4561080, 4560728, 4560333, 4560336, 4560617, 4560317, 4560514, 4560515, 4559977, 8806940, 9430349, 4559968, 4559956, 4559939, 4559975, 4560730, 4561202, 4561123, 4561090, 4361883, 5784443, 4560571, 4560828, 4560767, 4560766, 8227322, 11657057, 10449139, 4561288, 4561256, 4561283, 4561273, 4561284, 4561274, 4561275, 4561286, 4561276, 4561241, 4561249, 4561248, 4561233, 4561327, 4561250, 4561308, 4561318, 4561302, 10963772, 10330460, 7368053, 5099098, 1700141, 5098486, 5098471, 5098495, 5099242, 1698816, 1708596, 1708655, 1708220, 1708482, 1708532, 1708663, 1708286, 1705496, 1715787, 1715746, 1707865, 1707880, 1713172, 1699432, 1699438, 1699459, 11372732, 1701443, 1701527, 1709971, 1709973, 1709968, 1705959, 1705949, 1705961, 1705945, 1705951, 1705947, 1705936, 1714267, 1701387, 1709528, 1709505, 1709561, 1714146, 1710742, 1710800, 1710754, 1710831, 1710792, 1710733, 1710735, 1704555, 1704550, 1704558, 1704551, 1704556, 1704559, 1704552, 1704557, 1704560, 1704554, 1702607, 1710717, 1700186, 1700184, 1704126, 1704110, 4403736, 1704116, 1704130, 1706651, 1706666, 1706648, 1703023, 1711948, 7827900, 1700669, 7596978, 1699558, 1699588, 1699775, 1699688, 1699740, 1699678, 1710957, 1710955, 1710932, 1710949, 1710971, 1710909, 1709422, 1709434, 1709410, 1707985, 1711361, 1717979, 1717980, 1716482, 1720465, 1722209, 1718794, 1721564, 7384726, 1716137, 1724090, 1724098, 1697617, 1697603, 1698652, 1698650, 1698651, 1698654, 1698478, 1697739, 1698289, 1698560, 1698566, 1698568, 9203121, 1697685, 1697688, 9166296, 5098052, 5098050, 8742357, 1698292, 8122973, 1692644, 4403051, 1684286, 8049117, 1684338, 1684370, 1684279, 1684325, 1684290, 7754425, 1684327, 4403059, 4403015, 1688017, 1688160, 9010793, 1688210, 1688306, 1688099, 1688195, 1688293, 1688328, 1688198, 1688104, 1688223, 1687557, 1729294, 1729250, 7676257, 1729299, 1729254, 1729295, 5101121, 8159162, 1729278, 5101131, 8111999, 1729291, 1729313, 1729317, 1729248, 1729280, 9210154, 1729312, 1729802, 8409857, 1681211, 4402785, 1687814, 1694753, 1694757, 1683704, 1683715, 1683708, 1683717, 1683707, 1692648, 1685672, 9506695, 5732384, 1685930, 1684219, 1683492, 1683491, 1683493, 1683205, 1683144, 8337855, 7818136, 1692208, 1692213, 8060901, 5976805, 1684037, 1683999, 1683971, 1684039, 1683997, 1693043, 7607697, 1690302, 1690258, 1690242, 4402659, 1690301, 1690310, 1690274, 1690309, 1690298, 1690241, 1690237, 1690270, 1690267, 1690265, 1690299, 1694814, 1694547, 1685548, 1685553, 1685546, 1693928, 1693920, 1693966, 1691168, 1688483, 1684098, 7648014, 4402907, 4402914, 4402916, 4402911, 1685200, 1685184, 4402915, 1685290, 4402912, 1685217, 4402917, 4402913, 1685261, 1695272, 1685188, 1685223, 8029295, 1693617, 5096164, 1694196, 1694176, 1694181, 1694225, 1694213, 1694194, 1694178, 1694184, 1694198, 1694206, 4402877, 9093097, 7961856, 7473363, 1683963, 4402811, 4402820, 1684423, 1684420, 1692871, 1692368, 1688392, 10957950, 7313107, 3585010, 8528335, 7830710, 7404415, 7355662, 7476554, 7404415, 3991218, 3608170, 2650652, 4258215, 2650613, 11024204, 2650593, 4258930, 4256561, 7803877, 4256886, 4016963, 5275359, 7319129, 5656645, 4011890, 7597214, 3752103, 2651092, 4039363, 7335563, 5613441, 5274875, 5613324, 10685776, 8231122, 2650180, 7917024, 2688176, 5219303, 2435261, 5219073, 5219007, 5219057, 2434779, 2440339, 2440709, 2440735, 4262590, 2441184, 2440669, 8123917, 2432667, 2432621, 5218476, 5218523, 5739436, 5787719, 2432582, 5218519, 2432427, 2432430, 2435665, 2435551, 2436788, 2436789, 2436679, 2438594, 2438492, 2439439, 2437304, 5298946, 8809775, 5324926, 3121429, 2888307, 12191890, 8108046, 3015596, 3802666, 2684184, 10957950, 7313107, 3585010, 7830710, 7355662, 4039363, 5274865, 5613441, 5613324, 10685776, 2684507, 2684184, 2685577, 2865134, 5329163, 5328680, 2864467, 5330522, 2724729, 2722344, 2728531, 2723371, 2722101, 2722760, 2718117, 2726725, 2722046, 2731327, 2714220, 5289788, 4932408, 4152690, 8358373, 4124964, 2705315, 4110465, 4127331, 11098873, 5678643, 4112245, 4120732, 2704674, 2704720, 4144397, 6432155, 6432155, 6432021, 5329315, 5329466, 2701520, 2857503, 2857446, 8365808, 2857748, 2855964, 5326577, 2855374, 2855337, 2855338, 2855379, 10671015, 2858662, 2768599, 2768843, 2768436, 2768950, 2768421, 2778450, 2740602, 2740588, 2740522, 2739652, 2739851, 2754399, 5304469, 2771837, 8171325, 2767252, 2767291, 2747796, 2747562, 5298488, 5300841, 5300375, 5300824, 5300612, 5300571, 5300574, 5300607, 2753523, 5299588, 2808640, 5323572, 2795952, 2795866, 2795869, 2795845, 2797313, 8809775, 10939543, 5319031, 5319046, 7227849, 5319022, 5318891, 7227849, 5319214, 5319011, 2834242, 2840691, 2840587, 2840422, 2840410, 2840457, 5324947, 5324926, 5324958, 12222157, 2792792, 2792823, 2849399, 2849615, 2849324, 2798366, 2798208, 2798436, 2798444, 5831893, 3633974, 3642051, 3641026, 3637808, 3636648, 3630000, 9393490, 5539675, 9348906, 3630865, 3105531, 3122645, 3104499, 4235471, 3104525, 3104470, 3121429, 3121262, 3120923, 3121387, 8137610, 3098613, 5398267, 5398244, 3105428, 8088443, 3127662, 12068747, 3128595, 3128049, 7468889, 3128022, 3128353, 3128480, 3127473, 3128839, 3097037, 5392252, 3113465, 3112721, 3143056, 5403502, 8221907, 7444427, 7379976, 3131272, 3131776, 3093880, 5694634, 4211341, 3140535, 4210368, 3132517, 3133531, 3142177, 3094889, 3094899, 3087419, 3087444, 3093358, 3125943, 8075117, 3108080, 3108888, 3105718, 3105709, 4218285, 4218280, 4218630, 3097203, 3128612, 8306779, 7939048, 3168262, 5413099, 7222063, 3164489, 5375066, 3054029, 5708780, 3041767, 8449058, 3042605, 3042797, 3042624, 3042918, 3042399, 9073641, 5373247, 3040701, 5376452, 5373530, 5373462, 5373507, 5835035, 5373475, 5373461, 5373533, 5373511, 5373472, 5373474, 5373522, 5373485, 5376403, 8376149, 3050152, 3049489, 5375519, 3048474, 5377151, 5374198, 5377797, 3053415, 3047770, 3047763, 3047767, 3047762, 3046747, 5585118, 7267859, 7267578, 7267749, 3811846, 3808252, 5586222, 5586437, 3810117, 3808482, 3808387, 5587273, 5587262, 7662000, 5585819, 5585543, 8337357, 5383918, 5567951, 5383917, 5383924, 7515774, 3760494, 7788633, 12191190, 3594304, 3594336, 8095200, 3614259, 3614186, 3857544, 4095966, 4095830, 4164146, 3064110, 3067114, 3065201, 3069679, 2951624, 3965840, 5629532, 5343495, 5342657, 5346662, 5346856, 2947371, 2947355, 2947357, 5354605, 5356950, 9144783, 5347723, 5356559, 5356840, 5356876, 5356836, 5356893, 5356846, 6309401, 3979603, 5611691, 3968896, 2974799, 2975379, 2975282, 2975141, 3575531, 5525462, 7570714, 3840751, 3828671, 3826450, 3826194, 2890983, 8257208, 4067595, 4058916, 4068166, 4059956, 8405185, 7930390, 9479684, 4067320, 4058159, 4067409, 5606476, 5608751, 3885512, 3895043, 10836683, 3900481, 3884303, 3891669, 3891662, 8117625, 3890500, 7307469, 3889964, 3888771, 3901655, 7308378, 4931003, 3892603, 4939647, 3745163, 3989666, 5524064, 2882398, 7263169, 2882404, 5572860, 8074424, 4155899, 4155899, 4156521, 4090794, 5668095, 4090162, 5668182, 8333551, 4089603, 4090542, 7812265, 7699652, 4088489, 4089767, 4089510, 4089439, 4089302, 5652611, 4036610, 7380730, 4007266, 5640973, 5641574, 7933553, 4004972, 3921843, 6710361, 3927271, 9680003, 3920959, 3924925, 3921209, 4198600, 4198135, 4197651, 4197241, 4197353, 7670884, 4194757, 8350478, 3032182, 3032178, 3032179, 10800268, 3024897, 5366702, 3020871, 10865719, 3020780, 7271631, 7470443, 3753004, 3753813, 3752577, 3752513, 3754891, 2914482, 2915237, 2915084, 2913980, 8019701, 7720261, 9516357, 5578445, 5578495, 5578459, 5667897, 5667895, 3172271, 3741143, 3740165, 3732560, 3737855, 7332902, 8013319, 5559164, 7376915, 7446038, 7790128, 7639090, 9644635, 7997882, 3728644, 3724648, 3676970, 2928626, 3802666, 2929993, 5792656, 4159329, 3595098, 3595627, 3596509, 7331423, 3595399, 3595738, 5663312, 5665115, 5663414, 4456155, 4427568, 5744642, 1118090, 1118085, 1118094, 9026086, 4458869, 1160391, 1160394, 1100529, 1149587, 1150125, 1112045, 6265069, 6545022, 1142727, 1146542, 4459584, 1096257, 1113733, 1113735, 8118266, 7599943, 1128496, 1132852, 1132842, 4458877, 7910744, 1148809, 1105395, 1150182, 1153065, 8749265, 4458809, 1102045, 7814841, 1102048, 1115612, 1124322, 8964613, 4458788, 8283537, 1101936, 5005592, 1149503, 8152915, 1153658, 1153669, 8194816, 1151419, 1158993, 1162241, 1081184, 1081167, 1079594, 1079611, 1080601, 1080517, 4451510, 4428747, 4429492, 4429497, 4429485, 4429440, 4429459, 4429501, 4428989, 4428899, 4428902, 4428477, 4429037, 4428696, 4429265, 4450496, 4450507, 1072120, 4431082, 4431070, 4431073, 4431089, 5747828, 5743111, 5743110, 5743119, 4458557, 4457579, 4471240, 5007652, 8486909, 10761814, 4455270, 4455118, 4455106, 8380351, 5878395, 7779633, 9157531, 10706107, 4455095, 10745977, 4454265, 8794260, 9014846, 10726337, 8725697, 4455265, 4455015, 4454252, 4449486, 4449485, 5778117, 5778128, 5778136, 4561556, 4561492, 4561511, 5778103, 8790745, 5778104, 5778114, 4561688, 4561735, 9416298, 4561785, 8956212, 4567413, 4567416, 4567419, 4567090, 4566916, 4566738, 7344449, 4566728, 4566923, 4566952, 4566938, 4566946, 4566963, 4566701, 4566696, 4562870, 4562893, 4562889, 4562901, 4562934, 4562942, 4562940, 4566212, 8948014, 9183153, 4566069, 4566130, 4566086, 4566109, 4566118, 4566072, 9470407, 4566089, 4566121, 4566025, 4566048, 4566061, 4566093, 4566096, 4566077, 4566052, 9793988, 9045085, 8270733, 12177052, 4563195, 9356383, 4563883, 4563872, 9370866, 4563883, 4563871, 4563887, 9692606, 4563874, 5779397, 5782976, 9041363, 4564164, 4564125, 4564158, 4564194, 4564073, 4564176, 4564101, 8788224, 4564187, 4564135, 9403432, 4564258, 9494377, 4564225, 4564069, 8260427, 4563734, 4563556, 4563526, 4563541, 4563535, 4563550, 4563563, 4563494, 4563492, 4563517, 4563522, 5782977, 4563570, 4563567, 4563565, 9089874, 4564351, 5783299, 5783302, 9267190, 5783308, 11694607, 5783298, 11087406, 5783306, 9020510, 8914745, 9458358, 8856234, 8801783, 8315283, 9500338, 7681435, 5783323, 9026386, 9841183, 10599637, 10436011, 10203248, 4565680, 4565665, 4565660, 4565707, 4565667, 4565071, 4565081, 4565136, 4565037, 4565824, 4565185, 9387458, 5780090, 9635884, 5780146, 5780082, 10685454, 5780144, 4565619, 4564582, 9438493, 9300627, 9380838, 5783292, 5783342, 8945674, 4565044, 4565052, 10582104, 10404024, 4565035, 4565033, 11118513, 5782985, 5782986, 9191595, 5782988, 7763114, 9201833, 10862044, 4565866, 4565462, 4565038, 4564928, 4565197, 4565222, 4565191, 4565199, 4565203, 4565223, 4565193, 4565821, 9634232, 4565609, 4564871, 4565231, 4565272, 4565226, 12187124, 4565255, 4565396, 4564933, 4564930, 4564953, 4564704, 4564735, 4564741, 4564743, 4566639, 4566631, 4566633, 4566595, 4566597, 4566609, 4566645, 4566580, 4566651, 4566598, 4566576, 4566582, 4566572, 4566614, 11075444, 4566601, 5781195, 9227616, 4567532, 4562952, 4562959, 4562958, 4562962, 4562990, 4562994, 4562988, 4567454, 5781058, 4567182, 2293983, 4567215, 4567975, 4567897, 9396461, 9419288, 9286964, 9476400, 4567965, 5783497, 4567996) 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 12297101 records were derived from 10001 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0003529-260221153910048/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.