Biodiversity In National Parks

Plant and animal species found in the American national park system

@kaggle.nationalparkservice_park_biodiversity

Table List

2 tables(2.59 MB)

Species

@kaggle.nationalparkservice_park_biodiversity.species

2.58 MB
119248 rows
14 columns

species_id Species ID	park_name Park Name	category Category	order Order	family Family	scientific_name Scientific Name	common_names Common Names	record_status Record Status	occurrence Occurrence	nativeness Nativeness	abundance Abundance	seasonality Seasonality	conservation_status Conservation Status	unnamed_13 Unnamed: 13
ACAD-1000	Acadia National Park	Mammal	Artiodactyla	Cervidae	Alces alces	Moose	Approved	Present	Native	Rare	Resident	nan	nan
ACAD-1001	Acadia National Park	Mammal	Artiodactyla	Cervidae	Odocoileus virginianus	Northern White-Tailed Deer, Virginia Deer, White-Tailed Deer	Approved	Present	Native	Abundant	nan	nan	nan
ACAD-1002	Acadia National Park	Mammal	Carnivora	Canidae	Canis latrans	Coyote, Eastern Coyote	Approved	Present	Not Native	Common	nan	Species of Concern	nan
ACAD-1003	Acadia National Park	Mammal	Carnivora	Canidae	Canis lupus	Eastern Timber Wolf, Gray Wolf, Timber Wolf	Approved	Not Confirmed	Native	nan	nan	Endangered	nan
ACAD-1004	Acadia National Park	Mammal	Carnivora	Canidae	Vulpes vulpes	Black Fox, Cross Fox, Eastern Red Fox, Fox, Red Fox, Silver Fox	Approved	Present	Unknown	Common	Breeder	nan	nan
ACAD-1005	Acadia National Park	Mammal	Carnivora	Felidae	Lynx canadensis	Canada Lynx	Approved	Not Confirmed	Native	nan	nan	nan	nan
ACAD-1006	Acadia National Park	Mammal	Carnivora	Felidae	Lynx rufus	Bay Lynx, Bobcat, Red Lynx, Wild Cat	Approved	Not Present (Historical Report)	Not Native	nan	Vagrant	nan	nan
ACAD-1007	Acadia National Park	Mammal	Carnivora	Mephitidae	Mephitis mephitis	Eastern Skunk, Polecat, Striped Skunk	Approved	Not Present (Historical Report)	Native	nan	nan	nan	nan
ACAD-1008	Acadia National Park	Mammal	Carnivora	Mustelidae	Lutra canadensis	Otter, River Otter	Approved	Present	Native	Common	Breeder	nan	nan
ACAD-1009	Acadia National Park	Mammal	Carnivora	Mustelidae	Martes pennanti	Blackcat, Fisher, Pekan	Approved	Present	Native	Rare	nan	nan	nan


CREATE TABLE species (
  "species_id" VARCHAR,
  "park_name" VARCHAR,
  "category" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "scientific_name" VARCHAR,
  "common_names" VARCHAR,
  "record_status" VARCHAR,
  "occurrence" VARCHAR,
  "nativeness" VARCHAR,
  "abundance" VARCHAR,
  "seasonality" VARCHAR,
  "conservation_status" VARCHAR,
  "unnamed_13" VARCHAR
);