A dataset containing 2079438 records in GBIF matching the query: SELECT kingdom, kingdomkey, phylum, phylumkey, "year", GBIF_EQDGCODE(1, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eqdcellcode, IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY kingdomkey, GBIF_EQDGCODE(1, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) kingdomcount, COUNT(DISTINCT recordedby) distinctobservers, COUNT(*) occurrences FROM occurrence WHERE occurrence.basisofrecord IN ('OBSERVATION', 'MACHINE_OBSERVATION', 'HUMAN_OBSERVATION', 'MATERIAL_SAMPLE', 'PRESERVED_SPECIMEN', 'OCCURRENCE') AND occurrence.continent = 'EUROPE' AND GBIF_WITHIN('POLYGON((-37.00539 23.98721,70.51515 23.98721,70.51515 83.05118,-37.00539 83.05118,-37.00539 23.98721))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE AND occurrence.hascoordinate = TRUE AND occurrence.occurrencestatus = 'PRESENT' AND occurrence.hasgeospatialissues = FALSE AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE) AND (occurrence.distancefromcentroidinmeters >= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND (occurrence.phylumkey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE) GROUP BY occurrence.kingdom, occurrence.kingdomkey, occurrence.phylum, occurrence.phylumkey, occurrence."year", GBIF_EQDGCODE(1, occurrence.decimallatitude, occurrence.decimallongitude, COALESCE(occurrence.coordinateuncertaintyinmeters, 1000)) The dataset's 2079438 records were derived from 30667 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0007575-250426092105405/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.