US AM FM Radio Database Product Code 112

Sofmedia Global Radio Database Group in the most comprehensive directory of worldwide
radio stations available. The database includes station management, email addresses,
telephone/fax, technical data and detailed market information.
Note: In the broadcast group, SoftMedia also provides a complete database for Canadian
Radio.

In additional to cross ownership many Stations are co-located in the same facility. To remove
duplicates only address, email or fax the records that have a capital X in the PRLABEL field.

If you need maps of the transmitter location, or City Grade B Coverage maps, logon to our web
site at: http://www.globalcommnet.com and click the blue 'OPERATORS' button, select Radio
Stations and enter a state abbreviation, format or call sign.

If you require 5 digit zip code coverage for radio stations, simply overlay the contour map
in your mapping software and export the zip codes within the polygon.

International Radio Database Product Code 113

SoftMedia’s international broadcast radio database covers over 1,738 stations in
over 122 countries. The databases are updated semi-annually and include Addresses, Telephone/Fax numbers and URL/Emails. The International database does not include management names, however we have had great success in using title addressing such as ‘Attention Technical Director..etc..’

Canadian Broadcast Radio and TV Product Code 108

In the radio group, SoftMedia also provides a complete database for Canadian Radio Stations. As with the US database, Canadian TV includes management and Email addresses. The Canadian Television and Radio database in contained in the same database. The Database has a datafield called ‘TYPE’ and this datafield should be used to identify the station as Radio or Television.

        AMFMRADIO
        Number of data records: 12613                                                    Product Code 112
        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