John Brown

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
100
Potential ability
120
Home reputation
100
Current reputation
100
World reputation
40
International appearances
0
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
0
Hair length code
4
Skin tone code
5

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 15
Tactical knowledge 8
Hardness of training 16
Youngsters 18
Motivating 8
People management 13
Discipline 19
Determination 18
Buying players 10

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

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 7
Tempo 10
Width 13
Depth 14
Pressing 15
Flexibility 12
Flamboyancy 10
Squad rotation 11
Dirtiness allowance 13

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: 4 of 8 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
Hamilton Academical Player — — Current
Dundee Player — — Current
Rangers Player — — Current
Rangers Coach 1997-07-01 2006-06-27 Ended
Clyde Manager 2008-01-25 2009-11-21 Ended
Rangers Scout 2011-03-08 2012-06-22 Ended
Dundee Manager 2013-02-23 2014-02-03 Ended
Rangers Scout 2017-10-30 — Current

National-team spells

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

Club contract

Club
Rangers
Joined
2017-10-30
Contract start
2017-10-30
Expires
2023-05-31
Weekly wage
£766

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

ClubRating
Dundee 50
Rangers 100

Disliked clubs

ClubRating
Celtic 100

Personal information

Date of birth
1962-01-26
Nationality
Scotland
Birth city
Dundee
Joined current club
2017-10-30

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 13
Ambition 8
Controversy 15
Loyalty 20
Pressure 7
Professionalism 17
Sportsmanship 7
Temperament 8