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

description: A dataset containing 11527 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "Country is Finland",
 "Country is Sweden"
 ]
 },
 "Year 1990-2018",
 "HasCoordinate is true",
 "TaxonKey is Ledum Ruppius ex L.",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 20 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Gynochthodes lacunosa (King & Gamble) Razafim. & B.Bremer"
 ]
}

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

description: A dataset containing 281 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Eremias argus Peters, 1869",
 "Geometry POLYGON((45.28 25.36,45.28 66.11,143.92 66.11,143.92 25.36,45.28 25.36))",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 2430 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Human Observation",
 "CoordinateUncertaintyInMeters 0.0-1000.0",
 "Geometry POLYGON((-86.02411 39.87305,-71.32437 39.87305,-71.32437 49.18289,-86.02411 49.18289,-86.02411 39.87305))",
 "TaxonKey is Vincetoxicum rossicum (Kleopow) Barbar."
 ]
}

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

description: A dataset containing 5 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Helichrysum archeri Compton"
 ]
}

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

description: A dataset containing 2392 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Abutilon fraseri (Hook.) Walp."
 ]
}

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

description: A dataset containing 16653 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Epidalea calamita (Laurenti, 1768)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 238 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Acanthodactylus pardalis (Lichtenstein, 1823)"
 ]
}

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

description: A dataset containing 334 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Allium flavescens Besser",
 "HasCoordinate is true",
 "Continent is Europe",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 2000",
 "CoordinateUncertaintyInMeters is less than 10000"
 ]
}

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

description: A dataset containing 108 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Mexipyrgus churinceanus D.W.Taylor, 1966",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 207 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Anilios hamatus (Storr, 1981)"
 ]
}

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

description: A dataset containing 3 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cestrum chiapense Brandegee",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 15386 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Leontopodium nivale subsp. alpinum (Cass.) Greuter"
 ]
}

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

description: A dataset containing 5271 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is one of (Human Observation, Material sample, Material citation, Specimen, Fossil, Living Specimen, Occurrence evidence)",
 "Country is Canada",
 "GadmGid is CAN.2_1",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Amelanchier alnifolia (Nutt.) Nutt.",
 "Year 2000-2024"
 ]
}

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

description: A dataset containing 57 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Acalypha acrogyna Pax"
 ]
}

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

description: A dataset containing 40 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Polaskia chende (Rol.-Goss.) A.C.Gibson & K.E.Horak",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 93 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Hermannia amabilis Marloth ex K.Schum."
 ]
}

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

description: A dataset containing 19 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Hypothenemus hampei Ferrari, 1867"
 ]
}

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

description: A dataset containing 27 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Abutilon galpinii A.Meeuse"
 ]
}

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

description: A dataset containing 1 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Heliotropium makranicum Rech.fil. & Esfand."
 ]
}

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

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

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

description: A dataset containing 67 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Acacia octonervia R.S.Cowan & Maslin"
 ]
}

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

description: A dataset containing 6 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Gravesia hederoides H.Perrier"
 ]
}

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

description: A dataset containing 42 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Quercus hintonii E.F.Warb.",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 18 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cocconeis C.G.Ehrenberg, 1837",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "BasisOfRecord is one of (Specimen, Living Specimen, Observation, Human Observation, Machine Observation, Material sample, Literature Occurrence, Material citation, Occurrence evidence)",
 "Geometry POLYGON ((35.5808 -24.13,35.5909 -24.0715,30.5701 -24.0715,30.5701 -28.5786,32.4847 -28.5786,32.55 -28.5222,33.0346 -26.8668,32.9741 -26.7838,33.0415 -26.059,32.9304 -26.0011,32.7994 -26.1281,32.6834 -26.0015,32.813 -25.8728,32.8513 -25.7166,33.3048 -25.3731,35.1489 -24.6699,35.5808 -24.13))"
 ]
}

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

description: A dataset containing 60 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Human Observation",
 "Geometry POLYGON((-17.01002 41.47349,1.75232 41.47349,1.75232 50.73747,-17.01002 50.73747,-17.01002 41.47349))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Orcinus orca (Linnaeus, 1758)",
 "Year 1994-2025"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Eleocharis caduca (Delile) Schult.",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "BasisOfRecord is one of (Specimen, Living Specimen, Observation, Human Observation, Machine Observation, Material sample, Literature Occurrence, Material citation, Occurrence evidence)",
 "Geometry POLYGON ((18.2339 -32.5266,18.1411 -32.657,18.1007 -32.7021,18.0224 -32.6366,17.8923 -32.6419,17.754 -32.8255,17.7723 -32.9007,20.509 -32.9007,20.509 -28.5786,16.2782 -28.5786,16.4358 -28.7202,16.726 -29.1235,17.1957 -30.3752,17.6655 -31.1743,18.1322 -31.7679,18.2495 -32.2638,18.2339 -32.5266))"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0042680-250525065834625/datasets/export for details.
DOI: 10.5284/1132551
title: Site Images from an Archaeological Field Evaluation at Eckland Lodge Farm, Desborough Road, Braybrooke, Northamptonshire, March 2016

description: This collection consists of site images from an archaeological field evaluation at Eckland Lodge Farm, Desborough Road, Braybrooke, Northamptonshire, undertaken in March 2016 by University of Leicester Archaeological Services (ULAS). The archaeological field evaluation revealed limited evidence for medieval cultivation practice in in the form of several plough furrows in addition to a single undated pit or post hole.
DOI: 10.15468/dl.trst49
title: Occurrence Download

description: A dataset containing 4 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cocconeis C.G.Ehrenberg, 1837",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "BasisOfRecord is one of (Specimen, Living Specimen, Observation, Human Observation, Machine Observation, Material sample, Literature Occurrence, Material citation, Occurrence evidence)",
 "Geometry POLYGON ((31.8862 -21.3285,30.5701 -20.3186,30.5701 -24.0715,35.5909 -24.0715,35.6007 -24.0157,35.6007 -23.8125,35.4969 -23.7035,35.6007 -23.165,35.6007 -22.9702,35.227 -22.2482,34.6862 -21.6944,34.013 -21.3095,33.5 -21.1593,32.9675 -21.1092,32.4352 -21.1612,31.8862 -21.3285))"
 ]
}

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

description: A dataset containing 261339 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Briza media L.",
 "OccurrenceStatus is Present",
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "Year is greater than or equal to 1900",
 "Year is less than or equal to 2010"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Eleocharis caduca (Delile) Schult.",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "BasisOfRecord is one of (Specimen, Living Specimen, Observation, Human Observation, Machine Observation, Material sample, Literature Occurrence, Material citation, Occurrence evidence)",
 "Geometry POLYGON ((15.6372 -28.0032,16.2782 -28.5786,20.509 -28.5786,20.509 -24.0715,15.4933 -24.0715,15.4945 -24.1257,16.0509 -25.6631,15.6372 -28.0032))"
 ]
}

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

description: A dataset containing 222 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.countrycode = 'NR'
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence."year" &gt;= 2000 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 222 records were derived from 12 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0042673-250525065834625/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.cy8ppm
title: Occurrence Download

description: A dataset containing 1231 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Dendroctonus ponderosae Hopkins, 1902"
 ]
}

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

description: A dataset containing 2488 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.countrycode = 'CC'
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence."year" &gt;= 2000 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 2488 records were derived from 35 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0042670-250525065834625/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.