|
AMFMRADIO
Number of data
records: 12613
Product Code 109
Field
Field Name
Type
Width
|
1
|
AMFM
|
Character
|
4
|
Identifies
AM or FM Station
|
|
2
|
FMCALLSIGN
|
Character
|
4
|
Station
FM Callsign
|
|
3
|
AMCALLSIGN
|
Character
|
4
|
Station
AM Callsign
|
|
4
|
ADDRESS
|
Character
|
35
|
Station
Address
|
|
5
|
CITY
|
Character
|
25
|
Station
City Office
|
|
6
|
STATE
|
Character
|
2
|
State
for Station Office
|
|
7
|
ZIPCODE
|
Character
|
10
|
Zip
Code for Station Address
|
|
8
|
MCSZ
|
Character
|
45
|
Station
Mailing City State Zip Code
|
|
9
|
TELEPHONE
|
Character
|
20
|
Station
Telephone Number
|
|
10
|
FAX
|
Character
|
20
|
Station
Fax Number
|
|
11
|
APPLCITY
|
Character
|
25
|
City
of Station License
|
|
12
|
APPLSTATE
|
Character
|
2
|
State
of Station License
|
|
13
|
COUNTY
|
Character
|
35
|
Primary
County
|
|
14
|
MARKETAREA
|
Character
|
35
|
Market
Area DMA
|
|
15
|
METRO
|
Character
|
1
|
Station
in Metro Area (Yes) (No)
|
|
16
|
METRORANK
|
Character
|
3
|
Metro
Rank
|
|
17
|
MKTSHARE
|
Character
|
2
|
Published
Market Share
|
|
18
|
GNLMANAGER
|
Character
|
35
|
Station
General Manager
|
|
19
|
ENGMANAGER
|
Character
|
35
|
Station
Engineering Manager
|
|
20
|
AMFORMAT
|
Character
|
25
|
AM
Format
|
|
22
|
FMFORMAT
|
Character
|
25
|
FM
Format
|
|
22
|
AMFREQ
|
Character
|
10
|
AM
Frequency
|
|
23
|
FMFREQ
|
Character
|
10
|
FM
Frequency
|
|
24
|
FMURL
|
Character
|
75
|
FM
Web Site
|
|
25
|
FMEMAIL
|
Character
|
55
|
FM
Email
|
|
26
|
AMURL
|
Character
|
55
|
AM
Web Site
|
|
27
|
AMEMAIL
|
Character
|
35
|
Main
Market City
|
|
28
|
NITEPOWER
|
Character
|
10
|
AM
Night Power Authorization
|
|
29
|
DAYPOWER
|
Character
|
10
|
AM
DAY Power Authorization
|
|
30
|
FMPOWER
|
Character
|
45
|
FM
Transmitter Power
|
|
31
|
ANTENNAHGT
|
Character
|
8
|
Antenna
Height in Meters
|
|
32
|
LATITUDE
|
Character
|
25
|
Tower
Antenna Latitude
|
|
33
|
LONGITUDE
|
Character
|
25
|
Tower
Antenna Longitude
|
|
34
|
GROUPOWNER
|
Character
|
75
|
Corporate
Owners
|
|
35
|
ADVREP
|
Character
|
35
|
Advertising
Representative
|
|
36
|
PRLABEL
|
Character
|
1
|
Identifies
Duplicate Addresses
|
CANADIAN TV/RADIO2010.DBF
Product Code 108
Number of data records: 1013
Field
Field Name
Type
Width
|
1
|
SERVICE
|
Character
|
8
|
Denote Radio
or Broadcast TV
|
|
2
|
CALLSIGN
|
Character
|
10
|
Station Call Sign
|
|
3
|
FORMAT
|
Character
|
35
|
Radio Format
|
|
4
|
STATUS
|
Character
|
10
|
Digital
Status
|
|
5
|
ADDRESS
|
Character
|
28
|
Mailing
Address
|
|
6
|
MCSZ
|
Character
|
50
|
Mail City
State/Province Zip Code
|
|
7
|
CITY
|
Character
|
35
|
City
|
|
8
|
ZIPCODE
|
Character
|
15
|
Zip Code
|
|
9
|
STATE
|
Character
|
2
|
Province
Abbreviation
|
|
10
|
COUNTY
|
Character
|
25
|
Province
|
|
11
|
TELEPHONE
|
Character
|
25
|
Station
Telephone Number
|
|
12
|
FAX
|
Character
|
20
|
Office Fax
Number
|
|
13
|
STNEMAIL
|
Character
|
75
|
Station Email
|
|
14
|
URL
|
Character
|
75
|
Station Web
Site
|
|
15
|
OWNER
|
Character
|
45
|
Corporate
Owner
|
|
16
|
GNLMANAGER
|
Character
|
35
|
General
Manager
|
|
17
|
GMEMAIL
|
Character
|
75
|
GM Email
|
|
18
|
ENGMANAGER
|
Character
|
35
|
Engineering
Manager
|
|
19
|
ENGEMAIL
|
Character
|
75
|
Engineering
Manager Email
|
|
20
|
NEWSDIR
|
Character
|
55
|
News
Director
|
|
21
|
NEWSEMAIL
|
Character
|
75
|
News
Director Email
|
|
22
|
SALESMGR
|
Character
|
35
|
Sales
Manager
|
|
23
|
SALESEMAIL
|
Character
|
75
|
Sales
Manager Email
|
|
24
|
PROGMGR
|
Character
|
35
|
Programming
Manager
|
|
25
|
PROGEMAIL
|
Character
|
75
|
Program
Manager Email
|
|
26
|
FREQUENCY
|
Character
|
10
|
Station
Frequency
|
|
27
|
TVCHANNEL
|
Character
|
10
|
Channel
|
|
28
|
TRANSPOWER
|
Character
|
10
|
Transmitter
Power
|
|
29
|
ANTHEIGHT
|
Character
|
10
|
Antenna
Height in Meters
|
|
30
|
ANTENNAPOL
|
Character
|
25
|
Antenna
Polarization
|
|
31
|
LONGITUDE
|
Character
|
15
|
Tower
Longitude
|
|
32
|
LATITUDE
|
Character
|
15
|
Tower
Latitude
|
International Radio2010
Product Code 110
Number
of data records: 1,738
Field
Field Name
Type
Width
|
1
|
STATION
|
Character
|
44
|
Station
Name/Call Sign
|
|
2
|
ADDRESS
|
Character
|
30
|
Address
|
|
3
|
CITY_ZIP
|
Character
|
35
|
Station
City
/ Mailing, Zip Code
|
|
4
|
COUNTRY
|
Character
|
25
|
Station
Country
|
|
5
|
TELEPHONE
|
Character
|
15
|
Station
Office Telephone Number
|
|
6
|
FAX
|
Character
|
20
|
FAX
|
|
7
|
EMAIL
|
Character
|
75
|
Station Email
Address
|
|
8
|
ALT_EMAIL
|
Character
|
75
|
GM’s Alternate Email Address
|
|
9
|
URL
|
Numeric
|
75
|
Station Web
Site URL
|
|
10
|
MANAGER
|
Character
|
65
|
General
Manager ‘Title Addressing’
|
|
11
|
ENGINEER
|
Character
|
35
|
Technical
Director ‘Title Addressing’
|
|