cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.15468/dl.6h8twx
title: Occurrence Download

description: A dataset containing 6194 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 2684359 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 2684359 OR CAST(occurrence.kingdomkey AS INTEGER) = 2684359 OR CAST(occurrence.phylumkey AS INTEGER) = 2684359 OR CAST(occurrence.classkey AS INTEGER) = 2684359 OR CAST(occurrence.orderkey AS INTEGER) = 2684359 OR CAST(occurrence.familykey AS INTEGER) = 2684359 OR CAST(occurrence.genuskey AS INTEGER) = 2684359 OR CAST(occurrence.specieskey AS INTEGER) = 2684359)
 AND occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL)
GROUP BY
 occurrence.kingdom,
 occurrence.kingdomkey,
 occurrence.phylum,
 occurrence.phylumkey,
 occurrence.class,
 occurrence.classkey,
 occurrence."order",
 occurrence.orderkey,
 occurrence.family,
 occurrence.familykey,
 occurrence.genus,
 occurrence.genuskey,
 occurrence.species,
 occurrence.specieskey,
 occurrence."year"

 The dataset's 6194 records were derived from 2295 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0011188-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.7d9udf
title: Occurrence Download

description: A dataset containing 6 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Nitidula bipunctata",
 "Country is Italy",
 "HasCoordinate is true"
 ]
}

 The dataset includes 6 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000740-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.82144/e8be8273
title: Bycatch along Romanian Black Sea coasts 2010-2011

description: Original provider:
Mare Nostrum

Dataset credits:
Mare Nostrum NGO, National Institute for Marine Research and Development "Grigore Antipa"

Abstract:
In the Black Sea, the cetaceans are represented by three species: &lt;i&gt;Phocoena phocoena relicta&lt;/i&gt;, &lt;i&gt;Tursiops truncatus ponticus&lt;/i&gt; and &lt;i&gt;Delphinus delphis ponticus&lt;/i&gt;. The main threat and cause of decline for the Black Sea dolphins are the fishing nets, or bycatches. For the protection of dolphin populations from the Romanian Black Sea area, in conformity with the objectives of the "National Action Plan for Conservation of Dolphins" and the "Agreement on the Conservation of Cetaceans of the Black Sea, Mediterranean Sea and contiguous Atlantic Area," and with financial support from the European Union through the Sectorial Operational Programme – Environment, NGO "Mare Nostrum" started a series of activities in partnership with the National Institute for Marine Research and Development "Grigore Antipa" Constanța, Danube Delta Biosphere Reserve Authority, National Agency for Fishing and Aquaculture, Natural Science Museum Complex "Dolphinarium" Constanța, Border Police Inspectorate of Constanța County. The present database presents the situation of dolphin bycatch events at the Romanian coast during 2010 and 2011. The data were collected from the entire Romanian coast, from Sulina to Vama Veche.
DOI: 10.15468/dl.akzzgz
title: Occurrence Download

description: A dataset containing 694 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Limnothrissa miodon",
 "HasCoordinate is true"
 ]
}

 The dataset includes 694 records from 18 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000741-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.k4a4tq
title: Occurrence Download

description: A dataset containing 2 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Rumex crispus",
 "Country is Kyrgyzstan",
 "HasCoordinate is true"
 ]
}

 The dataset includes 2 records from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031211-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.6084/m9.figshare.29622093
title: Data from Strategic menu optimisation could reduce carbon emissions and saturated fat consumption: A simulation modelling study of UK hospital inpatient meals

description: ESM.zip
DOI: 10.6084/m9.figshare.29622093.v1
title: Data from Strategic menu optimisation could reduce carbon emissions and saturated fat consumption: A simulation modelling study of UK hospital inpatient meals

description: ESM.zip
DOI: 10.6084/m9.figshare.29498315
title: Multi-bioinformatics approach reveals COX5B-mediated Modulation of Oxidative Phosphorylation by Water and Ethanol Extracts of Schisandrae Fructus_Supplementary materials

description: Multi-bioinformatics approach reveals COX5B-mediated Modulation of Oxidative Phosphorylation by Water and Ethanol Extracts of Schisandrae Fructus_Supplementary materials
DOI: 10.6084/m9.figshare.29498315.v1
title: Multi-bioinformatics approach reveals COX5B-mediated Modulation of Oxidative Phosphorylation by Water and Ethanol Extracts of Schisandrae Fructus_Supplementary materials

