RADIO MALL TV LIST DOCUMENTATION

This file contains about 3,950 U.S. commercial and noncommercial stations. If you have any difficulties installing it, call us at 800-759-4561 or 763-522-6256 for technical support.  Most major database and spreadsheet programs will have no trouble importing this information.  This file is NOT a self-contained program.            

BEFORE YOU BEGIN!!!

We suggest you download this file to your My Documents folder. We strongly suggest you make a copy of the file on CD or flash drive BEFORE trying to import the file. The field lengths are in brackets [].
 
There are 21 fields for each record.  They are:                                [size]type

COMPANY   (the station's call letters)                                           [23]C
ADDRESS   (street address or P.O. Box)                                      [40]C
CITY                                                                                           [21]C
STATE                                                                                        [2]C
ZIP (includes Plus 4 code)                                                            [10]C
FORMAT  (network affiliation - see below)                                      [50]C
NOTES  (includes info on duplicates)                                            [80]C 
SIZE  (ranked by 210 DMA market sizes)                                      [6]N For the full list, go to:  http://www.nielsen.com/content/dam/corporate/us/en/docs/solutions/measurement/television/2014-2015%20DMA%20RANKS.pdf
POWER   (power output in kilowatts)                                            [8]N
FREQ   (primary channel)                                                            [11]C
PHONE                                                                                      [25]C
FAX                                                                                            [13]C Removed 4/1/16
NUMBER (An unchanging serial number)                                       [5]N
DPBC  Delivery Point for Bar Coding                                              [2]C
MARKET The actual name of the market i.e. Chicago                     [42]C
GM  General Manager's name                                                      [25][C
EMAILGM  The E-mail address of the General Manager                  [50]C 
CE Chief Engineer's name                                                            [25][C
EMAILCE  The E-mail address of the Chief Engineer                       [50]C 
CSD Creative Services Director's name                                          [25][C
EMAILCSD  The E-mail address of the Creative Services Director     [50]C 
WEBSITE The URL of the station's website                                     [50]C 

THE NOTES CATEGORY

Sometimes there is more than one station operating or managed at a single address.  In any case where there is more than one station with the same General Manager at a single address, "DUPE" (for duplicate) appears in the notes category. We also keep various notes here, including info on affiliation and previous call letters.  Noncommercial stations have a semi-colon ( ; ) in this field.

FORMAT (or NETWORK AFFILIATION)


Here's the legend:
ABC                 
AS - AMERICA'S STORE                
CBS                                
CW - NEW NETWORK FORMED BY CBS & FORMER WB NETWORK                
EDU - EDUCATIONAL                
ETH - MULTICULTURAL PROGRAMMING               
ETH/PUB - MULTICULTURAL NON-COMMERCIAL PROGRAMMING            
FAM - FAMILY NET NETWORK               
FOX                 
HSN - HOME SHOPPING NETWORK                
IND - INDEPENDENT                
ION - FORMERLY PAX             
MNT - MY NETWORK TELEVISION
NBC                 
PBS                 
PUB - PUBLIC NON-COMMERCIAL                
REL - INDEPENDENT CHRISTIAN PROGRAMMING
RTV - RETRO TELEVISION                 
SHOPAMERICA         
SHOPNBC             
SPAN (AZTECA)    The SPAN designation means Spanish)   
SPAN (HTV)          
SPAN (TELEMUNDO)    
SPAN (TELEVISIA)    
SPAN (UNIMAS)
SPAN (UNIVISION)    
TBN - TRINITY BROADCASTING NETWORK - CHRISTIAN PROGRAMMING
TBS - TURNER BROADCASTING SYSTEM
WX - WEATHER

EMAIL ADDRESSES

You should remove all duplicate E-mail addresses prior to using this file for those purposes. There can be duplicate e-mail addresses within one station.  At smaller stations, one person often wears several hats. If the GM is also the Chief Engineer and the Creative Services Director, that e-mail address will appear 3 times in one record. If it's a cluster of 5 stations, that e-mail address will appear 15 times. We do not recommend sending 15 e-mail messages to the same e-mail address! Be sure to use blind carboning (BCC) when you send e-mail.  If you're not sure what this means, call us! 

We are not lawyers, but our understanding of the CAN-SPAM act is that all unsolicited e-mail ads must comply with the following:
1: You must provide a valid return e-mail address.
2. The subject line of your e-mail must make it clear that the e-mail 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 e-mail list.  We believe the following statement would suffice:

To 0pt out, please reply to this e-mail to let us know. .

UPDATES

Here at our headquarters, this database is a living, breathing thing.  Like a small baby, it needs to be changed and fed quite often.  We make regular changes on an on-going basis.   The accuracy of this data deteriorates rapidly over time.  We've priced our updates so they will usually cost you less than the wasted postage, printing and address correction fees you will pay for using the wrong addresses.  And you'll save hours of data entry time, too.  We suggest you obtain an update at least once a year.  If you plan on updating the info yourself, be sure every piece you mail contains a "CHANGE SERVICE REQUESTED" endorsement.  For example, if you mail by standard mail class without this endorsement, and the address is wrong, they will throw your piece in the garbage.  Whether you purchase our updates, or do it yourself, it really must be done.


LIMITATIONS OF USE:

This list is � 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.  You may not sell, rent, loan, or otherwise furnish it to other entities or use it on their behalf.  IT MAY NOT BE POSTED TO A WEB SITE OR FTP SITE. It may NOT be used to mail or email other companies' material.  You must remove all duplicate e-mail addresses before sending e-mail and use blind carboning (BCC) when you send e-mail. 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.  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 or email info@radio-mall.com.

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