Coventry City Player Database (3 Viewers)

[Nick]

oldfiver just posted this - http://www.neilbrown.newcastlefans.com/coventry/coventry.html

It's interesting because you can see a list of ex players and their stats in one place to compare appearances.

The only thing is it is a list.

I could knock up a simple web version where you can sort players by year, appearances, name, position etc easy enough if anybody else wanted to volunteer to help populate it?

Wiki does have the info, but it means searching for each player to compare.

It's a better use of time than some of the unconstructive posts and it is actually ccfc related and interesting! I'm happy to spend a few hours inputting player info and I am sure it will be quite good for the older members memories to think of players who have been missed off!

 

---

[Astute]

I could knock up a simple web version where you can sort players by year, appearances, name, position etc

It's a better use of time than some of the unconstructive posts

Great idea Nick

 

[Nick]

I'll have a think tonight and sort something tomorrow night. At least we can learn things like Barry Quinn playing more games than Micky Quinn

 

[steve82]

This sites pretty useful..
Coventry City - Club's profile | Transfermarkt

 

[italiahorse]

It would be nice to have that if you have the time.
Fascinating list but would like a few sort options.
Quite a task to put it into a database though and the functionality will be an issue.

Should keep you off the board for a few days

 

[Nick]

Nah the web database and functionality would take a couple of hours.

Populating it might take a while but if anybody gets bored they are welcome to do a letter each

 

[steve82]

It's a good idea. Always good to look up old players and compare there stats.

Did you no for example Darius Henderson has a better goals per minute ratio than Marvin Sordell this season
Sordell 294 minutes per goal
Henderson 241 minutes per goal

 

[JimmyHillsbeard]

Search Former Players Database : Coventry City Former Players Association || CCFPA

 

[Nick]

Search Former Players Database : Coventry City Former Players Association || CCFPA

Cheers. Might be a way i can improve functionality

 

[Nick]

It's a good idea. Always good to look up old players and compare there stats.

Did you no for example Darius Henderson has a better goals per minute ratio than Marvin Sordell this season
Sordell 294 minutes per goal
Henderson 241 minutes per goal

That might be too precise, would have to know how many minutes off every game!

 

[steve82]

That might be too precise, would have to know how many minutes off every game!

That's what transfermkt is good for. Really useful site.

Been looking through and Ryan Haynes has our best minutes per goals ratio so far.. 175 mins

 

[robbiekeane]

I'll take the letter Z mate

 

[robbiekeane]

But seriously ill help out if I can

 

[shmmeee]

Turned the list in OP into a Google Spreadsheet and added a couple of calculated columns like goals per appearance and appearances per season.

 

[singers_pore]

If SISU had any interest in the club they would be drawing on the skills of fans like Nick to turn the club around. Fair play.

 

[Nick]

If SISU had any interest in the club they would be drawing on the skills of fans like Nick to turn the club around. Fair play.

Not sure I could do too much with that by making web apps, but thanks

 

[Nick]

Turned the list in OP into a Google Spreadsheet and added a couple of calculated columns like goals per appearance and appearances per season.

Damn those insomniacs beating me to it!

Can you make it filterable too?

 

[covman]

If SISU had any interest in the club they would be drawing on the skills of fans like Nick to turn the club around. Fair play.

Interesting...

 

[italiahorse]

If SISU had any interest in the club they would be drawing on the skills of fans like Nick to turn the club around. Fair play.

Is he the sugar daddy then ?

 

[shmmeee]

Damn those insomniacs beating me to it!

Can you make it filterable too?

Not sure I can, no. I can filter it, but the option disappears when I share it here.

I've made the link editable, feel free to take it off me and have a play.

 

[Nick]

Not sure I can, no. I can filter it, but the option disappears when I share it here.

I've made the link editable, feel free to take it off me and have a play.

Looks like it auto parses it

Can you put it onto a link where you select text, click the link button and do it there?

 

[shmmeee]

LINK

 

[shmmeee]

docs.google.com /spreadsheets/d/1u0SByg8pAitDH8xUxBujrx-DQlNuE8oxt733JXeTObk/edit?usp=sharing

Or take out the space after .com

 

[shmmeee]

Will warn that anyone can edit so probably best to take a copy straight away

 

[Nick]

I like how it gives animal names for those viewing

 

[Nick]

Yep, took CSV and Excel backups

 

[shmmeee]

Added a stats tab, here's the clubs we've sold to most over the years:

TRANSFERRED TO Count
Birmingham City 16
Northampton Town 13
Retired 12
Walsall 12
Nuneaton Borough 11
Derby County 10
Aston Villa 9
Plymouth Argyle 9
Retired (injury) 9
Luton Town 8
Sheffield Wednesday 8
Cambridge United 7
Cardiff City 7
Nottingham Forest 7
Notts County 7
Rugby Town 7
Torquay United 7
West Bromwich Albion 7
Brighton 6
Charlton Athletic 6
Stoke City 6
Tottenham Hotspur 6
Wolverhampton Wanderers 6
Blackburn Rovers 5
Bristol City 5
Huddersfield Town 5
Liverpool 5
Mansfield Town 5
Millwall 5
Norwich City 5

 

[shmmeee]

Here are the positions we've had the most players in:

POS. Count
M 149
F 120
FB 83
W 66
G 59
CD 55
D 34
IF 33
CF 30
WH 20
CH 7

 

[Irish Sky Blue]

Turned the list in OP into a Google Spreadsheet and added a couple of calculated columns like goals per appearance and appearances per season.

It's interesting that in your table Mick Hartford is No 2 in the goals to appearances ratio. ( who is number 1, I thought it would be him?). I think he came on as a sub against Newcastle for the last 15 mins, scored the winner, got injured and never played for us again.
A great idea I think. Interesting that Birmingham are our largest customer for player sales.

 

[robbiekeane]

Here are the positions we've had the most players in:

POS. Count
M 149
F 120
FB 83
W 66
G 59
CD 55
D 34
IF 33
CF 30
WH 20
CH 7

I reckon strikers would be at the top this year haha.

Nice work. On my phone atm but will have a play when I'm near a laptop