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

description: A dataset containing 1359 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is China",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Cannabis sativa L."
 ]
}

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

description: A dataset containing 1213 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Ceraclea annulicornis (Stephens, 1836), Hydropsyche guttata Pictet, 1834)",
 "Geometry POLYGON((-9.36035 44.71551,-10.59082 42.81152,-11.82129 36.80928,-7.69043 36.17336,-3.38379 35.88905,3.12012 38.13456,9.18457 38.20366,11.7334 37.16032,12.78809 34.74161,17.09473 33.79741, 23.15918 34.23451,30.10254 32.62087,33.2666 32.99024,35.72754 35.03,33.00293 35.53223,28.69629 35.17381,28.34473 36.31513,25.7959 37.50973,24.91699 39.90974,28.78418 40.6473,30.71777 41.17865,36.87012 45.213,38.18848 46.98025,38.71582 47.7541,39.94629 47.93107,40.20996 49.61071,37.0459 50.34546,35.72754 50.40152,33.79395 52.26816,31.68457 51.94426,31.4209 53.27835,32.56348 53.43572,30.98145 54.77535,30.89355 55.52863,28.43262 56.02295,27.20215 57.65716,27.37793 58.30949,27.90527 59.17593,29.66309 59.88894,27.6416 60.58697,31.50879 62.75473,28.78418 69.83962,30.89355 70.28912,29.22363 71.55274,21.75293 71.30079,14.28223 70.14036,11.38184 67.47492,4.87793 63.66576,-5.53711 71.52491,-10.63477 71.69129,-21.5332 67.74276,-28.56445 65.36684,-24.3457 61.35461,-9.36035 44.71551))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 1980",
 "Year is less than or equal to 2021"
 ]
}

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

description: A dataset containing 3937 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Acalypha wilkesiana Müll.Arg."
 ]
}

 The dataset includes 3937 records from 253 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0204106-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.f67f4w
title: Occurrence Download

description: A dataset containing 14715 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Human Observation",
 "DatasetKey is iNaturalist Research-grade Observations",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Agelaius phoeniceus (Linnaeus, 1766)",
 "Year 2011-2018"
 ]
}

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

description: A dataset containing 459 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ateles fusciceps Gray, 1866"
 ]
}

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

description: A dataset containing 11219 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Trillium pusillum var. pusillum, Cirsium wrightii A.Gray, Ligusticum canadense (L.) Britton, Ligusticum scoticum L., Physalis walteri Nutt.)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 736 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is one of (Human Observation, Specimen)",
 "Geometry POLYGON((-81.69297 -4.57026,-64.34537 -4.31242,-64.75574 5.4002,-64.93288 12.77425,-81.10145 12.82135,-81.69297 -4.57026))",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Trachemys callirostris (Gray, 1856)"
 ]
}

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

description: A dataset containing 8 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Specimen",
 "TaxonKey is Anolis megalopithecus Rueda-Almonacid, 1989"
 ]
}

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

description: A dataset containing 50 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cajanus cajanifolius (Haines) Maesen",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 61 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Crocidura nimbae Heim de Balsac, 1956"
 ]
}

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

description: A dataset containing 4 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Thorius infernalis Hanken, Wake & Freeman, 1999"
 ]
}

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

description: A dataset containing 31271 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Radula complanata (L.) Dumort., Radulomyces confluens (Fr.) M.P.Christ.)",
 "Geometry POLYGON((-9.36035 44.71551,-10.59082 42.81152,-11.82129 36.80928,-7.69043 36.17336,-3.38379 35.88905,3.12012 38.13456,9.18457 38.20366,11.7334 37.16032,12.78809 34.74161,17.09473 33.79741, 23.15918 34.23451,30.10254 32.62087,33.2666 32.99024,35.72754 35.03,33.00293 35.53223,28.69629 35.17381,28.34473 36.31513,25.7959 37.50973,24.91699 39.90974,28.78418 40.6473,30.71777 41.17865,36.87012 45.213,38.18848 46.98025,38.71582 47.7541,39.94629 47.93107,40.20996 49.61071,37.0459 50.34546,35.72754 50.40152,33.79395 52.26816,31.68457 51.94426,31.4209 53.27835,32.56348 53.43572,30.98145 54.77535,30.89355 55.52863,28.43262 56.02295,27.20215 57.65716,27.37793 58.30949,27.90527 59.17593,29.66309 59.88894,27.6416 60.58697,31.50879 62.75473,28.78418 69.83962,30.89355 70.28912,29.22363 71.55274,21.75293 71.30079,14.28223 70.14036,11.38184 67.47492,4.87793 63.66576,-5.53711 71.52491,-10.63477 71.69129,-21.5332 67.74276,-28.56445 65.36684,-24.3457 61.35461,-9.36035 44.71551))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 1980",
 "Year is less than or equal to 2021"
 ]
}

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