description: Multi-bioinformatics approach reveals COX5B-mediated Modulation of Oxidative Phosphorylation by Water and Ethanol Extracts of Schisandrae Fructus_Supplementary materials
DOI: 10.6084/m9.figshare.29498315.v2
title: Multi-bioinformatics approach reveals COX5B-mediated Modulation of Oxidative Phosphorylation by Water and Ethanol Extracts of Schisandrae Fructus_Supplementary materials

description: Multi-bioinformatics approach reveals COX5B-mediated Modulation of Oxidative Phosphorylation by Water and Ethanol Extracts of Schisandrae Fructus_Supplementary materials
DOI: 10.15468/dl.vrqpqn
title: Occurrence Download

description: A dataset containing 42 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ochna insculpta",
 "HasCoordinate is true",
 "Geometry POLYGON ((-17.66889 -35.11691, 51.34702 -35.11691, 51.34702 37.62, -17.66889 37.62, -17.66889 -35.11691))"
 ]
}

 The dataset includes 42 records from 10 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031212-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.8kppmq
title: Occurrence Download

description: A dataset containing 620335 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "BasisOfRecord is one of (Human Observation, Machine Observation, Occurrence evidence, Observation)",
 "TaxonKey is one of (Gavia arctica)",
 "Country is one of (Åland Islands, Albania, Andorra, Austria, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Czechia, Denmark, Estonia, Faroe Islands, Finland, France, Germany, Gibraltar, Greece, Guernsey, Holy See, Hungary, Iceland, Ireland, Isle of Man, Italy, Jersey, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Moldova, Republic of, Monaco, Montenegro, Netherlands, North Macedonia, Norway, Poland, Portugal, Romania, Russian Federation, San Marino, Serbia, Slovakia, Slovenia, Spain, Svalbard and Jan Mayen, Sweden, Switzerland, Ukraine, United Kingdom of Great Britain and Northern Ireland)"
 ]
}

 The dataset includes 620335 records from 369 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031189-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.gzg76x
title: Occurrence Download

description: A dataset containing 1593 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Rhaphithamnus spinosus"
 ]
}

 The dataset includes 1593 records from 69 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031213-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.9ujuxb
title: Occurrence Download

description: A dataset containing 1948 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cirsium vulgare",
 "Country is South Africa",
 "HasCoordinate is true"
 ]
}

 The dataset includes 1948 records from 13 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031214-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.q8683d
title: Occurrence Download

description: A dataset containing 15 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Aeschynomene elaphroxylon",
 "Country is Senegal",
 "HasCoordinate is true"
 ]
}

 The dataset includes 15 records from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031215-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.26179/qj98-bd44
title: Orthomosaic and digital surface model of ASPA101, Antarctica 11th November 2024
DOI: 10.15468/dl.r6xaby
title: Occurrence Download

description: A dataset containing 38230 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cirsium vulgare",
 "Country is United States of America",
 "HasCoordinate is true"
 ]
}

 The dataset includes 38230 records from 193 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031216-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.k57b4s
title: Occurrence Download

description: A dataset containing 3269 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Cyprinus rubrofuscus"
 ]
}

 The dataset includes 3269 records from 22 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031217-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.5ehys8
title: Occurrence Download

description: A dataset containing 20 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Rumex crispus",
 "Country is Peru",
 "HasCoordinate is true"
 ]
}

 The dataset includes 20 records from 5 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031218-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.69ptnr
title: Occurrence Download

description: A dataset containing 2 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Rumex crispus",
 "Country is Timor-Leste",
 "HasCoordinate is true"
 ]
}

 The dataset includes 2 records from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031219-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.d9uqpr
title: Occurrence Download

description: A dataset containing 21343 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Rumex crispus",
 "Country is United States of America",
 "HasCoordinate is true"
 ]
}

 The dataset includes 21343 records from 219 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031220-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.6084/m9.figshare.29622102
title: Sediment heterogeneity affects navigation by burrowers: A modeling study - Supplementary Videos (actual observation)

description: Supplementary Videos -actual observation.zip
DOI: 10.6084/m9.figshare.29622102.v1
title: Sediment heterogeneity affects navigation by burrowers: A modeling study - Supplementary Videos (actual observation)

description: Supplementary Videos -actual observation.zip
DOI: 10.6084/m9.figshare.29622105
title: Sediment heterogeneity affects navigation by burrowers: A modeling study - Supplementary Videos (numerical simulation)

description: Supplementary Videos -numerical simulation.zip
DOI: 10.6084/m9.figshare.29622105.v1
title: Sediment heterogeneity affects navigation by burrowers: A modeling study - Supplementary Videos (numerical simulation)

description: Supplementary Videos -numerical simulation.zip
DOI: 10.15468/dl.6n7re9
title: Occurrence Download

