SoftMedia’s Telephone/Cable System Database Group is comprised
of (4) individual databases

1. Telco2008 - Database - 5,804 Records Product Code 201
The Telecom 2008 database is a detailed database of Telephone Companies and
includes complete contact data with management, telephone, addresses and emails.
Each record provides data on service type including those providing cable
television service.

2. Lata2008- Database - 124,169 Records Product Code 202
A LATA is a geographical area in which the local telephone company is allowed to
carry local and long distance toll calls. The LATA boundary is the point where your
call is handed off from your local carrier to your long-distance company. These areas
were defined at Divestiture, when Judge Greene broke up the AT&T monopoly in
1984. The companies LATA database goes far beyond data provided by others and
includes NPA (Area Code), NXX (Prefix), Zip Code, City, State, and LATA Number.
SoftMedia's LATA2008 database can be imported into most mapping software
programs so that you can create your own unique LATA Maps.

3. Telephone/Cable2008- Database - 193,938 Records Product Code 203
The Telephone/Cable2008 is the most complete set of data currently available for the Industry.
With over 193,000 records the Telco2008 database list 25 datafields for all
combinations of NPA/NXX/Zip Codes. Each 5 digit zip code covers all NXX codes for
Wireless, PCS and Wireline operators, Cable Operators, House-Holds, Population, and
Cable Subscribers.

4.    Telephone & Block Group Database – Records 318,370      Product Code 206.
       If you are looking for data regarding income, occupation or education etc.., then the
       smallest geographic unit for which you'll be able to get that data is the block group.
       The Tract/Block group database is quite large and is best used by applying the data in
       an overlay to your base map.

tructure for table: Telephonecable.DBF Product Code 204
Number of data records: 193,939
Field Field Name Type Width

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	MARKETNAME	Character	45	Name of Designated Market area
9	REGION	Character	15	Name of Geographical Region in the US.
10	DIVISION	Character	15	Name of Division of Regions.
11	LATITUDE	Character	15	Latitude of Centroid of Zip Code in Service Area
12	LONGITUDE	Character	15	Longitude of Centroid of Zip Code in Service Area
13	TELCOOPER	Character	45	Name of Telephone Company serving the area.
14	CABLEOPER	Character	55	Name of Cable Operator serving the area.
15	TOTALPOP	Character	15	Total Population within the Service Area Zip Code.
16	TOTALHH	Character	15	Total House Holds within the Service Area Zip Code.
17	CABLESUBS	Character	15	Total Cable Subscribers within the Service Area Zip Code
18	OCN	Character	45	Unique Operating Company Number
19	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.
20	CLLI	Character	20	Common Language Location Identifier.
21	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.
22	SWNAME	Character	35	Manufacturer/Suppier of Switch Equipment
23	SWTYPE	Character	35	Model/Type of Switch Equipemnet
24	LATA	Character	55	3 Digit Code for each Local Access Transport Area.
25	MARKETRAK	Character	5	Market Rank

       Structure for table: LATA2008.DBF                                  Product Code 202
        Number of data records: 126,904
        Field      Field Name             Type                 Width

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

        Structure for table: Telco2008.dbf                                       Product Code 201
        Number of data records: 5,804
        Field         Field Name             Type               Width

1	Company Name	Character	35	Legal Name of Telco
2	Address	Character	10