← Back to Statistics

Data Cleansing

Tools for identifying and resolving data quality issues in the match database.

Match Cleanse
Checks every match for goals errors, missing scorers, missing line-ups and incomplete line-ups — flagging each issue type separately.
Run Match Cleanse
🔍
Scorer Cleanse
Finds matches where scorer names cannot be matched to the team line-up, highlighting entries that need attention.
Run Scorer Cleanse
🟨
Discipline Cleanse
Finds matches where booked or sent-off names cannot be matched to the team line-up, highlighting entries that need attention.
Run Discipline Cleanse
🔤
Name Cleanse
Lists all players recorded with a single name only (no first name), so missing first names can be researched and added.
Run Name Cleanse
📄
Name Report
Generates the same single-name player list as Name Cleanse, but formatted for export as a PDF or CSV file to share with researchers.
Run Name Report
🔤
Initials Report
Lists every player recorded with an initial only and no full first name — for example "J Smith" or "A.B. Jones". Useful for identifying players whose full first name could be researched.
Run Initials Report
🔎
Surname Report
Enter a surname to find all matching player entries across the match database, grouped by season — useful for identifying players that may or may not be the same person.
Run Surname Report
🤝
Common Matches
Enter two player names to find every match in which both players appear in the line-up together — useful for verifying whether two similarly-named entries could be the same person.
Run Common Matches
👤
Player Cleanse
Browse all players by surname initial — view appearances, goals and seasons to verify and cross-check player records.
Run Player Cleanse