World's Specimens Of Horseshoe Bats And Relatives by Kaggle | Other

About this Dataset

World's Specimens Of Horseshoe Bats And Relatives

World's Specimens of Horseshoe Bats and Relatives

Revealing the Impact of Geography on Diversity

About this dataset

This dataset provides comprehensive taxonomic, geographic, and multimedia information related to species occurrence data. By analyzing patterns of distribution, possible environmental effects on the species' distributions can be identified and future research can also be facilitated. The dataset includes records from both GBIF and the respective publisher's datasets as well as a total records count for analysis. With this reliable source of knowledge about species strategies for survival, it is now possible to develop better-informed conservation strategies to ensure that these fragile populations are adequately protected for generations to come. By unlocking the secrets behind these species' patterns of distribution, we have been presented with an opportunity to safeguard our environment and its delicate ecosystems from a preventable collapse which arises from human interference or climate change

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

Research Ideas

analyzing the distribution of species across different environments or geographic areas

determining if population size is shrinking or increasing in certain regions

identifying relationships between species and different factors such as climate and land use

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: rapid-data-providers_2021-05-03.csv

Column name	Description
datasetKey_gbifP	A unique identifier for the dataset. (String)
publisherKey_gbifP	A unique identifier for the publisher. (String)
datasetTitle_gbifP	The title of the dataset. (String)
records on both	The number of records that are present in both the GBIF and the publisher's datasets. (Integer)
records only on GBIF	The number of records that are only present in the GBIF dataset alone. (Integer)
total records	The total number of records in the dataset (both from GBIF and from Publisher). (Integer)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

N 1620226888 Rapid Gazeteer

@kaggle.thedevastator_unlocking_species_distribution_patterns.n_1620226888_rapid_gazeteer

14.94 MB
10341 rows
19 columns


CREATE TABLE n_1620226888_rapid_gazeteer (
  "countrycode" VARCHAR,
  "country" VARCHAR,
  "stateprovince" VARCHAR,
  "county" VARCHAR,
  "locality" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateprecision" DOUBLE,
  "coordinateuncertaintyinmeters" BIGINT,
  "coordinateuncertaintywkt" VARCHAR,
  "footprintwkt" VARCHAR,
  "georeferenceprotocol" VARCHAR,
  "georeferenceremarks" VARCHAR,
  "georeferencesources" VARCHAR,
  "georeferenceverificationstatus" VARCHAR,
  "georeferencedbyid" VARCHAR,
  "georeferencedby" VARCHAR,
  "georeferenceddate" TIMESTAMP
);

N 1623690110

@kaggle.thedevastator_unlocking_species_distribution_patterns.n_1623690110

58.6 MB
89837 rows
781 columns


