Fixing Duplicates

Identifying Duplicates

  • Look for common title, host and URL.
  • The same program on the same station is always a single program. Local programs on different stations with common titles like “Afternoon News” are not duplicates.

These are probably duplicates:

  • When the title and host are similar enough you can see the program is the same
  • When the program is popular on many stations
  • When the URL is the same
  • When the title or host is unique enough (e.g. “Scuba Radio”)
  • When the host name is unique and the same
  • When time slots are undefined like “special programming” or generic “infomercial”

These are not duplicates:

  • Local news programs on different stations
  • “Best of” programs
  • When the station qualifies the program name (e.g. “Afternoon News” is a different program than “Morning News”)
  • When the program is obviously unaffiliated (e.g. another country/language; a different format)
  • A different Infomercial sponsor

Steps to Find Duplicate Records

  • Sort by title. If you find more than one program having the same title, check to see if the host information is the same. If it is the same, they are most likely duplicates. Check to see if they have different program numbers. Check out the Web site for both programs to see if the description conveys the same message. The program might be aired on different stations. If all this points to the same information, mark as duplicates.
  • Example: Programs on one station are re-broadcasted in multiple stations. “All Things Considered” is a very popular program. It is broadcasted on several stations like WYNC, Vermont public radio, WBFO and WBYI. All of these stations would point to just one program.