Audit missing club IDs across registered clubs, fixtures, and appearances to identify data gaps and improve normalization.
Examine unmapped team names found in fixtures and appearances. Most represent friendly touring sides (e.g. UCLA), charity matches (Legends), or blank TBD placeholders.
Review the exact 14 fixtures where home or away club IDs are missing. 10 of these are future knockout cup fixtures waiting for round winners.
Track player appearances missing club ID linkage. Currently, all 437,465 appearance records have been successfully resolved and aligned!
| Season | Category | Total Fixtures | Fixtures Missing ID | Fixture Coverage | Total Appearances | Apps Missing ID | App Coverage | Status |
|---|---|---|---|---|---|---|---|---|
| 26-27 | Men | 1,143 | 0 | 100% | 5,332 | 0 | 100% | Perfect |
| 26-27 | Schools | 353 | 0 | 100% | 2,408 | 0 | 100% | Perfect |
| 26-27 | Women | 359 | 0 | 100% | 576 | 0 | 100% | Perfect |
| 26-27 | Youth | 708 | 0 | 100% | 5,547 | 0 | 100% | Perfect |
| 25-26 | Men | 1,642 | 0 | 100% | 54,561 | 0 | 100% | Perfect |
| 25-26 | Schools | 1,168 | 0 | 100% | 28,497 | 0 | 100% | Perfect |
| 25-26 | Women | 426 | 3 | 99.3% | 12,980 | 0 | 100% | TBD Draws |
| 25-26 | Youth | 3,773 | 6 | 99.8% | 116,612 | 552 | 99.5% | Needs Audit |
| 24-25 | Men | 1,626 | 2 | 99.9% | 52,431 | 0 | 100% | TBD Draws |
| 24-25 | Schools | 857 | 1 | 99.9% | 24,163 | 0 | 100% | TBD Draws |
| 24-25 | Women | 378 | 0 | 100% | 11,494 | 0 | 100% | Perfect |
| 24-25 | Youth | 3,901 | 2 | 99.9% | 122,864 | 0 | 100% | TBD Draws |