CREATE TABLE n_1623690110 (
  "biospexid" VARCHAR,
  "abstract_gbifr" VARCHAR,
  "acceptednameusageid_gbifr" VARCHAR,
  "acceptednameusage_gbifr" VARCHAR,
  "accessrights_gbifr" VARCHAR,
  "accrualmethod_gbifr" VARCHAR,
  "accrualperiodicity_gbifr" VARCHAR,
  "accrualpolicy_gbifr" VARCHAR,
  "alternative_gbifr" VARCHAR,
  "associatedmedia_gbifr" VARCHAR,
  "associatedoccurrences_gbifr" VARCHAR,
  "associatedorganisms_gbifr" VARCHAR,
  "associatedreferences_gbifr" VARCHAR,
  "associatedsequences_gbifr" VARCHAR,
  "associatedtaxa_gbifr" VARCHAR,
  "audience_gbifr" VARCHAR,
  "available_gbifr" VARCHAR,
  "basisofrecord_gbifr" VARCHAR,
  "bed_gbifr" VARCHAR,
  "behavior_gbifr" VARCHAR,
  "bibliographiccitation_gbifr" VARCHAR,
  "catalognumber_gbifr" VARCHAR,
  "class_gbifr" VARCHAR,
  "collectioncode_gbifr" VARCHAR,
  "collectionid_gbifr" VARCHAR,
  "conformsto_gbifr" VARCHAR,
  "continent_gbifr" VARCHAR,
  "contributor_gbifr" VARCHAR,
  "coordinateprecision_gbifr" DOUBLE,
  "coordinateuncertaintyinmeters_gbifr" DOUBLE,
  "countrycode_gbifr" VARCHAR,
  "country_gbifr" VARCHAR,
  "county_gbifr" VARCHAR,
  "coverage_gbifr" VARCHAR,
  "created_gbifr" TIMESTAMP,
  "creator_gbifr" VARCHAR,
  "datageneralizations_gbifr" VARCHAR,
  "datasetid_gbifr" VARCHAR,
  "datasetname_gbifr" VARCHAR,
  "dateaccepted_gbifr" VARCHAR,
  "datecopyrighted_gbifr" VARCHAR,
  "dateidentified_gbifr" VARCHAR,
  "datesubmitted_gbifr" VARCHAR,
  "date_gbifr" VARCHAR,
  "day_gbifr" VARCHAR,
  "decimallatitude_gbifr" DOUBLE,
  "decimallongitude_gbifr" DOUBLE,
  "description_gbifr" VARCHAR,
  "disposition_gbifr" VARCHAR,
  "dynamicproperties_gbifr" VARCHAR,
  "earliestageorloweststage_gbifr" VARCHAR,
  "earliesteonorlowesteonothem_gbifr" VARCHAR,
  "earliestepochorlowestseries_gbifr" VARCHAR,
  "earliesteraorlowesterathem_gbifr" VARCHAR,
  "earliestperiodorlowestsystem_gbifr" VARCHAR,
  "educationlevel_gbifr" VARCHAR,
  "enddayofyear_gbifr" DOUBLE,
  "establishmentmeans_gbifr" VARCHAR,
  "eventdate_gbifr" VARCHAR,
  "eventid_gbifr" VARCHAR,
  "eventremarks_gbifr" VARCHAR,
  "eventtime_gbifr" VARCHAR,
  "extent_gbifr" VARCHAR,
  "family_gbifr" VARCHAR,
  "fieldnotes_gbifr" VARCHAR,
  "fieldnumber_gbifr" VARCHAR,
  "footprintsrs_gbifr" VARCHAR,
  "footprintspatialfit_gbifr" VARCHAR,
  "footprintwkt_gbifr" VARCHAR,
  "format_gbifr" VARCHAR,
  "formation_gbifr" VARCHAR,
  "gbifid_gbifr" DOUBLE,
  "genus_gbifr" VARCHAR,
  "geodeticdatum_gbifr" VARCHAR,
  "geologicalcontextid_gbifr" VARCHAR,
  "georeferenceprotocol_gbifr" VARCHAR,
  "georeferenceremarks_gbifr" VARCHAR,
  "georeferencesources_gbifr" VARCHAR,
  "georeferenceverificationstatus_gbifr" VARCHAR,
  "georeferencedby_gbifr" VARCHAR,
  "georeferenceddate_gbifr" VARCHAR,
  "group_gbifr" VARCHAR,
  "habitat_gbifr" VARCHAR,
  "hasformat_gbifr" VARCHAR,
  "haspart_gbifr" VARCHAR,
  "hasversion_gbifr" VARCHAR,
  "higherclassification_gbifr" VARCHAR,
  "highergeographyid_gbifr" VARCHAR,
  "highergeography_gbifr" VARCHAR,
  "highestbiostratigraphiczone_gbifr" VARCHAR,
  "identificationid_gbifr" VARCHAR,
  "identificationqualifier_gbifr" VARCHAR,
  "identificationreferences_gbifr" VARCHAR,
  "identificationremarks_gbifr" VARCHAR,
  "identificationverificationstatus_gbifr" VARCHAR,
  "identifiedbyid_gbifr" VARCHAR,
  "identifiedby_gbifr" VARCHAR,
  "identifier_gbifr" VARCHAR,
  "individualcount_gbifr" DOUBLE,
  "informationwithheld_gbifr" VARCHAR
);

