cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.6084/m9.figshare.5031476
title: An inverse elevational species richness gradient of Caucasian vascular plants and Encyrtidae (Hymenoptera, Chalcidoidea)

description: The elevational gradient in biodiversity, i.e. the decrease in species richness with increasing altitude, is well established in ecology. Here, we examined the respective gradient of parasitic hymenopterans (Encyrtidae) and plants in the Lagodekhi National Park (Country of Georgia) across an elevational gradient from 665 m to 2559 m a.s.l. by means of a year-round sampling of insects and a seasonal sampling of plants. Contrary to expectation, we found species richness of both taxa to peak at highest elevations. This unusual pattern was related to particular shifts in vegetation types, from relatively species-poor forests over rich grasslands towards poorer highland scrub vegetation. Our results call for a closer look at elevational gradients and highlights the need for including vegetation types in the assessment of altitudinal diversity gradients.
DOI: 10.6084/m9.figshare.5031476.v1
title: An inverse elevational species richness gradient of Caucasian vascular plants and Encyrtidae (Hymenoptera, Chalcidoidea)

description: The elevational gradient in biodiversity, i.e. the decrease in species richness with increasing altitude, is well established in ecology. Here, we examined the respective gradient of parasitic hymenopterans (Encyrtidae) and plants in the Lagodekhi National Park (Country of Georgia) across an elevational gradient from 665 m to 2559 m a.s.l. by means of a year-round sampling of insects and a seasonal sampling of plants. Contrary to expectation, we found species richness of both taxa to peak at highest elevations. This unusual pattern was related to particular shifts in vegetation types, from relatively species-poor forests over rich grasslands towards poorer highland scrub vegetation. Our results call for a closer look at elevational gradients and highlights the need for including vegetation types in the assessment of altitudinal diversity gradients.
DOI: 10.6084/m9.figshare.5031413
title: data_PLOS_SeattlePAP.txt

description: breathing characteristics of premature infants during respiratory support on bubble nasal continuous positive airway pressure with standard and with Seattle-PAP bubble devices
DOI: 10.6084/m9.figshare.5031410
title: Data_Repository_Eastern_Alps.xlsx

description: 40Ar/39Ar data from 19 modern river sand samples within the Eastern Alps
DOI: 10.15468/dl.nnsfjw
title: Occurrence Download

description: A dataset containing 874 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Tribulus macropterus Boiss."
 ]
}

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

description: A dataset containing 146 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Closterocerus formosus Westwood, 1833",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Cophixalus monticola Richards, Dennis, Trenerry & Werren, 1994)",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2000",
 "BasisOfRecord is one of (Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 100",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

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

description: A dataset containing 28 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Nitela lucens Gayubo & Felton, 2000",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Parhoplophryne usambarica Barbour & Loveridge, 1928)",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2000",
 "BasisOfRecord is one of (Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 100",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

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

description: A dataset containing 957 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Diglyphus isaea (Walker, 1838)",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 703 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Nitela borealis Valkeila, 1974",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Anilany helenae (Vallan, 2000))",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2000",
 "BasisOfRecord is one of (Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 100",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

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

description: A dataset containing 58 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Diglyphus begini (Ashmead, 1904)",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 298 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Miscophus concolor Dahlbom, 1844",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 39368 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)"
 ]
 }
 }
 ]
 },
 "Year is greater than or equal to 1999",
 "TaxonKey is Acacia dealbata Link",
 {
 "or" : [
 {
 "not" : {
 "EstablishmentMeans" : [
 "is one of (MANAGED, INTRODUCED)"
 ]
 }
 },
 "EstablishmentMeans is null"
 ]
 }
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Ericabatrachus baleensis Largen, 1991)",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2000",
 "BasisOfRecord is one of (Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 100",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

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

description: A dataset containing 11 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Nomia melanderi Cockerell, 1906",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 174 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Miscophus bicolor Jurine, 1807",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Petropedetes perreti Amiet, 1973)",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2000",
 "BasisOfRecord is one of (Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 100",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

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

description: A dataset containing 3717 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Trigona spinipes (Fabricius, 1793)",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 531 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Miscophus ater Lepeletier de Saint Fargeau, 1845",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Phrynobatrachus irangi Drewes & Perret, 2000)",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2000",
 "BasisOfRecord is one of (Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 100",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

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

description: A dataset containing 874 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Tribulus macropterus Boiss."
 ]
}

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

description: A dataset containing 2886 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Nysson spinosus (J.Forster, 1771)",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

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

description: A dataset containing 36504 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)"
 ]
 }
 }
 ]
 },
 "SpeciesKey is Osmia cornuta (Latreille, 1805)",
 "Year is greater than or equal to 2004",
 "Year is less than or equal to 2023"
 ]
}

 The dataset includes 36504 records from 242 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0088746-240626123714530/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.13370487
title: Open Trade Statistics Database

