Telco Data

SoftMedia’s Telco System Database Group is comprised of (5) individual database group;

1. TeleCom2008 - 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. Telephone2008- Database - 193,938 Records Product Code 203
The Telco2008 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.

4.      TelephoneCable2008- Database - 193,938 Records            Product Code 204
       The TelephoneCable database includes all of the data available in Telephone2008, Plus it includes the
       Systemname of the Cable Operator and the number of Subscribers, House-Hold by 5 digit zip code.
       You can view Telephone Cable data by area code, prefix, house-holds, cable franchise, digital service,
       Internet, Telco service providers or hundreds of combinations.
       This new version of has an additional data field called ‘COMMALIAS’. This datafield is the
       community alias name As an example; Most of the Primary zip codes have the same name in large
       cities such as Los Angeles or New York. The community alias is the alias name given to small
       communities within the large city areas. (Example: Los Angeles = Whittier)

SoftMedia’s cablecomzip files can be imported into most mapping software programs.
(Sample Map)

Structure for table: Telecom2008.DBF/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	Physical Address
3	City	Character	10	City
4	State	Character	25	State
5	City/State/Zipcode	Character	3	Mailing City/State/Zip Code for labeling convenience
6	Zipcode	Character	25	Zip Code
7	Fax Number	Character	75	Office Fax Number
8	Telephone		15	Main Telephone Number
9	General Manager	Character	45	General Manager
10	Web Site	Character	15	URL
11	Email	Character	15	GM Email
12	Service Type	Character	10	RBOC, ILEC, CLEC, etc...
13	Corporate Owners	Character	45	Corporate Owner

Structure for table: Telephone2008.DBF Product Code 203
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	REGION	Character	15	Name of Geographical Region in the US.
8	DIVISION	Character	15	Name of Division within Regions.
9	LATITUDE	Character	15	Latitude of Centroid of Zip Code in Service Area
10	LONGITUDE	Character	15	Longitude of Centroid of Zip Code in Service Area
11	TELCOOPER	Character	45	Name of Telephone Company serving the area.
12	TOTALPOP	Character	15	Total Population within the Service Area Zip Code.
13	TOTALHH	Character	15	Total House Holds within the Service Area Zip Code.
14	OCN	Character	45	Unique Operating Company Number
15	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.
16	CLLI	Character	20	Common Language Location Identifier.
17	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.
18	SWNAME	Character	35	Manufacturer/Suppier of Switch Equipment
19	SWTYPE	Character	35	Model/Type of Switch Equipemnet
20	LATA	Character	55	3 Digit Code for each Local Access Transport Area.

Structure 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	DMANAME & Rank	Character	45	Name of Designated Market area
9	REGION	Character	15