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

54.99 MB
970505 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
);