RADIO MALL NONCOMMERCIAL DATABASE DOCUMENTATION
Shortcuts: List of what's in the file (FIELDS.) Radio formats. Limitations of use. About market sizes.
The full noncommercial database contains about 4,70 U.S. non-commercial radio stations, and about 2,100 when duplicates are purged. Because of simulcast stations, there are about 3,950 records in the file. Please note that this documentation is also used for smaller selections from the list. If you have any difficulties installing it, call us at 800-759-4561 or 763-522-6256 for tech support.
BEFORE YOU BEGIN!!!
We strongly suggest you make a back-up copy before trying to import the file. If you're using Excel, you may skip the rest of this paragraph. PLEASE REVIEW THE INSTRUCTIONS FOR YOUR database IF YOU NEED TO IMPORT THIS FILE. For most applications you'll begin by downloading our file to your hard drive. Be sure to note which folder (or directory) you download our file to. Then open your database program. If you have a menu, it probably has a choice marked something like: "CREATE A NEW FILE" or "OPEN A NEW FILE," or "RETRIEVE A FILE." If so, select this option. At some point, there may be an option asking for the SOURCE of the new file, or allowing you to IMPORT data. You may need to enter the number and type of fields in each record (41.) We've made a notation in brackets [ ] to show you how many characters to allow per field. Depending on your database, you may need to structure ZIP field as a character field so the database doesn't delete any zeros at the beginning of an entry.
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 are surveyed. 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 New area codes now corrected bi-monthly FAX Character 13 0 Removed 4/1/16 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 HD Character 1 0 Removed 4/1/16
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. We still suggest you title-address all of your postal mailings. We have sold to over 7,500 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 POSTAL MAILING WILL VOID OUR GUARANTEE OF 99% DELIVERABILITY.
Here's additional information on the data:
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 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 INFO
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.
THE NOTES CATEGORY and DUPLICATE ADDRESSES
All noncommercial stations have a semi-colon (;) in the notes
category. This allows you to merge the files and still have the capability of
selecting non-commercial stations.
If several stations are at the same address with the General
Manager, but are not
simulcast, we create a separate record for each station and we mark the second
station as a "DUPE" and the third station as
"DUPE3," etc. This is entered in the notes category. In some cases, there are a large number of dupes at lone address. For example, in the zip code 38803 there are
93 dupes owned by American Family. You do not want to mail them 93 envelopes!
cases, there are a large number of dupes at lone address. For example, in the
zip code 38803 there are 90 dupes owned by American Family. You do not want to
mail them 90 envelopes! In zip code 95765 there are over 200 stations owned by
Educational Media Foundation.
We also keep various notes here, including previous call letters and syndication notes. 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. The pound sign ( # ) in this field means the station is owned by a College or University.
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.
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 just in the ADDRESS, CALL LETTER and FORMAT and EMAIL categories. The accuracy of this data deteriorates rapidly over time.
LIMITATIONS OF USE
This list is Copyright (c) 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. It may NOT be used to mail or e-mail another company's materials or fliers. It may NOT be posted on a web, FTP site, or file-sharing folder. 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 for resale in any form or posted to a web site. There are hundreds of duplicate e-mail addresses in this file. You agree to remove all duplicates before e-mailing and to use blind-carboning (BCC.) Please contact us if you don't know what this means. This data is "seeded" with the addresses of Radio Mall agents to ensure that the list is not being illegally reproduced. If you have any questions about these restrictions, please write us at: 2412 Unity Ave. N., Minneapolis, MN 55422-3450 USA or email email@example.com.
Help us keep up-to-date!
Please let our data center know about any changes or errors in the database. You can call them at 888-757-2688.
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: firstname.lastname@example.org
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.