|
1
|
Dupe Zip
|
Character
|
10
|
Duplicate Zip
Code used for sorting
|
|
2
|
AreaCode (NPA)
|
Character
|
10
|
3-Digit Area
Code
|
|
3
|
Prefix
(NXX)
|
Character
|
10
|
The area
designated as the area within which a LEC or CLC may provide local
exchange services.
|
|
4
|
ComZIP
|
Character
|
10
|
5-Digit Zip
Code associated with the State and City
|
|
5
|
PlaceCode
|
Character
|
15
|
State,County,City
FIPS Place Code
|
|
6
|
Bus_POBox
|
Character
|
10
|
ID’s Zip as
Business Zip Code, not consumer
|
|
7
|
Consumer
|
Character
|
10
|
ID’s Zip as
Consumer, not business
|
|
8
|
City
|
Character
|
25
|
City of
Service Area.
|
|
9
|
CityAlias
|
Character
|
75
|
Alias Name
for City in Service Area
|
|
10
|
County
|
Character
|
25
|
County of
City within Service Area.
|
|
11
|
State
|
Character
|
3
|
State by
5-Digit Zip Code for Service Area
|
|
12
|
MarketName
|
Character
|
45
|
Name of
Designated Market area
|
|
13
|
DTVMARank
|
Character
|
3
|
Rank of
Market Area
|
|
14
|
Region
|
Character
|
15
|
Name of
Geographical Region in the US.
|
|
15
|
Division
|
Character
|
15
|
Name of
Division of Regions.
|
|
16
|
Latitude
|
Character
|
15
|
Latitude of
Centroid of Zip Code in Service Area
|
|
17
|
Longitude
|
Character
|
15
|
Longitude
of Centroid of Zip Code in Service Area
|
|
18
|
TelcoOper
|
Character
|
45
|
Name
of Telephone Company serving the area.
|
|
19
|
CableOper
|
Character
|
55
|
Name
of Primary Cable Operator serving the area.
|
|
20
|
UverseCBL
|
Character
|
15
|
AT&T
U-Verse Cable Service
|
|
21
|
FiOSCBL
|
Character
|
15
|
Verizon
FiOS Cable Service
|
|
22
|
POPbyZip
|
Character
|
15
|
Total
Population within the Service Area Zip Code.
|
|
23
|
HHbyZip
|
Character
|
15
|
Total
House Holds within the Service Area Zip Code.
|
|
24
|
CableSUBS
|
Character
|
15
|
Total
Cable Subscribers within the Service Area Zip Code
|
|
25
|
OCN
|
Character
|
45
|
Unique
Operating Company Number
|
|
26
|
RateCenter
|
Character
|
45
|
A
geographically specified area used for determining mileage and/or
usage dependent rates in the Public Switched Telephone Network. A
rate center is not always the exact equivalent of an Exchange Area,
but can be.
|
|
27
|
CLLI
|
Character
|
20
|
Common
Language Location Identifier.
|
|
28
|
Type
|
Character
|
10
|
Codes
to Identify various service types; CLC (Competitive Local Carrier),
CLEC (Competitive Local Exchange Carrier), IEC (InterExchange
Carrier) see the list of acronyms for details.
|
|
29
|
SWName
|
Character
|
35
|
Manufacturer/Suppier
of Switch Equipment
|
|
30
|
SWType
|
Character
|
35
|
Model/Type
of Switch Equipemnet
|
|
3 31
|
LATA
|
Character
|
55
|
3 Digit Code
for each Local Access Transport Area.
|
|
32
|
Broadband
|
Character
|
15
|
Identification as Broadband
System
|