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

description: A dataset containing 3738 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Mammillaria dioica K.Brandegee"
 ]
}

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

description: A dataset containing 198 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-100.60256 15.53822,-94.75388 15.53822,-94.75388 20.5769,-99.26844 21.74425,-102.85389 20.12425,-100.60256 15.53822))",
 "OccurrenceStatus is Present",
 "TaxonKey is Crotalus intermedius Troschel, 1865"
 ]
}

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

description: A dataset containing 3854 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Czechia",
 "OccurrenceStatus is Present",
 "TaxonKey is Anura"
 ]
}

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

description: A dataset containing 15055267 species occurrences available in GBIF matching the query:
{
 "Country" : [
 "is Japan"
 ]
}

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

description: A dataset containing 63 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "Country is Korea, Republic of",
 "TaxonKey is one of (Bromus rigidus Roth)"
 ]
}

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

description: A dataset containing 3407 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Nicotiana attenuata Torr. ex S.Watson"
 ]
}

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

description: A dataset containing 62 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is Microzooplankton abundance measured on water bottle samples at station PS58/038-3"
 ]
}

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

description: A dataset containing 134 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "Country is Korea, Republic of",
 "TaxonKey is one of (Chloris virgata Sw.)"
 ]
}

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

description: A dataset containing 31 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Calliostoma hassler Clench & Aguayo, 1939",
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 {
 "not" : {
 "BasisOfRecord" : [
 "is Fossil"
 ]
 }
 },
 {
 "or" : [
 {
 "not" : {
 "EstablishmentMeans" : [
 "is MANAGED"
 ]
 }
 },
 {
 "not" : {
 "EstablishmentMeans" : [
 "is not null"
 ]
 }
 }
 ]
 },
 {
 "or" : [
 "OccurrenceStatus is Present",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is not null"
 ]
 }
 }
 ]
 }
 ]
}

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

description: A dataset containing 101921 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Specimen",
 "Year 1990-2017",
 "HasCoordinate is true",
 "TaxonKey is Caryophyllaceae",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 14 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Ptiloprora plumbea (Salvadori, 1895)"
 ]
}

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

description: A dataset containing 1552 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Calliopius laeviusculus (Krøyer, 1838)",
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 {
 "not" : {
 "BasisOfRecord" : [
 "is Fossil"
 ]
 }
 },
 {
 "or" : [
 {
 "not" : {
 "EstablishmentMeans" : [
 "is MANAGED"
 ]
 }
 },
 {
 "not" : {
 "EstablishmentMeans" : [
 "is not null"
 ]
 }
 }
 ]
 },
 {
 "or" : [
 "OccurrenceStatus is Present",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is not null"
 ]
 }
 }
 ]
 }
 ]
}

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

description: A dataset containing 2473 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Eulaema cingulata (Fabricius, 1804)"
 ]
}

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

description: A dataset containing 29 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Selasphorus ardens Salvin, 1870"
 ]
}

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

description: A dataset containing 3 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Megophrys gigantica Liu, Hu & Yang, 1960"
 ]
}

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

description: A dataset containing 2024 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Macrotus waterhousii Gray, 1843",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 60094 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is one of (Jungermanniaceae)"
 ]
}

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

description: A dataset containing 2 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Philautus tytthus Smith, 1940"
 ]
}

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

description: A dataset containing 56 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is Microzooplankton abundance measured on water bottle samples at station PS58/041-2"
 ]
}

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

description: A dataset containing 1546 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Leptasthenura yanacensis Carriker, 1933"
 ]
}

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

description: A dataset containing 32 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Astylosternus laurenti Amiet, 1978"
 ]
}

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

description: A dataset containing 26 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Echinops kotschyi Boiss."
 ]
}

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

description: A dataset containing 235 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Tremarctos ornatus (F.G.Cuvier, 1825)"
 ]
}

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

description: A dataset containing 7702 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Leucosticte nemoricola (Hodgson, 1836)"
 ]
}

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

