The United States National Parks by Kaggle | Demographics and Population Studies

About this Dataset

The United States National Parks

Discover America's Natural Wonders

About this dataset

The United States is home to 63 national parks, each with its own unique story and natural wonders to explore. This dataset provides information on all of the national parks in the country, including the state in which each park is located, the date when it was established, its total area, the number of recreation visitors it receives each year, and a description of its key features. Whether you're looking to discover America's hidden gems or simply want to find a new place to explore, this dataset is a great resource for planning your next adventure

How to use the dataset

This dataset has been designed to provide information on the 63 national parks in the United States. It includes data on the park name, location, date established, area, recreation visitors, and description. This dataset can be used by researchers interested in studying the national parks of the United States, as well as by individuals planning a visit to one or more of these parks

Research Ideas

Creating a map of all 63 national parks in the US
Determining which states have the most national parks
Planning a road trip to visit all 63 national parks

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: df_1.csv

Column name	Description
0

File: df_4.csv

File: df_3.csv

Column name	Description
State	The state in which the national park is located. (String)
Total parks	The total number of national parks in the state. (Integer)
Exclusive parks	The number of national parks that are exclusive to the state. (Integer)
Shared parks	The number of national parks that are shared with other states. (Integer)

File: df_2.csv

Column name	Description
Name	The name of the national park. (String)
Image	An image of the national park. (URL)
Location	The location of the national park. (String)
Description	A description of the national park. (String)

File: df_5.csv

Column name	Description
vteFederal protected areas in the United States	A list of all federal protected areas in the United States. (List)
vteFederal protected areas in the United States.1	A list of all federal protected areas in the United States, including the state in which each park is located, the total number of parks in that state, the number of exclusive parks in that state, and the number of shared parks in that state. (List)

Tables

Df 1

@kaggle.thedevastator_the_united_states_national_parks.df_1

2.28 KB
2 rows
2 columns


CREATE TABLE df_1 (
  "unnamed_0" BIGINT,
  "n_0" VARCHAR
);

Df 2

@kaggle.thedevastator_the_united_states_national_parks.df_2

28.87 KB
63 rows
8 columns


CREATE TABLE df_2 (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "image" VARCHAR,
  "location" VARCHAR,
  "date_established_as_park_7_12" VARCHAR,
  "area_2021_13" VARCHAR,
  "recreation_visitors_2021_11" BIGINT,
  "description" VARCHAR
);

Df 3

@kaggle.thedevastator_the_united_states_national_parks.df_3

4.5 KB
32 rows
5 columns


CREATE TABLE df_3 (
  "unnamed_0" BIGINT,
  "state" VARCHAR,
  "total_parks" BIGINT,
  "exclusive_parks" VARCHAR,
  "shared_parks" VARCHAR
);

Df 4

@kaggle.thedevastator_the_united_states_national_parks.df_4

1.54 KB
2 rows
1 column


CREATE TABLE df_4 (
  "unnamed_0" BIGINT
);

Df 5

@kaggle.thedevastator_the_united_states_national_parks.df_5

7.75 KB
1 row
3 columns


CREATE TABLE df_5 (
  "unnamed_0" BIGINT,
  "vtefederal_protected_areas_in_the_united_states" VARCHAR,
  "vtefederal_protected_areas_in_the_united_states_1" VARCHAR
);