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

description: A dataset containing 135 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Thomasomys paramorum Thomas, 1898"
 ]
}

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

description: A dataset containing 4 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-8.39697 17.25138,110.39697 17.25138,110.39697 64.74862,-8.39697 64.74862,-8.39697 17.25138))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Mycoarthris Marvanová & P.J.Fisher"
 ]
}

 The dataset includes 4 records from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0422145-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.etgef8
title: Occurrence Download

description: A dataset containing 31 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ceropegia mayottae H.Huber"
 ]
}

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

description: A dataset containing 10542 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Pantherophis alleghaniensis (Holbrook, 1836)"
 ]
}

 The dataset includes 10542 records from 47 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218953-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.jznhzf
title: Occurrence Download

description: A dataset containing 42 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ceropegia media (H.Huber) Ansari"
 ]
}

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

description: A dataset containing 109689 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Empidonax wrightii S.F.Baird, 1858"
 ]
}

 The dataset includes 109689 records from 110 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218954-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.4e9xyb
title: Occurrence Download

description: A dataset containing 163765 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Henicorhina leucophrys (Tschudi, 1844)"
 ]
}

 The dataset includes 163765 records from 204 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218959-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.u44gvr
title: Occurrence Download

description: A dataset containing 74 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ceropegia attenuata Hook."
 ]
}

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

description: A dataset containing 1 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ceropegia mendesii Stopp"
 ]
}

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

description: A dataset containing 2617 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-9.5023 41.17012,-7.58715 41.19419,-7.59493 42.21995,-9.50692 42.1553,-9.5023 41.17012))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Mollusca",
 "Year 1000-2022"
 ]
}

 The dataset includes 2617 records from 29 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218965-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.ah85d9
title: Occurrence Download

description: A dataset containing 347 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Macropanax rosthornii (Harms) C.Y.Wu ex G.Hoo"
 ]
}

 The dataset includes 347 records from 17 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0015801-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.pu8kuf
title: Occurrence Download

description: A dataset containing 200 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-9.5023 41.17012,-7.58715 41.19419,-7.59493 42.21995,-9.50692 42.1553,-9.5023 41.17012))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Chaetognatha",
 "Year 1000-2022"
 ]
}

 The dataset includes 200 records from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218970-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.tch4m5
title: Occurrence Download

description: A dataset containing 2 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Specimen",
 "DatasetKey is Field Museum of Natural History (Botany) Seed Plant Collection",
 "Geometry POLYGON((-106.32104 35.6173,-106.36441 35.54092,-106.48158 35.39031,-106.59964 35.27978,-106.58965 35.2383,-106.63917 35.2068,-106.6928 35.13097,-106.69165 35.09283,-106.66303 35.07031,-106.65987 35.05811,-106.6735 35.03657,-106.67555 35.0164,-106.68785 35.00507,-106.69103 34.978,-106.68282 34.92655,-106.72295 34.86561,-106.71474 34.81404,-106.75572 34.71144,-106.73935 34.64725,-106.7471 34.59736,-106.77128 34.57633,-106.76588 34.54674,-106.7961 34.52179,-106.81059 34.44249,-106.80498 34.41126,-106.86165 34.34518,-106.84231 34.29296,-106.87505 34.26049,-106.89469 34.25779,-106.89962 34.22957,-106.87975 34.1419,-106.88907 34.11977,-106.87176 34.07892,-106.87158 34.00904,-106.86314 34.08348,-106.88574 34.12034,-106.87647 34.14844,-106.89282 34.25494,-106.85632 34.26044,-106.83741 34.28585,-106.85731 34.34221,-106.79559 34.41214,-106.80175 34.47746,-106.79014 34.52095,-106.76398 34.53641,-106.76602 34.57509,-106.74136 34.59547,-106.73626 34.64165,-106.7483 34.70887,-106.70638 34.81291,-106.71899 34.86343,-106.67521 34.9183,-106.68613 34.97369,-106.67241 35.00775,-106.66642 35.03855,-106.65462 35.0595,-106.65708 35.07016,-106.69009 35.10102,-106.6383 35.19997,-106.58334 35.23862,-106.59489 35.28159,-106.47946 35.3848,-106.35784 35.54212,-106.32104 35.6173))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Plantae"
 ]
}

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

description: A dataset containing 158 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is Mamíferos colectados en expedición al Río Apaporis - Proyecto Colombia BIO"
 ]
}

 The dataset includes 158 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0422851-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.8nygsr
title: Occurrence Download

description: A dataset containing 73 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ceropegia multiflora Baker"
 ]
}

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

description: A dataset containing 64 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-9.5023 41.17012,-7.58715 41.19419,-7.59493 42.21995,-9.50692 42.1553,-9.5023 41.17012))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Bryozoa",
 "Year 1000-2022"
 ]
}

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

description: A dataset containing 128 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ceropegia candelabrum L."
 ]
}

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

description: A dataset containing 1451 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "BasisOfRecord is Human Observation",
 "BasisOfRecord is Specimen"
 ]
 },
 "Geometry POLYGON((-91.58203 3.86719,-82.44141 -28.47656,-55.72266 -24.96094,-56.77734 24.96094,-91.58203 3.86719))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Tremarctos ornatus (F.G.Cuvier, 1825)"
 ]
}

 The dataset includes 1451 records from 42 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0273604-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.3dgjvf
title: Occurrence Download

description: A dataset containing 2130 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Flaveria trinervia (Spreng.) C.Mohr",
 "HasCoordinate is true"
 ]
}

 The dataset includes 2130 records from 109 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0013914-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.8d8hpa