description: A dataset containing 2 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Echinops kurdicus Bunge"
 ]
}

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

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

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

description: A dataset containing 1001 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Cinclodes pabsti Sick, 1969"
 ]
}

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

description: A dataset containing 515 species occurrences available in GBIF matching the query:
{
 "and" : [
 {
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
 },
 "TaxonKey is Thamnophilus aroyae (Hellmayr, 1904)"
 ]
}

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

description: A dataset containing 1091 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Corylus colurna L."
 ]
}

 The dataset includes 1091 records from 105 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0013062-190918142434337/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.28740278
title: Pan-genome analysis of Liriodendron reveals presence/absence variations associated with growth traits

description: In this study, we constructed a pan-genome of Liriodendron based on 24 accessions. Comparative analysis with the reference genome revealed 116 Mb of non-reference sequences and obtained 32,773 genes, including 3,558 novel genes. We subsequently employed resequencing data from 247 Liriodendron genotypes to identify PAVs, comprising 13,779 core genes and 18,179 dispensable genes. To further assess PAV applicability, a genome-wide association study (GWAS) was conducted to link gene PAVs with growth traits, including tree height (H), diameter at breast height (DBH), clear bole height (CBH), and crown length ratio (CLR), in hybrid Liriodendron. This approach identified 14 candidate genes associated with these growth traits above. Additionally, gene PAVs appeared to predominantly contribute to heterosis in growth traits, displaying a dominant expression pattern when comparing leaf, shoot, and phloem tissues of strong and weak heterotic combinations. Additionally, we identified two key candidate genes, Litul.02G164100 and Litul.01G057400, which appear to drive hybrid vigor by exhibiting high parental expression patterns in strong heterotic combinations of leaf and shoot tissues. Altogether, this study expands the Liriodendron genomic dataset, identifies candidate genes linked to growth traits, and provides insights into their heterotic mechanisms in hybrid Liriodendron. These findings offer a valuable genetic resource for molecular breeding and functional genomics research in Liriodendron.
DOI: 10.15468/dl.558f6b
title: Occurrence Download

description: A dataset containing 26696 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Blumea DC."
 ]
}

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

description: A dataset containing 728 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Aulopus filamentosus (Bloch, 1792)",
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Specimen, Material sample)"
 ]
 }
 },
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 10000",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

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

description: A dataset containing 684 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Schisandra arisanensis",
 "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 684 records from 14 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0027340-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.36qav6
title: Occurrence Download

description: A dataset containing 108 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 PRINTF('%04d-%02d', "year", "month") yearmonth,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, PRINTF('%04d-%02d', "year", "month"))) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, PRINTF('%04d-%02d', "year", "month"))) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, PRINTF('%04d-%02d', "year", "month"))) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, PRINTF('%04d-%02d', "year", "month"))) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, PRINTF('%04d-%02d', "year", "month"))) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, PRINTF('%04d-%02d', "year", "month"))) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.basisofrecord = 'PRESERVED_SPECIMEN'
 AND occurrence.countrycode = 'US'
 AND occurrence.occurrencestatus = 'PRESENT'
 AND LOWER(occurrence.stateprovince) IN (LOWER('Florida'), LOWER('FL.'), LOWER('FLA.'), LOWER('FLORIDA.'), LOWER('Fla'))
 AND (CAST(occurrence.taxonkey AS INTEGER) = 1341198 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 1341198 OR CAST(occurrence.kingdomkey AS INTEGER) = 1341198 OR CAST(occurrence.phylumkey AS INTEGER) = 1341198 OR CAST(occurrence.classkey AS INTEGER) = 1341198 OR CAST(occurrence.orderkey AS INTEGER) = 1341198 OR CAST(occurrence.familykey AS INTEGER) = 1341198 OR CAST(occurrence.genuskey AS INTEGER) = 1341198 OR CAST(occurrence.specieskey AS INTEGER) = 1341198)
 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."month" 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,
 PRINTF('%04d-%02d', "year", "month")

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