David Geraint Williams

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
95
Potential ability
135
Home reputation
95
Current reputation
95
World reputation
50
International appearances
13
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
4

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 12
Judging player potential 10
Tactical knowledge 10
Hardness of training 10
Youngsters 10
Motivating 15
People management 12
Discipline 14
Mind games 5
Determination 14
Buying players 10

11 of 26 values recorded from staff_ability. Not recorded: Judging staff ability, Judging team data, Analysing data, Presenting data, Coaching, Coaching technique, Physiotherapy, Injury management, Patience, Eccentricity, Versatility, Negotiating, Business, Resources, Interference.

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 14
Defending 12
Technical 12
Tactical 12
Mental 11
Fitness 10
Attacking 14
Defending 12
Technical 12
Tactical 12
Mental 11
Fitness 10

6 of 6 values recorded from staff_coaching.

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 13
Directness 8
Tempo 14
Width 8
Depth 10
Pressing 15
Flexibility 12
Squad rotation 12

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

Career spells

Marked current: 2 of 9 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
Bristol Rovers Player 1979-07-01 1985-01-02 Ended
Derby County Player 1985-01-02 1992-07-01 Ended
Ipswich Town Player 1992-07-01 1998-07-01 Ended
Colchester United Player 1998-07-01 — Current
Colchester United Coach 2000-07-01 2003-06-30 Ended
Colchester United Assistant Manager 2003-07-01 2006-06-30 Ended
Colchester United Manager 2006-07-01 2008-09-22 Ended
Leyton Orient Manager 2009-02-05 2010-04-05 Ended
Ipswich Town Assistant Manager 2022-07-01 — Current

National-team spells

National-team spells from person_nation_contract.
NationRoleFromToStatus
Wales Manager 2012-07-10 2016-11-30 Ended

Club contract

Joined
2022-07-01
Contract start
2022-07-01
Expires
—
Weekly wage
£700

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

Disliked clubs

ClubRating
Swansea City 75

Liked people

Personal information

Date of birth
1962-01-05
Nationality
Wales
Birth city
Treorchy
Joined current club
2022-07-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 —
Ambition 12
Controversy 5
Loyalty 16
Pressure 15
Professionalism 17
Sportsmanship 15
Temperament 18