Jump to content


Photo

Scottish footballer databases


  • Please log in to reply
31 replies to this topic

#1 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 18 May 2011 - 07:43 PM

If you've ever seen my posts, you will realise how much of a stats geek I am. Anyway, I've been gradually building a couple of databases of footballers eligible for the Scottish national squad. They're FAR from complete, but I thought I'd post them here for everyone's benefit when it comes to team selections, etc. I'm also allowing everyone to edit them so they can be expanded and updated.

This is the database for general players (my favoured players are darker)

and this is the database for scoring rates (for players with 15% and above)Club stats are from soccerbase.com and international stats from wikipedia if you're going to contribute to editing/updating.


Edit 25/05/2011:

I've just spent a few hours merging and updating my two databases.
You can find it here.

#2 craig

craig

    Site Owner

  • Administrators
  • 52,393 posts

Posted 18 May 2011 - 08:34 PM

I have made this topic a sticky

#3 jaybee

jaybee

    The Don

  • Members
  • 30,370 posts

Posted 18 May 2011 - 09:20 PM

Nice one Panda.

Follow @sffpodcast on Twitter and send the team a tweet


#4 PaulBand

PaulBand

    Scottish Football View

  • Members
  • 1,360 posts

Posted 18 May 2011 - 09:48 PM

I'd happily help out and add to this

#5 ?apester

?apester

    Football Legend

  • Members
  • 20,954 posts

Posted 18 May 2011 - 10:27 PM

If you've ever seen my posts, you will realise how much of a stats geek I am. Anyway, I've been gradually building a couple of databases of footballers eligible for the Scottish national squad. They're FAR from complete, but I thought I'd post them here for everyone's benefit when it comes to team selections, etc. I'm also allowing everyone to edit them so they can be expanded and updated.

This is the database for general players (my favoured players are darker)

and this is the database for scoring rates (for players with 15% and above)Club stats are from soccerbase.com and international stats from wikipedia if you're going to contribute to editing/updating.

Does that mean you prefer your favourite players to have a nice tan Panda
Muhahahahaha

#6 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 19 May 2011 - 10:16 AM

If you've ever seen my posts, you will realise how much of a stats geek I am. Anyway, I've been gradually building a couple of databases of footballers eligible for the Scottish national squad. They're FAR from complete, but I thought I'd post them here for everyone's benefit when it comes to team selections, etc. I'm also allowing everyone to edit them so they can be expanded and updated.

This is the database for general players (my favoured players are darker)

and this is the database for scoring rates (for players with 15% and above)Club stats are from soccerbase.com and international stats from wikipedia if you're going to contribute to editing/updating.

Does that mean you prefer your favourite players to have a nice tan Panda

Haha, nah I haven't even included Iwelumo and Miller's tan is fake anyway.

#7 jaybee

jaybee

    The Don

  • Members
  • 30,370 posts

Posted 19 May 2011 - 11:06 AM

Why is he not included?

Follow @sffpodcast on Twitter and send the team a tweet


#8 Oisín

Oisín

    Hall Of Fame

  • Members
  • 2,163 posts

Posted 19 May 2011 - 11:09 AM

'cause he's shite ?
when glasgow celtic beat inter milan

#9 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 19 May 2011 - 02:05 PM

Why is he not included?

'cause he's shite ?

Aye pretty much :P He's coming up 33 and has a 24.2% scoring rate. He's not the worst player available, but he's not gonna get any better. I think 30-32 is the maximum age for a striker to be considered. Generally the only way is down after that. Kenny Miller is just on the brink, in my opinion. The only reason he hasn't been replaced is that no-one has really shone through yet and he's had a good season.

#10 jaybee

jaybee

    The Don

  • Members
  • 30,370 posts

Posted 19 May 2011 - 03:52 PM

If you are creating a database of Scottish players it should surely include those who are capped and still playing?

Follow @sffpodcast on Twitter and send the team a tweet


#11 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 19 May 2011 - 04:50 PM

If you are creating a database of Scottish players it should surely include those who are capped and still playing?

It was a database for myself so I could make a more informed decision on team selections etc. I wouldn't pick him to play and already know enough about him to know why. My database. My rules :P

Feel free to add him if you'd like though ;)

#12 jaybee

jaybee

    The Don

  • Members
  • 30,370 posts

Posted 19 May 2011 - 05:36 PM

I can't see it on my phone for some reason.

I will need to wait till I'm on laptop or pc.

Follow @sffpodcast on Twitter and send the team a tweet


#13 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 24 May 2011 - 01:40 AM

I've just spent a few hours merging and updating my two databases.
You can find it here.

#14 jaybee

jaybee

    The Don

  • Members
  • 30,370 posts

Posted 11 August 2011 - 04:23 PM

Other players for list are David Marshall, Ryan Jack, Fraser Fyvie, Scott Allan and Stuart Armstrong.

Follow @sffpodcast on Twitter and send the team a tweet


#15 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 12 August 2011 - 02:12 PM

Other players for list are David Marshall, Ryan Jack, Fraser Fyvie, Scott Allan and Stuart Armstrong.

Added. I'll update all the stats and look for more players soon.

#16 jaybee

jaybee

    The Don

  • Members
  • 30,370 posts

Posted 12 August 2011 - 04:33 PM

If I think of any more I will let you know.

Follow @sffpodcast on Twitter and send the team a tweet


#17 Elchappy

Elchappy

    bought the T shirt

  • Members (over 1000 posts)
  • 6,466 posts

Posted 08 September 2011 - 08:43 PM

Good work Panda lad. Nae telly in your hoose?

#18 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 08 September 2011 - 10:22 PM

Good work Panda lad. Nae telly in your hoose?

Telly's boring, spreadsheets are where it's at :roll: haha

#19 pandamonk

pandamonk

    Football Legend

  • Members (over 1000 posts)
  • 3,522 posts

Posted 13 October 2011 - 04:38 PM

I've updated the database so all the teams and stats should now be correct. You can see this database here. Players in black would be my first choice, in dark grey 2nd choice, light grey 3rd choice/under 23, and light blue 4th choice/under 21. Players with yellow background are players yet to be capped who I think deserve a chance soon.

#20 jaybee

jaybee

    The Don

  • Members
  • 30,370 posts

Posted 13 October 2011 - 06:22 PM

Nice one Panda, any new players been added?

Follow @sffpodcast on Twitter and send the team a tweet





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users