DOI: 10.15468/dl.6gcpcc
title: Occurrence Download

description: A dataset containing 520167 records in GBIF matching the query:
SELECT "year", countryCode AS countryCode, datasetKey, speciesKey, species, family, class, sex, COUNT(*) AS occurrences FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND continent = 'EUROPE' AND "year" &gt;= 2000 AND speciesKey IN (8894817, 2442225, 9789983, 2481800, 8277073, 2498112, 8332393, 8214667, 8000602, 9761484, 2498017, 2498036, 2481776, 2498255, 2498261, 2498265, 5232446, 5232437, 5232464, 2498326, 2481606, 2481748, 2481759, 2481765, 2481741, 2481743, 6178228, 2481521, 2481521, 2481521, 2481312, 2480311, 9566659, 2481119, 2498273, 6178421, 2498338, 2498347, 2498343, 2480876, 2481353, 2474377, 2481433, 2481433, 2481959, 2481958, 2481263, 7788295, 2480449, 2482001, 10884686, 4408455, 6065841, 2481236, 2481139, 7406504, 7982160, 2481174, 2481174, 2481174, 6065810, 2481172, 8151548, 9413670, 6065824, 2481681, 2481685, 2498238, 2498247, 2498285, 9537647, 2498375, 2480964, 2480964, 2481792, 2481784, 2482001, 2482012, 2481991, 2481861, 2481890, 8250742, 2480801, 2480332, 2480327, 2482059, 2482054, 2482051, 2482065, 5232431, 5788464, 2481463, 5229343, 5739277, 5229361, 5229360, 5229380, 5229377, 2480259, 2481205, 2498352, 2481621, 2481609, 2481618, 7192406, 5229249, 9367409, 5229230, 2481240, 5789279, 2498009, 2481725, 2481713, 2481726, 2481714, 2481342, 2480242, 2289348, 2289359, 2290522, 2290374, 2289671, 9385151, 2290849, 12232247, 2290489, 2290469, 9809222, 4287132, 2402203, 5214401, 2420813, 2420797, 2412685, 2412623, 2420446, 2392210, 8006460, 5212973, 2417115, 2389391, 5214450, 5214448, 2408575, 2408554, 2408516, 2408543, 2369178, 2395359, 5210955, 2415505, 2409909, 2386906, 2386887, 2389708, 2346315, 5216423, 5216437, 5216430, 2421020, 2421147, 2421203, 2379498, 2420726, 2336745, 2336534, 2336774, 2336786, 2400863, 2417343, 5213909, 8351946, 8351946, 2416296, 2403490, 2351027, 2351211, 2351174, 5209780, 5215150, 5962255, 2420911, 2419543, 2421127, 2376296, 2392679, 2394622, 5210983, 5210969, 9777888, 5210968, 5210979, 2420234, 2420247, 2420174, 2386469, 5214892, 2414031, 2395031, 2388507, 2346633, 2421071, 2421031, 2421064, 2336597, 4284220, 8084280, 2415603, 2415581, 2418259, 5215626, 5215611, 2411201, 5213996, 2403289, 2375526, 4286361, 2420586, 2420569, 5201064, 5201134, 2409218, 2357093, 5215455, 5215127, 5216248, 2383648, 5216239, 2421365, 5210267, 2409395, 2409391, 2336734, 2336719, 2378673, 2378690, 5851603, 2419863, 2419849, 2419852, 2419875, 5213960, 2415070, 2415075, 5211321, 5215092, 2415822, 2415788, 2415643, 2410133, 2410130, 2410119, 2410108, 2415777, 5214022, 2419188, 5214883, 5214875, 5214880, 5215435, 2396862, 9530947, 2418315, 2418313, 2418361, 2419310, 2379089, 2416878, 2405532, 2392603, 5216313, 2392566, 2392562, 2392557, 2392554, 8140485, 2334967, 8236498, 5214919, 2409330, 7700106, 2415872, 2415861, 5211265, 2409418, 5216016, 5216024, 5216033, 5216014, 5216053, 5216046, 2420418, 2417443, 2420268, 7595433, 8215487, 2382155, 5208593, 2413224, 2392628, 2399670, 2374161, 2374149, 2409418, 2409418, 2409403, 2334658, 2334619, 2334600, 2334574, 2418684, 2418670, 2421174, 2388710, 2388724, 5214139, 5214139, 2418794, 2393205, 2393205, 2392356, 2413452, 5216368, 5216342, 2417781, 2384043, 2383970, 2409453, 9694948, 2373980, 5203999, 5215518, 2386475, 5210496, 5210490, 5210473, 2415973, 4286391, 2336771, 2415923, 2415916, 2415906, 2360504, 2397850, 7744449, 2381013, 2440728, 2440709, 2440714, 2440735, 2440718, 8324617, 2440605, 2440596, 5220027, 2434806, 2434806, 5220013, 2440694, 5220086, 2440412, 2440397, 2440417, 2434779, 2440483, 5219369, 2434793, 2440669, 2440669, 8123917, 8123917, 2440440, 5219369, 5220055, 5220045, 2440433, 2440447, 2440369) AND 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 GROUP BY "year", basisOfRecord, datasetKey, countryCode, speciesKey, species, family, class, sex ORDER BY "year" DESC, countryCode ASC

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