cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.15468/frrdmn
title: Flora Helvetica - Linderniaceae

description: This dataset contains the digitized treatments in Plazi based on the original book chapter Konrad Lauber, Gerhart Wagner, Andreas Gygax (2018): Flora Helvetica - Linderniaceae. In: Flora Helvetica. Bern: Haupt Verlag: 926, ISBN: 978-3-258-08047-5
DOI: 10.15468/dl.tdt9ys
title: Occurrence Download

description: A dataset containing 91 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Cameroon",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 292 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Colombia",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 2271 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Brazil",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 992 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Cordia dichotoma",
 "Geometry POLYGON((119.300000 20.500000, 122.100000 20.500000, 122.100000 25.400000, 119.300000 25.400000, 119.300000 20.500000))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

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

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

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

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

description: A dataset containing 6 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Cook Islands",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 132 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is El Salvador",
 "HasCoordinate is true"
 ]
}

 The dataset includes 132 records from 9 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023253-250920141307145/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.6084/m9.figshare.30225790
title: Growing Tibetan Pigs Adapt to High-Fiber Diets by Enhancing Fiber Degradation Capacity

description: The systematic analysis of the synergistic mechanism between microbial fiber-degrading enzymes and short-chain fatty acids under high-fiber diet conditions is limited. In this study, we evaluated the effects of a high-fiber diet on the growth performance, nutrient digestibility, blood and serum metrics, cellulase/hemicellulase activity, and fecal microbial composition of growing Tibetan pigs. Forty Tibetan pigs were allocated to a control group (CON, 5% crude fiber) or a high-fiber group (HF, 10% crude fiber) based on crude fiber levels as a blocking factor. The pre-trial period was 7 d, and the formal trial lasted 28 d. The HF group showed significantly higher fecal cellulase and hemicellulase activities than those of the CON group (P &lt; 0.05). Additionally, the HF group showed significantly elevated levels of acetic, propionic, and butyric acids, as well as increased relative abundances of Fibrobacter and p-75-a5 in the feces (P &lt; 0.05). The correlation analysis revealed that Fibrobacter exhibited significant positive correlations with acetic acid, butyric acid, cellulase, and hemicellulase, whereas p-75-a5 was significantly positively correlated with hemicellulase (P &lt; 0.05). In conclusion, this study revealed that a high-fiber diet significantly enhanced short-chain fatty acid production in Tibetan pigs by selectively enriching obligate fiber-degrading bacteria and upregulating key fiber-digesting enzymes.
DOI: 10.6084/m9.figshare.30225790.v1
title: Growing Tibetan Pigs Adapt to High-Fiber Diets by Enhancing Fiber Degradation Capacity

description: The systematic analysis of the synergistic mechanism between microbial fiber-degrading enzymes and short-chain fatty acids under high-fiber diet conditions is limited. In this study, we evaluated the effects of a high-fiber diet on the growth performance, nutrient digestibility, blood and serum metrics, cellulase/hemicellulase activity, and fecal microbial composition of growing Tibetan pigs. Forty Tibetan pigs were allocated to a control group (CON, 5% crude fiber) or a high-fiber group (HF, 10% crude fiber) based on crude fiber levels as a blocking factor. The pre-trial period was 7 d, and the formal trial lasted 28 d. The HF group showed significantly higher fecal cellulase and hemicellulase activities than those of the CON group (P &lt; 0.05). Additionally, the HF group showed significantly elevated levels of acetic, propionic, and butyric acids, as well as increased relative abundances of Fibrobacter and p-75-a5 in the feces (P &lt; 0.05). The correlation analysis revealed that Fibrobacter exhibited significant positive correlations with acetic acid, butyric acid, cellulase, and hemicellulase, whereas p-75-a5 was significantly positively correlated with hemicellulase (P &lt; 0.05). In conclusion, this study revealed that a high-fiber diet significantly enhanced short-chain fatty acid production in Tibetan pigs by selectively enriching obligate fiber-degrading bacteria and upregulating key fiber-digesting enzymes.
DOI: 10.15468/dl.ttarme
title: Occurrence Download

description: A dataset containing 588 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Coriaria japonica",
 "Geometry POLYGON((119.300000 20.500000, 122.100000 20.500000, 122.100000 25.400000, 119.300000 25.400000, 119.300000 20.500000))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 588 records from 10 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023254-250920141307145/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.6084/m9.figshare.29974183.v1
title: Divergences christologiques dans les néo-mouvements religieux africains du Sud-Kivu.pdf

description: Cette étude analyse deux néomouvements religieux du Sud-Kivu en République Démocratique du Congo : l’Église de Dieu des Ancêtres au Congo - CREDA et la Communauté de Réveil de Dieu des Ancêtres - CREDA
DOI: 10.15468/dl.rg2gvh
title: Occurrence Download

description: A dataset containing 78 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Guatemala",
 "HasCoordinate is true"
 ]
}

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

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

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

description: A dataset containing 98 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Honduras",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 43 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Alangium chinense",
 "Geometry POLYGON((119.300000 20.500000, 122.100000 20.500000, 122.100000 25.400000, 119.300000 25.400000, 119.300000 20.500000))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 288 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Madagascar",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 31 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Mauritius",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 9 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Mozambique",
 "HasCoordinate is true"
 ]
}

 The dataset includes 9 records from 3 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023262-250920141307145/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.6084/m9.figshare.30225880
title: Supplementary table 1

description: Clinical characteristics, genetic findings, and perinatal outcomes of 262 fetal ROH cases.
DOI: 10.6084/m9.figshare.30225880.v1
title: Supplementary table 1

description: Clinical characteristics, genetic findings, and perinatal outcomes of 262 fetal ROH cases.
DOI: 10.15468/dl.64p3vd
title: Occurrence Download

description: A dataset containing 24 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Hellenia speciosa",
 "Geometry POLYGON((119.300000 20.500000, 122.100000 20.500000, 122.100000 25.400000, 119.300000 25.400000, 119.300000 20.500000))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 24 records from 2 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023263-250920141307145/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.6084/m9.figshare.30225928
title: Raw numerical data (image data and sequencing data are not included).

description: Numerical data of figures.
DOI: 10.6084/m9.figshare.30225928.v1
title: Raw numerical data (image data and sequencing data are not included).

description: Numerical data of figures.
DOI: 10.15468/dl.bz4jn8
title: Occurrence Download

description: A dataset containing 4 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Myanmar",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 11 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Nepal",
 "HasCoordinate is true"
 ]
}

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

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

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

description: A dataset containing 293 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Kalanchoe delagoensis",
 "Geometry POLYGON((119.300000 20.500000, 122.100000 20.500000, 122.100000 25.400000, 119.300000 25.400000, 119.300000 20.500000))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

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

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

description: A dataset containing 18 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Ludwigia octovalvis",
 "Country is Viet Nam",
 "HasCoordinate is true"
 ]
}

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

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

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

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

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

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

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