Selection of Columns for FRS EZ Query


STEP 2: Select TWO or more column(s) for your output by clicking on the square box next to the column name.
When you are finished selecting columns, click on the STEP 3: Enter Search Criteria
button at the bottom of this page.

Selection of Columns

* Selects ALL columns listed for output!
Count Function for *. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN! Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS!
COUNT
STATE_ABBR A two-character abbreviation for the name of a state, U.S. Territory, or Armed Forces ZIP Code designation. If APO/FPO, then the State Abbreviation will be "AA", "AE", or "AP".
COUNTY_CODE The Federal Information Processing Standard (FIPS) Code assigned to a given county or parish within a state. In Alaska, it identifies a region within the state.
COUNTY_NAME The name of the U.S. county or county equivalent in which the facility site is physically located.
CITY_NAME The name of the city, town, village or other locality, when identifiable, within whose boundaries (the majority of ) the facility site is located or the name of the city where the mail is delivered. The two are not always the same.
ZIP_CODE A five-digit code which identifies a specific geographic delivery area. ZIP Codes can represent an area within a state, an area which crosses state boundaries (unusual condition) or a single building or company which has a very high mail volume. ZIP is an acronym for "Zone Improvement Plan."
REGION_CODE The code that represents an EPA region.
STATE_NAME The name of a principal administrative subdivision of the United States, Canada, or Mexico.
STD_CITY_NAME The standardized City Name returned by the standardization and parsing routines.
STD_COUNTY_NAME The standardized County Name returned by the standardization and parsing routines.
USER_ID A code that identifies the registered user of the system.
CREATE_DATE A system-generated value that represents the calendar date and time the corresponding information was first posted to the database.
STATE_CODE The U.S. Postal Service abbreviation that represents the state or state equivalent for the U.S. and Canada.