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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Salvelinus namaycush",
 "Country is Japan",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 20 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prioniturus platurus)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 465 species occurrences available in GBIF matching the query:
{
 "and" : [
 "OccurrenceStatus is Present",
 "TaxonKey is Panstrongylus rufotuberculatus"
 ]
}

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

description: A dataset containing 817 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prioniturus platenae)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 299 species occurrences available in GBIF matching the query:
{
 "and" : [
 "OccurrenceStatus is Present",
 "TaxonKey is Mepraia spinolai"
 ]
}

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

description: A dataset containing 0 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 (Myiozetetes similis)",
 "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 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023636-250802193616735/datasets/export for details.
DOI: 10.15468/dl.gmsbmd
title: Occurrence Download

description: A dataset containing 2 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prioniturus verticalis)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 27 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Phylloscopus burkii",
 "Country is China",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Telmatherina obscura)",
 "BasisOfRecord is one of (Specimen, Literature Occurrence, Human Observation, Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 1991",
 "Year is less than or equal to 2025"
 ]
}

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

description: A dataset containing 0 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 (Myiozetetes similis)",
 "Country is one of (American Samoa, Australia, Christmas Island, Cocos (Keeling) Islands, Cook Islands, Fiji, French Polynesia, Guam, Heard Island and McDonald Islands, Kiribati, Marshall Islands, Micronesia (Federated States of), Nauru, New Caledonia, New Zealand, Niue, Norfolk Island, Northern Mariana Islands, Palau, Papua New Guinea, Pitcairn, Samoa, Solomon Islands, Tokelau, Tonga, Tuvalu, United States Minor Outlying Islands, Vanuatu, Wallis and Futuna)"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Salvelinus namaycush",
 "Country is New Zealand",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 955 species occurrences available in GBIF matching the query:
{
 "and" : [
 "OccurrenceStatus is Present",
 "TaxonKey is Rhodnius neglectus"
 ]
}

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

description: A dataset containing 40 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Salvelinus namaycush",
 "Country is Norway",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 8660 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prionochilus maculatus)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

 The dataset includes 8660 records from 19 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023644-250802193616735/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.15628700
title: WHEN AI-GENERATED CONTENT LIKE SNOWBALL ON THE SPREAD OF FAKE NEWS AMONG SOCIAL MEDIA USERS
DOI: 10.5281/zenodo.15628701
title: WHEN AI-GENERATED CONTENT LIKE SNOWBALL ON THE SPREAD OF FAKE NEWS AMONG SOCIAL MEDIA USERS
DOI: 10.15468/dl.bsnf6n
title: Occurrence Download

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

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023645-250802193616735/datasets/export for details.
DOI: 10.5281/zenodo.16757665
title: Embodied carbon for concrete building
DOI: 10.5281/zenodo.16757666
title: Embodied carbon for concrete building
DOI: 10.15468/dl.2khkuj
title: Occurrence Download

description: A dataset containing 653 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prioniturus waterstradti)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 17 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Continent is Asia",
 "Country is India",
 "GadmGid is IND.15_1",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Chromolaena odorata"
 ]
}

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

description: A dataset containing 143 species occurrences available in GBIF matching the query:
{
 "and" : [
 "OccurrenceStatus is Present",
 "TaxonKey is Panstrongylus chinai"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Pseudogyrinocheilus prochilus)",
 "BasisOfRecord is one of (Specimen, Literature Occurrence, Human Observation, Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 1991",
 "Year is less than or equal to 2025"
 ]
}

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

description: A dataset containing 1470 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prionochilus olivaceus)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 347 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Salvelinus namaycush",
 "Country is Switzerland",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 1614 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Phylloscopus valentini",
 "Country is China",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Salvelinus namaycush",
 "Country is United Kingdom of Great Britain and Northern Ireland",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 2223 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prionochilus plateni)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 5711 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prionochilus percussus)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

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

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

description: A dataset containing 104 species occurrences available in GBIF matching the query:
{
 "and" : [
 "OccurrenceStatus is Present",
 "TaxonKey is Triatoma nitida"
 ]
}

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

description: A dataset containing 1281 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prionochilus thoracicus)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 6998 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Australia",
 "OccurrenceStatus is Present",
 "TaxonKey is Neoceratodus forsteri"
 ]
}

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

description: A dataset containing 3 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Clarias hilli)",
 "BasisOfRecord is one of (Specimen, Literature Occurrence, Human Observation, Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 1991",
 "Year is less than or equal to 2025"
 ]
}

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

description: A dataset containing 578 species occurrences available in GBIF matching the query:
{
 "and" : [
 "OccurrenceStatus is Present",
 "TaxonKey is Rhodnius robustus"
 ]
}

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

description: A dataset containing 970353 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 (Myiozetetes similis)",
 "Country is one of (Anguilla, Antigua and Barbuda, Argentina, Aruba, Bahamas, Barbados, Belize, Bolivia (Plurinational State of), Bonaire, Sint Eustatius and Saba, Bouvet Island, Brazil, Cayman Islands, Chile, Colombia, Costa Rica, Cuba, Curaçao, Dominica, Dominican Republic, Ecuador, El Salvador, Falkland Islands (Malvinas), French Guiana, Grenada, Guadeloupe, Guatemala, Guyana, Haiti, Honduras, Jamaica, Martinique, Mexico, Montserrat, Nicaragua, Panama, Paraguay, Peru, Puerto Rico, Saint Barthélemy, Saint Kitts and Nevis, Saint Lucia, Saint Martin (French part), Saint Vincent and the Grenadines, Sint Maarten (Dutch part), South Georgia and the South Sandwich Islands, Suriname, Trinidad and Tobago, Turks and Caicos Islands, Uruguay, Venezuela (Bolivarian Republic of), Virgin Islands (British), Virgin Islands (U.S.))"
 ]
}

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

description: A dataset containing 4736 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prionochilus xanthopygius)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

description: A dataset containing 2672 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Prionodura newtoniana)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "License is one of (CC-BY 4.0, CC0 1.0)"
 ]
}

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

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

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

description: A dataset containing 1289 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 countrycode countrycode,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, countrycode, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, countrycode, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, countrycode, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, countrycode, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, countrycode, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, countrycode, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 (CAST(occurrence.taxonkey AS INTEGER) = 1862837 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 1862837 OR CAST(occurrence.kingdomkey AS INTEGER) = 1862837 OR CAST(occurrence.phylumkey AS INTEGER) = 1862837 OR CAST(occurrence.classkey AS INTEGER) = 1862837 OR CAST(occurrence.orderkey AS INTEGER) = 1862837 OR CAST(occurrence.familykey AS INTEGER) = 1862837 OR CAST(occurrence.genuskey AS INTEGER) = 1862837 OR CAST(occurrence.specieskey AS INTEGER) = 1862837)
 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.occurrencestatus = 'PRESENT'
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE)
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",
 occurrence.countrycode

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