Can I fix Jeopardy?

Series that require continual maintenance and / or aggressive cleanup.
Former Moderator
Posts: 896
Joined: Wed Oct 19, 2011 2:22 am

Thu Feb 02, 2012 6:42 pm

Done, Your making awesome progress.
I'm semi-retired atm, but I appear occasionally
Posts: 6
Joined: Mon Sep 26, 2011 3:25 pm

Tue Feb 14, 2012 3:22 pm

Thanks. Is there anyway I could finish this via a dump of some kinds instead of having to through the web interface? I can scrape the j-archive site and write a program to generate SQL, CSV, XML, etc.
Posts: 1390
Joined: Mon Jul 13, 2009 12:10 am

Thu Feb 16, 2012 2:39 am

Sadly, no. We have no method of importing dumps. Trust me, I wish we did.
All PM's will be ignored unless I'm bored, so stop sending them!
Site Moderator
Posts: 685
Joined: Sun May 30, 2010 5:48 pm

Wed Jun 13, 2012 11:32 am

I was wondering if anything is currently happening with this show? Is ajayrockrock still working on this? After looking at the first couple of seasons I was wondering why thee isn't set way to enter the data? I see seasons with the name field filled in with the date of the show, I see the name field with the names of contestants and I see the name field filled with a title of a show. Which way should this be? Any ideas?

Posts: 7
Joined: Tue Mar 17, 2009 12:30 pm

Tue Mar 18, 2014 3:20 am

Game shows episodes are rarely named anything more than Show #x in production, so if anything I prefer the method which lists the contestants on the show as the title, as it provides more information about the episode rather than redundantly repeating the air date.

Games shows need a lot of love on TVDB, and being of a throw away nature, will be hard to find reliable information on. Jeopardy! has a summer hiatus and follows similar production cycles as Wheel of Fortune and therefore doesn't make sense being displayed as a yearly season. That being said, I couldn't even begin to produce a reliable episode list for you to work from without huge gaps due to lack of information. All I can tell you is that a jeopardy "season" usually begins in September and ends in August or July, and they are currently on Season 30, but they're only counting the 1984 revival and not the original with Art Flemming. (source:

I browsed the Jeopardy Archive mentioned in the original post and it is probably the most accurate and comprehensive listing of Jeopardy shows that I have seen, but it is still incomplete in many areas. It's a shame ajrockrock gave up on his project, but given the daunting task in front of him I don't blame him.
Posts: 432
Joined: Thu Jul 18, 2013 3:18 pm

Mon Aug 04, 2014 5:03 pm

FYI, I'm working on fleshing out the missing Jeopardy! data, and as such I've added a few missing/truncated years, and made a bunch of fixes (I'm working on the 2000s so far). The 2013 year had a few too many episodes (some from the break), so there are a few empty episodes at the end of the year now (awaiting eventual deletion).

As for episode titles, is there a consensus that we should be using the contestant names? I'd be glad to change the episodes over from dates to contestants if that is what folks would like to see.

My $0.02 on years vs seasons: I've noticed that there are some years that get a repeat of a particular tournament due to it occurring late in one season, and early in the following season (tournaments are not repeated in a particular season). As such, I kinda like the idea of switching to seasons. The show's set often changes at the start of a season too, which makes it easier for any artwork to match what's going on. If we do decide to change, I'd suggest that we create a 2nd show for the early (pre-syndication) show (ala "Jeopardy! (1964)") and then switch the seasons from 1984 .. 2014 to seasons 1 .. 30 in the current show -- is there a behind-the-scenes way of moving anything around?

That said, I'm also fine leaving things as years if we'd prefer to just leave it alone. I'm currently just fixing the data in the year format, but noting when the season changes in the data itself.

Posts: 432
Joined: Thu Jul 18, 2013 3:18 pm

Tue Aug 05, 2014 10:44 am

wayned42 wrote:I'd be glad to change the episodes over from dates to contestants if that is what folks would like to see.
I've been trying this out in the latest seasons I've been fixing, and I'm liking it better than the date as the summary (though, obviously, any episode that has unknown contestants still gets a date summary). If anyone wants to see how this looks on a full year, check out the (newly added) year 2000 and see what you think.
Posts: 5
Joined: Sun Nov 09, 2014 7:23 am

Sun Nov 09, 2014 8:09 am

Sorry for resurrecting an old thread. I have just signed up on the forum here in the hopes that something can be done with Jeopardy!

I have imported a few hundred episodes into my DVR (mythtv) and it uses thetvdb to get the metadata. I am now looking for a solution to fix all of those hundreds of mislabelled episodes.

1. It is absolutely ridiculous to label the seasons by year when the seasons run from September to August.
2. Even considering point 1, the episode dates which double as episode names are completely random.

It is very sad to see that this issue was identified at least 5 years ago and nothing* has been done to improve it. If I, as the owner of the infrastructure on which J! Archive runs (but not the owner of the site; only one member of the very good team that maintains it) can offer any help, let me know.

* I understand that some have been doing something, but it is far too little to fix such a big problem.

Posts: 5
Joined: Sun Nov 09, 2014 7:23 am

Sun Nov 09, 2014 8:30 am

I have been looking through the forum to find other discussions about this show. I found some reference to the "proper" season/episode numbering convention. If it is at all helpful, I have a script that converts Jeopardy!'s dates and episode numbers to that format for all 31 seasons of the current show.

The production numbers from the first season have a bit of a glitch in that they reran 65 episodes with new numbers (eps #196 to #260). Episode 261 was 2x01, while the last ep of season 1 was #195.

Posts: 432
Joined: Thu Jul 18, 2013 3:18 pm

Sun Nov 09, 2014 12:05 pm

Yeah, I agree that Jeopardy would be better organized in its (well-defined) seasons (and was just thinking about asking about that again). Here's what I would like to see:
  • Remove the now-empty episodes from the "1985" season (see below).
  • Rename the current Jeopardy! show to "Jeopardy! (1984)" (keeping the 77075 series-id).
  • Create a new "Jeopardy!" series that begins in 1964.
  • Move the 1964 season to the new series.
  • Move the Jan-Aug(-ish) episodes of each season into the prior season (or move the shorter list of trailing episodes into the following season -- each season's start is noted in the title, so it's easy to see where things are divided).
  • Change all the current show's year season numbers to seasons 1 - 31 (with the one extra, empty season being removed).
@bpmod: thanks for pointing out the duplicate production numbers prior to 261. I have used that info to renumber the episodes in 1985, which leaves 65 extra episodes at the end.

Is there anything else that would be needed to clean things up?
Post Reply