Bionomia Datasets Attributions Key 2021–02–25

@kaggle.thedevastator_unlocking_species_distribution_patterns.bionomia_datasets_attributions_key_2021_02_25

14.16 KB
103 rows
3 columns


CREATE TABLE bionomia_datasets_attributions_key_2021_02_25 (
  "datasetkey" VARCHAR,
  "title" VARCHAR,
  "frictionless_data_package_download" VARCHAR
);

Bionomia Problem Dates All Datasets 2021–02–25

@kaggle.thedevastator_unlocking_species_distribution_patterns.bionomia_problem_dates_all_datasets_2021_02_25

8.79 KB
21 rows
10 columns


CREATE TABLE bionomia_problem_dates_all_datasets_2021_02_25 (
  "n__gbif_datasetkey" VARCHAR,
  "gbif_gbifid" BIGINT,
  "n__action" VARCHAR,
  "n__wikidata" VARCHAR,
  "n__date_born" VARCHAR,
  "n__date_born_precision" VARCHAR,
  "n__date_died" VARCHAR,
  "n__date_died_precision" VARCHAR,
  "n__dwc_eventdate" VARCHAR,
  "n__dwc_dateidentified" VARCHAR
);

Multimedia

@kaggle.thedevastator_unlocking_species_distribution_patterns.multimedia

4.83 MB
31865 rows
22 columns


CREATE TABLE multimedia (
  "coreid" VARCHAR,
  "ac_accessuri" VARCHAR,
  "idigbio_datemodified" VARCHAR,
  "idigbio_dataqualityscore" DOUBLE,
  "idigbio_etag" VARCHAR,
  "idigbio_flags" VARCHAR,
  "dcterms_format" VARCHAR,
  "idigbio_hasspecimen" BOOLEAN,
  "ac_licenselogourl" VARCHAR,
  "idigbio_mediatype" VARCHAR,
  "dcterms_modified" VARCHAR,
  "idigbio_recordids" VARCHAR,
  "idigbio_records" VARCHAR,
  "idigbio_recordsets" VARCHAR,
  "dcterms_rights" VARCHAR,
  "ac_tag" VARCHAR,
  "dc_type" VARCHAR,
  "idigbio_uuid" VARCHAR,
  "idigbio_version" VARCHAR,
  "xmprights_webstatement" VARCHAR,
  "exif_pixelxdimension" DOUBLE,
  "exif_pixelydimension" DOUBLE
);

Multimedia Raw

@kaggle.thedevastator_unlocking_species_distribution_patterns.multimedia_raw

2.2 MB
31865 rows
129 columns


