Derek McInnes

Staff

Staff record

staff is the non-playing subtype of person: people this export decoded as staff rather than as players. It is only one of the three places a career can live. Plenty of well-known managers have no staff row at all — some are stored as players, and many sit in person_unclassified, whose subtype the decoder could not determine. Whichever table a person is in, their jobs come from staff_history joined to job_type, which is the table below.

Current ability
120
Potential ability
140
Home reputation
120
Current reputation
120
World reputation
0
International appearances
2
Coaching qualification
1

Ability and the three reputations are the raw game figures, which run to roughly 200 rather than to 20 — they are printed exactly as stored and nothing is converted. coaching_qualification is a badge level with no lookup table in the export, so it is shown as the stored number and no name is invented for it.

Appearance

Ethnicity code
0
Hair colour code
11
Hair length code
6
Skin tone code
1

Raw codes from the source. The export carries no lookup table for any of them, so they are shown as stored and are not given names.

Non-playing ability

Judging player ability 10
Judging player potential 15
Tactical knowledge 10
Hardness of training 11
Youngsters 11
Physiotherapy 4
Motivating 13
People management 14
Discipline 12
Mind games 5
Patience 10
Determination 16
Buying players 13
Business 14
Resources 8
Interference 2

16 of 26 values recorded from staff_ability. Not recorded: Judging staff ability, Judging team data, Analysing data, Presenting data, Coaching, Coaching technique, Injury management, Eccentricity, Versatility, Negotiating.

Coaching

Coaching Coaching: 6 of 6 values recorded, plotted on a 1 to 20 scale. Coaching: 6 of 6 values recorded, plotted on a 1 to 20 scale.
6 of 6 recorded
Coaching — every value plotted above, plus the ones that are not recorded.
AttributeValue
Attacking 9
Defending 11
Technical 13
Tactical 8
Mental 15
Fitness 12
Attacking 9
Defending 11
Technical 13
Tactical 8
Mental 15
Fitness 12

6 of 6 values recorded from staff_coaching.

Goalkeeping coaching

Goalkeeper shot stopping 1
Goalkeeper handling 1
Goalkeeper distribution 1

3 of 3 values recorded from staff_coaching.

Tactical style

The tactical preferences this person brings to a side, on the same 1 to 20 scale.

Attacking 11
Directness 12
Tempo 13
Width 14
Depth 7
Pressing 13
Flexibility 3
Flamboyancy 8
Squad rotation 3
Dirtiness allowance 6

10 of 17 values recorded from staff_tactical_style. Not recorded: Sitting back, Marking, Offside, Use of playmaker, Use of subs, Free roles, Set pieces.

Career spells

Marked current: 2 of 12 spells. A spell counts as current when date_left is empty or falls in the future — the source records plenty of long-finished spells with no end date, so more than one spell can carry the mark.

Career spells from staff_history, in the order the export wrote them.
ClubRoleFromToStatus
Greenock Morton Player 1988-08-13 1995-11-13 Ended
Rangers Player 1995-11-13 1999-12-27 Ended
Stockport County Player 1998-11-06 1999-05-06 Ended
Toulouse FC Player 1999-12-27 2000-08-10 Ended
West Bromwich Albion Player 2000-08-10 2003-06-30 Ended
Dundee United Player 2003-07-11 2006-06-30 Ended
Millwall Player 2006-07-03 2007-01-01 Ended
St Johnstone Player 2007-01-01 — Current
St Johnstone Manager 2007-11-26 2011-10-15 Ended
Bristol City Manager 2011-10-15 2013-01-12 Ended
Aberdeen Manager 2013-04-06 2021-03-08 Ended
Kilmarnock Manager 2022-01-04 — Current

National-team spells

No national-team spells are recorded in person_nation_contract for this person.

Club contract

Joined
2022-01-04
Contract start
2022-09-30
Expires
2026-05-31
Weekly wage
£2,800

Squad numbers

Squad numbers from club_squad_number, keyed on team_uid.
TeamNumber
Team 1580 —

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

Disliked clubs

ClubRating
Celtic 100
Wolverhampton Wanderers 70

Liked people

PersonRating
Brian Reid 100
Tony Docherty 100
Paul Sheerin 100
Graham Kirk 95
Ian McCall 85
— 75
David Mackay 75
— 70
Barry Ferguson 60

Disliked people

PersonRating
Edward Henrik Larsson 25
Thomas Boyd 60

Personal information

Date of birth
1971-07-05
Nationality
Scotland
Birth city
Paisley
Joined current club
2022-01-04

Personality

Personality is stored on the same 1–20 scale as the attributes, and is shown exactly as recorded. A dash is a value the export did not record, which is not a zero.

Adaptability 3
Ambition 18
Controversy 6
Loyalty 14
Pressure 8
Professionalism 18
Sportsmanship 14
Temperament 15