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

description: A dataset containing 74380 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Saxicola torquatus (Linnaeus, 1766), Saxifraga aquatica Lapeyr.)",
 "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 74380 records from 440 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0252408-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.qqfncc
title: Occurrence Download

description: A dataset containing 288 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Cabassous unicinctus (Linnaeus, 1758))",
 "BasisOfRecord is one of (Specimen, Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 288 records from 32 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0066677-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-10821
title: Put' = Voie = [The way], no. 19 (November 1929)

description: [description english/roman)] Irregular frequency
DOI: 10.15468/dl.asm5zy
title: Occurrence Download

description: A dataset containing 14226 species occurrences available in GBIF matching the query:
{
 "and" : [
 "CoordinateUncertaintyInMeters 0.0-1000.0",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Callicarpa americana L.",
 "Year 2012-2022"
 ]
}

 The dataset includes 14226 records from 6 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0362566-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-10120
title: Put' = Voie = [The way], no. 13 (October 1928)

description: [description english/roman)] Irregular frequency
DOI: 10.15468/dl.hjsa5d
title: Occurrence Download

description: A dataset containing 213 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Cyclopes didactylus (Linnaeus, 1758))",
 "BasisOfRecord is one of (Specimen, Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 10882 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Saxifraga cuneata Willd., Saxifraga serpyllifolia Pursh, Saxifraga exarata Vill.)",
 "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 10882 records from 78 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0252435-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-11462
title: Put' = Voie = [The way], no. 24 (October 1930)

description: [description english/roman)] Irregular frequency
DOI: 10.15468/dl.27ru7s
title: Occurrence Download

description: A dataset containing 1557 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Euphorbia chamaesyce L.",
 "HasCoordinate is true",
 "Year is greater than or equal to 1900",
 "BasisOfRecord is one of (Human Observation, Specimen, Unknown evidence)"
 ]
}

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

description: A dataset containing 285 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Pseudo-nitzschia granii (G.R.Hasle) G.R.Hasle, 1974"
 ]
}

 The dataset includes 285 records from 7 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0068178-220831081235567/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-11420
title: Put' = Voie = [The way], no. 24 (October 1930)

description: [description english/roman)] Irregular frequency
DOI: 10.15468/dl.xhy72s
title: Occurrence Download

description: A dataset containing 1422618 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "Country is one of (United States of America, Mexico, Canada)",
 "Year is greater than 1978",
 "Year is less than 2014",
 "HasGeospatialIssue is false",
 "TaxonKey is Columba livia J.F.Gmelin, 1789"
 ]
}

 The dataset includes 1422618 records from 84 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0066671-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-11460
title: Put' = Voie = [The way], no. 24 (October 1930)

description: [description english/roman)] Irregular frequency
DOI: 10.15468/dl.7yztfz
title: Occurrence Download

description: A dataset containing 103 species occurrences available in GBIF matching the query:
{
 "Geometry" : [
 "POLYGON((153.15268 -32.57678,153.17225 -32.58639,153.16572 -32.56373,153.16195 -32.56202,153.15268 -32.57678))"
 ]
}

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

description: A dataset containing 1 species occurrences available in GBIF matching the query:
{
 "and" : [
 "VerbatimScientificName is one of (Cladonia rangiformis, Undaria pinnatifida)",
 "BasisOfRecord is one of (Specimen, Human Observation, Observation, Machine Observation)",
 "Country is one of (Canada)",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2001",
 "Year is less than or equal to 2020",
 "CoordinateUncertaintyInMeters is less than 1000",
 "ScientificName is not null",
 "DecimalLongitude is not null",
 "DecimalLatitude is not null"
 ]
}

 The dataset includes 1 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0009817-240425142415019/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-13280
title: Put' = Voie = [The way], no. 42 (January-March 1934)

description: [description english/roman)] Irregular frequency
DOI: 10.15468/dl.6rs34z
title: Occurrence Download

description: A dataset containing 9 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Ruellia pulverulenta Leonard"
 ]
}

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

