|
1
|
Dupe Zip
|
Character
|
|
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
|
Bus_POBox
|
Character
|
10
|
ID’s Zip
as Business Zip Code, not consumer
|
|
6
|
Consumer
|
Character
|
10
|
ID’s Zip
as Consumer, not business
|
|
7
|
City
|
Character
|
25
|
City of
Service Area.
|
|
8
|
CityAlias
|
Character
|
75
|
Alias Name
for City in Service Area
|
|
9
|
County
|
Character
|
25
|
County of
City within Service Area.
|
|
10
|
State
|
Character
|
3
|
State by
5-Digit Zip Code for Service Area
|
|
11
|
MarketName
|
Character
|
45
|
Name of
Designated Market area
|
|
12
|
MarketRank
|
Character
|
3
|
Rank of
Market Area
|
|
13
|
Region
|
Character
|
15
|
Name of
Geographical Region in the US.
|
|
14
|
Division
|
Character
|
15
|
Name of
Division of Regions.
|
|
15
|
Latitude
|
Character
|
15
|
Latitude of
Centroid of Zip Code in Service Area
|
|
16
|
Longitude
|
Character
|
15
|
Longitude of Centroid of Zip Code in Service Area
|
|
17
|
TelcoOper
|
Character
|
45
|
Name of Telephone Company serving the area.
|
|
18
|
CableOper
|
Character
|
55
|
Name of Primary Cable Operator serving the area.
|
|
19
|
AltCable
|
Character
|
55
|
Alternate Cable System
|
|
20
|
AltCable2
|
Character
|
55
|
Alternate Cable System # 2
|
|
21
|
UverseCBL
|
Character
|
15
|
AT&T U-Verse Cable Service
|
|
22
|
FiOSCBL
|
Character
|
15
|
Verizon FiOS Cable Service
|
|
23
|
TotalPOP
|
Character
|
15
|
Total Population within the Service Area Zip Code.
|
|
24
|
TotalHH
|
Character
|
15
|
Total House Holds within the Service Area Zip Code.
|
|
25
|
CableSUBS
|
Character
|
15
|
Total Cable Subscribers within the Service Area Zip
Code
|
|
26
|
OCN
|
Character
|
45
|
Unique Operating Company Number
|
|
27
|
RateCenter
|
Character
|
45
|
A geographically specified area used for determining
mileage and/or usage dependent rates in the Public Switched
Telephone Network.
|
|
28
|
CLLI
|
Character
|
20
|
Common Language Location Identifier.
|
|
29
|
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.
|
|
30
|
SWName
|
Character
|
35
|
Manufacturer/Suppier of Switch Equipment
|
|
31
|
SWType
|
Character
|
35
|
Model/Type of Switch Equipemnet
|
|
32
|
LATA
|
Character
|
55
|
3 Digit
Code for each Local Access Transport Area.
|
|
33
|
Broadband
|
Character
|
15
|
Identification as
Broadband Sysem
|
|
1
|
AREACODE
NPA)
|
Character
|
10
|
3-Digit
Area Code
|
|
2
|
PREFIX
(NXX)
|
Character
|
10
|
The area
designated as the area within which a LEC or CLC may provide
local exchange services.
|
|
3
|
COMZIP
|
Character
|
10
|
5-Digit Zip
Code associated with the State and City
|
|
4
|
COUNTY
|
Character
|
25
|
County of
City within Service Area.
|
|
5
|
STATE
|
Character
|
3
|
State by
5-Digit Zip Code for Service Area
|
|
6
|
CITY
|
Character
|
25
|
City of
Service Area.
|
|
7
|
CITYALIAS
|
Character
|
75
|
Alias Name
for City in Service Area
|
|
8
|
CLLI
|
Character
|
20
|
Common Language Location Identifier.
|
|
9
|
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.
|
|
10
|
LATA
|
Character
|
55
|
3 Digit
Code for each Local Access Transport
|