ZIP Code Database Technical Specs

Questions? 1-800-425-1169
Field Names, Descriptions, and More

Actual Customer Emails
I appreciate your great customer service and your fine product.
Best,
Alan Maitland
Online Yellow Pages
ZIP Code Database versions
Tired of Downloading?
Take a look at our
ZIP Code API

Database Technical Specifications


Downloads

Review Purchase Options


Show:

  • All Fields
  • Standard Database Fields Only
  • Deluxe Database Fields Only
  • Business Database Fields Only
Field Name Data Type Description
ZipCodeChar(5)00000-99999 Five digit numeric ZIP Code of the area.
StateChar(2)2 letter state name abbreviation.
StateFullNameVarChar(35)The full US State Name.
CityVarChar(35)Name of the city as designated by the USPS.
CityAliasNameVarChar(35)Alias name of the city if it exists.
CountyVarChar(45)Name of County or Parish this ZIP Code resides in.
AreaCodeVarChar(55)The telephone area codes available in this ZIP Code.
LatitudeDecimal(12, 6)Geographic coordinate as a point measured in degrees north or south of the equator.
LongitudeDecimal(12, 6)Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian.
ElevationIntegerThe average elevation of the county.
CityTypeChar(1)Indicates the type of locale such as Post Office, Stations, or Branch.
CityAliasAbbreviationVarChar(13)13 Character abbreviation for the city alias name.
CountyFIPSChar(5)FIPS code for the County this ZIP Code resides in.
StateFIPSChar(2)FIPS code for the State this ZIP Code resides in.
TimeZoneChar(2)Hours past Greenwich Time Zone this ZIP Code belongs to.
DayLightSavingChar(1)Flag indicating whether this ZIP Code observes daylight savings.
ClassificationCodeChar(1)The classification type of this ZIP Code.
MultiCountyChar(1)Flag indicating whether this ZIP Code crosses county lines.
CityAliasCodeVarChar(5)Code indication the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more.
PrimaryRecordChar(1)Character 'P' denoting if this row is a Primary Record or not. Absence of character denotes a non-primary record.
HouseholdsPerZipcodeIntegerThe estimated number of households of the ZIP Code based on 2010 Census data.
PersonsPerHouseholdDecimal(4, 2)The estimated average number of persons per household of the ZIP Code based on 2010 Census data.
AverageHouseValueInteger The median house value in the ZIP Code based on the latest American Community Survey (ACS) data from the U.S. Census.
IncomePerHouseholdInteger The median household per ZIP Code based on the latest American Community Survey (ACS) data from the U.S. Census.
PopulationIntegerThe population of the ZIP Code based on 2010 Census data.
CurrentPopulationIntegerThis field gives the estimated household population for this ZIP Code for September, 2017.
WhitePopulationIntegerThe estimated White/Caucasian Population of the ZIP Code based on 2010 Census data.
BlackPopulationIntegerThe estimated Black/African American Population of the ZIP Code based on 2010 Census data.
HispanicPopulationIntegerThe estimated Hispanic Population of the ZIP Code based on 2010 Census data.
AsianPopulationIntegerThe estimated Asian Population of the ZIP Code based on 2010 Census data.
HawaiianPopulationIntegerThe estimated Hawaiian or Pacific Islander Population of the ZIP Code based on 2010 Census data.
IndianPopulationIntegerThe estimated American Indian and Alaska Native Population of the ZIP Code based on 2010 Census data.
OtherPopulationIntegerThe estimated Population of all other races for the ZIP Code based on 2010 Census data.
MalePopulation Integer The estimated Male Population of the ZIP Code based on 2010 Census data.
FemalePopulationInteger The estimated Female Population of the ZIP Code based on 2010 Census data.
MSAVarChar(35)Metropolitan Statistical Area number assigned by Census 2000.
MSA_NameVarChar(150)Primary Metropolitan Statistical Area name or Title.
PMSAChar(4)Primary Metropolitan Statistical Area Number.
PMSA_NameVarChar(150)Primary Metropolitan Statistical Area name or Title.
CSAChar(3)Core Statistical Area. This area is a group of MSA's combined into a population core area.
CBSAChar(5)Core Based Statistical Area Number.
CBSA_DIVChar(5)Core Based Statistical Area Division.
CBSA_TypeChar(5)Core Based Statistical Area Type (Metro or Micro).
CBSA_NameVarChar(150)Core Based Statistical Area Name or Title.
RegionVarChar(10)4 geographically grouped areas consisting of several States
DivisionVarChar(20)9 geographically grouped areas consisting of several States
MailingNameChar(1)Yes or No (Y/N) flag indicating whether or not the USPS accepts this City Alias Name for mailing purposes.
NumberOfBusinesses Integer The total number of Business Establishments for this ZIP Code. Data taken from Census for 2011.
NumberOfEmployees Integer The total number of employees for this ZIP Code. Data taken from Census for 2011.
BusinessFirstQuarterPayroll Integer The total payroll for the first quarter this ZIP Code in $1000. Data taken from Census for 2011.
BusinessAnnualPayroll Integer The total annual payroll for this ZIP Code in $1000. Data taken from Census for 2011.
BusinessEmploymentFlag Char(1) Employment flag indicating range of employment in protected classes.
GrowthRankNumberThe rank in which this county is growing according to the US Census.
GrowingCountyAIntegerThe estimated number of housing units in this county as of July 1, 2003.
GrowingCountyBIntegerThe estimated number of housing units in this county as of July 1, 2004.
GrowthIncreaseNumberIntegerThe change in housing units from 2003 to 2004, expressed as a number.
GrowthIncreasePercentageDecimal(3, 1)The change in housing units from 2003 to 2004, expressed as a percentage.
CBSAPopulationIntegerThe estimated population for the selected CBSA in 2003.
CBSADivisionPopulationIntegerThe estimated population for the selected CBSA Division in 2003.
CongressionalDistrict VarChar(150) This field shows which 110th Congressional Districts the ZIP Code belongs to.
CongressionalLandArea VarChar(150) This field provides the approximate land area covered by the Congressional District for which the ZIP Code belongs to.
DeliveryResidentialIntegerThe # of active residential delivery mailboxes and centralized units for this ZIP Code.
DeliveryBusinessIntegerThe # of active business delivery mailboxes and centralized units for this ZIP Code.
DeliveryTotalIntegerThe total number of delivery receptacles for this ZIP Code.
MedianAgeDecimal(3, 1)The median age for all people based on 2010 Census data.
MedianAgeMaleDecimal(3, 1)The median age for males based on 2010 Census data.
MedianAgeFemaleDecimal(3, 1)The median age for females based on 2010 Census data.
PreferredLastLineKeyVarChar(10)Links this record with other products ZIP-Codes.com offers.
CityStateKeyVarChar(10)Links this record with other products ZIP-Codes.com offers such as the ZIP+4.
LandAreaDecimal(12, 6)Shows the approximate land area of this ZIP Code in square miles.
WaterAreaDecimal(12, 6)Shows the approximate water area of this ZIP Code in square miles.
CityAliasCodeVarChar(5)Code indication the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more.
CityMixedCase VarChar(35)The city name in mixed case (i.e. Not in all uppercase letters).
CityAliasMixedCaseVarChar(35)The city alias name in mixed case (i.e. Not in all uppercase letters).
BoxCountIntegerTotal count of PO Box deliveries in this ZIP Code
SFDUIntegerTotal count of single family deliveries in this ZIP Code; generally analogous to homes.
MFDUIntegerInteger Total count of multifamily deliveries in this ZIP Code; generally analogous to apartments.
StateANSIVarChar(2)ANSI code for the State this ZIP Code resides in.
CountyANSIVarChar(3)ANSI code for the County/Parish this ZIP Code resides in..
ZIPIntroVarChar(15)The date this ZIP Code was introduced into the database.
AliasIntroVarChar(15) The date this City Alias was introduced for this ZIP Code.
FacilityCodeVarChar(1)The type of locale identified in the city/state name.
CityDeliveryIndicatorVarChar(1)Specifies whether or not a post office has city-delivery carrier routes.
CarrierRouteRateSortationVarChar(1)Identifies where automation Carrier Route rates are available.
FinanceNumberVarChar(6)A code assigned to Postal Service facilities.
UniqueZIPNameVarChar(1)Field that specifies whether the City State Record contains the organization name for a unique ZIP Code.

Portions of data provided by and © United States Postal Service 2017. Zip-Codes.com is a non-exclusive licensee of the United States Postal Service.