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

22 rows where pres_or_congress = "W. Clinton"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: states, current_agency, action, date, year

Link rowid ▼ current_name states original_name current_agency action date year pres_or_congress acres_affected
38 38 Pinnacles National Park California Pinnacles National Monument NPS Enlarged 1/11/00 2000 W. Clinton 7,900
152 152 Craters of the Moon National Monument Idaho   NPS, BLM Enlarged under BLM 11/9/00 2000 W. Clinton 661,287
251 251 Buck Island Reef National Monument Virgin Islands   NPS Enlarged 1/17/01 2001 W. Clinton 17,255
281 281 Grand Staircase-Escalante National Monument Utah   BLM Established 9/18/96 1996 W. Clinton 1,700,000
282 282 Agua Fria National Monument Arizona   BLM Established 1/11/00 2000 W. Clinton 71,100
283 283 California Coastal National Monument California   BLM Established (BLM) 1/11/00 2000 W. Clinton 883
286 286 Grand Canyon-Parashant National Monument Arizona   BLM Established 1/11/00 2000 W. Clinton 1,014,000
287 287 Part of Sequoia National Forest California Giant Sequoia National Monument USFS Established 4/15/00 2000 W. Clinton 327,769
288 288 Canyon of the Ancients National Monument Colorado   BLM Established 6/9/00 2000 W. Clinton 164,000
289 289 Cascade-Siskiyou National Monument Oregon   BLM Established (BLM) 6/9/00 2000 W. Clinton 52,000
291 291 Hanford Reach National Monument Washington   FWS Established 6/9/00 2000 W. Clinton 195,000
292 292 Ironwood Forest National Monument Arizona   BLM Established 6/9/00 2000 W. Clinton 128,917
293 293 President Lincoln and Soldier's Home National Monument Washington, DC   NPS Established 7/7/00 2000 W. Clinton 2.3
294 294 Vermillion Cliffs National Monument Arizona   BLM Established 11/9/00 2000 W. Clinton 293,000
295 295 Carrizo Plain National Monument California   BLM Established 1/17/01 2001 W. Clinton 204,107
296 296 Kasha-Katuwe Tent Rocks National Monument New Mexico   BLM Established 1/17/01 2001 W. Clinton 4,148
297 297 Minidoka National Historic Site Idaho Minidoka Internment National Monument NPS Established 1/17/01 2001 W. Clinton 72.75
299 299 Pompeys Pillar National Monument Montana   BLM Established 1/17/01 2001 W. Clinton 51
300 300 Sonoran Desert National Monument Arizona   BLM Established 1/17/01 2001 W. Clinton 486,149
301 301 Upper Missouri River Breaks National Monument Montana   BLM Established 1/17/01 2001 W. Clinton 377,346
302 302 Virgin Islands Coral Reef National Monument Virgin Islands   NPS Established 1/17/01 2001 W. Clinton 12,708
303 303 Governors Island National Monument New York   NPS Established 1/19/01 2001 W. Clinton 20

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 59.216ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette