Sneak Peek: Database Design for Version 2.0

For all of the Wait Wait fans out there that also are into database designs, you are in for a small treat. Below is an EER diagram of the recently updated database used to house the statistics and other information for the Stats Page. You can view the diagram in its full-sized glory by clicking on this link. My goal is to get the database data and tables as normalized as possible by way of mapping tables. As you can see from the “ww_showpnlmap” table that I have fields for recording: how many points each panelist had, how many points each panelist had before and how many questions the panelists answered correctly during the Lightning Fill-in-the-Blank round. I don’t have data for every single show or panelist at this point. Right now, there is one additional mapping table that I will need to create …

Launching the wwdt.me Blog!

‎Wait Wait Don’t Tell Me! Fans, I would like to announce a new blog dedicated to the ongoing development of the WWDTM Stats Page. Also, I have started working on a new version of the Stats Page that will incorporate some of the most requested features, including: the locations that each show is recorded at, Bluff the Listener information and breaking down panelist points. Please come check out the new blog at http://wwdt.me/blog and feel free to post any comments, questions or feature requests.

Kicking Off Development of WWDTM Stats Version 2.0

First and foremost, I would like to welcome you to the new wwdt.me blog! I have started this blog as a means to announce that the design and development of version 2.0 of the Wait Wait… Don’t Tell Me! Stats Page has started. This blog will also provide some insights into what will go into the new version and maybe a few peeks behind the curtains. I don’t have any set milestones or timelines for the development and launch of the new version; but, I hope to have something like an alpha version ready by July 26th. What’s so special about July 26th? Well, let’s just say that I’ll be in Chicago that day ;) N.B.: Please note that this blog, like the new version of the WWDTM Stats Page, is still under some development. Not all of the design elements have been finalized and …

WWDTM Stats: More and more data entry

It’s been a while since I’ve blogged about updates to the Wait Wait… Don’t Tell Me! Stats Page, but I have been making a little bit more progress on a couple of things. First thing is that I have been able to locate MP3s of Wait Wait shows from early 2003 through early 2006, stopping where the first show was made available as a podcast. My goal is to listen through each show and fill in scores and other information that is currently missing. Along with that, I will be entering in not only which panelist had the correct bluff, but also the panelist that the listener chose. Once I get that information entered, I will find a way to display both on the page. Next, I have been slowly collecting where the show has been recorded and will be entering that into the …

Wait Wait Stats Update: Not My Job Data

I have finished entering the list of Not My Job guests into the Wait Wait… Don’t Tell Me! Stats Page database; although, I have not included any guest scores as that will be a nice process of listening to the older shows. I am now working on adding in show descriptions for shows, filling the void between 2000 and 2004. This process will probably take a couple of weeks to complete. Thankfully, it isn’t quite as tedious as entering in the list of Not My Job guests. Please note that I am basing the show descriptions on what is listed in the show archives on NPR.org, so the level of detail may vary dramatically. Once that has been completed, I will work on filling in the data for shows prior to 2000. It’s just easier to do it in chunks, particularly when the really …

Wait Wait Stats Update: Panelist Appearances (Part 3)

I have finished entering in all of the panelist appearances into the database for the Wait Wait… Don’t Tell Me! Stats Page. Unfortunately, the panelist scores are still void since that data will have to be collected and entered through other means. It is also unfortunate that a lot of the earlier show audio is no longer available through the Wait Wait… Don’t Tell Me! archives, so I will need to figure out other means to procure that information. Next up? I’m going to try to finish filling in the Not My Job guest appearances.