CREATE TABLE multimedia_raw (
  "coreid" VARCHAR,
  "iptc4xmpext_countryname" VARCHAR,
  "iptc4xmpext_locationcreated" VARCHAR,
  "iptc4xmpext_provincestate" VARCHAR,
  "iptc4xmpext_worldregion" VARCHAR,
  "ac_idofcontainingcollection" VARCHAR,
  "ac_accessuri" VARCHAR,
  "ac_associatedspecimenreference" VARCHAR,
  "ac_attributionlogourl" VARCHAR,
  "ac_bestqualityaccessuri" VARCHAR,
  "ac_bestqualityformat" VARCHAR,
  "ac_caption" VARCHAR,
  "ac_capturedevice" VARCHAR,
  "ac_comments" VARCHAR,
  "ac_derivedfrom" VARCHAR,
  "ac_digitizationdate" VARCHAR,
  "ac_fundingattribution" VARCHAR,
  "ac_furtherinformationurl" VARCHAR,
  "ac_goodqualityaccessuri" VARCHAR,
  "ac_hasserviceaccesspoint" VARCHAR,
  "ac_hashfunction" VARCHAR,
  "ac_hashvalue" VARCHAR,
  "ac_licenselogourl" VARCHAR,
  "ac_metadatacreator" VARCHAR,
  "ac_metadatalanguage" VARCHAR,
  "ac_metadatalanguageliteral" VARCHAR,
  "ac_metadataprovider" VARCHAR,
  "ac_metadataproviderliteral" VARCHAR,
  "ac_physicalsetting" VARCHAR,
  "ac_provider" VARCHAR,
  "ac_providerid" VARCHAR,
  "ac_providerliteral" VARCHAR,
  "ac_providermanagedid" VARCHAR,
  "ac_resourcecreationtechnique" VARCHAR,
  "ac_serviceexpectation" VARCHAR,
  "ac_subjectcategoryvocabulary" VARCHAR,
  "ac_subjectorientation" VARCHAR,
  "ac_subjectpart" VARCHAR,
  "ac_subtype" VARCHAR,
  "ac_subtypeliteral" VARCHAR,
  "ac_tag" VARCHAR,
  "ac_taxoncount" VARCHAR,
  "ac_taxoncoverage" VARCHAR,
  "ac_thumbnailaccessuri" VARCHAR,
  "ac_variant" VARCHAR,
  "ac_variantliteral" VARCHAR,
  "dc_creator" VARCHAR,
  "dc_format" VARCHAR,
  "dc_language" VARCHAR,
  "dc_rights" VARCHAR,
  "dc_source" VARCHAR,
  "dc_type" VARCHAR,
  "dcterms_accessrights" VARCHAR,
  "dcterms_audience" VARCHAR,
  "dcterms_available" VARCHAR,
  "dcterms_created" VARCHAR,
  "dcterms_creator" VARCHAR,
  "dcterms_description" VARCHAR,
  "dcterms_format" VARCHAR,
  "dcterms_identifier" VARCHAR,
  "dcterms_language" VARCHAR,
  "dcterms_license" VARCHAR,
  "dcterms_modified" VARCHAR,
  "dcterms_publisher" VARCHAR,
  "dcterms_references" VARCHAR,
  "dcterms_rights" VARCHAR,
  "dcterms_rightsholder" VARCHAR,
  "dcterms_source" VARCHAR,
  "dcterms_title" VARCHAR,
  "dcterms_type" VARCHAR,
  "dwc_identification" VARCHAR,
  "dwc_associatedtaxa" VARCHAR,
  "dwc_basisofrecord" VARCHAR,
  "dwc_catalognumber" VARCHAR,
  "dwc_collectioncode" VARCHAR,
  "dwc_collectionid" VARCHAR,
  "dwc_coordinateuncertaintyinmeters" VARCHAR,
  "dwc_country" VARCHAR,
  "dwc_county" VARCHAR,
  "dwc_dateidentified" VARCHAR,
  "dwc_day" VARCHAR,
  "dwc_decimallatitude" VARCHAR,
  "dwc_decimallongitude" VARCHAR,
  "dwc_eventdate" VARCHAR,
  "dwc_family" VARCHAR,
  "dwc_genus" VARCHAR,
  "dwc_geodeticdatum" VARCHAR,
  "dwc_georeferencedby" VARCHAR,
  "dwc_habitat" VARCHAR,
  "dwc_higherclassification" VARCHAR,
  "dwc_identificationqualifier" VARCHAR,
  "dwc_identifiedby" VARCHAR,
  "dwc_institutioncode" VARCHAR,
  "dwc_kingdom" VARCHAR,
  "dwc_locality" VARCHAR,
  "dwc_minimumelevationinmeters" VARCHAR,
  "dwc_month" VARCHAR,
  "dwc_municipality" VARCHAR,
  "dwc_occurrenceid" VARCHAR,
  "dwc_occurrenceremarks" VARCHAR
);

Occurrence

@kaggle.thedevastator_unlocking_species_distribution_patterns.occurrence

208.2 MB
829063 rows
81 columns


