John David Schofield

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
90
Potential ability
105
Home reputation
88
Current reputation
88
World reputation
25
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
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 13
Tactical knowledge 15
Hardness of training 14
Youngsters 13
Motivating 11
People management 11
Discipline 13
Mind games 2
Determination 13
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 12
Defending 12
Technical 9
Tactical 11
Mental 10
Fitness 11
Attacking 12
Defending 12
Technical 9
Tactical 11
Mental 10
Fitness 11

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 17
Directness 9
Tempo 15
Width 16
Depth 14
Pressing 12
Flexibility 10
Squad rotation 6

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 28 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
Matlock Town Player 1987-07-01 1988-03-01 Ended
Gainsborough Trinity Player 1988-03-01 1988-11-01 Ended
Lincoln City Player 1988-11-01 1994-11-01 Ended
Doncaster Rovers Player 1994-11-01 1997-08-08 Ended
Mansfield Town Player 1997-08-08 1999-06-30 Ended
Hull City Player 1999-07-28 2000-06-30 Ended
Lincoln City Player 2000-08-08 — Current
Lincoln City Player / Manager 2000-08-08 2001-02-28 Ended
Lincoln City Manager 2001-02-28 2005-06-30 Ended
Lincoln City Coach 2005-06-30 2006-06-15 Ended
Lincoln City Manager 2006-06-15 2007-10-15 Ended
Scunthorpe United Coach 2008-02-18 2008-05-29 Ended
Walsall Assistant Manager 2008-07-01 2009-01-10 Ended
Walsall Manager 2009-01-10 2009-01-19 Ended
Cheltenham Town Assistant Manager 2009-03-19 2009-10-20 Ended
Cheltenham Town Manager 2009-10-20 2009-12-21 Ended
Cheltenham Town Assistant Manager 2009-12-22 2010-06-30 Ended
Cambridge United Coach 2010-07-28 2011-02-01 Ended
Notts County Coach 2011-04-16 2012-02-18 Ended
Gillingham Assistant Manager 2012-07-01 2014-06-30 Ended
Scunthorpe United Assistant Manager 2014-07-01 2014-10-08 Ended
Lincoln City Coach 2014-12-30 2015-05-21 Ended
York City Assistant Manager 2015-05-21 2015-10-14 Ended
Doncaster Rovers Coach 2016-09-07 2017-06-30 Ended
Doncaster Rovers Manager 2017-07-01 2020-07-01 Ended
Peterborough United Coach 2020-07-01 2021-07-26 Ended
Port Vale Assistant Manager 2023-06-13 2024-02-05 Ended
Scunthorpe United Assistant Manager 2024-07-01 — Current

National-team spells

National-team spells from person_nation_contract.
NationRoleFromToStatus
Northern Ireland Coach 2020-07-01 2021-07-26 Ended
Northern Ireland Manager 2021-07-26 2023-02-01 Ended

Club contract

Joined
2024-07-01
Contract start
2024-10-04
Expires
2026-06-30
Weekly wage
£750

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

Liked people

PersonRating
— 90
Jack Hobbs 80
— 75
Steve Parkin 60
— 60

Personal information

Date of birth
1965-05-16
Nationality
England
Birth city
Barnsley
Joined current club
2024-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 10
Ambition 9
Controversy 1
Loyalty 15
Pressure 10
Professionalism 15
Sportsmanship 10
Temperament 16