Occurrence Download

A dataset containing 15848788 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" >= 1950 AND speciesKey IN (2480578, 4408405, 4408410, 2493124, 2493114, 5739298, 5229165, 2475532, 2474045, 2474055, 6178325, 2498026, 2490274, 5228644, 2480510, 2480506, 2480509, 2480500, 2480505, 2480934, 2480906, 2497295, 2498259, 2473663, 2480910, 5232464, 5232451, 5959092, 2494394, 2481606, 2482100, 2480564, 2490681, 6177960, 2481521, 8109681, 4408795, 2480311, 2480281, 2490674, 2474864, 2481119, 2481912, 2481909, 2480666, 2480482, 2480487, 2480491, 2480495, 2495427, 2495434, 2495459, 2495406, 2475365, 4408498, 2480740, 2498347, 2477927, 6177296, 6177279, 8773033, 2478031, 2477872, 7190969, 2480876, 2480372, 2491490, 2491469, 2491482, 8014966, 2481034, 9813242, 2481037, 9584698, 2481047, 8069880, 2481062, 2492601, 2492605, 2492608, 6175538, 2494442, 2474381, 9330514, 2481831, 2481959, 2481962, 2481958, 7192423, 2480757, 5232162, 2474950, 2480649, 2480389, 2480449, 5844449, 2480685, 5229126, 2493219, 5229142, 4408455, 2480850, 5227692, 5227710, 7745240, 2492854, 2492855, 7406504, 6065810, 8151548, 6065841, 2481681, 2494177, 2490604, 4408732, 2498390, 2490613, 2498285, 5229167, 5229168, 2480696, 2481789, 5959143, 2480863, 2482001, 2482012, 5231234, 5231236, 5231233, 2474921, 2498302, 2480726, 5844831, 2481991, 2480353, 2480350, 2473966, 2473961, 2480420, 4408479, 6066518, 5739290, 8250742, 9691034, 2477804, 2478548, 2480801, 2480773, 2480332, 2482059, 5232431, 2474416, 2474627, 2474621, 2474628, 2480204, 2480193, 2481473, 2481463, 5739275, 5229360, 5229377, 2482552, 2480259, 2492522, 2484880, 2484886, 7192406, 2481236, 5229249, 9367409, 5229230, 2481240, 2497522, 2497509, 2497894, 2492953, 2492955, 6100917, 2492965, 2492949, 2498015, 7191070, 2473577, 5228228, 2481713, 5739334, 6065721) AND occurrence.hasgeospatialissues = FALSE AND occurrence.hascoordinate = TRUE AND (coordinateUncertaintyInMeters = 1950.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 15848788 records were derived from 7425 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000319-260225131425191/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.