Telco Data

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

1. TeleCom2009 - Database - 5,804 Records Product Code 201
The Telecom 2009 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. Lata2009- 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 LATA2009 database can be imported into most mapping software programs so that you can create your own unique LATA Maps.

3. Telephone2009- Database - 193,938 Records Product Code 203
The Telco2009 is the most complete set of data currently available for the Industry. With over 193,000 records the Telco2009 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.      TelephoneCable2009- Database - 193,938 Records            Product Code 204
       The TelephoneCable database includes all of the data available in Telephone2009, 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: Telecom2009.DBF/Telco2009.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: Telephone2009.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	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.

Structure for table: LATA2009.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 Area.

5. Complete Telco/Cable Group 2009- Database Product Code 205
The CompleteTelcoCableGroup2009 Includes all of the following databases. This group enables you to analyze every aspect of the Telephone and Cable industry.

For details of datafields in the Complete Telco/Cable Group 2009, scroll down;

TelcoCableGroup2009
(All Databases below are included in the Telco/Cable Group Product Code 205)

TelephoneCable2009

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	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.

1	Company Name	Character	35	3-Digit Area Code
2	Address	Character	10	The area designated as the area within which a LEC or CLC may provide local exchange services.
3	City	Character	10	5-Digit Zip Code associated with the State and City
4	State	Character	25	County of City within Service Area.
5	City/State/Zipcode	Character	3	State by 5-Digit Zip Code for Service Area
6	Zipcode	Character	25	City of Service Area.
7	Fax Number	Character	75	Alias Name for City in Service Area
8	Telephone		15	Main Telephone Number
9	General Manager	Character	45	Name of Designated Market area
10	Web Site	Character	15	Name of Geographical Region in the US.
11	Email	Character	15	Name of Division within Regions.
12	Service Type	Character	10	RBOC, ILEC, CLEC, etc...
13	Corporate Owners	Character	45	Corporate Owner

1	COMSTATE	Character	10	State System located in
2	COMMUNITY	Character	35	Community System located in
3	COMZIP	Character	10	Zip Code covered by System
4	COUNTY	Character	45	County of Office
5	SYSTEMNAME	Character	50	System Assumed Name
6	ADDRESS	Character	35	Mailing Address
7	MAILCITY	Character	35	Mailing City (Office)
8	STATE	Character	15	Mailing State
9	ZIPCODE	Character	5	Mailing Zip Code
10	GM	Character	75	General Manager Name
11	GMEMAIL	Character	75	General Manager Email Address
12	AREAMGR	Character	75	Area/Region Manager
13	AMPHONE	Character	15	Telephone of Area/Region Manager
14	AMEMAIL	Character	75	Area/Region Manager Email Address
15	ENGMGR	Character	45	Engineering Manager Name
16	ENGEMAIL	Character	75	Engineering Manager Email Address
17	TELEPHONE	Character	15	Office Telephone
18	FAX	Character	15	Office Fax
19	SYSTEMSUBS	Numeric	8	Total Subscribers for system
20	SYSMILES	Numeric	8	Total Miles of cable plant for system
22	SYSHH	Numeric	8	Total Households in franchise
22	HHPASSED	Numeric	8	Total Households passed in the Franchise
23	WEBSITE	Character	45	Web Site URL
24	SERVICE	Character	55	Type of Service
25	MODEM	Character	55	Modem Manufacturer
26	DIGITAL	Character	10	Digital or Analog Service

1	OWNERMSO	Character	50	Corporate Owner
2	ADDRESS	Character	30	Address
3	MAILADDRES	Character	13	Address #2(PO Box)
4	CITY	Character	25	Mail City
5	STATE	Character	2	Mail State
6	ZIPCODE	Character	10	Zip Code
7	TELEPHONE	Character	12	Telephone
8	FAX	Character	12	Fax
9	BASICSUBS	Numeric	9	Total Basicsubs for Operator
10	SYSOWNED	Numeric	6	Total Number of Systems Owned
11	ENGMANAGER	Character	20	Engineering Manager
12	CHIEFEXOFF	Character	20	CEO
13	CHIEFOPOFF	Character	20	Executive VP
14	CHIEFFIOFF	Character	20	Financial Officer
15	PROGRAMMER	Character	20	Programming Manager
16	ADMANAGER	Character	20	Advertising Manager
17	MCSZ	Character	30	Mail, City, State, Zip code (For mailing labels)
18	WEBSITE	Character	50

1	SYSTEMID	Character	9	System Identification number
2	COMZIP	Character	10	Community/Zip Code
3	COMMUNITY	Character	40	Community Name
4	COMSTATE	Character	2	Community/State
5	SYSTEMNAME	Character	50	System Assumed Name
6	ADDRESS	Character	30	System Mailing Address
7	CITY	Character	24	System Mailing City
8	STATE	Character	9	System Mailing State
9	ZIPCODE	Character	9	System Mailing Zip Code
10	COMMALIAS	Character	35	Alias name for community (Example: Los Angeles = Whittier)
11	COUNTY	Character	34	County community located in
12	TELEPHONE	Character	15	Local Telephone
13	GM	Character	35	General Manager
14	GMEMAIL	Character	65	General Manager Email
15	DIGANALOG	Character	15	Digital or Analog Service
16	LATITUDE	Character	25	Community Latitude Centroid
17	LONGITUDE	Character	25	Community Longitude Centroid
18	BASICSUBS	Character	20	Total Subs within community
19	SYSSUBS	Character	20	Total Subscribers for Franchise
20	PLANTMILES	Character	20	Total Cable Plant Miles for Community/Zip Code
21	TOTALPOP	Character	20	Total Population for Community/Zip Code
22	TOTALHH	Character	20	Total Households for Community/Zip Code
23	WHITEPOP	Character	20	Total White Population in Community/Zip Code
24	BLACKPOP	Character	20	Total Black Population in Community/Zip Code
25	HISPPOP	Character	20	Total Hispanic Population in Community/Zip Code
26	HHINCOME	Character	20	Household Income in Community/Zip Code
27	HHVALUE	Character	20	Average HH Value
28	TOTALSYS	Character	20	Total subscriber for the Franchise (Nation Wide)
29	DIGITAL	Character	10	Digital or Analog Service
30	MODEM	Character	11	Manufacturer of Internet/Modems
31	Service	Character	11	Name/Type of Internet Service