description: A dataset containing 20863 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "Country is Albania",
 "Country is Andorra",
 "Country is Bosnia and Herzegovina",
 "Country is Holy See",
 "Country is Croatia",
 "Country is Slovenia",
 "Country is Spain",
 "Country is Greece",
 "Country is Italy",
 "Country is North Macedonia",
 "Country is Malta",
 "Country is Montenegro",
 "Country is Portugal",
 "Country is San Marino",
 "Country is Serbia",
 "Country is Denmark",
 "Country is Estonia",
 "Country is Finland",
 "Country is Ireland",
 "Country is Iceland",
 "Country is Latvia",
 "Country is Lithuania",
 "Country is Norway",
 "Country is United Kingdom of Great Britain and Northern Ireland",
 "Country is Sweden",
 "Country is Germany",
 "Country is Austria",
 "Country is Slovakia",
 "Country is Hungary",
 "Country is Liechtenstein",
 "Country is Luxembourg",
 "Country is Poland",
 "Country is Czechia",
 "Country is Romania",
 "Country is Switzerland"
 ]
 },
 "DatasetKey is iNaturalist Research-grade Observations",
 "TaxonKey is Carabidae"
 ]
}

 The dataset includes 20863 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0362568-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-ouc11210146
title: Put' = Voie = [The way], no. 33 (April 1932)

description: [description english/roman)] Irregular frequency
DOI: 10.15468/dl.4b6nrk
title: Occurrence Download

description: A dataset containing 103 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Ingerophrynus galeatus (Günther, 1864))",
 "BasisOfRecord is one of (Specimen, Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 103 records from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0066830-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-5952
title: Baptist Ukrainy = [Ukrainian Baptist], no. 4 ([April] 1928)

description: [description english/roman)] Monthly
DOI: 10.15468/dl.u3654n
title: Occurrence Download

description: A dataset containing 538 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Caesio lunaris Cuvier, 1830"
 ]
}

 The dataset includes 538 records from 57 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0031889-220831081235567/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/pcra-c14-5963
title: Baptist Ukrainy = [Ukrainian Baptist], no. 4 ([April] 1928)

description: [description english/roman)] Monthly
DOI: 10.15468/dl.b7b79h
title: Occurrence Download

description: A dataset containing 756 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Mesophylla macconnelli Thomas, 1901)",
 "BasisOfRecord is one of (Specimen, Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 43114 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Saxifraga aizoides L., Saxifraga cespitosa L., Saxifraga sedoides L.)",
 "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 43114 records from 173 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0252415-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.tigaw2
title: Occurrence Download

description: A dataset containing 71 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Boa constrictor Linnaeus, 1758",
 "HasCoordinate is true",
 "Geometry POLYGON((-78.222656 1.142502,-70.224609 2.372368,-67.324218 2.196727,-63.896484 3.951940,-61.611328 6.315298,-60.117187 7.536764,-58.886718 7.100892,-56.689453 6.140554,-53.789062 5.790896,-51.152343 4.390228,-50.361328 2.021065,-47.988281 -2.021065,-49.746093 -7.188100,-54.931640 -12.297068,-60.292968 -12.382928,-67.851562 -14.689881,-75.761718 -12.554563,-78.574218 -9.449061,-80.947265 -5.003394,-80.595703 -1.845383,-80.244140 0.615222,-78.222656 1.142502))"
 ]
}

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

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

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

description: A dataset containing 2453 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Specimen",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Andropogon gerardii Vitman"
 ]
}

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

description: A dataset containing 7076556 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is Great Backyard Bird Count"
 ]
}

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

description: A dataset containing 25 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Griffinia nocturna Ravenna"
 ]
}

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

description: A dataset containing 2293 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Brazil",
 "TaxonKey is Braconidae"
 ]
}

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

description: A dataset containing 10127 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Rubus idaeus L.",
 "MediaType is Image",
 "BasisOfRecord is Human Observation"
 ]
}

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

description: A dataset containing 1266 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "or" : [
 "Country is Japan",
 "Country is Russian Federation"
 ]
 },
 "CoordinateUncertaintyInMeters 0.0-10000.0",
 "Geometry POLYGON((125 28.583,151.583 28.583,151.583 57.083,125 57.083,125 28.583))",
 "HasCoordinate is true",
 "TaxonKey is Reptilia",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 13 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Paronychia johnstonii Chaudhri"
 ]
}

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

description: A dataset containing 8798 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Polypedates leucomystax (Gravenhorst, 1829))",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 397 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-91.57104 42.39101,-87.61597 42.39101,-87.61597 44.21371,-91.57104 44.21371,-91.57104 42.39101))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Peromyscus leucopus (Rafinesque, 1818)"
 ]
}

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

description: A dataset listing the 974905 species recorded in GBIF matching the query:
{
 "TaxonKey" : [
 "is Plantae"
 ]
}

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

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