CREATE TABLE occurrence (
  "coreid" VARCHAR,
  "idigbio_associatedsequences" VARCHAR,
  "idigbio_barcodevalue" VARCHAR,
  "dwc_basisofrecord" VARCHAR,
  "dwc_bed" VARCHAR,
  "gbif_canonicalname" VARCHAR,
  "dwc_catalognumber" VARCHAR,
  "dwc_class" VARCHAR,
  "dwc_collectioncode" VARCHAR,
  "dwc_collectionid" VARCHAR,
  "idigbio_collectionname" VARCHAR,
  "dwc_recordedby" VARCHAR,
  "dwc_vernacularname" VARCHAR,
  "idigbio_commonnames" VARCHAR,
  "dwc_continent" VARCHAR,
  "dwc_coordinateuncertaintyinmeters" DOUBLE,
  "dwc_country" VARCHAR,
  "idigbio_isocountrycode" VARCHAR,
  "dwc_county" VARCHAR,
  "idigbio_eventdate" VARCHAR,
  "idigbio_datemodified" VARCHAR,
  "idigbio_dataqualityscore" DOUBLE,
  "dwc_earliestageorloweststage" VARCHAR,
  "dwc_earliesteonorlowesteonothem" VARCHAR,
  "dwc_earliestepochorlowestseries" VARCHAR,
  "dwc_earliesteraorlowesterathem" VARCHAR,
  "dwc_earliestperiodorlowestsystem" VARCHAR,
  "idigbio_etag" VARCHAR,
  "dwc_eventdate" VARCHAR,
  "dwc_family" VARCHAR,
  "dwc_fieldnumber" VARCHAR,
  "idigbio_flags" VARCHAR,
  "dwc_formation" VARCHAR,
  "dwc_genus" VARCHAR,
  "dwc_geologicalcontextid" VARCHAR,
  "idigbio_geopoint" VARCHAR,
  "dwc_group" VARCHAR,
  "idigbio_hasimage" BOOLEAN,
  "idigbio_hasmedia" BOOLEAN,
  "dwc_higherclassification" VARCHAR,
  "dwc_highestbiostratigraphiczone" VARCHAR,
  "dwc_individualcount" DOUBLE,
  "dwc_infraspecificepithet" VARCHAR,
  "dwc_institutioncode" VARCHAR,
  "dwc_institutionid" VARCHAR,
  "idigbio_institutionname" VARCHAR,
  "dwc_kingdom" VARCHAR,
  "dwc_latestageorhigheststage" VARCHAR,
  "dwc_latesteonorhighesteonothem" VARCHAR,
  "dwc_latestepochorhighestseries" VARCHAR,
  "dwc_latesteraorhighesterathem" VARCHAR,
  "dwc_latestperiodorhighestsystem" VARCHAR,
  "dwc_lithostratigraphicterms" VARCHAR,
  "dwc_locality" VARCHAR,
  "dwc_lowestbiostratigraphiczone" VARCHAR,
  "dwc_maximumdepthinmeters" DOUBLE,
  "dwc_maximumelevationinmeters" DOUBLE,
  "idigbio_mediarecords" VARCHAR,
  "dwc_member" VARCHAR,
  "dwc_minimumdepthinmeters" DOUBLE,
  "dwc_minimumelevationinmeters" DOUBLE,
  "dwc_municipality" VARCHAR,
  "dwc_occurrenceid" VARCHAR,
  "dwc_order" VARCHAR,
  "dwc_phylum" VARCHAR,
  "idigbio_recordids" VARCHAR,
  "dwc_recordnumber" VARCHAR,
  "idigbio_recordset" VARCHAR,
  "dwc_scientificname" VARCHAR,
  "dwc_specificepithet" VARCHAR,
  "dwc_startdayofyear" DOUBLE,
  "dwc_stateprovince" VARCHAR,
  "dwc_taxonid" VARCHAR,
  "dwc_taxonomicstatus" VARCHAR,
  "dwc_taxonrank" VARCHAR,
  "dwc_typestatus" VARCHAR,
  "idigbio_uuid" VARCHAR,
  "dwc_verbatimeventdate" VARCHAR,
  "dwc_verbatimlocality" VARCHAR,
  "idigbio_version" VARCHAR,
  "dwc_waterbody" VARCHAR
);

