

{"id":9868,"date":"2014-03-09T11:22:13","date_gmt":"2014-03-09T15:22:13","guid":{"rendered":"http:\/\/streamingradioguide.com\/startingover\/?p=9868"},"modified":"2014-03-09T11:51:07","modified_gmt":"2014-03-09T15:51:07","slug":"auto-extracting-affiliate-lists","status":"publish","type":"post","link":"https:\/\/streamingradioguide.com\/startingover\/?p=9868","title":{"rendered":"Auto extracting affiliate lists"},"content":{"rendered":"<p>This is a waste of time, but heck &#8211; I have almost 3 years left to waste, so I better get busy!<\/p>\n<p>Dave Graveline hosts a technology show that airs live from 2-5 PM on Sundays.   He&#8217;s actually on my Facebook account as a friend!<\/p>\n<p>I have a routine I&#8217;ve played around with several times to try to automatically extract schedule information for a show, but there are a number of obstacles, including the data is often quite wrong or out of date, or incomplete to actually verify that an affiliate exists.<\/p>\n<p>I&#8217;ve long beefed that these lists are deliberately padded to try to puff up the &#8220;size&#8221; of a show&#8217;s audience.   I&#8217;m not picking on Dave&#8217;s show.   Things that can be wrong are<br \/>\n&#8211; station no longer exists<br \/>\n&#8211; station never existed<br \/>\n&#8211; are simulcasts counted as more than one station?  (that&#8217;s a philosophical issue)<br \/>\n&#8211; is the show actually on the air when the syndicator says it is?<\/p>\n<p>Here is the claim:<\/p>\n<p>&#8220;The show airs on over 200 AM &#038; FM radio stations around the U.S. and a plethora of other sources! &#8221;<\/p>\n<p>The list of affiliates is here:<br \/>\n<a href=\"http:\/\/www.graveline.com\/radiostations.html\">http:\/\/www.graveline.com\/radiostations.html<\/a><\/p>\n<p>So what do I find when I parse the list?<\/p>\n<p>I counted 191 things in the list that look like a radio station name.  Notice that some lines have both AM &#038; FM listed<br \/>\n34 of the &#8220;stations&#8221; are not valid stations<\/p>\n<p>[KXIQ] => AM<br \/>\n[KTBM] => AM<br \/>\n[KHEL] => FM<br \/>\n[KTSE] => AM<br \/>\n[Key] => AM [Cape] => AM [West] => AM<br \/>\n(bogus on my part- West is part of the city, not a radio station WEST)<br \/>\n[KBLI] => AM<br \/>\n[WNSH] => AM<br \/>\n[WMSX] => AM<br \/>\n[WPEP] => AM<br \/>\n[WSNV] => FM<br \/>\n[WJZF] => FM<br \/>\n[WYCD] => ??<br \/>\n  (HD3 channel!)<br \/>\n[WPIQ] => FM<br \/>\n[KNUU] => AM<br \/>\n[WELV] => AM<br \/>\n[Coos] => FM<br \/>\n[KHJ] => FM<br \/>\n[WRDD] => AM<br \/>\n[WPSE] => FM<br \/>\n[WMNY] => AM<br \/>\n[WTN] => FM<br \/>\n[KNET] => FM<br \/>\n[WZBZ] => AM<br \/>\n[WTDY] => AM<br \/>\n[CKLW] => AM<br \/>\n   Okay, it&#8217;s a canadian station heard in Detroit<br \/>\n[KJAZ] => FM<br \/>\n   Bermuda is not part of the United States<br \/>\n[KOOL] => FM<br \/>\n   Neither is New Zealand<br \/>\n[CRN] => ??<br \/>\n   Cable radio syndicator<br \/>\n[City] => ??<br \/>\n (Canada?)<br \/>\n[Cell] => ??<br \/>\n (Canada?)<br \/>\n[WWCR] => ??<br \/>\n (Shortwave)<br \/>\n[WWPM] => ??<br \/>\n  (Online only)<\/p>\n<p>Of those left, 17 are simulcasts, 1 is a duplicate (WDAY-AM).   49 don&#8217;t have a known stream &#8211; you can see a number don&#8217;t even have a web site.<\/p>\n<p>After that scrubbing we have 95 potential streaming affiliates &#8211; But the big problem is the affiliate list does NOT show date and times.  How could one possibly confirm the affiliates actually do air the program (a related problem is the station might air the program, but not stream it &#8211; or even more likely have sports preemptions!)<\/p>\n<p>So the best I can hope to do as a start is to assume that the 95 stations carry the show live and try to listen then and see what I find.  Based on a prior show who had a PR person give me a list with inflated counts, the list Dave published could be a list of &#8220;CRN affiliates&#8221;  that carry -some- CRN show, not necessarily THIS show.<\/p>\n<p>If you&#8217;re totally bored and want to start scouring web sites looking for the actual show times for a show:<br \/>\n<a href=\"http:\/\/streamingradioguide.com\/radio-show.php?showid=240\">http:\/\/streamingradioguide.com\/radio-show.php?showid=240<\/a><\/p>\n<p>So what do the 95 stations look like?  Does it look credible?<br \/>\n47 are News\/Talk stations, 17 are full service stations that carry mostly local shows, 9 are all-sports (probably changed formats and no longer carry show), 3 play Oldies music, and a smattering of other formats<\/p>\n<p>If you look closer at the affiliates claimed in the top 50 markets (that stream), here is the list:<\/p>\n<pre>\r\n+----------+-------------+----------+----------------+-------+----------+\r\n| CallSign | ServiceType | Power_Kw | CityName       | State | CityRank |\r\n+----------+-------------+----------+----------------+-------+----------+\r\n| WJOB     | AM          |        1 | HAMMOND        | IN    |        3 |\r\n| WWRC     | AM          |       35 | WASHINGTON     | DC    |        8 |\r\n| WSMN     | AM          |        5 | NASHUA         | NH    |       11 |\r\n| WMGG     | AM          |        5 | DUNEDIN        | FL    |       19 |\r\n| KAHI     | AM          |        5 | AUBURN         | CA    |       26 |\r\n| KDWN     | AM          |       50 | LAS VEGAS      | NV    |       32 |\r\n| KLIV     | AM          |        5 | SAN JOSE       | CA    |       34 |\r\n| WMEL     | AM          |        5 | COCOA BEACH    | FL    |       37 |\r\n| WPTF     | AM          |       50 | RALEIGH        | NC    |       43 |\r\n| WWTN     | FM          |      100 | HENDERSONVILLE | TN    |       44 |\r\n+----------+-------------+----------+----------------+-------+----------+\r\n<\/pre>\n<p>WJOB is a tiny &#8220;rimshot&#8221; AM station in ChicagoLand<br \/>\nWWRC is the Salem station in DC and doesn&#8217;t list the show on their schedule<br \/>\nWSMN has a very incomplete weekend schedule and doesn&#8217;t list the show<br \/>\nWMGG is now Spanish Language<br \/>\nKAHI doesn&#8217;t list the show on their schedule<br \/>\nKDWN doesn&#8217;t list the show<br \/>\nWWTN was a known affiliate &#8211; they carry the show 5-7 AM on Sunday (prior week show)<\/p>\n<p>So you&#8217;re an advertiser &#8211; what goes through your mind about now?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a waste of time, but heck &#8211; I have almost 3 years left to waste, so I better get busy! Dave Graveline hosts a technology show that airs live from 2-5 PM on Sundays. He&#8217;s actually on my &hellip; <a href=\"https:\/\/streamingradioguide.com\/startingover\/?p=9868\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,18,141],"tags":[],"class_list":["post-9868","post","type-post","status-publish","format-standard","hentry","category-about-the-guide","category-radio-biz","category-syndicators"],"_links":{"self":[{"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=\/wp\/v2\/posts\/9868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9868"}],"version-history":[{"count":8,"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=\/wp\/v2\/posts\/9868\/revisions"}],"predecessor-version":[{"id":9876,"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=\/wp\/v2\/posts\/9868\/revisions\/9876"}],"wp:attachment":[{"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/streamingradioguide.com\/startingover\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}