Wait Wait Stats Update: Panelist Appearances

One of the features that I had been wanting to add to the Wait Wait… Don’t Tell Me! Statistics Page was to display when a panelist first appeared on Wait Wait and when was the panelist’s most recent appearance on the show. A fellow Wait Wait (and Paula Poundstone) enthusiast also asked about adding the feature as well. So, after a little bit of tinkering around with SQL queries, I was able to work out a view that I could query from the page’s PHP code. At first, the query included every show in which the panelist was on, including repeat and best of shows. The problem with that is not all best of shows have panelists associated to them, so the dates would not …

Wait Wait Stats Update: Jumping Down to a Specific Show

Up until now, there was no way to create a link that goes to a certain show on the Wait Wait… Don’t Tell Me statistics page. Instead, you would have to go the page and scroll down or search for the show’s date. Now, you can create links that refers to a specific show’s entry. To link to a specific entry, you can use the following URL template: http://wwdt.me/stats/#s<YYYYMMDD> Replace “<YYYYMMDD>” with the show’s four digit year, two digit month and two digit day. For example, to create a link that points to the spot for the April 23, 2011 show, the URL you would use is: http://wwdt.me/stats/#s20110423 I know, it’s a small update, but I hope someone finds it useful. :)

Mo Rocca, The World’s Worst Obstetrician

During the second panelist round of Wait Wait… Don’t Tell Me! that aired the weekend of 2011-06-18, the discussion lead to Mo Rocca saying that having a Hula dancer in the same room as a mother giving birth would help the mother relax. This led to Luke Burbank asking if this would be blogged on “Mo Rocca, The World’s Worst Obstetrician dot net”. I didn’t get to listen to that segment until several days later and noticed that the MoRoccaTheWorldsWorstObstetrician.net domain had not been taken… yet. So, I decided to register the domain and set up the site to redirect to my Wait Wait… Don’t Tell Me! statistics page. Well, this week’s Wait Wait… Don’t Tell Me! show was all about listener favorite segments and requests. Many of …

Wait Wait Stats Update: Page Loads

I have made a significant change to how the Wait Wait Stats page is served up to visitors. Up until earlier this morning, each page view required the server to process and parse through all of the data, then serve up the results. Each time the page is processed takes about a second and requires the server to send out the contents out in its entirety, even if there hasn’t been any changes. That’s a waste of time and bandwidth (both mine and yours), along with processor cycles. With the new change, the server generates a static version of the page every Saturday at 13:00 (Pacific Time) and each request of the Wait Wait Stats page will go through a simple script that determines if …

Wait Wait Stats Update: 1998 Part Deux

As noted in the original “Wait Wait Stats Update: 1998” post, my goal was to complete filling out the panelists, guests and descriptions for all of 1998 by the end of June. Well, it’s now 1 July 2011 and I still haven’t gotten all of the show descriptions filled out. At least I have the guests entered in (without scores). What I was able to do before the end of June was to add one of the features that I had been thinking about doing (and some have been asking for). If you visit the stats page, you will notice that all of the show dates are now links. When you click on the link, it will send you over to that show’s specific page …

The voice of Carl Kasell has arrived

When I got home tonight, I saw a package that was addressed from Wait Wait… Don’t Tell Me! and Chicago Public Radio in the pile of today’s mail. Within the package was a CD with an audio track containing the greeting that I requested Carl to record for me. Below is the picture of the CD that I received:   The following is the text of the greeting that I requested: Good day, I am Carl Kasell and you have reached the mailbox for Linh Pham. Linh is probably too busy geeking out or is out somewhere making a fool of himself. Just joking, okay maybe not. Please leave a message after the beep. Simple and reflects my quirky and ackward mannerisms :) Thank you, …