Occurrence Download

A dataset containing 78 records in GBIF matching the query:
SELECT
kingdom,
kingdomkey,
phylum,
phylumkey,
class,
classkey,
"order",
orderkey,
family,
familykey,
genus,
genuskey,
species,
specieskey,
"year",
countrycode countrycode,
IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
PARTITION BY genuskey, countrycode, "year")) genuscount,
COUNT(*) occurrences,
MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
occurrence
WHERE
occurrence.decimallatitude >= 56.91065
AND occurrence.decimallatitude <= 83.27109
AND (occurrence.decimallongitude >= -140.66144 AND occurrence.decimallongitude <= -59.18683)
AND GBIF_WITHIN('POLYGON ((-140.66144 69.63744, -138.99152 68.859, -136.88214 68.7637, -135.56378 68.31351, -133.63019 68.24847, -131.16925 68.89067, -127.74152 68.95389, -126.0716 68.63599, -124.84113 68.39456, -123.43488 68.01933, -123.08331 66.83888, -122.02863 66.63058, -121.01789 66.08428, -120.18292 65.08537, -118.513 65.23306, -117.54621 64.71253, -117.53762 63.45964, -115.50756 62.79925, -113.5568 62.13912, -112.64356 62.11857, -112.487 61.7464, -112.43756 61.7464, -112.2508 61.78798, -112.14093 61.78798, -111.95416 61.78798, -111.86078 61.89167, -111.94318 61.7464, -111.56964 61.7464, -107.52667 61.7464, -105.4173 62.36418, -103.5716 62.24163, -101.81378 62.24163, -100.362 61.70207, -98.20709 61.4063, -96.79767 61.27438, -96.17608 60.18913, -95.10869 58.64589, -92.62234 56.91065, -92.33326 58.91589, -93.77075 59.74442, -92.6438 61.26898, -90.98949 62.23565, -89.83317 62.79756, -88.92678 63.34319, -87.28978 63.24111, -86.47672 62.95604, -85.02637 62.37748, -83.53192 61.69029, -81.42194 61.80065, -80.54182 61.18426, -78.95735 60.17772, -79.47982 59.34658, -79.55796 58.36669, -77.69276 57.66292, -77.58538 56.94522, -76.42331 56.98751, -75.46642 57.2514, -74.78313 57.77354, -73.24075 57.59132, -71.73803 57.41395, -69.61149 57.90701, -68.17091 58.59949, -65.85142 59.05329, -64.69168 59.05272, -63.58446 58.09009, -62.50351 57.64586, -61.69936 58.40208, -62.79143 60.02676, -63.60113 60.89601, -65.99287 61.65887, -64.4493 61.98669, -63.38226 62.91545, -63.72146 63.62109, -63.96042 64.418, -62.5734 64.44454, -62.59263 65.2182, -60.83208 66.19259, -60.65356 67.16495, -62.40589 67.8342, -64.68008 68.35223, -66.04247 68.51999, -65.77896 68.85179, -65.7793 69.3153, -66.65887 69.73175, -67.9779 70.55398, -67.53912 70.77356, -69.21039 70.97773, -70.70587 71.40533, -71.59014 71.85849, -73.1829 72.04163, -74.43482 72.82277, -75.70821 72.76818, -76.49716 73.7502, -78.38475 73.91662, -80.27234 73.83854, -78.59418 74.9083, -77.34723 76.10438, -75.38068 77.67379, -73.0296 78.9142, -72.37042 79.36539, -67.36066 80.59486, -59.18683 82.36582, -62.263 82.73606, -68.23956 83.27109, -80.80792 83.09373, -92.67316 81.98907, -100.23175 80.55168, -101.46222 80.07863, -106.80158 79.51838, -109.85578 79.02769, -114.55792 78.47928, -118.33722 77.90384, -121.67706 77.30011, -123.7394 76.30251, -124.04393 75.5825, -124.12564 74.78553, -125.34375 74.62469, -126.19794 74.15467, -126.50006 73.01893, -127.45587 71.59045, -130.2464 70.65218, -135.30011 70.00128, -140.66144 69.63744))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE
AND occurrence.hascoordinate = TRUE
AND occurrence.hasgeospatialissues = FALSE
AND occurrence.occurrencestatus = 'PRESENT'
AND (occurrence.taxonkey = 1035920 OR occurrence.acceptedtaxonkey = 1035920 OR occurrence.kingdomkey = 1035920 OR occurrence.phylumkey = 1035920 OR occurrence.classkey = 1035920 OR occurrence.orderkey = 1035920 OR occurrence.familykey = 1035920 OR occurrence.genuskey = 1035920 OR occurrence.specieskey = 1035920)
AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
AND (occurrence.distancefromcentroidinmeters >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE)
GROUP BY
occurrence.kingdom,
occurrence.kingdomkey,
occurrence.phylum,
occurrence.phylumkey,
occurrence.class,
occurrence.classkey,
occurrence."order",
occurrence.orderkey,
occurrence.family,
occurrence.familykey,
occurrence.genus,
occurrence.genuskey,
occurrence.species,
occurrence.specieskey,
occurrence."year",
occurrence.countrycode

The dataset's 78 records were derived from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000208-250515123054153/datasets/export for details.

Data from some individual datasets included in this download may be licensed under less restrictive terms.