John Brown
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
- 7
- Hair length code
- 0
- 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
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: 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.
| Club | Role | From | To | Status |
|---|---|---|---|---|
| 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
- Team
- —
- Joined
- 2017-10-30
- Contract start
- —
- Expires
- —
- Weekly wage
- —
Languages
No languages are recorded in person_language for this person.
Relations and preferences
Liked clubs
Disliked clubs
| Club | Rating |
|---|---|
| Celtic | 100 |
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.