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

1. Telco2008 - Database - 2,304 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.  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.

        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 where 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 Zip Code for Service Area
6	CITY	Character	25	City of Service Area.
7	REGION	Character	15	Name of Geographical Region.
8	DIVISION	Character	15	Name of Division within Regions.
9	LATITUDE	Character	15	Latitude of Centroid of Zip Code
10	LONGITUDE	Character	15	Longitude of Centroid of Zip Code
11	TELCOOPER	Character	45	Name of Telephone Company
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 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; such as CLC (Competitive Local Carrier)
18	SWNAME	Character	35	Manufacturer 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: 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	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
6	Zipcode	Character