THE RADIO MALL COMMERCIAL RADIO DATABASE DOCUMENTATION
Shortcuts: List of what's in the file (FIELDS.)  Radio formats.  Limitations of use.  About market sizes.

The full commercial radio database contains over 12,100 U.S. radio stations. There are about 4100 unique General Managers and about 10760 records. This documentation is also used to provide information on several custom files that are extracted from this file. We guarantee this list can be run on your system. If you have any difficulties installing it, call us at 763-522-6256 or 800-759-4561. 

There are 41 fields for each record. They are: 

Name         Type   Length  Decimals  Description  
COMPANY      Character  23       0 Station' call letters
ADDRESS      Character  40       0 Street address or PO Box
CITY         Character  21       0
STATE        Character  2        0
ZIP          Character  10       0 Includes PLUS 4 code
FORMAT       Character  50       0 Station's format i.e. Country, News/Talk, etc. Full list is below. Multiple formats are listed alphabetically.
NOTES        Character  80       0 Includes info on duplicates. Further details below
SIZE         Numeric    6        1 Nielsen Audio MSA markets used for the first 260-290, depending on how many markets they survey. Further details below 
MARKET       Character  42       0 The actual name of the market, i.e. Chicago IL 
POWER        Numeric    8        0 Power output
FREQ         Character  17       0 Frequency 
PHONE        Character  25       0 
SATELLITE    Character  17       0 Full-time satellite or automated.
NUMBER       Numeric    5        0 Never-changing serial number used as a key field
DPBC         Character  2        0 Delivery Point for bar-coding
EMAIL        Character  50       0 A general e-mail address
GM           Character  25       0 General Manager's name
EMAILGM      Character  50       0 The E-mail address of the General Manager
PD           Character  25       0 Program Director's name
EMAILPD      Character  50       0 The E-mail address of the Program Director
SM           Character  25       0 Sales Manager's name
EMAILSM      Character  50       0 The E-mail address of the Sales Manager
CE           Character  25       0 Chief Engineer's name
EMAILCE      Character  50       0 The E-mail address of the Chief Engineer*
ND           Character  25       0 News Director's name
EMAILND      Character  50       0 The E-mail address of the News Director
MD           Character  25       0 The name of the Music Director
EMAILMD      Character  50       0 The E-mail address of the Music Director
OWNER        Character  42       0 The company that owns or controls the station. Includes pending owners.
WEBSITE      Character  50       0 
COUNTY       Character  42       0 The county the station's address is in
LONGITUDE    Numeric    7        2 Degrees/Minutes for the mailing address
LATITUDE     Numeric    6        2 Degrees/Minutes for the mailing address
DISTRICT     Character  2        0 Congressional District
TIME         Numeric    2        0 Time Zone in hours behind Greenwich time
OPS          Character  25       0 Operations Director's name
EMAILOPS     Character  50       0 The Email address of the Operations Director
PRD          Character  25       0 Production Director's name
EMAILPRD     Character  50       0 The Email address of the Production Director
PRM          Character  25       0 The name of the Promotion Director
EMAILPRM     Character  50       0 The Email address of the Promotion Director

* If the station is using a contract engineer and has no engineer onsite, the field will be blank.

WARNING ABOUT USE OF PERSONNEL NAMES!

We do the best job we can on the budget we have, but we cannot warrant the accuracy of these names or email addresses. We still suggest you title-address all of your postal mailings. We have sold to over 8,00 radio stations using title-addressing, so we know it works. Because the postal service allows individuals to file personal change-of-address forms, THE USE OF PERSONNEL NAMES IN A MAILING WILL VOID OUR GUARANTEE OF 99% DELIVERABILITY.

FORMAT CODES

AC  Adult contemporary stations
AC (DANCE) - Rhythmic Adult Contemporary
AC (HOT) - Adult contemporary with up tempo music
AC (NR) - Modern AC
AC (SOFT) - Adult contemporary stations with "Lite" formats
AC/B/U - Urban Adult Contemporary and R&B
AH Adult Hits (Jack-type format)
AMERICANA - A mix of folk, bluegrass and some classic country.
AOR - Album-oriented rock and Active Rock
AOR (AA) - Adult Album Alternative...aka Triple A
AOR (AP) (Album Progressive) Alternative Rock
AOR (CR) - Classic rock
AOR (CMR) - Classic Modern rock
AOR (NR) - New rock or Modern rock
AOR (REL) - Christian Rock
B/EZ  Beautiful music/Easy listening
BLUEGRASS
BLUES
B/U  Black/Urban Hip Hop and Rap
CHR  Contemporary Hit Radio, formerly known as Top 40
CHR (DANCE) - Rhythmic Contemporary Hit Radio
CHR (GOLD) - Classic Hits
CHR (REL) - Christian Top 40
CLAS  Classical
CTRY  Country
CTRY (CLSC)  Classic Country
CTRY (HOT)  New (Top 40) Country
CTRY (REL)  Christian Country
ETH  Ethnic, other than Spanish
GOLD   Oldies
GOSPEL   Gospel Music
JAZZ
MISC  Variety and Block formatting. Usually three or more formats every day.
MOR   Middle of the road. AKA full service
NOST   Adult Standards/Big Band/Nostalgia
N/T   News/Talk
N/T (SPORTS)   All Sports Programming
N/T/SPORTS   News/Talk and some Sports
PRE-TEEN   Programming for children, and hopefully some of their parents.
R&B   Rhythm and Blues
REL   Christian Preaching, Teaching and Inspirational Programming
REL (CC)   Contemporary Christian Music
SPAN   Spanish   Subcategories: NORTENO, RANCHERA, REGIONAL, ROMANTICA, TEJANO, TROPICAL

