home / fivethirtyeight

Menu
  • GraphQL API

Antiquities Act: actions_under_antiquities_act.csv

Table actions
  • GraphQL API for antiquities-act/actions_under_antiquities_act

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

8 rows where states = "Montana"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: current_name, original_name, current_agency, action, date, year, pres_or_congress, acres_affected

Link rowid ▼ current_name states original_name current_agency action date year pres_or_congress acres_affected
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
47 47 Lewis and Clark Caverns State Park Montana Lewis and Clark Cavern National Monument State of Montana Boundaries Confirmed 5/16/11 1911 W. Taft 160
48 48 Lewis and Clark Caverns State Park Montana Lewis and Clark Cavern National Monument State of Montana Transferred to MT, now a state park 8/24/37 1937 75th Congress  
80 80 Big Hole National Battlefield Montana Big Hole Battlefield National Monument NPS Established 6/23/10 1910 W. Taft 5
81 81 Big Hole National Battlefield Montana Big Hole Battlefield National Monument NPS Enlarged 6/29/39 1939 F. D. Roosevelt 195
82 82 Big Hole National Battlefield Montana Big Hole Battlefield National Monument NPS Redesignated NB 5/17/63 1963 88th Congress  
299 299 Pompeys Pillar National Monument Montana   BLM Established 1/17/01 2001 W. Clinton 51
301 301 Upper Missouri River Breaks National Monument Montana   BLM Established 1/17/01 2001 W. Clinton 377,346

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
);
Powered by Datasette · Queries took 86.882ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette