Antiquities Act: actions_under_antiquities_act.csv

Table actions

This table contains the data behind the story Trump Might Be The First President To Scrap A National Monument.

This data was compiled by the National Parks Conservation Association and includes national monuments that were created by presidents by under the Antiquities Act. It does not include national monuments created by Congress.

Header Definition
current_name Current name of piece of land designated under the Antiquities Act
states State(s) or territory where land is located
original_name If included, original name of piece of land designated under the Antiquities Act
current_agency Current land management agency. NPS = National Parks Service, BLM = Bureau of Land Management, USFS = US Forest Service, FWS = US Fish and Wildlife Service, NOAA = National Oceanic and National Oceanic and Atmospheric Administration
action Type of action taken on land
date Date of action
year Year of action
pres_or_congress President or congress that issued action
acres_affected Acres affected by action. Note that total current acreage is not included. National monuments that cover ocean are listed in square miles.

Sources: National Parks Conservation Association and National Parks Service Archeology Program

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

18 rows where pres_or_congress = "T. Roosevelt"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: current_name, states, current_agency, date, year, acres_affected

Link rowid ▼ current_name states original_name current_agency action date year pres_or_congress acres_affected
1 1 Devils Tower National Monument Wyoming   NPS Established 9/24/06 1906 T. Roosevelt 1,193.91
2 2 El Morro National Monument New Mexico   NPS Established 12/8/06 1906 T. Roosevelt 160
4 4 Montezuma Castle National Monument Arizona   NPS Established 12/8/06 1906 T. Roosevelt 161.39
8 8 Petrified Forest National Park Arizona Petrified Forest National Monument NPS Established 12/8/06 1906 T. Roosevelt 60,776.02
14 14 Chaco Culture National Historical Park New Mexico Chaco Canyon National Monument NPS Established 3/11/07 1907 T. Roosevelt 10,643.13
17 17 Lassen Volcanic National Park California Cinder Cone National Monument NPS Established 5/6/07 1907 T. Roosevelt 5,120
19 19 Lassen Volcanic National Park California Lassen Volcanic National Monument NPS Established 5/6/07 1907 T. Roosevelt 1,280
21 21 Gila Cliff Dwellings National Monument New Mexico   NPS Established 11/16/07 1907 T. Roosevelt 160
23 23 Tonto National Monument Arizona   NPS Established 12/19/07 1907 T. Roosevelt 640
25 25 Muir Woods National Monument California   NPS Established 1/9/08 1908 T. Roosevelt 295
30 30 Grand Canyon National Park Arizona Grand Canyon National Monument NPS Established 1/11/08 1908 T. Roosevelt 808,120
32 32 Pinnacles National Park California Pinnacles National Monument NPS Established 1/16/08 1908 T. Roosevelt 1,320
40 40 Jewel Cave National Monument South Dakota   NPS Established 2/7/08 1908 T. Roosevelt 1,274.56
41 41 Natural Bridges National Monument Utah   NPS Established 4/16/08 1908 T. Roosevelt 120
46 46 Lewis and Clark Caverns State Park Montana Lewis and Clark Cavern National Monument State of Montana Established 5/11/08 1908 T. Roosevelt 160
49 49 Tumacacori National Historical Park Arizona Tumacacori National Monument NPS Established 9/15/08 1908 T. Roosevelt 10
54 54 Part of Rio Grande National Forest Colorado Wheeler National Monument BLM Established 12/7/08 1908 T. Roosevelt 300
56 56 Olympic National Park Washington Mount Olympus NPS Established 3/2/09 1909 T. Roosevelt 639,200

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "antiquities-act/actions_under_antiquities_act" (
"current_name" TEXT,
  "states" TEXT,
  "original_name" TEXT,
  "current_agency" TEXT,
  "action" TEXT,
  "date" TEXT,
  "year" INTEGER,
  "pres_or_congress" TEXT,
  "acres_affected" TEXT
);