National Park Species Dataset

National Park Species Dataset 2024

@kaggle.umerhaddii_national_park_species_dataset

Table List

1 table(1.37 MB)

Most Visited Nps Species Data

@kaggle.umerhaddii_national_park_species_dataset.most_visited_nps_species_data

1.37 MB
61119 rows
28 columns

parkcode ParkCode	parkname ParkName	categoryname CategoryName	order Order	family Family	taxonrecordstatus TaxonRecordStatus	sciname SciName	commonnames CommonNames	parkaccepted ParkAccepted	recordstatus RecordStatus	occurrence Occurrence	occurrencetags OccurrenceTags	nativeness Nativeness	nativenesstags NativenessTags	abundance Abundance	npstags NPSTags	parktags ParkTags	references References	observations Observations	externallinks ExternalLinks	testatus TEStatus	statestatus StateStatus	ozonesensitivestatus OzoneSensitiveStatus	grank GRank	srank SRank
ACAD	Acadia National Park	Mammal	Artiodactyla	Cervidae	Active	Alces alces	Moose	true	Approved	Present	nan	Native	nan	Rare	Resident	nan	11	1	nan	50	nan	nan	G5	ME: S5
ACAD	Acadia National Park	Mammal	Artiodactyla	Cervidae	Active	Odocoileus virginianus	Northern White-tailed Deer, Virginia Deer, White-tailed Deer	true	Approved	Present	nan	Native	nan	Abundant	nan	nan	20		nan	50	nan	nan	G5	ME: S5
ACAD	Acadia National Park	Mammal	Carnivora	Canidae	Active	Canis latrans	Coyote, Eastern Coyote	true	Approved	Present	nan	Non-native	nan	Common	nan	nan	8	1	nan	SC	nan	nan	G5	ME: S5
ACAD	Acadia National Park	Mammal	Carnivora	Canidae	Active	Canis lupus	Eastern Timber Wolf, Gray Wolf, Timber Wolf	true	Approved	Unconfirmed	nan	Native	nan	nan	nan	nan	2		nan	E	nan	nan	G5	ME: SH
ACAD	Acadia National Park	Mammal	Carnivora	Canidae	Active	Vulpes vulpes	Black Fox, Cross Fox, Eastern Red Fox, Fox, Red Fox, Silver Fox	true	Approved	Present	nan	Unknown	nan	Common	Breeder	nan	16		nan	nan	nan	nan	G5	ME: S5
ACAD	Acadia National Park	Mammal	Carnivora	Felidae	Active	Lynx canadensis	Canada Lynx	true	Approved	Unconfirmed	nan	Native	nan	nan	nan	nan	1		nan	nan	ME: SC	nan	G5	ME: S2
ACAD	Acadia National Park	Mammal	Carnivora	Felidae	Active	Lynx rufus	Bay Lynx, Bobcat, Red Lynx, Wild Cat	true	Approved	Present	nan	Non-native	nan	nan	Vagrant	nan	7		nan	RT	nan	nan	G5	ME: S5
ACAD	Acadia National Park	Mammal	Carnivora	Mephitidae	Active	Mephitis mephitis	Eastern Skunk, Polecat, Striped Skunk	true	Approved	Not In Park	Historical	Native	nan	nan	nan	nan	10		nan	nan	nan	nan	G5	ME: S5
ACAD	Acadia National Park	Mammal	Carnivora	Mustelidae	Active	Lutra canadensis	Otter, River Otter	true	Approved	Present	nan	Native	nan	Common	Breeder	nan	10		nan	nan	nan	nan	nan	nan
ACAD	Acadia National Park	Mammal	Carnivora	Mustelidae	Active	Martes pennanti	Blackcat, Fisher, Pekan	true	Approved	Present	nan	Native	nan	Rare	nan	nan	5		nan	nan	nan	nan	nan	nan


CREATE TABLE most_visited_nps_species_data (
  "parkcode" VARCHAR,
  "parkname" VARCHAR,
  "categoryname" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "taxonrecordstatus" VARCHAR,
  "sciname" VARCHAR,
  "commonnames" VARCHAR,
  "synonyms" VARCHAR,
  "parkaccepted" BOOLEAN,
  "sensitive" BOOLEAN,
  "recordstatus" VARCHAR,
  "occurrence" VARCHAR,
  "occurrencetags" VARCHAR,
  "nativeness" VARCHAR,
  "nativenesstags" VARCHAR,
  "abundance" VARCHAR,
  "npstags" VARCHAR,
  "parktags" VARCHAR,
  "references" BIGINT,
  "observations" BIGINT,
  "vouchers" BIGINT,
  "externallinks" VARCHAR,
  "testatus" VARCHAR,
  "statestatus" VARCHAR,
  "ozonesensitivestatus" VARCHAR,
  "grank" VARCHAR,
  "srank" VARCHAR
);