Occurrence Raw

@kaggle.thedevastator_unlocking_species_distribution_patterns.occurrence_raw

154.75 MB
829063 rows
183 columns


CREATE TABLE occurrence_raw (
  "coreid" VARCHAR,
  "aec_associatedtaxa" VARCHAR,
  "dc_rights" VARCHAR,
  "dcterms_accessrights" VARCHAR,
  "dcterms_bibliographiccitation" VARCHAR,
  "dcterms_language" VARCHAR,
  "dcterms_license" VARCHAR,
  "dcterms_modified" VARCHAR,
  "dcterms_references" VARCHAR,
  "dcterms_rights" VARCHAR,
  "dcterms_rightsholder" VARCHAR,
  "dcterms_source" VARCHAR,
  "dcterms_type" VARCHAR,
  "dwc_identification" VARCHAR,
  "dwc_measurementorfact" VARCHAR,
  "dwc_resourcerelationship" VARCHAR,
  "dwc_verbatimeventdate" VARCHAR,
  "dwc_acceptednameusage" VARCHAR,
  "dwc_accessrights" VARCHAR,
  "dwc_associatedmedia" VARCHAR,
  "dwc_associatedoccurrences" VARCHAR,
  "dwc_associatedorganisms" VARCHAR,
  "dwc_associatedreferences" VARCHAR,
  "dwc_associatedsequences" VARCHAR,
  "dwc_associatedtaxa" VARCHAR,
  "dwc_basisofrecord" VARCHAR,
  "dwc_bed" VARCHAR,
  "dwc_behavior" VARCHAR,
  "dwc_catalognumber" VARCHAR,
  "dwc_class" VARCHAR,
  "dwc_classs" VARCHAR,
  "dwc_collectioncode" VARCHAR,
  "dwc_collectionid" VARCHAR,
  "dwc_continent" VARCHAR,
  "dwc_coordinateprecision" VARCHAR,
  "dwc_coordinateuncertaintyinmeters" DOUBLE,
  "dwc_country" VARCHAR,
  "dwc_countrycode" VARCHAR,
  "dwc_county" VARCHAR,
  "dwc_datageneralizations" VARCHAR,
  "dwc_datasetid" VARCHAR,
  "dwc_datasetname" VARCHAR,
  "dwc_dateidentified" VARCHAR,
  "dwc_day" VARCHAR,
  "dwc_decimallatitude" VARCHAR,
  "dwc_decimallongitude" DOUBLE,
  "dwc_disposition" VARCHAR,
  "dwc_dynamicproperties" VARCHAR,
  "dwc_earliestageorloweststage" VARCHAR,
  "dwc_earliesteonorlowesteonothem" VARCHAR,
  "dwc_earliestepochorlowestseries" VARCHAR,
  "dwc_earliesteraorlowesterathem" VARCHAR,
  "dwc_earliestperiodorlowestsystem" VARCHAR,
  "dwc_enddayofyear" DOUBLE,
  "dwc_establishmentmeans" VARCHAR,
  "dwc_eventdate" VARCHAR,
  "dwc_eventid" VARCHAR,
  "dwc_eventremarks" VARCHAR,
  "dwc_eventtime" VARCHAR,
  "dwc_family" VARCHAR,
  "dwc_fieldnotes" VARCHAR,
  "dwc_fieldnumber" VARCHAR,
  "dwc_footprintsrs" VARCHAR,
  "dwc_footprintspatialfit" VARCHAR,
  "dwc_footprintwkt" VARCHAR,
  "dwc_formation" VARCHAR,
  "dwc_genus" VARCHAR,
  "dwc_geodeticdatum" VARCHAR,
  "dwc_geologicalcontextid" VARCHAR,
  "dwc_georeferenceprotocol" VARCHAR,
  "dwc_georeferenceremarks" VARCHAR,
  "dwc_georeferencesources" VARCHAR,
  "dwc_georeferenceverificationstatus" VARCHAR,
  "dwc_georeferencedby" VARCHAR,
  "dwc_georeferenceddate" VARCHAR,
  "dwc_group" VARCHAR,
  "dwc_habitat" VARCHAR,
  "dwc_higherclassification" VARCHAR,
  "dwc_highergeography" VARCHAR,
  "dwc_highergeographyid" VARCHAR,
  "dwc_highestbiostratigraphiczone" VARCHAR,
  "dwc_identificationid" DOUBLE,
  "dwc_identificationqualifier" VARCHAR,
  "dwc_identificationreferences" VARCHAR,
  "dwc_identificationremarks" VARCHAR,
  "dwc_identificationverificationstatus" VARCHAR,
  "dwc_identifiedby" VARCHAR,
  "dwc_individualcount" DOUBLE,
  "dwc_informationwithheld" VARCHAR,
  "dwc_infraspecificepithet" VARCHAR,
  "dwc_institutioncode" VARCHAR,
  "dwc_institutionid" VARCHAR,
  "dwc_island" VARCHAR,
  "dwc_islandgroup" VARCHAR,
  "dwc_kingdom" VARCHAR,
  "dwc_language" VARCHAR,
  "dwc_latestageorhigheststage" VARCHAR,
  "dwc_latesteonorhighesteonothem" VARCHAR,
  "dwc_latestepochorhighestseries" VARCHAR,
  "dwc_latesteraorhighesterathem" VARCHAR
);

