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

7 rows where pres_or_congress = "G. W. Bush"

✎ 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
304 304 Governors Island National Monument New York   NPS Reaffirmed 1/31/03 2003 G. W. Bush 22
305 305 African Burial Ground National Monument New York   NPS Established 2/27/06 2006 G. W. Bush 0.345
306 306 Papahānaumokuākea Marine National Monument Hawaii Northwestern Hawaiian Islands National Monument FWS, NOAA Established (FWS and NOAA) 6/15/06 2006 G. W. Bush 140,000 sq. miles
309 309 World War II Valor in the Pacific National Monument Hawaii   NPS, FWS Established 12/5/08 2008 G. W. Bush 6,310 sq. miles
310 310 Rose Atoll National Monument American Samoa   NOAA Established 1/6/09 2009 G. W. Bush 13,451 sq. miles
311 311 Pacific Remote Islands National Monument Hawaii   FWS, NOAA Established 1/6/09 2009 G. W. Bush 86,888 sq. miles
313 313 Mariana's Trench National Monument Northern Mariana Islands, Guam   NOAA Established 1/6/09 2009 G. W. Bush 95,216 sq. miles

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
);