⚠️ Data Quality Alert: Database Anomaly Detected #34
Loading…
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
⚠️ Data Quality Alert: Database Anomaly Detected
Audit Timestamp: 2026-11-17 13:01 UTC
Repository:
john4064/Sports-IngestionCommit SHA:
381bd371bc4a5438a301a4abfe35d8a9f8e477ecGridiron Ledger: Comprehensive Accuracy & Integrity Audit Report
Audit Timestamp:
2026-11-17 05:01:00 PSTTarget Season:
2026(and historical backfill downward)Live Deployment Target: https://nfl.rcslabs.dev
Database Host Target:
postgres://rcsdev:%E2%80%A2%E2%80%A2%E2%80%A2%E2%80%A2@192.168.0.140:5432/zeta?sslmode=disable1. Executive Summary & Quality Scorecard
0CLEAN (0)0CLEAN (0)0CLEAN (0)1FLAGGED (1)17PASS182. Detailed Findings by Category
Live Deployment (nfl.rcslabs.dev)
1.
✅ PASS/api/seasons contract verifiedSuccessfully verified 28 seasons descending from 2026 to 1999.
2.
✅ PASS/api/teams 32-franchise count verifiedExactly 32 NFL franchises returned with valid division mappings.
3.
✅ PASS/api/teams?team=SF franchise detail verifiedSuccessfully retrieved 44 roster players and 17 schedule games for SF.
4.
✅ PASS/api/matchups Week 11 slate verifiedAll 13 games populated with kickoff times, venues, betting odds, and impact players.
5.
✅ PASS/api/player/advanced contract verifiedProfile and advanced telemetry successfully returned for p_patrick_mahomes (Season 2026).
6.
✅ PASS/api/player/career contract verifiedSuccessfully retrieved 8 game log rows and career totals for p_patrick_mahomes.
7.
✅ PASSPassing leader ground truth reconciliation verifiedVerified 5 top passing leaders in DB against external telemetry.
Database Relational & Schema Integrity
1.
✅ PASSTeam code canonicalization verifiedZero legacy or ghost team aliases ('LA', 'OAK', 'SD') found across all player stats tables.
2.
✅ PASSPlayer identity deduplication verifiedZero suffix-induced fragmented player records found.
3.
✅ PASSPlayer ID slug canonicalization verifiedAll player_id entries in weekly_stats conform to canonical ^p_ prefix.
4.
✅ PASSReferential integrity verifiedAll weekly_stats rows successfully link to master players directory.
5.
✅ PASSGame score status consistency verified (Season 2026)All scheduled games have NULL scores, and all final games have valid non-null scores.
6.
✅ PASSClosing betting lines verified for completed games (Season 2026)All finalized games have non-null closing spreads and over/under totals.
7.
✅ PASSWeekly stats week boundaries verifiedZero seasonal aggregate rows (week <= 0) found in weekly_stats.
Database Statistical Consistency
1.
✅ PASSStatistical bounds verified (Season 2026)All single-game yardage metrics remain within legitimate historical NFL maximums.
2.
ℹ️ LOWCross-source stat variance between ESPN and Sleeper (Season 2026)Out of 7011 matched player-games, found 1 pass yard mismatches, 1 rush yard mismatches, and 1 rec yard mismatches.
0 discrepancies between official box scores3 total stat variancesExternal Ground Truth: Yahoo Sports
1.
✅ PASSYahoo Sports cross-validation clean (150 games verified)All 150 audited games across Season 2026 Weeks 1-5 matched Yahoo Sports official scores 100%.
External Ground Truth: Historical Games Registry
1.
✅ PASSCanonical games registry parity verified (272 games, Season 2026)All 272 games in Season 2026 matched 100% against canonical GSIS/PFR game records.
3. Master Idempotent Remediation Script
Below is the consolidated, safe idempotent SQL script to remediate all database discrepancies identified during this audit run:
Raw Execution Logs
This issue was automatically generated by the weekly Tuesday Data Quality Forgejo Action.