description: A dataset containing 579 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Strombosia scheffleri",
 "HasCoordinate is true",
 "Geometry POLYGON ((-17.66889 -35.11691, 51.34702 -35.11691, 51.34702 37.62, -17.66889 37.62, -17.66889 -35.11691))"
 ]
}

 The dataset includes 579 records from 33 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031221-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.n9hxcv
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Rhinanthus angustifolius"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031222-250717081556266/datasets/export for details.
DOI: 10.15468/dl.2s7bgb
title: Occurrence Download

description: A dataset containing 5 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia leptocarpa",
 "Country is Senegal",
 "HasCoordinate is true"
 ]
}

 The dataset includes 5 records from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031224-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.6h3vqm
title: Occurrence Download

description: A dataset containing 1 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Rumex crispus",
 "Country is Uzbekistan",
 "HasCoordinate is true"
 ]
}

 The dataset includes 1 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031225-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.bve68s
title: Occurrence Download

description: A dataset containing 64 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Hemerocallis lilioasphodelus",
 "Country is Belgium",
 "HasCoordinate is true"
 ]
}

 The dataset includes 64 records from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031226-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.hndfd4
title: Occurrence Download

description: A dataset containing 149 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cotula australis",
 "Country is Argentina",
 "HasCoordinate is true"
 ]
}

 The dataset includes 149 records from 6 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031227-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.8dae9r
title: Occurrence Download

description: A dataset containing 750 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Jasminum grandiflorum",
 "HasCoordinate is true",
 "Geometry POLYGON ((-17.66889 -35.11691, 51.34702 -35.11691, 51.34702 37.62, -17.66889 37.62, -17.66889 -35.11691))"
 ]
}

 The dataset includes 750 records from 34 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031228-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.x7je3e
title: Occurrence Download

description: A dataset containing 402 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Hemerocallis lilioasphodelus",
 "Country is Canada",
 "HasCoordinate is true"
 ]
}

 The dataset includes 402 records from 10 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031229-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.eyvu8x
title: Occurrence Download

description: A dataset containing 19 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Nymphaea micrantha",
 "Country is Senegal",
 "HasCoordinate is true"
 ]
}

 The dataset includes 19 records from 5 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031231-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.kbnwr7
title: Occurrence Download

description: A dataset containing 5 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Hemerocallis lilioasphodelus",
 "Country is Croatia",
 "HasCoordinate is true"
 ]
}

 The dataset includes 5 records from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031230-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.f2zyxv
title: Occurrence Download

description: A dataset containing 19710 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Rhinanthus glacialis"
 ]
}

 The dataset includes 19710 records from 161 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031232-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.2pnxec
title: Occurrence Download

description: A dataset containing 112 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Hemerocallis lilioasphodelus",
 "Country is Czechia",
 "HasCoordinate is true"
 ]
}

 The dataset includes 112 records from 3 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031233-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.jt5k8f
title: Occurrence Download

description: A dataset containing 732517 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "BasisOfRecord is one of (Human Observation, Machine Observation, Occurrence evidence, Observation)",
 "TaxonKey is one of (Falco subbuteo)",
 "Country is one of (Åland Islands, Albania, Andorra, Austria, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Czechia, Denmark, Estonia, Faroe Islands, Finland, France, Germany, Gibraltar, Greece, Guernsey, Holy See, Hungary, Iceland, Ireland, Isle of Man, Italy, Jersey, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Moldova, Republic of, Monaco, Montenegro, Netherlands, North Macedonia, Norway, Poland, Portugal, Romania, Russian Federation, San Marino, Serbia, Slovakia, Slovenia, Spain, Svalbard and Jan Mayen, Sweden, Switzerland, Ukraine, United Kingdom of Great Britain and Northern Ireland)"
 ]
}

 The dataset includes 732517 records from 2211 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031200-250717081556266/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.c58qyc
title: Occurrence Download

description: A dataset containing 6742448 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence."year" &gt;= 2001 AND occurrence."year" &lt;= 2025)
 AND occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL)
GROUP BY
 occurrence.kingdom,
 occurrence.kingdomkey,
 occurrence.phylum,
 occurrence.phylumkey,
 occurrence.class,
 occurrence.classkey,
 occurrence."order",
 occurrence.orderkey,
 occurrence.family,
 occurrence.familykey,
 occurrence.genus,
 occurrence.genuskey,
 occurrence.species,
 occurrence.specieskey,
 occurrence."year"

 The dataset's 6742448 records were derived from 52538 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0008447-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.