cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.1594/pangaea.983494
title: Seawater carbonate chemistry and survival of different members in Antarctic macroalgal-associated amphipod assemblages

description: To assess how long-term acidification may influence the survival of different members in Antarctic macroalgal-associated amphipod assemblages, mesograzers, particularly amphipods, associated with the brown alga Desmarestia menziesii were collected from the immediate vicinity of Palmer Station, Antarctica (S64°46′, W64°03′) in January 2020 and maintained under three different pH treatments simulating ambient conditions (approximately pH 8.1), near-future conditions for 2100 (pH 7.7), and distant future conditions (pH 7.3) for 52 days then enumerated.This dataset is included in the OA-ICC data compilation maintained in the framework of the IAEA Ocean Acidification International Coordination Centre (see https://oa-icc.ipsl.fr). Original data were downloaded from U.S. Antarctic Program Data Center (see Source) by the OA-ICC data curator. In order to allow full comparability with other ocean acidification data sets, the R package seacarb (Gattuso et al, 2024) was used to compute a complete and consistent set of carbonate system variables, as described by Nisumaa et al. (2010). In this dataset the original values were archived in addition with the recalculated parameters (see related PI). The date of carbonate chemistry calculation by seacarb is 2025-07-02.
DOI: 10.1594/pangaea.983617
title: Seawater carbonate chemistry and photosynthetic carbon fixation rates and grazing rates of mixotrophic protists

description: We studied responses to simulated ocean acidification in three strains of the mixotrophic chrysophyte Ochromonas (CCMP1391, CCMP2951, and CCMP1393). After acclimatization of the strains to treatment with high-CO2 (1000 ppm, pH 7.9) and low-CO2 concentrations (350 ppm, pH 8.3), strains CCMP1393 and CCMP2951 both exhibited higher growth rates in response to the high-CO2 treatment. In terms of the balance between phototrophic and heterotrophic metabolism, diverse responses were observed.This dataset is included in the OA-ICC data compilation maintained in the framework of the IAEA Ocean Acidification International Coordination Centre (see https://oa-icc.ipsl.fr). Original data were downloaded from Figshare (see Source) by the OA-ICC data curator. In order to allow full comparability with other ocean acidification data sets, the R package seacarb (Gattuso et al, 2024) was used to compute a complete and consistent set of carbonate system variables, as described by Nisumaa et al. (2010). In this dataset the original values were archived in addition with the recalculated parameters (see related PI). The date of carbonate chemistry calculation by seacarb is 2025-07-03.
DOI: 10.15468/dl.rgnmn3
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "BasisOfRecord is one of (Human Observation, Machine Observation, Occurrence evidence, Observation)",
 "TaxonKey is one of (Piaya cayana)",
 "Country is one of (Afghanistan, Armenia, Azerbaijan, Bahrain, Bangladesh, Bhutan, Brunei Darussalam, Cambodia, China, Cyprus, Georgia, Hong Kong, India, Indonesia, Iran (Islamic Republic of), Iraq, Israel, Japan, Jordan, Kazakhstan, Korea (Democratic People’s Republic of), Korea, Republic of, Kuwait, Kyrgyzstan, Lao People’s Democratic Republic, Lebanon, Macao, Malaysia, Maldives, Mongolia, Myanmar, Nepal, Oman, Pakistan, Palestine, State of, Philippines, Qatar, Saudi Arabia, Singapore, Sri Lanka, Syrian Arab Republic, Tajikistan, Thailand, Timor-Leste, Türkiye, Turkmenistan, United Arab Emirates, Uzbekistan, Viet Nam, Yemen)"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0022825-250802193616735/datasets/export for details.
DOI: 10.1594/pangaea.983649
title: Basic measurements of radiation at station Lampedusa (2025-04)

description: From 18 April at 7:21 UT to 26 April at 21:43 UT shutdown of all the instruments and PC for extraordinary maintenance at the observatory.
DOI: 10.15468/dl.dy34p9
title: Occurrence Download

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

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

description: A dataset containing 11 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Garra mcclellandi)",
 "BasisOfRecord is one of (Specimen, Literature Occurrence, Human Observation, Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 1991",
 "Year is less than or equal to 2025"
 ]
}

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

description: A dataset containing 2101 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Larvivora sibilans",
 "Country is China",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "BasisOfRecord is one of (Human Observation, Machine Observation, Occurrence evidence, Observation)",
 "TaxonKey is one of (Piaya cayana)",
 "Country is one of (Åland Islands, Albania, Andorra, Austria, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Czechia, Denmark, Estonia, Faroe Islands, Finland, France, Germany, Gibraltar, Greece, Guernsey, Holy See, Hungary, Iceland, Ireland, Isle of Man, Italy, Jersey, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Moldova, Republic of, Monaco, Montenegro, Netherlands, North Macedonia, Norway, Poland, Portugal, Romania, Russian Federation, San Marino, Serbia, Slovakia, Slovenia, Spain, Svalbard and Jan Mayen, Sweden, Switzerland, Ukraine, United Kingdom of Great Britain and Northern Ireland)"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "BasisOfRecord is one of (Human Observation, Machine Observation, Occurrence evidence, Observation)",
 "TaxonKey is one of (Piaya cayana)",
 "Country is one of (American Samoa, Australia, Christmas Island, Cocos (Keeling) Islands, Cook Islands, Fiji, French Polynesia, Guam, Heard Island and McDonald Islands, Kiribati, Marshall Islands, Micronesia (Federated States of), Nauru, New Caledonia, New Zealand, Niue, Norfolk Island, Northern Mariana Islands, Palau, Papua New Guinea, Pitcairn, Samoa, Solomon Islands, Tokelau, Tonga, Tuvalu, United States Minor Outlying Islands, Vanuatu, Wallis and Futuna)"
 ]
}

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

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

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

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

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

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

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

