A dataset containing 8809861 records in GBIF matching the query: SELECT PRINTF('%04d-%02d', "year", "month") AS yearMonth, GBIF_EEARGCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, familyKey, family, speciesKey, species, COALESCE(sex, 'NOT_SUPPLIED') AS sex, COALESCE(occurrence.lifestage.concept, 'NOT_SUPPLIED') AS lifestage, COUNT(*) AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate)) AS minTemporalUncertainty, IF(ISNULL(familyKey), NULL, SUM(COUNT(*)) OVER (PARTITION BY familyKey)) AS familyCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND continent = 'EUROPE' AND "year" >= 1100 AND kingdomKey = 1 AND classKey = 359 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 "month" IS NOT NULL GROUP BY yearMonth, eeaCellCode, familyKey, family, speciesKey, species, sex, lifestage ORDER BY yearMonth DESC, eeaCellCode ASC, speciesKey ASC The dataset's 8809861 records were derived from 9237 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0007944-240506114902167/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.