Andy Johnson

Club

Crystal Palace

Squad

Crystal Palace

Squad number

8

Type

—

Squad status

—

Joined

2002-07-27

Contract start

—

Expires

2006-06-30

Weekly wage

£5,000

Estimated value

—

Transfer status

—

Asking price

—

Current ability

126

Potential ability

143

Home reputation

105

Current reputation

105

World reputation

35

Personality

—

Media handling

—

Favourite squad number

—

Season record

One row per season as the export recorded it. A transfer fee is shown where a figure was stored; where the source recorded only a sentinel — "Undisclosed fee", "Unknown fee" — that sentinel is printed instead. A fee of zero is a fee of zero, not a missing one.

• person_days_at_location, person_trained_status Training days and recorded home-grown status Exported; UI pendingThe modern schema includes days, age bands and trained-at-club or trained-in-nation relationships. Rule codes and target kinds must be respected; these rows do not prove eligibility under every competition rule.
• person names, date_of_birth, height_cm, weight_kg Names, birth date, height and weight Now liveRecorded identity and measurements are displayed; missing values stay blank.
• export_meta.reference_date Age at the in-game date No reference dateThe base .dat source does not store an authoritative reference date. Birth year alone cannot establish an exact age.
• person_nationality, person.declared_nation_uid Additional nationalities and declared nation Now liveSecond, third and resident nationalities with their source relationship labels, and the declared nation, are displayed where the version exports them; CSV-era versions say so.
• person_contract_detail, person_club_status Contract type, squad status and explicit unattached status Partial exportContract type is displayed where contract_status is decoded (FM24); the FM26 exports carry the column as NULL on every row. squad_status has no lookup table and has_no_club is not yet used; a missing contract is not evidence of free agency.
• playing-time promises and market status Playing-time promise, transfer or loan listing and asking price Needs source dataThese facts are not established by the current contract-detail or club-status columns.
• person_contract_clause, person_contract_bonus Contract clauses and bonuses Partial exportRecorded clauses are displayed. Starting-contract bonus rows are counted with their raw type codes; cash and misc need clause-specific interpretation before any amount or condition is shown.
• agent identity and representation Agent Needs source dataThe current catalog has no agent identity or representation relation.
• player attribute tables and PlayerRoles Role suitability Now liveFMDB calculates its own weighted attribute scores for competent positions, with coverage thresholds; these are not stored scouting stars.
• attribute tables in the previous version of the same game Attribute changes since the previous version Now liveComparisons distinguish a changed value, newly recorded data, missing data and off-scale values.
• player and person_club_contract across versions Ability, potential, value and wage across versions Now liveCharts use recorded values after identity checks in each target database. Missing values and coded potential are not invented chart points.
• person personality attributes; preferred_move.bit_index Personality, media handling and preferred-move labels Needs validationPersonality scores and move bits are recorded. Validated labels and era-specific mappings are still missing.
• person_international_record Senior and under-21 goals, caps and debut details Now liveSenior and under-21 caps and goals, previous nations, debut and first goal are displayed where the version exports them; CSV-era versions fall back to senior caps from the player row. Youth categories are not established.
• starting_person_history, starting_person_history_date Personal honours and milestones Partial exportFM24 achievements include record_type, job, flags and date precision. Other versions remain unsupported; the page still needs validated event interpretation. Club membership in a winning season does not prove a medal.
• player_history Career totals and recorded season history with fees Now liveTotals use bounded history and exclude overlapping summary rows. Coverage depends on the selected player and version.
• player attribute vectors within a bounded division cohort Similar players Now liveFMDB compares shared recorded attributes within the documented ability band and candidate cap; this is not a whole-database search.
• award_history_winner and person relationship tables Recorded awards, liked and disliked clubs and people Now liveOnly resolving identities are linked; missing relationships remain missing.
• explicit youth and first-professional-contract events Youth club and first professional contract Needs source dataAn earliest career row, current contract start or forced initial contract date does not establish either fact.