Name: Paleobiology
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Paleobiology

The Paleobiology Database is a public database of paleontological data that anyone can use, maintained by an international non-governmental group of paleontologists. You can explore the data online in the Navigator, which lets you filter fossil occurrences by time, space, and taxonomy, and displays their modern and paleogeographic locations; or you can download the data to your own computer to do your own analyses.

https://paleobiodb.org/

Tables

Pbdb Data

@kaggle.joebeachcapital_paleobio.pbdb_data

57.66 MB
970,505 rows
112 columns

CREATE TABLE pbdb_data (
  "occurrence_no" BIGINT,
  "record_type" VARCHAR,
  "reid_no" DOUBLE,
  "flags" VARCHAR,
  "collection_no" BIGINT,
  "accepted_name" VARCHAR,
  "accepted_attr" VARCHAR,
  "accepted_rank" VARCHAR,
  "accepted_no" BIGINT,
  "early_interval" VARCHAR,
  "late_interval" VARCHAR,
  "max_ma" DOUBLE,
  "min_ma" DOUBLE,
  "ref_author" VARCHAR,
  "ref_pubyr" DOUBLE,
  "reference_no" BIGINT,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "plant_organ" VARCHAR,
  "plant_organ2" VARCHAR,
  "abund_value" VARCHAR,
  "abund_unit" VARCHAR,
  "lng" DOUBLE,
  "lat" DOUBLE,
  "collection_name" VARCHAR,
  "collection_subset" DOUBLE,
  "collection_aka" VARCHAR,
  "cc" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "latlng_basis" VARCHAR,
  "latlng_precision" VARCHAR,
  "geogscale" VARCHAR,
  "geogcomments" VARCHAR,
  "paleomodel" VARCHAR,
  "paleolng" DOUBLE,
  "paleolat" DOUBLE,
  "geoplate" VARCHAR,
  "cc_1" VARCHAR,
  "protected" VARCHAR,
  "formation" VARCHAR,
  "stratgroup" VARCHAR,
  "member" VARCHAR,
  "stratscale" VARCHAR,
  "zone" VARCHAR,
  "localsection" VARCHAR,
  "localbed" VARCHAR,
  "localorder" VARCHAR,
  "regionalsection" VARCHAR,
  "regionalbed" VARCHAR,
  "regionalorder" VARCHAR,
  "stratcomments" VARCHAR,
  "lithdescript" VARCHAR,
  "lithology1" VARCHAR,
  "lithadj1" VARCHAR,
  "lithification1" VARCHAR,
  "minor_lithology1" VARCHAR,
  "fossilsfrom1" VARCHAR,
  "lithology2" VARCHAR,
  "lithadj2" VARCHAR,
  "lithification2" VARCHAR,
  "minor_lithology2" VARCHAR,
  "fossilsfrom2" VARCHAR,
  "environment" VARCHAR,
  "tectonic_setting" VARCHAR,
  "geology_comments" VARCHAR,
  "assembl_comps" VARCHAR,
  "articulated_parts" VARCHAR,
  "associated_parts" VARCHAR,
  "common_body_parts" VARCHAR,
  "rare_body_parts" VARCHAR,
  "feed_pred_traces" VARCHAR,
  "artifacts" VARCHAR,
  "component_comments" VARCHAR,
  "pres_mode" VARCHAR,
  "preservation_quality" VARCHAR,
  "spatial_resolution" VARCHAR,
  "temporal_resolution" VARCHAR,
  "lagerstatten" VARCHAR,
  "concentration" VARCHAR,
  "orientation" VARCHAR,
  "abund_in_sediment" VARCHAR,
  "sorting" VARCHAR,
  "fragmentation" VARCHAR,
  "bioerosion" VARCHAR,
  "encrustation" VARCHAR,
  "preservation_comments" VARCHAR,
  "collection_type" VARCHAR,
  "collection_methods" VARCHAR,
  "museum" VARCHAR,
  "collection_coverage" VARCHAR,
  "collection_size" VARCHAR,
  "rock_censused" VARCHAR,
  "collectors" VARCHAR,
  "collection_dates" VARCHAR,
  "collection_comments" VARCHAR,
  "taxonomy_comments" VARCHAR
);