A dataset containing 61504584 records in GBIF matching the query: SELECT "year", GBIF_ISEA3HCode( 6, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000)) AS isea3hCellCode, orderKey, classKey, class, familyKey, family, genusKey, genus, speciesKey, species, basisOfRecord, institutionCode, collectionCode, COUNT(*) AS occurrences, SUM(individualCount) AS totalOccurrenceCount, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate)) AS minTemporalUncertainty, IF(ISNULL(familyKey), NULL, SUM(COUNT(*)) OVER (PARTITION BY familyKey, "year", basisOfRecord)) AS familyCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND continent IS NOT NULL AND (coordinateUncertaintyInMeters <= 25000 OR coordinateUncertaintyInMeters IS NULL) AND kingdomKey = 1 AND hasCoordinate = TRUE AND speciesKey IS NOT 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 "year" IS NOT NULL AND basisOfRecord != 'FOSSIL_SPECIMEN' GROUP BY "year", isea3hCellCode, orderKey, classKey, class, familyKey, family, genusKey, genus, speciesKey, species, basisOfRecord, institutionCode, collectionCode ORDER BY "year" DESC, familyKey ASC, speciesKey ASC, basisOfRecord ASC; The dataset's 61504584 records were derived from 40422 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0032873-240906103802322/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.