Skip common site navigation and headers
United States Environmental Protection Agency
Pesticides: Endangered Species Protection Program
Begin Hierarchical Links EPA Home > Pesticides > Environmental Effects > Endangered Species Protection Program > Endangered Species Protection Program Databases End Hierarchical Links
For Kids:
  Coloring Book
  Poster
  

 

Endangered Species Protection Program Databases

The databases available here are the endangered species by county database (ES_COUNT.DBF) and the species information database (SPECIES.DBF). They are contained in a self-extracting compressed file named "county99.exe."  Once you have downloaded the file to a directory on your computer, you can extract all the files in the archive by simply typing the name of the file at the DOS prompt.

The databases here have been updated as of  December 31, 1999.  The Agency's Endangered Species Protection Program will release newer, updated files periodically. Click here to download county99.exe.

Structure of the databases:

Structure of the ES_COUNT.DBF file:

Field Description
STATE 2-letter state abbreviation
NSTATE Full state name
COUNTY County name
FIPS2 FIPS code for the county and state (5-digit)
KNOWN Whether the species is known to occur in the county
INVNAME Common name - inverse listing
XGROUP Clarification of the KNOWN field. F in KNOWN field means that existence of the species is possible.
ACTION Type of listing action (Listing, Proposed, Delisting)
DATE Date this file was released
GROUP Taxonomic group

Structure of the SPECIES.DBF file:

Field Description
INVNAME Common name - inverse listing
SCINAME Scientific name
ACTION Type of listing action (Listing, Proposed, Delisting)
STATUS Indicates species status (see below.)
ACTDATE Date of FWS final listing
GROUPNAME Taxonomic group
FAMILY Taxonomic family
DATE Date this file was released

Species status codes:

  • PE = Proposed Endangered
  • PT = Proposed Threatened
  • E = Endangered
  • T = Threatened
  • CH = Critical Habitat
  • PXN = Proposed Nonessential Experimental Population
  • PXE = Proposed Essential Experimental Population
  • XN = Nonessential Experimental Population
  • XE = Essential Experimental Population
  • PD = Proposed delisting
  • Delist = Delisted
  • S/A = For similarity of appearance species

 

Publications | Glossary | A-Z Index | Jobs

 
Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us