Commentary: Format definition is not an exact science. Also, be aware that many program director's perceptions of their own format is open to debate. When searching for formats, your filter should be based on CONTAINS instead of EQUALS. If you searched for all records where format equals "N/T" you would miss all the combinations of News/Talk. When a station has multiple formats, they will be listed in alphabetical order.

MARKET SIZE  
For the first 260-290 markets, Nielsen Audio rankings are used. If a radio station located in one city shows up in the rating book of a larger city, its market size is listed with the larger city. If a market size ends with ".1", this means the market size is tied with another market. Many market sizes are listed as "555."  This means the market isn't rated.  Nielsen Audio market sizes DO CHANGE. If you've saved a search or filter using specific size numbers, be sure to confirm that you're getting the same markets when you re-use the filter. A full list of markets can be found here: http://www.nielsen.com/content/dam/corporate/us/en/docs/nielsen-audio/market_populations_and_rankings_2015.pdf

THE NOTES CATEGORY

If an AM & FM station are at the same address with the same General Manager, but are not simulcast, we create a separate record for each station and we mark the second station as a "DUPE." If there are 3 or more stations at the same address, the third is marked DUPE3, the fourth is DUPE4 and so on. This is entered in the notes category. "D-PE" means it is a dupe, but with separate management. We also keep various notes here. Most of the codes and info (other than "DUPE") will be of no use to you, but if you are curious about a specific note, please let us know. We also keep a station's previous call letters here and often list some of their syndicated programming. If you're having trouble finding a certain set of call letters, you might want to direct your search to this category.

EMAIL ADDRESSES


Please note that you should remove all duplicate Email addresses prior to using this file for those purposes. If you are unsure how to remove them with your software, call us within 30 days of your purchase and we will create customized files for an extra $50. Be sure to use blind carboning (BCC) on all email! If you're not sure what this means, please call us! We are not lawyers, but our understanding of the CAN-SPAM act is that all unsolicited email ads must comply with the following:
1: You must provide a valid return email address.
2. The subject line of your email must make it clear that the email is an ad.
3. Your mailing address must appear in the email. PO Boxes are acceptable.
4. You must provide an easy way for the person to be removed from your email list.  We believe the following statement would suffice:

To 0pt out, please reply to this email to let us know.

UPDATES

Here at RADIO MALL headquarters, this database is a living, breathing thing. Like a small baby, it needs to be changed and fed quite often. We make hundreds of changes every month and the accuracy of this data deteriorates rapidly over time. We spend thousands of dollars annually on updating the info.

LIMITATIONS OF USE

This list is (C) Copyright 2017, The Radio Mall. Your company and its legal subsidiaries may have unlimited in-house use of this list. It is not copy-protected and you may duplicate it for your company's own use. It is licensed to promote one single, company, artist, author, VO person, etc. Please call us if you need a multiple use license. You may not sell, rent, loan, or otherwise furnish it to other entities. The data cannot be posted to a web site or FTP site. It may not be used to promote other companies in any way. In the event of personnel changes, the rights to use this list will be restricted to the individual or company that originally made payment for the list, unless a company provides proof that they reimbursed a former employee for the list. The data may not be reproduced in whole or in part. This data is "seeded" with the addresses of Radio Mall agents to ensure that the list is not being illegally reproduced. You must remove all duplicate e-mail addresses before sending e-mail and use blind carboning (BCC) when you send e-mail.  If you're not sure what this means, call us! 

NON-COMMERCIAL RADIO AND U.S. TELEVISION LISTS ARE ALSO AVAILABLE. TO ORDER BY CREDIT CARD, PHONE OR FAX 763-522-6256 or 800-759-4561..

If you're NOT on our automatic update program and you purchased our complete commercial radio database:

If at any time in the next TWO MONTHS, you decide you wish to get on a subscription, we'll apply the payment for this copy towards the subscription rate. That means you can get 5 more automatic bi-monthly updates for an additional $299 if you agree to take them via e-mail. If you can't take them via e-mail, please call us. To order, call 800-759-4561. In Minnesota, or outside of the US, call 763-522-6256. This offer applies only to our full commercial radio database. 

Help us keep up-to-date!

Please inform our data center of any changes or errors in the database. You can call the data center at: 888-757-2688 or 281-554-8646 or email changes@radiomall.com.

Non-Commercial US Radio and US Television radio lists are also available.

To order by phone, please call 800-759-4561 or 763-522-6256.

You can click here to email us: info@radio-mall.com

Radio Mall, 2412 Unity Ave. N, Minneapolis, MN 55422-3450 USA

To go back to the page you were on, please use your browser's BACK button.