description: The Open Trade Statistics initiative was developed to ease access to international trade data by providing downloadable SQL database dumps, a public API, a dashboard, and an R package for data retrieval. This project was born out of the recognition that many academic institutions in Latin America lack access to academic subscriptions and comprehensive datasets like the United Nations Commodity Trade Statistics Database. The OTS project not only offers a solution to this problem regarding international trade data but also emphasizes the importance of reproducibility in data processing. Through the use of open-source tools, the project ensures that its datasets are accessible and easy to use for research and analysis.

OTS, based on the official correlation tables, provides a harmonized dataset where the values are converted to HS revision 2012 for the years 1980-2021 and it involved transforming some of the reported data to find equivalent codes between the different classifications. For instance, the HS revision 1992 code '271011' (aviation spirit) does not have a direct equivalent in HS revision 2012 and it can be converted to the more general code '271000' (oils petroleum, bituminous, distillates, except crude). The same process was applied to the SITC codes.

Country codes are also standardized in OTS. For instance, missing ISO-3 country codes in the raw data were replaced by the values expressed in UN COMTRADE documentation. For instance, the numeric code '490' corresponds to 'e-490' but it appears as a blank value in the raw data, and UN COMTRADE documentationindicates that 'e-490' corresponds to 'Other Asia, Not Elsewhere Specified (NES)'.

Commercial purposes are strictly out of the boundaries of what you can do with this data according to UN Comtrade dissemination clauses.

Visit tradestatistics.io to access the dashboard and R package for data retrieval.
DOI: 10.5281/zenodo.13370486
title: Open Trade Statistics Database

description: The Open Trade Statistics initiative was developed to ease access to international trade data by providing downloadable SQL database dumps, a public API, a dashboard, and an R package for data retrieval. This project was born out of the recognition that many academic institutions in Latin America lack access to academic subscriptions and comprehensive datasets like the United Nations Commodity Trade Statistics Database. The OTS project not only offers a solution to this problem regarding international trade data but also emphasizes the importance of reproducibility in data processing. Through the use of open-source tools, the project ensures that its datasets are accessible and easy to use for research and analysis.

OTS, based on the official correlation tables, provides a harmonized dataset where the values are converted to HS revision 2012 for the years 1980-2021 and it involved transforming some of the reported data to find equivalent codes between the different classifications. For instance, the HS revision 1992 code '271011' (aviation spirit) does not have a direct equivalent in HS revision 2012 and it can be converted to the more general code '271000' (oils petroleum, bituminous, distillates, except crude). The same process was applied to the SITC codes.

Country codes are also standardized in OTS. For instance, missing ISO-3 country codes in the raw data were replaced by the values expressed in UN COMTRADE documentation. For instance, the numeric code '490' corresponds to 'e-490' but it appears as a blank value in the raw data, and UN COMTRADE documentationindicates that 'e-490' corresponds to 'Other Asia, Not Elsewhere Specified (NES)'.

Commercial purposes are strictly out of the boundaries of what you can do with this data according to UN Comtrade dissemination clauses.

Visit tradestatistics.io to access the dashboard and R package for data retrieval.
DOI: 10.5281/zenodo.4136984
title: SQL Databases for Students and Educators

description: Publicly accessible databases often impose query limits or require registration. Even when I maintain public and limit-free APIs, I never wanted to host a public database because I tend to think that the connection strings are a problem for the user.

See https://databases.pacha.dev
DOI: 10.5281/zenodo.4136985
title: SQL Databases for Students and Educators

description: Publicly accessible databases often impose query limits or require registration. Even when I maintain public and limit-free APIs, I never wanted to host a public database because I tend to think that the connection strings are a problem for the user. I’ve decided to host different light/medium size by using PostgreSQL, MySQL and SQL Server backends (in strict descending order of preference!). Why 3 database backends? I think there are a ton of small edge cases when moving between DB back ends and so testing lots with live databases is quite valuable. With this resource you can benchmark speed, compression, and DDL types. Please send me a tweet if you need the connection strings for your lectures or workshops. My Twitter username is @pachamaltese. See the SQL dumps on each section to have the data locally.
DOI: 10.5281/zenodo.4145173
title: SQL Databases for Students and Educators

description: Publicly accessible databases often impose query limits or require registration. Even when I maintain public and limit-free APIs, I never wanted to host a public database because I tend to think that the connection strings are a problem for the user.

See https://databases.pacha.dev
DOI: 10.15468/dl.c4g4mc
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Phrynobatrachus manengoubensis (Angel, 1940))",
 "OccurrenceStatus is Present",
 "Year is greater than or equal to 2000",
 "BasisOfRecord is one of (Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 {
 "or" : [
 "CoordinateUncertaintyInMeters is less than 100",
 "CoordinateUncertaintyInMeters is null"
 ]
 }
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0088748-240626123714530/datasets/export for details.