Abstract
A dataset containing 49271924 records in GBIF matching the query: SELECT specieskey, species, kingdom, phylum, class, "order", family, basisofrecord, publishingorgkey, datasetkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0) eeacellcode, "year", "month", YEAR(CAST(lastinterpreted AS TIMESTAMP)) year_published, MONTH(CAST(lastinterpreted AS TIMESTAMP)) month_published, COUNT(*) occurrences FROM occurrence WHERE occurrence.countrycode = 'SE' AND occurrence.hascoordinate = TRUE AND occurrence.hasgeospatialissues = FALSE AND occurrence.occurrencestatus = 'PRESENT' AND occurrence.specieskey IS NOT NULL GROUP BY occurrence.specieskey, occurrence.species, occurrence.kingdom, occurrence.phylum, occurrence.class, occurrence."order", occurrence.family, occurrence.basisofrecord, occurrence.publishingorgkey, occurrence.datasetkey, GBIF_EEARGCODE(10000, occurrence.decimallatitude, occurrence.decimallongitude, 0), occurrence."year", occurrence."month", YEAR(CAST(occurrence.lastinterpreted AS TIMESTAMP)), MONTH(CAST(occurrence.lastinterpreted AS TIMESTAMP)) The dataset's 49271924 records were derived from 1244 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0059865-260226173443078/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.