DOI: 10.15468/dl.227qjx
title: Occurrence Download

description: A dataset containing 483041 records in GBIF matching the query:

SELECT 
 -- Dimensions: 
 PRINTF('%04d-%02d', "year", "month") AS yearMonth,
 GBIF_EEARGCode(
 1000,
 decimalLatitude,
 decimalLongitude,
 COALESCE(coordinateUncertaintyInMeters, 1000)
 ) AS eeaCellCode,
 taxonKey,
 acceptedTaxonKey,
 familyKey,
 family,
 speciesKey,
 species,
 scientificname,
 -- Measurements 
 COUNT(*) AS occurrences, 
 MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters,
 MIN(GBIF_TemporalUncertainty(eventDate, null)) AS minTemporalUncertainty
FROM
 occurrence
WHERE occurrenceStatus = 'PRESENT'
 AND basisofrecord NOT IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND countryCode = 'NL'
 AND "year" &lt; 2025
 AND "year" &gt;= 2020
 AND hasCoordinate = TRUE
 AND speciesKey IN (133142097, 104109161, 304189867, 100145582, 165902491, 116902418, 222466917, 155309291, 180177343, 143705799, 304185247, 302565820, 176605732, 100481856, 102089338, 273121764, 176605738, 164696338, 299348704, 159935932, 2481912, 299348685, 2481916, 100510281, 100509370, 133144857, 304185545, 202601409, 176652855, 102096937, 159936440, 143705524, 165912027, 100148051, 160795980, 304185384, 155308918, 180173783, 2494686, 273193859, 299384074, 165902045, 181869563, 202602190, 100184464, 159937579, 160796399, 180172635, 102111547, 2497921, 273163251, 299396274, 100142980, 222463059, 155307572, 176613352, 180176709, 100482429, 2480495, 273149606, 102085731, 185023118, 133143465, 164696471, 165901118, 288470265, 168241351, 202601924, 159938733, 299355909, 160796294, 10687398, 2480487, 2480491, 185022515, 165900128, 104148941, 133137699, 100184572, 180172625, 100484324, 164696298, 159935993, 2498415, 273154524, 102112205, 299396361, 273199666, 304185377, 100174403, 165917716, 222457820, 104135740, 176633068, 180174878, 159937050, 264619828, 2492943, 155308427, 299386420, 304185321, 165919488, 304189805, 116900717, 133153088, 304185485, 100148870, 104128292, 143705569, 302565958, 273187271, 102098771, 222458165, 100483288, 159937287, 10042909, 159937319, 288439939, 9515886, 202601299, 160795932, 180173413, 176639208, 181870117, 155308616, 299380246, 133156786, 302565983, 302565978, 304185491, 165917884, 100174417, 304185379, 104135750, 180174857, 104135783, 222457844, 180174834, 6094046, 100484007, 10731929, 2492960, 264619899, 299386541, 273199902, 159937054, 164696496, 176633109, 9694782, 9612559, 165910870, 116897567, 304185338, 133145869, 100147705, 176643378, 143705606, 104120669, 222460390, 2491534, 100483028, 164696604, 159936301, 180174084, 102095785, 273187735, 159936266, 288444149, 10496117, 299370844, 100523475, 100153417, 302565904, 176635189, 165911579, 143705648, 133148537, 304185310, 102100309, 273183562, 180174214, 159937197, 9701857, 155308654, 299377677, 165907573, 100160095, 302565824, 222467018, 140698905, 133168422, 104150646, 116895440, 100482580, 273208080, 164696309, 159938571, 180175869, 176614434, 2474156, 102092495, 299359329, 116898548, 302565901, 2490266, 100483422, 133148896, 102100269, 222458943, 159937263, 100153290, 143705654, 273183210, 165911037, 304185308, 176635061, 180174288, 299377441, 155308666, 116896838, 116896878, 222461878, 273189436, 102094766, 180174005, 116896953, 176650601, 159936520, 9409796, 140698857, 100147048, 133155101, 165921416, 104114949, 100482914, 288446806, 159936522, 299381204, 155308974, 104108753, 160796163, 121513394, 165904076, 202600648, 222463967, 176607298, 100171527, 133140391, 2481819, 116901139, 100481524, 273134485, 102089057, 159937810, 180177776, 160796164, 202600651, 181869781, 299350879, 155306364, 2481817, 299350862, 133155020, 302565923, 121498444, 304185282, 176650645, 104115592, 165921569, 102094941, 5229490, 180173970, 273189283, 100147203, 299380944, 159936546, 104135409, 100143233, 133150075, 273192320, 165918819, 102103070, 176640965, 222458384, 180175457, 100483856, 2493220, 159936178, 299381493, 2493214, 304185387, 222459173, 180173585, 8104397, 176653431, 159936328, 100148209, 273194664, 134111940, 165911917, 155308921, 299385090, 304185286, 102094773, 176650590, 100147079, 304189828, 185018224, 304185498, 165921434, 104115013, 133154826, 273189403, 116896922, 222461874, 2482513, 100482926, 180174001, 159936530, 155308968, 299381145, 304187327, 304185311, 100153399, 133148650, 304185553, 165911510, 304189801, 302565905, 143705646, 116898569, 116898574, 104122193, 222458905, 273183613, 102100299, 176635168, 100483447, 9687165, 159937213, 159937216, 180174253, 299377808, 155308643, 100171867, 185022640, 165903945, 116901109, 176607173, 222464147, 2481714, 180177678, 159937726, 100481685, 133140352, 102089191, 273133880, 299350403, 155306300, 100172401, 165901664, 140698860, 133135440, 116894347, 304185589, 104146907, 222455648, 302565842, 2497266, 273163984, 176617928, 100484250, 159937545, 180172708, 176617915, 102111322, 299392204, 299392455, 165193309, 165193310, 176633811, 304185514, 102105106, 165914086, 100182075, 273174033, 133155905, 143705574, 116899402, 304185351, 104139875, 222460565, 2490774, 100484116, 159937098, 180174983, 155308714, 299360717, 304185314, 116896334, 100174305, 160795687, 181869956, 116896315, 273180074, 165914900, 159936499, 180174787, 222460736, 202601204, 104134889, 102102825, 164696538, 9809229, 176631440, 155308003, 299374387, 165526076, 304185219, 176613710, 104151575, 180176168, 100482600, 100160388, 165930789, 116895672, 159938549, 9752149, 202602032, 160796051, 102092902, 273207394, 299359122, 205105248, 143705558, 302565897, 102093977, 100143305, 273191671, 133153885, 165920071, 304185290, 104118147, 159937357, 176652316, 8077224, 155308820, 180173883, 299388094, 133140765, 304185235, 100145526, 143705938, 202600994, 159938349, 2480242, 116901926, 104107974, 165905019, 222464927, 180178614, 100481074, 273136932, 102088435, 176607718, 164696409, 155305984, 299350008, 133141675, 165904087, 104113502, 155309058, 143705795, 100168865, 116906995, 100482697, 222455060, 102093456, 176619071, 4408498, 273157338, 180175653, 299396523, 165930012, 116903738, 116903809, 304187286, 140698870, 304185188, 102091893, 104112807, 222462028, 100147980, 176605050, 100482545, 159938617, 9616058, 273202754, 180176418, 155307629, 165475835, 299357431, 304189888, 104108835, 304185232, 143618336, 133140519, 202600686, 100171668, 165904477, 100481587, 222464083, 180177724, 176607331, 2481792, 164696397, 159937754, 102089122, 273134137, 160796156, 202600679, 155306235, 2481784, 299350625, 2481791, 121513174, 133140262, 100148818, 222464906, 273138658, 102088518, 100481114, 164696345, 159938314, 165905049, 104108031, 7788295, 180178689, 176608008, 155306120, 299351335, 133140502, 143705978, 116900944, 222464016, 160796202, 165904452, 100171647, 2481685, 159937767, 104108823, 164696402, 180177751, 176607377, 100481565, 102089109, 273134228, 155306320, 299350690, 205111561, 116898838, 100159097, 222458810, 273199012, 133145199, 304185300, 102101653, 165912704, 176635329, 288426747, 104122923, 5231198, 202601280, 160795840, 159936470, 10094195, 159936474, 180174669, 299385766, 155308025, 5231190, 304189792, 165930745, 222467101, 176614594, 140698903, 304185221, 116895490, 104151162, 164696306, 102092741, 104151319, 100482593, 159938474, 2473958, 160796049, 273206518, 180176189, 299358724, 100515889, 165910784, 302565934, 116897570, 133145730, 222460386, 304189843, 100147710, 273187704, 176643335, 2491482, 180174082, 100483032, 102095806, 164696600, 159936303, 299370904, 9566476, 303470831, 273119451, 102089968, 304187254, 100146696, 143705754, 180177164, 246549174, 165905316, 133138977, 222463681, 176621228, 2495708, 100482226, 299346825, 159937631, 100171727, 144032017, 165904369, 104108706, 160796200, 116901076, 202600727, 133140486, 8250742, 181869794, 100481632, 176607120, 204868630, 222463821, 273134935, 180177812, 164696391, 116899367, 100181977, 165913760, 140698846, 176633803, 133155884, 304185348, 222460599, 273174222, 102105089, 2490737, 100484096, 164696521, 159937114, 180174996, 155308721, 299360923, 304189846, 304185337, 100147698, 143705605, 133145607, 165910878, 222460402, 7634625, 116897538, 302565933, 176643304, 104120627, 159936304, 180174030, 100483015, 273187754, 102095751, 164696605, 299370801)
 -- AND acceptedTaxonKey IN (133142097, 104109161, 304189867, 100145582, 165902491, 116902418, 222466917, 155309291, 180177343, 143705799, 304185247, 302565820, 176605732, 100481856, 102089338, 273121764, 176605738, 164696338, 299348704, 159935932, 2481912, 299348685, 2481916, 100510281, 100509370, 133144857, 304185545, 202601409, 176652855, 102096937, 159936440, 143705524, 165912027, 100148051, 160795980, 304185384, 155308918, 180173783, 2494686, 273193859, 299384074, 165902045, 181869563, 202602190, 100184464, 159937579, 160796399, 180172635, 102111547, 2497921, 273163251, 299396274, 100142980, 222463059, 155307572, 176613352, 180176709, 100482429, 2480495, 273149606, 102085731, 185023118, 133143465, 164696471, 165901118, 288470265, 168241351, 202601924, 159938733, 299355909, 160796294, 10687398, 2480487, 2480491, 185022515, 165900128, 104148941, 133137699, 100184572, 180172625, 100484324, 164696298, 159935993, 2498415, 273154524, 102112205, 299396361, 273199666, 304185377, 100174403, 165917716, 222457820, 104135740, 176633068, 180174878, 159937050, 264619828, 2492943, 155308427, 299386420, 304185321, 165919488, 304189805, 116900717, 133153088, 304185485, 100148870, 104128292, 143705569, 302565958, 273187271, 102098771, 222458165, 100483288, 159937287, 10042909, 159937319, 288439939, 9515886, 202601299, 160795932, 180173413, 176639208, 181870117, 155308616, 299380246, 133156786, 302565983, 302565978, 304185491, 165917884, 100174417, 304185379, 104135750, 180174857, 104135783, 222457844, 180174834, 6094046, 100484007, 10731929, 2492960, 264619899, 299386541, 273199902, 159937054, 164696496, 176633109, 9694782, 9612559, 165910870, 116897567, 304185338, 133145869, 100147705, 176643378, 143705606, 104120669, 222460390, 2491534, 100483028, 164696604, 159936301, 180174084, 102095785, 273187735, 159936266, 288444149, 10496117, 299370844, 100523475, 100153417, 302565904, 176635189, 165911579, 143705648, 133148537, 304185310, 102100309, 273183562, 180174214, 159937197, 9701857, 155308654, 299377677, 165907573, 100160095, 302565824, 222467018, 140698905, 133168422, 104150646, 116895440, 100482580, 273208080, 164696309, 159938571, 180175869, 176614434, 2474156, 102092495, 299359329, 116898548, 302565901, 2490266, 100483422, 133148896, 102100269, 222458943, 159937263, 100153290, 143705654, 273183210, 165911037, 304185308, 176635061, 180174288, 299377441, 155308666, 116896838, 116896878, 222461878, 273189436, 102094766, 180174005, 116896953, 176650601, 159936520, 9409796, 140698857, 100147048, 133155101, 165921416, 104114949, 100482914, 288446806, 159936522, 299381204, 155308974, 104108753, 160796163, 121513394, 165904076, 202600648, 222463967, 176607298, 100171527, 133140391, 2481819, 116901139, 100481524, 273134485, 102089057, 159937810, 180177776, 160796164, 202600651, 181869781, 299350879, 155306364, 2481817, 299350862, 133155020, 302565923, 121498444, 304185282, 176650645, 104115592, 165921569, 102094941, 5229490, 180173970, 273189283, 100147203, 299380944, 159936546, 104135409, 100143233, 133150075, 273192320, 165918819, 102103070, 176640965, 222458384, 180175457, 100483856, 2493220, 159936178, 299381493, 2493214, 304185387, 222459173, 180173585, 8104397, 176653431, 159936328, 100148209, 273194664, 134111940, 165911917, 155308921, 299385090, 304185286, 102094773, 176650590, 100147079, 304189828, 185018224, 304185498, 165921434, 104115013, 133154826, 273189403, 116896922, 222461874, 2482513, 100482926, 180174001, 159936530, 155308968, 299381145, 304187327, 304185311, 100153399, 133148650, 304185553, 165911510, 304189801, 302565905, 143705646, 116898569, 116898574, 104122193, 222458905, 273183613, 102100299, 176635168, 100483447, 9687165, 159937213, 159937216, 180174253, 299377808, 155308643, 100171867, 185022640, 165903945, 116901109, 176607173, 222464147, 2481714, 180177678, 159937726, 100481685, 133140352, 102089191, 273133880, 299350403, 155306300, 100172401, 165901664, 140698860, 133135440, 116894347, 304185589, 104146907, 222455648, 302565842, 2497266, 273163984, 176617928, 100484250, 159937545, 180172708, 176617915, 102111322, 299392204, 299392455, 165193309, 165193310, 176633811, 304185514, 102105106, 165914086, 100182075, 273174033, 133155905, 143705574, 116899402, 304185351, 104139875, 222460565, 2490774, 100484116, 159937098, 180174983, 155308714, 299360717, 304185314, 116896334, 100174305, 160795687, 181869956, 116896315, 273180074, 165914900, 159936499, 180174787, 222460736, 202601204, 104134889, 102102825, 164696538, 9809229, 176631440, 155308003, 299374387, 165526076, 304185219, 176613710, 104151575, 180176168, 100482600, 100160388, 165930789, 116895672, 159938549, 9752149, 202602032, 160796051, 102092902, 273207394, 299359122, 205105248, 143705558, 302565897, 102093977, 100143305, 273191671, 133153885, 165920071, 304185290, 104118147, 159937357, 176652316, 8077224, 155308820, 180173883, 299388094, 133140765, 304185235, 100145526, 143705938, 202600994, 159938349, 2480242, 116901926, 104107974, 165905019, 222464927, 180178614, 100481074, 273136932, 102088435, 176607718, 164696409, 155305984, 299350008, 133141675, 165904087, 104113502, 155309058, 143705795, 100168865, 116906995, 100482697, 222455060, 102093456, 176619071, 4408498, 273157338, 180175653, 299396523, 165930012, 116903738, 116903809, 304187286, 140698870, 304185188, 102091893, 104112807, 222462028, 100147980, 176605050, 100482545, 159938617, 9616058, 273202754, 180176418, 155307629, 165475835, 299357431, 304189888, 104108835, 304185232, 143618336, 133140519, 202600686, 100171668, 165904477, 100481587, 222464083, 180177724, 176607331, 2481792, 164696397, 159937754, 102089122, 273134137, 160796156, 202600679, 155306235, 2481784, 299350625, 2481791, 121513174, 133140262, 100148818, 222464906, 273138658, 102088518, 100481114, 164696345, 159938314, 165905049, 104108031, 7788295, 180178689, 176608008, 155306120, 299351335, 133140502, 143705978, 116900944, 222464016, 160796202, 165904452, 100171647, 2481685, 159937767, 104108823, 164696402, 180177751, 176607377, 100481565, 102089109, 273134228, 155306320, 299350690, 205111561, 116898838, 100159097, 222458810, 273199012, 133145199, 304185300, 102101653, 165912704, 176635329, 288426747, 104122923, 5231198, 202601280, 160795840, 159936470, 10094195, 159936474, 180174669, 299385766, 155308025, 5231190, 304189792, 165930745, 222467101, 176614594, 140698903, 304185221, 116895490, 104151162, 164696306, 102092741, 104151319, 100482593, 159938474, 2473958, 160796049, 273206518, 180176189, 299358724, 100515889, 165910784, 302565934, 116897570, 133145730, 222460386, 304189843, 100147710, 273187704, 176643335, 2491482, 180174082, 100483032, 102095806, 164696600, 159936303, 299370904, 9566476, 303470831, 273119451, 102089968, 304187254, 100146696, 143705754, 180177164, 246549174, 165905316, 133138977, 222463681, 176621228, 2495708, 100482226, 299346825, 159937631, 100171727, 144032017, 165904369, 104108706, 160796200, 116901076, 202600727, 133140486, 8250742, 181869794, 100481632, 176607120, 204868630, 222463821, 273134935, 180177812, 164696391, 116899367, 100181977, 165913760, 140698846, 176633803, 133155884, 304185348, 222460599, 273174222, 102105089, 2490737, 100484096, 164696521, 159937114, 180174996, 155308721, 299360923, 304189846, 304185337, 100147698, 143705605, 133145607, 165910878, 222460402, 7634625, 116897538, 302565933, 176643304, 104120627, 159936304, 180174030, 100483015, 273187754, 102095751, 164696605, 299370801)
 AND (coordinateUncertaintyInMeters &lt;= 1000 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 ( 
 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
 yearMonth,
 eeaCellCode,
 taxonKey,
 acceptedTaxonKey,
 familyKey,
 family,
 speciesKey,
 species,
 scientificname
ORDER BY 
 yearMonth DESC,
 eeaCellCode ASC,
 speciesKey ASC;


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