Occurrence Download

A dataset containing 51 records in GBIF matching the query: SELECT countrycode, COUNT(*) total_occurrences, COUNT(DISTINCT publisher) total_publishers, SUM(CASE WHEN kingdom = 'Animalia' THEN 1 ELSE 0 END) animalia_occurrences, SUM(CASE WHEN kingdom = 'Plantae' THEN 1 ELSE 0 END) plantae_occurrences, SUM(CASE WHEN kingdom = 'Fungi' THEN 1 ELSE 0 END) fungi_occurrences, SUM(CASE WHEN kingdom = 'Protozoa' THEN 1 ELSE 0 END) protista_occurrences, SUM(CASE WHEN kingdom = 'Bacteria' THEN 1 ELSE 0 END) bacteria_occurrences, SUM(CASE WHEN kingdom = 'Archaea' THEN 1 ELSE 0 END) archaea_occurrences, SUM(CASE WHEN kingdom = 'Chromista' THEN 1 ELSE 0 END) chromista_occurrences, SUM(CASE WHEN kingdom = 'incertae sedis' THEN 1 ELSE 0 END) incertae_sedis_occurrences FROM occurrence WHERE occurrence.countrycode IN ('AT', 'BE', 'BG', 'HR', 'CY', 'CZ', 'DK', 'EE', 'FI', 'FR', 'DE', 'GR', 'HU', 'IE', 'IT', 'LV', 'LT', 'LU', 'MT', 'NL', 'PL', 'PT', 'RO', 'SK', 'SI', 'ES', 'SE', 'AL', 'AD', 'AM', 'BY', 'BA', 'FO', 'GE', 'GI', 'IS', 'XK', 'LI', 'MK', 'MD', 'MC', 'ME', 'NO', 'RU', 'SM', 'RS', 'CH', 'TR', 'UA', 'GB', 'BG', 'VA') GROUP BY occurrence.countrycode ORDER BY countrycode The dataset's 51 records were derived from 42570 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021615-260208012135463/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.