Rapid Data Providers 2021–05–03

@kaggle.thedevastator_unlocking_species_distribution_patterns.rapid_data_providers_2021_05_03

20.42 KB
120 rows
8 columns


CREATE TABLE rapid_data_providers_2021_05_03 (
  "idigbio_recordset_idbp" VARCHAR,
  "datasetkey_gbifp" VARCHAR,
  "publisherkey_gbifp" VARCHAR,
  "datasettitle_gbifp" VARCHAR,
  "records_on_both" DOUBLE,
  "records_only_on_gbif" DOUBLE,
  "records_only_on_idigbio" DOUBLE,
  "total_records" BIGINT
);

Rapid Joined Records Country Cleanup 2020–09–23

@kaggle.thedevastator_unlocking_species_distribution_patterns.rapid_joined_records_country_cleanup_2020_09_23

37.07 MB
89837 rows
737 columns


CREATE TABLE rapid_joined_records_country_cleanup_2020_09_23 (
  "gbif" BIGINT,
  "idigbio" BIGINT,
  "gbifid_gbifr" DOUBLE,
  "idigbio_uuid_idbp" VARCHAR,
  "abstract_gbifp" VARCHAR,
  "abstract_gbifr" VARCHAR,
  "acceptednameusage_gbifp" VARCHAR,
  "acceptednameusage_gbifr" VARCHAR,
  "acceptednameusage_idbr" VARCHAR,
  "acceptednameusageid_gbifp" VARCHAR,
  "acceptednameusageid_gbifr" VARCHAR,
  "acceptedscientificname_gbifp" VARCHAR,
  "acceptedtaxonkey_gbifp" DOUBLE,
  "accessrights_gbifp" VARCHAR,
  "accessrights_gbifr" VARCHAR,
  "accessrights_idbr" VARCHAR,
  "accrualmethod_gbifp" VARCHAR,
  "accrualmethod_gbifr" VARCHAR,
  "accrualperiodicity_gbifp" VARCHAR,
  "accrualperiodicity_gbifr" VARCHAR,
  "accrualpolicy_gbifp" VARCHAR,
  "accrualpolicy_gbifr" VARCHAR,
  "aec_associatedtaxa_idbr" VARCHAR,
  "alternative_gbifp" VARCHAR,
  "alternative_gbifr" VARCHAR,
  "associatedmedia_gbifr" VARCHAR,
  "associatedmedia_idbr" VARCHAR,
  "associatedoccurrences_gbifp" VARCHAR,
  "associatedoccurrences_gbifr" VARCHAR,
  "associatedoccurrences_idbr" VARCHAR,
  "associatedorganisms_gbifp" VARCHAR,
  "associatedorganisms_gbifr" VARCHAR,
  "associatedorganisms_idbr" VARCHAR,
  "associatedreferences_gbifp" VARCHAR,
  "associatedreferences_gbifr" VARCHAR,
  "associatedreferences_idbr" VARCHAR,
  "associatedsequences_gbifp" VARCHAR,
  "associatedsequences_gbifr" VARCHAR,
  "associatedsequences_idbr" VARCHAR,
  "associatedtaxa_gbifp" VARCHAR,
  "associatedtaxa_gbifr" VARCHAR,
  "associatedtaxa_idbr" VARCHAR,
  "audience_gbifp" VARCHAR,
  "audience_gbifr" VARCHAR,
  "available_gbifp" VARCHAR,
  "available_gbifr" VARCHAR,
  "basisofrecord_gbifp" VARCHAR,
  "basisofrecord_gbifr" VARCHAR,
  "basisofrecord_idbp" VARCHAR,
  "basisofrecord_idbr" VARCHAR,
  "bed_gbifp" VARCHAR,
  "bed_gbifr" VARCHAR,
  "bed_idbp" VARCHAR,
  "bed_idbr" VARCHAR,
  "behavior_gbifp" VARCHAR,
  "behavior_gbifr" VARCHAR,
  "behavior_idbr" VARCHAR,
  "bibliographiccitation_gbifp" VARCHAR,
  "bibliographiccitation_gbifr" VARCHAR,
  "catalognumber_gbifp" VARCHAR,
  "catalognumber_gbifr" VARCHAR,
  "catalognumber_idbp" VARCHAR,
  "catalognumber_idbr" VARCHAR,
  "class_gbifp" VARCHAR,
  "class_gbifr" VARCHAR,
  "class_idbp" VARCHAR,
  "class_idbr" VARCHAR,
  "classkey_gbifp" DOUBLE,
  "classs_idbr" VARCHAR,
  "collectioncode_gbifp" VARCHAR,
  "collectioncode_gbifr" VARCHAR,
  "collectioncode_idbp" VARCHAR,
  "collectioncode_idbr" VARCHAR,
  "collectionid_gbifp" VARCHAR,
  "collectionid_gbifr" VARCHAR,
  "collectionid_idbp" VARCHAR,
  "collectionid_idbr" VARCHAR,
  "conformsto_gbifp" VARCHAR,
  "conformsto_gbifr" VARCHAR,
  "continent_gbifp" VARCHAR,
  "continent_gbifr" VARCHAR,
  "continent_idbp" VARCHAR,
  "continent_idbr" VARCHAR,
  "contributor_gbifp" VARCHAR,
  "contributor_gbifr" VARCHAR,
  "coordinateprecision_gbifp" DOUBLE,
  "coordinateprecision_gbifr" DOUBLE,
  "coordinateprecision_idbr" VARCHAR,
  "coordinateuncertaintyinmeters_gbifp" DOUBLE,
  "coordinateuncertaintyinmeters_gbifr" DOUBLE,
  "coordinateuncertaintyinmeters_idbp" DOUBLE,
  "coordinateuncertaintyinmeters_idbr" DOUBLE,
  "coreid_idbr" VARCHAR,
  "country_gbifr" VARCHAR,
  "country_idbp" VARCHAR,
  "country_idbr" VARCHAR,
  "countrycode_gbifp" VARCHAR,
  "countrycode_gbifr" VARCHAR,
  "countrycode_idbr" VARCHAR,
  "county_gbifp" VARCHAR
);