Just A Minute

In my inexplicable (yet continuing) mission to convert JAM data to a nice, neat normalised form, please find attached a CSV list of all episodes (including JJAM and TV) and their subjects. 

I don't know why you would want this, but it was a bit of fun for me. I love a challenging bout of data-wrangling with a powerful text editor and complex spreadsheet formulae. 

It would make a jolly neat table in a fully-normalised JamBASE if anyone cared to build one. 

Actually, if Dean were willing, we could maybe build him a shiny online database he could control to save him time manually collating and updating all his webpages after every episode airs. 

I know the pain of manually maintaining a huge collection that requires increasing onerous changes to include all the knock-on effects of every small addition. When a collection is small, it is easy and fun to update; when it's the size of an elephant with nearly a thousand episodes two hundred players, 6664 unique subjects, and over 8000 rounds - it must be a major pain to keep up to date and maintain data integrity.

As usual, total thanks go to Dean for his online JAM data (http://just-a-minute.info/subjects.html) from which this was parsed and processed.

(I'd normally zip the attached text data, but I suspect Yahoo wouldn't let zipped data through.)

Regards

Mark
--