| Field# |
Field Name |
Data Type |
Field Description |
| 1 |
ZIP_CODE |
nchar(5) |
The ZIP Code of the city designated by the USPS. |
| 2 |
CITY |
varchar(35) |
The name of the city designated by the USPS. |
| 3 |
STATE |
char(2) |
The two-letter abbreviation for the state to that particular ZIP code. |
| 4 |
AREA_CODE |
varchar(40) |
The telephone area code belonging to the particular postal code is located. |
| 5 |
CITY_ALIAS_NAME |
varchar(35) |
The alias name for the ZIP Code. This may be a city name, postal entity,
community or a municipality name. |
| 6 |
CITY_ALIAS_ABBR |
varchar(13) |
This is a standard 13-character abbreviation for city alias name. This field is
empty if names are less or equal to 13-character. |
| 7 |
CITY_TYPE |
char(1) |
The field indicates the type of locale identified in the city alias name such
as Post Office, station or branch. |
| 8 |
COUNTY_NAME |
varchar(25) |
The name of the county or parish in which the 5-digit ZIP Code resides. |
| 9 |
STATE_FIPS |
nchar(2) |
The FIPS code assigned to state. |
| 10 |
COUNTY_FIPS |
nchar(3) |
The FIPS code assigned to given county or parish within a state. |
| 11 |
TIME_ZONE |
nchar(2) |
The time zone number represents by the hours past the Greenwich Time Zone. |
| 12 |
DAY_LIGHT_SAVING |
char(1) |
This flag indicates whether the city observe day light saving. |
| 13 |
LATITUDE |
numerical |
The geographic coordinate of a point measured in degrees north or south of the
equator. |
| 14 |
LONGITUDE |
numerical |
The geographic coordinate of a point measured in degrees east or west of the
Greenwich meridian. |
| 15 |
ELEVATION |
numerical |
The counties average elevation. |
| 16 |
MSA2000 |
nchar(4) |
Metropolitan Statistical Area based on Census 2000 |
| 17 |
PMSA |
nchar(4) |
Primary Metropolitan Statistical Area |
| 18 |
CBSA |
nchar(5) |
Core Based Statistical Area, Metropolitan Statistical Area and Micropolitan
Statistical Area released by OMB in Year 2003 |
| 19 |
CBSA_DIV |
nchar(5) |
Metropolitan Division |
| 20 |
CBSA_TITLE |
varchar(128) |
Full title description of CBSA and MSA |
| 21 |
PERSONS_PER_HOUSEHOLD |
numeric |
The average amount of persons per Household based on Census 2000. |
| 22 |
ZIPCODE_POPULATION |
numeric |
The population of the ZIP Code based on Census 2000. |
| 23 |
COUNTIES_AREA |
numeric |
The counties square mileage based on Census 2000. |
| 24 |
HOUSEHOLDS_PER_ZIPCODE |
numeric |
Total estimated amount of households per ZIP Code based on Census 2000. |
| 25 |
WHITE_POPULATION |
numeric |
The estimate of Black population per ZIP code based on Census 2000. |
| 26 |
BLACK_POPULATION |
numeric |
The estimate of Black population per ZIP code based on Census 2000. |
| 27 |
HISPANIC_POPULATION |
numeric |
The estimate of Hispanic population per ZIP code based on Census 2000. |
| 28 |
INCOME_PER_HOUSEHOLD |
numeric |
The average household income within county based on Census 2000. |
| 29 |
AVERAGE_HOUSE_VALUE |
numeric |
The average house value within county based on Census 2000. |
