Derek McInnes
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
- 127
- Potential ability
- 140
- Home reputation
- 119
- Current reputation
- 125
- 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
A staff_ability row exists, but none of its 26 values are recorded.
Coaching
A staff_coaching row exists, but none of its 6 values are recorded.
Tactical style
A staff_tactical_style row exists, but none of its 17 values are recorded.
Career spells
Marked current: 3 of 11 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.
| Club | Role | From | To | Status |
|---|---|---|---|---|
| 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 | — | Current |
| 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 | — | Current |
National-team spells
No national-team spells are recorded in person_nation_contract for this person.
Club contract
- Club
- Aberdeen
- Team
- —
- Joined
- 2013-04-06
- Contract start
- —
- Expires
- —
- Weekly wage
- —
Languages
| Language | First language | Proficiency |
|---|---|---|
| English | Yes | — |
Relations and preferences
Liked clubs
| Club | Rating |
|---|---|
| Greenock Morton | 75 |
| Rangers | 25 |
| West Bromwich Albion | 70 |
Disliked clubs
| Club | Rating |
|---|---|
| Celtic | 100 |
| Wolverhampton Wanderers | 70 |
Liked people
| Person | Rating |
|---|---|
| Brian Reid | 100 |
| Tony Docherty | 100 |
| Graham Kirk | 95 |
| — | 75 |
| David Mackay | 75 |
| Gary John Megson | 70 |
| Barry Ferguson | 60 |
Disliked people
| Person | Rating |
|---|---|
| Edward Henrik Larsson | 25 |
| Thomas Boyd | 60 |
Personal information
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.