title: Occurrence Download

description: A dataset containing 11413 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-75.18958 5.70363,-72.69454 5.73772,-72.66046 9.15987,-75.18958 9.15987,-75.18958 5.70363))",
 "HasCoordinate is true",
 "TaxonKey is Lepidoptera",
 "Year 1000-2018"
 ]
}

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

description: A dataset containing 6809 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Bombina bombina (Linnaeus, 1761)",
 "HasCoordinate is true",
 "Year is greater than or equal to 2011",
 "Year is less than or equal to 2024"
 ]
}

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

description: A dataset listing the 249 species recorded in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "PublishingCountry is Colombia",
 {
 "and" : [
 "Country is Colombia",
 {
 "not" : {
 "Issue" : [
 "is Country coordinate mismatch"
 ]
 }
 }
 ]
 }
 ]
 },
 {
 "and" : [
 "Year 2007-2022",
 "StateProvince is one of (meta)",
 "TaxonKey is one of (Nymphalidae)"
 ]
 }
 ]
}

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

description: A dataset containing 3777 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Human Observation",
 "Country is Brazil",
 "TaxonKey is Elaenia mesoleuca (Deppe, 1830)"
 ]
}

 The dataset includes 3777 records from 5 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0273590-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.5bxhyx
title: Occurrence Download

description: A dataset containing 8627788 species occurrences available in GBIF matching the query:
(Query is too complex. Can be viewed on the landing page)

 The dataset includes 8627788 records from 1155 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0273561-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.15282375
title: Supplementary data for gorder
DOI: 10.5281/zenodo.15647606
title: MRDD

description: MRDD is a road defect dataset collected using drones and smartphones, covering a wide range of pavement structures and various types of defects.
DOI: 10.5281/zenodo.15647607
title: MRDD

description: MRDD is a road defect dataset collected using drones and smartphones, covering a wide range of pavement structures and various types of defects.
DOI: 10.5281/zenodo.15647990
title: Supplementary data for gorder
DOI: 10.15468/dl.8mne5m
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Achnanthes standeri Cholnoky, 1957",
 "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.6306 -23.844,35.6007 -23.8125,35.6007 -24.0157,35.6306 -23.844))"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Sphaeroclinium nigellifolium (DC.) Sch.Bip.",
 "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 ((25.0214 -34.0501,25.5395 -34.1098,25.5395 -32.9007,20.509 -32.9007,20.509 -34.5676,20.524 -34.555,20.8859 -34.5419,20.9606 -34.4398,21.2995 -34.5131,21.5296 -34.4338,21.8696 -34.4439,22.0323 -34.2835,22.221 -34.2428,22.2566 -34.1304,22.5993 -34.0741,22.9652 -34.1674,23.4069 -34.1858,23.4955 -34.0792,23.6056 -34.0563,24.8471 -34.2877,24.9447 -34.2397,25.0214 -34.0501))"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038174-250525065834625/datasets/export for details.
DOI: 10.5281/zenodo.15648022
title: SAKAN
DOI: 10.5281/zenodo.15648023
title: SAKAN
DOI: 10.7910/dvn/i8mvah
title: Publics’ Perception of Corporate National Responsibility (CNR) in China

description: The Study1 adopted a nationwide online survey assessing Chinese public perceptions of CNR and CSR, exploring the CR paradigm's relevance in China. This foundational study sets the stage for a deeper examination of CNR and CSR dynamics within the Chinese context.

Study 2 adopts a 2*2*3 mixed factorial design online experiment, with two between-group factors: CR strategy (CNR vs. CSR dispute-response) and crisis type (preventable vs. victim crisis); and one within-group factor: time, which includes pre-response, post-response (or pre-crisis), and post-crisis phases.
DOI: 10.15468/dl.u7wkxw
title: Occurrence Download

description: A dataset containing 3 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is one of (Human Observation, Machine Observation)",
 "Geometry POLYGON((-7.83657 38.82283,-6.79929 38.81466,-6.8081 39.49147,-7.77759 39.52578,-7.83657 38.82283))",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Capreolus capreolus (Linnaeus, 1758)",
 "Year 2012-2025"
 ]
}

 The dataset includes 3 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038176-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.a5jk5a
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Sphaeroclinium nigellifolium (DC.) Sch.Bip.",
 "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 ((32.064 -28.9416,32.4847 -28.5786,30.5701 -28.5786,30.5701 -30.7329,30.6252 -30.6659,31.4179 -29.4257,31.8178 -29.0299,32.064 -28.9416))"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Achnanthes subaffinis Cholnoky, 1959",
 "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 ((30.0251 -31.3959,30.5701 -30.7329,30.5701 -28.5786,25.5395 -28.5786,25.5395 -32.9007,28.2048 -32.9007,28.5753 -32.6569,29.4902 -31.7517,30.0251 -31.3959))"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038180-250525065834625/datasets/export for details.
DOI: 10.34740/kaggle/dsv/12142108
title: Peer-to-Peer Boliviano (BOB) Exchange Data
DOI: 10.15468/dl.3z3ptu
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Sphaeroclinium nigellifolium (DC.) Sch.Bip.",
 "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 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038182-250525065834625/datasets/export for details.
DOI: 10.15468/dl.rajrbh
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Achnanthes subaffinis Cholnoky, 1959",
 "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 ((30.5701 -24.0715,25.5395 -24.0715,25.5395 -28.5786,30.5701 -28.5786,30.5701 -24.0715))"
 ]
}

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

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