description: A dataset containing 548 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Paphies australis",
 "HasCoordinate is true",
 "BasisOfRecord is one of (Observation, Machine Observation, Human Observation, Occurrence evidence)",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is one of (Absent)"
 ]
 }
 }
 ]
}

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

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

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

description: A dataset containing 3 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Centaurea diluta",
 "Country is Denmark",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 466 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Paphies subtriangulata",
 "HasCoordinate is true",
 "BasisOfRecord is one of (Observation, Machine Observation, Human Observation, Occurrence evidence)",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is one of (Absent)"
 ]
 }
 }
 ]
}

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

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

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

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

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

description: A dataset containing 1129 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((83.45909 17.35146,128.12386 17.35146,128.12386 35.20972,83.45909 35.20972,83.45909 17.35146))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Eucalyptus"
 ]
}

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

description: A dataset containing 7675 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is China",
 "Year is 1915"
 ]
}

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

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

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

description: A dataset containing 208 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Betta pugnax)",
 "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 208 records from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0009191-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.vt6fh9
title: Occurrence Download

description: A dataset containing 2 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Myanmar",
 "Geometry POLYGON((79.08815 13.66882,115.39106 13.66882,115.39106 28.17135,79.08815 28.17135,79.08815 13.66882))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Tristaniopsis"
 ]
}

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

description: A dataset containing 142 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Paphies ventricosa",
 "HasCoordinate is true",
 "BasisOfRecord is one of (Observation, Machine Observation, Human Observation, Occurrence evidence)",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is one of (Absent)"
 ]
 }
 }
 ]
}

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

description: A dataset containing 228 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is one of (Human Observation, Material sample, Specimen, Occurrence evidence)",
 "PublishingOrg is one of (4f1aa16c-ac1f-4e25-95fa-70bd71b7a0b4, 396d5f30-dea9-11db-8ab4-b8a03c50a862, ad3f9c5f-5021-45a3-a7c4-3e64895f6f79, 1928bdf0-f5d2-11dc-8c12-b8a03c50a862, f121e450-78ba-11d8-a19c-b8a03c50a862, ada9d123-ddb4-467d-8891-806ea8d94230, b3bf3a83-1f68-4541-a03f-330d30d567f5, ff90b050-c256-11db-b71b-b8a03c50a862, 954e32db-634d-4d5f-908c-3d14c961b097)",
 "TaxonKey is Hypothenemus hampei"
 ]
}

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

description: A dataset containing 61 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Centaurea diluta",
 "Country is France",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 69 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Centaurea diluta",
 "Country is Netherlands",
 "HasCoordinate is true"
 ]
}

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

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

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Arenomya arenaria",
 "HasCoordinate is true",
 "BasisOfRecord is one of (Observation, Machine Observation, Human Observation, Occurrence evidence)",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is one of (Absent)"
 ]
 }
 }
 ]
}

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

description: A dataset containing 10269 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is China",
 "Year is 1916"
 ]
}

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

description: A dataset containing 54 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Zygochlamys delicatula",
 "Year 2000-2025"
 ]
}

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

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

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

description: A dataset containing 462 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Zygochlamys patagonica",
 "Year 2000-2025"
 ]
}

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

description: A dataset containing 13865 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Mya truncata",
 "HasCoordinate is true",
 "BasisOfRecord is one of (Observation, Machine Observation, Human Observation, Occurrence evidence)",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is one of (Absent)"
 ]
 }
 }
 ]
}

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

description: A dataset containing 39910 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 = 'NA'
 AND 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 39910 records were derived from 255 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0009172-250914085247600/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.