Just A Minute

JAM Series | JAM Stats | JAM Today | JAM Group

<<<< 10688 >>>>

Re: JAM player list [2 Attachments]

Messages in this topic: 1
Amro BilalMar 25, 2016

Always good fun!

Cheers,

From: mailto:just-a-minute@...

Sent: Friday, March 25, 2016 2:39 AM

To: just-a-minute@...

Subject: Re: [just-a-minute] JAM player list [2 Attachments]

[Attachment(s) from nylon included below]

One further JAM database item.

As you all know, in a relational database first normal form forbids the use of repeating fields (such as Guest1, guest2, guest3, guest4).

To alleviate that - for those of you who even know what I'm talking about (e.g. cleverboots at http://tvrdb.com/jam) - here's a separate table for players in each episode. It should fit neatly into a 3NF schema...

Naturally, one would want to create key field IDs for the players at some stage, but so far no duplication of natural names has occurred so it's not likely to be an issue using it as a key field in the near future.

O, what the hell. Also attached is the whole bunch as a flatfile XLSX that you can play with - or just look at.

As a tantalising bonus, if you visit the 'People' sheet you can see the COUNTIF calculation in the SHOWS column that counts the number of appearances of each guest.

According to the data, this is the top 10...

Fullname	FamilyName	GivenName	Shows
Clement Freud	Freud	Clement	540
Paul Merton	Merton	Paul	346
Kenneth Williams	Williams	Kenneth	342
Peter Jones	Jones	Peter	325
Derek Nimmo	Nimmo	Derek	308
Tony Hawks	Hawks	Tony	120
Sheila Hancock	Hancock	Sheila	102
Graham Norton	Norton	Graham	93
Gyles Brandreth	Brandreth	Gyles	86

I didn't realise Tony Hawks had been on so often!

Have fun!

If you don't have fun, it never happened and I was never here.

Thanks again to Dean whose page at http://just-a-minute.info/eps.html was the source of every gram of this datalicious goodness.

Mark

On 25 March 2016 at 12:57, Mark sirnylon@... [just-a-minute] <just-a-minute@...> wrote:

[Attachment(s) from Mark included below]
I don't know why, but today I compiled a list of every JAM player up until the end of Dean's list at http://just-a-minute.info/eps.html.

In all JAM history there have been 197 unique players of the game.

I don't know if Yahoo allows attachments, but I'll try it.

For those of you who love to fiddle with relational databases, here's a CSV file of all JAM players to date.

As usual, thanks to Dean for all the yummy raw data.

Enjoy.

--

Audio instructions - http://b9fx.com/jamhelp.mp3

Mark

Mark

mark at nylon dot net

http://nylon.net

<<<< 10688 >>>>

Back to the Top

Message History

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2019	10	23	12	1	13	5	1	19	12	31	4	14
2018	4	7	21	8	9	37	9	5	19	25	5	14
2017	4	34	22	12	17	20	4	19	23	44	23	16
2016	13	49	39	57	60	87	10	32	24	12	9	23
2015	51	97	32	49	41	54	20	28	0	14	31	16
2014	9	75	68	33	28	33	52	82	51	32	38	79
2013	463	251	98	87	81	192	88	98	86	38	54	27
2012	92	121	180	199	125	88	71	155	118	166	125	144
2011	112	78	71	73	134	225	252	152	62	183	165	63
2010	142	117	153	94	69	49	69	183	82	71	68	75
2009	67	45	42	97	90	149	110	70	63	42	35	39
2008	200	120	175	120	70	109	87	115	71	45	58	38
2007	165	447	132	99	95	57	140	118	74	88	125	99