David Wilson

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
85
Potential ability
107
Home reputation
20
Current reputation
85
World reputation
6
International appearances
0
Coaching qualification
—

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
15
Hair length code
6

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 14
Judging player potential 18
Tactical knowledge 16
Motivating 16
People management 16
Determination 17

6 of 26 values recorded from staff_ability. Not recorded: Judging staff ability, Judging team data, Analysing data, Presenting data, Coaching, Coaching technique, Hardness of training, Youngsters, Physiotherapy, Injury management, Discipline, Mind games, Patience, Eccentricity, Versatility, Buying players, Negotiating, Business, Resources, Interference.

Coaching

A staff_coaching row exists, but none of its 6 values are recorded.

Goalkeeping coaching

Goalkeeper shot stopping 1

1 of 3 values recorded from staff_coaching. Not recorded: Goalkeeper handling, Goalkeeper distribution.

Tactical style

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

Attacking 10

1 of 17 values recorded from staff_tactical_style. Not recorded: Directness, Tempo, Width, Depth, Pressing, Sitting back, Marking, Offside, Use of playmaker, Use of subs, Free roles, Flexibility, Flamboyancy, Squad rotation, Set pieces, Dirtiness allowance.

Career spells

Marked current: 1 of 10 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
Rovaniemen Palloseura Player 1993-01-01 1994-01-01 Ended
Ljungskile SK Player 1994-01-01 1999-01-01 Ended
Valkeakosken Haka Player 1999-01-01 2002-07-01 Ended
Helsingin Jalkapalloklubi Player 2002-07-01 2003-01-01 Ended
Ljungskile SK Player 2002-07-01 2008-11-16 Ended
Aston Villa Scout 1997-04-01 2012-01-31 Ended
Ljungskile SK Manager 2002-07-01 2005-11-11 Ended
GIF Sundsvall Manager 2005-11-11 2006-07-04 Ended
Ljungskile SK Manager 2006-08-26 2008-11-16 Ended
Chelsea Scout 2012-02-01 — Current

National-team spells

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

Club contract

Club
Chelsea
Joined
2012-02-01
Contract start
2012-02-01
Expires
—
Weekly wage
£1,000

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

ClubRating
Manchester United 75
Ljungskile SK 75

Liked people

PersonRating
Keith Armstrong 85

Personal information

Date of birth
1969-03-20
Nationality
England
Birth city
Burnley
Joined current club
2012-02-01

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 18
Ambition 8
Controversy —
Loyalty 18
Pressure 8
Professionalism 13
Sportsmanship 11
Temperament 3