description: A dataset containing 118 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Ilyodon furcidens)",
 "BasisOfRecord is one of (Specimen, Literature Occurrence, Human Observation, Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year is greater than or equal to 1991",
 "Year is less than or equal to 2025"
 ]
}

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

description: A dataset containing 2743 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Spain",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "License is one of (CC0 1.0, CC-BY 4.0)",
 "TaxonKey is Meles meles"
 ]
}

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

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

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

description: A dataset containing 803043 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Mexico",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Year 2024-2025"
 ]
}

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

description: A dataset containing 3530844 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is one of (Trifolium repens, Trifolium pratense, Teucrium polium, Tamarix, Sophora japonica, Ruta graveolens, Senecio vulgaris, Senna didymobotrya)"
 ]
}

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

description: A dataset containing 1247 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Malaysia",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Macaca nemestrina"
 ]
}

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

description: A dataset containing 5 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Nephrolepis brownii",
 "Country is Singapore",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 12 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Nephrolepis brownii",
 "Country is Panama",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 23 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Nephrolepis brownii",
 "Country is Saint Kitts and Nevis",
 "HasCoordinate is true"
 ]
}

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

description: A dataset containing 23 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Lomatogoniopsis alpina T.N.Ho & S.W.Liu",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 32 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

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

description: A dataset containing 11063 species occurrences available in GBIF matching the query:
{
 "and" : [
 "GadmGid is USA.3_1",
 "Geometry POLYGON((-112.37366 31.25793,-108.93127 31.25793,-108.93127 34.12903,-112.37366 34.12903,-112.37366 31.25793))",
 "TaxonKey is Curculionidae"
 ]
}

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

description: A dataset containing 33164781 species occurrences available in GBIF matching the query:
{
 "and" : [
 "DatasetKey is iNaturalist Research-grade Observations"
 ]
}

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

description: A dataset containing 4816 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Malaxis monophyllos (L.) Sw.",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 12379603 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Salix caprea L., Clymenella torquata (Leidy, 1855), Ilyanassa trivittata (Say, 1822), Galium verum L., Galium saxatile L., Pyronia tithonus (Linnaeus, 1771), Populus tremula L., Prunella modularis (Linnaeus, 1758), Echinocardium cordatum (Pennant, 1777), Grus canadensis (Linnaeus, 1758), Pitangus sulphuratus (Linnaeus, 1766), Platycheirus scutatus (Meigen, 1822), Bembidion tetracolum Say, 1823, Syritta pipiens (Linnaeus, 1758), Cornus racemosa Lam., Earophila badiata (Denis & Schiffermüller, 1775), Melanerpes uropygialis (S.F.Baird, 1854), Sigambra tentaculata (Treadwell, 1941), Pseudevernia furfuracea, Hippoglossina oblonga (Mitchill, 1815))",
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 1900"
 ]
}

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

description: A dataset containing 9553 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Continent is Africa",
 "TaxonKey is one of (Avicennia germinans (L.) L., Avicennia marina (Forssk.) Vierh., Bruguiera gymnorhiza (L.) Lam., Ceriops tagal (Perr.) C.B.Rob., Conocarpus erectus L., Heritiera littoralis Dryand. ex Aiton, Laguncularia racemosa (L.) C.F.Gaertn., Lumnitzera racemosa Willd., Pemphis acidula J.R.Forst. & G.Forst., Rhizophora mangle L., Rhizophora mucronata Poir., Rhizophora racemosa G.Mey., Sonneratia alba Sm., Xylocarpus granatum J.Koenig)"
 ]
}

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

description: A dataset containing 9673 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Bombus pratorum (Linnaeus, 1761)",
 "Geometry POLYGON((-8.00174339329464 54.1998526673513, 0.202120938926891 54.1998526673513, 0.202120938926891 61.2628565887411, -8.00174339329464 61.2628565887411, -8.00174339329464 54.1998526673513))",
 "CoordinateUncertaintyInMeters is 0,101",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 587 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Veronica alpina L.",
 "Geometry POLYGON((-8.00174339329464 54.1998526673513, 0.202120938926891 54.1998526673513, 0.202120938926891 61.2628565887411, -8.00174339329464 61.2628565887411, -8.00174339329464 54.1998526673513))",
 "CoordinateUncertaintyInMeters is 0,101",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 423 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 PRINTF('%04d-%02d-%02d', "year", "month", "day") yearmonthday,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, PRINTF('%04d-%02d-%02d', "year", "month", "day"))) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 (occurrence.taxonkey = 2417781 OR occurrence.acceptedtaxonkey = 2417781 OR occurrence.kingdomkey = 2417781 OR occurrence.phylumkey = 2417781 OR occurrence.classkey = 2417781 OR occurrence.orderkey = 2417781 OR occurrence.familykey = 2417781 OR occurrence.genuskey = 2417781 OR occurrence.specieskey = 2417781)
 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.occurrencestatus = 'PRESENT'
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence."month" IS NOT NULL AND occurrence."day" 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-%02d', "year", "month", "day")

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