Debug: Available stats for ARI:
Category 0: gamesPlayed teamGamesPlayed hitByPitch groundBalls strikeouts RBIs sacHits hits stolenBases walks catcherInterference runs GIDPs sacFlies atBats homeRuns grandSlamHomeRuns runnersLeftOnBase triples gameWinningRBIs intentionalWalks doubles flyBalls caughtStealing pitches gamesStarted pinchAtBats pinchHits playerRating isQualified isQualifiedSteals totalBases plateAppearances projectedHomeRuns extraBaseHits runsCreated avg pinchAvg slugAvg secondaryAvg onBasePct OPS groundToFlyRatio runsCreatedPer27Outs batterRating atBatsPerHomeRun stolenBasePct pitchesPerPlateAppearance isolatedPower walkToStrikeoutRatio walksPerPlateAppearance secondaryAvgMinusBA runsProduced runsRatio patienceRatio BIPA MLBRating offWARBR WARBR
Category 1: gamesPlayed teamGamesPlayed saves groundBalls strikeouts sacFlies losses hits earnedRuns battersHit walks runs stolenBases caughtStealing sacBunts saveOpportunities homeRuns triples finishes balks intentionalWalks flyBalls battersFaced holds doubles wins completeGames perfectGames wildPitches RBIs thirdInnings teamEarnedRuns shutouts pickoffAttempts pitches runSupport catcherInterference pitchesAsStarter gamesStarted avgGameScore qualityStarts inheritedRunners inheritedRunnersScored playerRating atBats opponentTotalBases isQualified isQualifiedSaves fullInnings partInnings blownSaves innings ERA WHIP winPct caughtStealingPct groundToFlyRatio pitchesPerStart pitchesPerInning pitchesPerPlateAppearance runSupportAvg opponentAvg opponentSlugAvg opponentOnBasePct opponentOPS savePct strikeoutsPerNineInnings strikeoutToWalkRatio toughLosses cheapWins saveOpportunitiesPerWin BIPA pitchCount strikes strikePitchRatio WARBR
Category 2: gamesPlayed teamGamesPlayed doublePlays opportunities errors passedBalls assists outfieldAssists pickoffs putouts outsOnField triplePlays ballsInZone extraBases outsMade hits totalBases gamesStarted catcherThirdInningsPlayed catcherCaughtStealing catcherStolenBasesAllowed catcherEarnedRuns isQualified isQualifiedCatcher isQualifiedPitcher successfulChances totalChances fullInningsPlayed partInningsPlayed fieldingPct rangeFactor zoneRating catcherCaughtStealingPct catcherERA defWARBR
✅ Found strikeouts for ARI: 1316
✅ Found stolenBases for ARI: 121
✅ Found homeRuns for ARI: 214
✅ Found avg for ARI: .251
✅ Found strikeouts for ARI: 1288
✅ Found stolenBases for ARI: 107
✅ Found homeRuns for ARI: 196
✅ Found strikeouts for ATL: 1371
✅ Found stolenBases for ATL: 82
✅ Found homeRuns for ATL: 190
✅ Found avg for ATL: .245
✅ Found strikeouts for ATL: 1416
✅ Found stolenBases for ATL: 152
✅ Found homeRuns for ATL: 197
✅ Found strikeouts for BAL: 1457
✅ Found stolenBases for BAL: 121
✅ Found homeRuns for BAL: 191
✅ Found avg for BAL: .235
✅ Found strikeouts for BAL: 1351
✅ Found stolenBases for BAL: 104
✅ Found homeRuns for BAL: 217
✅ Found strikeouts for BOS: 1419
✅ Found stolenBases for BOS: 139
✅ Found homeRuns for BOS: 186
✅ Found avg for BOS: .254
✅ Found strikeouts for BOS: 1361
✅ Found stolenBases for BOS: 124
✅ Found homeRuns for BOS: 164
✅ Found strikeouts for CHC: 1277
✅ Found stolenBases for CHC: 161
✅ Found homeRuns for CHC: 223
✅ Found avg for CHC: .249
✅ Found strikeouts for CHC: 1265
✅ Found stolenBases for CHC: 80
✅ Found homeRuns for CHC: 202
✅ Found strikeouts for CHW: 1364
✅ Found stolenBases for CHW: 85
✅ Found homeRuns for CHW: 165
✅ Found avg for CHW: .232
✅ Found strikeouts for CHW: 1286
✅ Found stolenBases for CHW: 147
✅ Found homeRuns for CHW: 189
✅ Found strikeouts for CIN: 1415
✅ Found stolenBases for CIN: 105
✅ Found homeRuns for CIN: 167
✅ Found avg for CIN: .245
✅ Found strikeouts for CIN: 1380
✅ Found stolenBases for CIN: 114
✅ Found homeRuns for CIN: 190
✅ Found strikeouts for CLE: 1344
✅ Found stolenBases for CLE: 129
✅ Found homeRuns for CLE: 168
✅ Found avg for CLE: .226
✅ Found strikeouts for CLE: 1381
✅ Found stolenBases for CLE: 108
✅ Found homeRuns for CLE: 169
✅ Found strikeouts for COL: 1531
✅ Found stolenBases for COL: 87
✅ Found homeRuns for COL: 160
✅ Found avg for COL: .237
✅ Found strikeouts for COL: 1093
✅ Found stolenBases for COL: 131
✅ Found homeRuns for COL: 251
✅ Found strikeouts for DET: 1454
✅ Found stolenBases for DET: 61
✅ Found homeRuns for DET: 198
✅ Found avg for DET: .247
✅ Found strikeouts for DET: 1375
✅ Found stolenBases for DET: 82
✅ Found homeRuns for DET: 187
✅ Found strikeouts for HOU: 1301
✅ Found stolenBases for HOU: 85
✅ Found homeRuns for HOU: 182
✅ Found avg for HOU: .250
✅ Found strikeouts for HOU: 1504
✅ Found stolenBases for HOU: 157
✅ Found homeRuns for HOU: 199
✅ Found strikeouts for KC: 1096
✅ Found stolenBases for KC: 111
✅ Found homeRuns for KC: 159
✅ Found avg for KC: .247
✅ Found strikeouts for KC: 1271
✅ Found stolenBases for KC: 47
✅ Found homeRuns for KC: 171
✅ Found strikeouts for LAA: 1627
✅ Found stolenBases for LAA: 88
✅ Found homeRuns for LAA: 226
✅ Found avg for LAA: .225
✅ Found strikeouts for LAA: 1280
✅ Found stolenBases for LAA: 124
✅ Found homeRuns for LAA: 223
✅ Found strikeouts for LAD: 1353
✅ Found stolenBases for LAD: 88
✅ Found homeRuns for LAD: 244
✅ Found avg for LAD: .253
✅ Found strikeouts for LAD: 1505
✅ Found stolenBases for LAD: 112
✅ Found homeRuns for LAD: 175
✅ Found strikeouts for MIA: 1247
✅ Found stolenBases for MIA: 138
✅ Found homeRuns for MIA: 154
✅ Found avg for MIA: .250
✅ Found strikeouts for MIA: 1294
✅ Found stolenBases for MIA: 191
✅ Found homeRuns for MIA: 199
✅ Found strikeouts for MIL: 1266
✅ Found stolenBases for MIL: 164
✅ Found homeRuns for MIL: 166
✅ Found avg for MIL: .258
✅ Found strikeouts for MIL: 1432
✅ Found stolenBases for MIL: 78
✅ Found homeRuns for MIL: 168
✅ Found strikeouts for MIN: 1372
✅ Found stolenBases for MIN: 114
✅ Found homeRuns for MIN: 191
✅ Found avg for MIN: .238
✅ Found strikeouts for MIN: 1372
✅ Found stolenBases for MIN: 134
✅ Found homeRuns for MIN: 194
✅ Found strikeouts for NYM: 1325
✅ Found stolenBases for NYM: 147
✅ Found homeRuns for NYM: 224
✅ Found avg for NYM: .249
✅ Found strikeouts for NYM: 1387
✅ Found stolenBases for NYM: 80
✅ Found homeRuns for NYM: 149
✅ Found strikeouts for NYY: 1463
✅ Found stolenBases for NYY: 134
✅ Found homeRuns for NYY: 274
✅ Found avg for NYY: .251
✅ Found strikeouts for NYY: 1440
✅ Found stolenBases for NYY: 102
✅ Found homeRuns for NYY: 175
✅ Found strikeouts for PHI: 1337
✅ Found stolenBases for PHI: 124
✅ Found homeRuns for PHI: 212
✅ Found avg for PHI: .258
✅ Found strikeouts for PHI: 1471
✅ Found stolenBases for PHI: 99
✅ Found homeRuns for PHI: 177
✅ Found strikeouts for PIT: 1422
✅ Found stolenBases for PIT: 115
✅ Found homeRuns for PIT: 117
✅ Found avg for PIT: .231
✅ Found strikeouts for PIT: 1314
✅ Found stolenBases for PIT: 105
✅ Found homeRuns for PIT: 153
✅ Found strikeouts for SD: 1161
✅ Found stolenBases for SD: 106
✅ Found homeRuns for SD: 152
✅ Found avg for SD: .252
✅ Found strikeouts for SD: 1425
✅ Found stolenBases for SD: 106
✅ Found homeRuns for SD: 178
✅ Found strikeouts for SF: 1380
✅ Found stolenBases for SF: 68
✅ Found homeRuns for SF: 173
✅ Found avg for SF: .235
✅ Found strikeouts for SF: 1358
✅ Found stolenBases for SF: 92
✅ Found homeRuns for SF: 143
✅ Found strikeouts for SEA: 1446
✅ Found stolenBases for SEA: 161
✅ Found homeRuns for SEA: 238
✅ Found avg for SEA: .244
✅ Found strikeouts for SEA: 1426
✅ Found stolenBases for SEA: 116
✅ Found homeRuns for SEA: 192
✅ Found strikeouts for STL: 1321
✅ Found stolenBases for STL: 89
✅ Found homeRuns for STL: 148
✅ Found avg for STL: .245
✅ Found strikeouts for STL: 1209
✅ Found stolenBases for STL: 121
✅ Found homeRuns for STL: 170
✅ Found strikeouts for TB: 1397
✅ Found stolenBases for TB: 194
✅ Found homeRuns for TB: 182
✅ Found avg for TB: .251
✅ Found strikeouts for TB: 1416
✅ Found stolenBases for TB: 152
✅ Found homeRuns for TB: 205
✅ Found strikeouts for TEX: 1327
✅ Found stolenBases for TEX: 134
✅ Found homeRuns for TEX: 175
✅ Found avg for TEX: .234
✅ Found strikeouts for TEX: 1344
✅ Found stolenBases for TEX: 127
✅ Found homeRuns for TEX: 172
✅ Found strikeouts for TOR: 1099
✅ Found stolenBases for TOR: 77
✅ Found homeRuns for TOR: 191
✅ Found avg for TOR: .265
✅ Found strikeouts for TOR: 1430
✅ Found stolenBases for TOR: 110
✅ Found homeRuns for TOR: 209
✅ Found strikeouts for WSH: 1351
✅ Found stolenBases for WSH: 132
✅ Found homeRuns for WSH: 161
✅ Found avg for WSH: .242
✅ Found strikeouts for WSH: 1248
✅ Found stolenBases for WSH: 107
✅ Found homeRuns for WSH: 214
✅ Found strikeouts for ATH: 1406
✅ Found stolenBases for ATH: 80
✅ Found homeRuns for ATH: 219
✅ Found avg for ATH: .253
✅ Found strikeouts for ATH: 1323
✅ Found stolenBases for ATH: 131
✅ Found homeRuns for ATH: 222
Debug: All stat names found across all teams:
BIPA
ERA
GIDPs
MLBRating
OPS
RBIs
WARBR
WHIP
assists
atBats
atBatsPerHomeRun
avg
avgGameScore
balks
ballsInZone
batterRating
battersFaced
battersHit
blownSaves
catcherCaughtStealing
catcherCaughtStealingPct
catcherERA
catcherEarnedRuns
catcherInterference
catcherStolenBasesAllowed
catcherThirdInningsPlayed
caughtStealing
caughtStealingPct
cheapWins
completeGames
defWARBR
doublePlays
doubles
earnedRuns
errors
extraBaseHits
extraBases
fieldingPct
finishes
flyBalls
fullInnings
fullInningsPlayed
gameWinningRBIs
gamesPlayed
gamesStarted
grandSlamHomeRuns
groundBalls
groundToFlyRatio
hitByPitch
hits
holds
homeRuns
inheritedRunners
inheritedRunnersScored
innings
intentionalWalks
isQualified
isQualifiedCatcher
isQualifiedPitcher
isQualifiedSaves
isQualifiedSteals
isolatedPower
losses
offWARBR
onBasePct
opponentAvg
opponentOPS
opponentOnBasePct
opponentSlugAvg
opponentTotalBases
opportunities
outfieldAssists
outsMade
outsOnField
partInnings
partInningsPlayed
passedBalls
patienceRatio
perfectGames
pickoffAttempts
pickoffs
pinchAtBats
pinchAvg
pinchHits
pitchCount
pitches
pitchesAsStarter
pitchesPerInning
pitchesPerPlateAppearance
pitchesPerStart
plateAppearances
playerRating
projectedHomeRuns
putouts
qualityStarts
rangeFactor
runSupport
runSupportAvg
runnersLeftOnBase
runs
runsCreated
runsCreatedPer27Outs
runsProduced
runsRatio
sacBunts
sacFlies
sacHits
saveOpportunities
saveOpportunitiesPerWin
savePct
saves
secondaryAvg
secondaryAvgMinusBA
shutouts
slugAvg
stolenBasePct
stolenBases
strikePitchRatio
strikeoutToWalkRatio
strikeouts
strikeoutsPerNineInnings
strikes
successfulChances
teamEarnedRuns
teamGamesPlayed
thirdInnings
totalBases
totalChances
toughLosses
triplePlays
triples
walkToStrikeoutRatio
walks
walksPerPlateAppearance
wildPitches
winPct
wins
zoneRating
Debug: Data collected per stat type:
battingAverage: 30 entries
homeRuns: 60 entries
stolenBases: 60 entries
strikeouts: 60 entries
Database Update Results:
⚠️ No rows updated: Rank 1 for Batting Average - TOR (check if row exists)
⚠️ No rows updated: Rank 2 for Batting Average - PHI (check if row exists)
⚠️ No rows updated: Rank 3 for Batting Average - MIL (check if row exists)
⚠️ No rows updated: Rank 4 for Batting Average - BOS (check if row exists)
⚠️ No rows updated: Rank 5 for Batting Average - ATH (check if row exists)
⚠️ No rows updated: Rank 1 for Home Runs - NYY (check if row exists)
⚠️ No rows updated: Rank 2 for Home Runs - COL (check if row exists)
⚠️ No rows updated: Rank 3 for Home Runs - LAD (check if row exists)
⚠️ No rows updated: Rank 4 for Home Runs - SEA (check if row exists)
⚠️ No rows updated: Rank 5 for Home Runs - LAA (check if row exists)
⚠️ No rows updated: Rank 1 for Stolen Bases - TB (check if row exists)
⚠️ No rows updated: Rank 2 for Stolen Bases - MIA (check if row exists)
⚠️ No rows updated: Rank 3 for Stolen Bases - MIL (check if row exists)
⚠️ No rows updated: Rank 4 for Stolen Bases - CHC (check if row exists)
⚠️ No rows updated: Rank 5 for Stolen Bases - SEA (check if row exists)
⚠️ No rows updated: Rank 1 for Strikeouts - COL (check if row exists)
⚠️ No rows updated: Rank 2 for Strikeouts - KC (check if row exists)
⚠️ No rows updated: Rank 3 for Strikeouts - TOR (check if row exists)
⚠️ No rows updated: Rank 4 for Strikeouts - SD (check if row exists)
⚠️ No rows updated: Rank 5 for Strikeouts - STL (check if row exists)
Top 5 Teams per Category:
| Rank |
League |
Category |
Team |
Value |
Updated |
| 1 |
MLB |
Batting Average |
TOR - BLUE JAYS |
.265 |
✅ |
| 2 |
MLB |
Batting Average |
PHI - PHILLIES |
.258 |
✅ |
| 3 |
MLB |
Batting Average |
MIL - BREWERS |
.258 |
✅ |
| 4 |
MLB |
Batting Average |
BOS - RED SOX |
.254 |
✅ |
| 5 |
MLB |
Batting Average |
ATH - ATHLETICS |
.253 |
❌ |
| 1 |
MLB |
Home Runs |
NYY - YANKEES |
274 |
✅ |
| 2 |
MLB |
Home Runs |
COL - ROCKIES |
251 |
✅ |
| 3 |
MLB |
Home Runs |
LAD - DODGERS |
244 |
✅ |
| 4 |
MLB |
Home Runs |
SEA - MARINERS |
238 |
✅ |
| 5 |
MLB |
Home Runs |
LAA - ANGELS |
226 |
❌ |
| 1 |
MLB |
Stolen Bases |
TB - RAYS |
194 |
✅ |
| 2 |
MLB |
Stolen Bases |
MIA - MARLINS |
191 |
✅ |
| 3 |
MLB |
Stolen Bases |
MIL - BREWERS |
164 |
✅ |
| 4 |
MLB |
Stolen Bases |
CHC - CUBS |
161 |
✅ |
| 5 |
MLB |
Stolen Bases |
SEA - MARINERS |
161 |
❌ |
| 1 |
MLB |
Strikeouts |
COL - ROCKIES |
1093 |
✅ |
| 2 |
MLB |
Strikeouts |
KC - ROYALS |
1096 |
✅ |
| 3 |
MLB |
Strikeouts |
TOR - BLUE JAYS |
1099 |
✅ |
| 4 |
MLB |
Strikeouts |
SD - PADRES |
1161 |
✅ |
| 5 |
MLB |
Strikeouts |
STL - CARDINALS |
1209 |
❌ |