| 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(30) |
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
July 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 |
STATE_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 east or west of
the Greenwich meridian. |
| 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. |
