|
|
The Cellular License Areas Data Product includes the following:
- a shapefile containing all FCC Metropolitan Statistical Area and Rural Service Area license markets,
- a demographic data set including '97 Population totals and '90 Census dempgraphics,
- a license ownership table detailing Cellular market ownership including both majority and minority owners for every market,
- a company contact database containing over 5000 industry points of contact
***********************************************************************************************
Shapefile Contents
MSA/RSAs Metropolitan Statistical Area and Rural Statistical Area boundaries.
Item Descriptions and Codes:
Shape Field which stores ArcView-related geographic features
CSA Metropolitan Statistical Area or Rural Statistical Area market codes (valid code range: 1 - 734)
Sub_mkt Sub-market code. Used for mapping split markets.
Name MSA/RSA name
State The name of the state in which the county is located
**********************************************************************************************
Demographic Data Table
MSA/RSAs Metropolitan Statistical Area and Rural Statistical Area boundaries.
Item Descriptions and Codes:
CSA Metropolitan Statistical Area or Rural Statistical Area market codes (valid code range: 1 - 734)
Sub_mkt Sub-market code. Used for mapping split markets.
Name MSA/RSA name
State The name of the state in which the county is located
Pop98 The total 1998 population
Pop97 The total 1997 population
Pop95 The total 1995 population
Pop90 The total 1990 population
Households Total number of households
Males Number of males
Females Number of females
White Number of people identified as white
Black Number of people identified as black
Ameri_es Number of people identified as American Indian, Eskimo, or Aleut
Asian_pi Number of people identified as Asian or Pacific Islander
Hispanic Number of people of all races identified as being of Hispanic origin)
Other Number of people identified as belonging to a race other than white, black, American Indian, or Asian
Imedian Median household income
Iund30 Number of households with an income of less than $30,000
I30_40 Number of households with income between $30,000 and $40,000
I40_50 Number of households with income between $40,000 and $50,000
I50_60 Number of households with income between $50,000 and $60,000
I60_75 Number of households with income between $60,000 and $75,000
I75_ Number of households with income over $75,000
A1_17 Number of persons aged 1 to 17 years
A18_24 Number of persons aged 18 to 24 years
A25_34 Number of persons aged 25 to 34 years
A35_44 Number of persons aged 35 to 44 years
A45_54 Number of persons aged 45 to 54 years
A55_64 Number of persons aged 55 to 64 years
A65_ Number of persons aged 65 years and over
Elt9 Number of persons educated less than 9th grade level
E9t12 Number of persons educated 9th to 12th grade level
Ehs Number of persons educated to a high school level
Esomec Number of persons educated to college level without a degree
Ead Number of persons educated to an associates degree level
Ebd Number of persons educated to an bachelors degree level
Egd Number of persons educated to an graduate degree level
**********************************************************************************************
Market Ownership Table
coxcsa.dbf DBASE table containing companies by Metropolitan Statistical Areas and Rural Service Areas.
Item Descriptions and Codes:
Csa MSA/RSA code (number and band)
Csa_num MSA/RSA number
Band Band
Sub_mkt Sub-market code. Used for handling split markets. xxx-0 values represent standard MSA/RSAs, xxx-1, xxx-2 ...xxx-9 represent geographically split markets. Note: Not all Geographically split market data was available, those with a Mkt_flag value of "X" represent known split markets for which the nature of the geographic split was unknown at the time of release of this product.
Co_id Operating company identifier
Pct_own Percent ownership of market
Noteid Note pertaining to pct_own, if applicable
Status Status of license/Start date
Sid SID code
Mhz Frequency band width of license
Type Type of market
Dba Doing business as name - name company is using in particular market
Custsvcnum Customer service number for consumers for particular market
Tech Technology of choice for market
**********************************************************************************************
Company Contact Table
company.dbf DBASE table containing contact information for all CTIA members and North American wireless licensees.
Item Descriptions and Codes:
Co Unique company identification number
Company Company name
Address Primary address of company
City City
State State
Zip Zip
Phone Phone
Fax Fax
Jobttl Job title of point of contact
Fname First name of contact
Mi Middle initial of contact
Lname Last name of contact
Cat Category of CTIA membership
G = General Member
A = Associate Member
N = Affiliate Member
M = Manufacturer Member
I = International Affiliate Member
U = Non-Member
|

Sponsored by:

For information regarding advertising rates Click Here!
|