MLB Data Dictionary

Main

mlb.seasons7 fieldsendpoints →

Each MLB season — spring training, the 162-game regular season, the Wild Card Series, the Division Series, the League Championship Series, and the World Series.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
league_idstringnullableOfficial MLB season identifier
end_datetimestamptznullable2018-10-28T00:00:00.000Z
post_season_start_datetimestamptznullable2018-10-02T00:00:00.000Z
regular_season_start_datetimestamptznullable2018-03-29T00:00:00.000Z
start_datetimestamptz2018-03-29T00:00:00.000Z
start_yearinteger2018
mlb.teams11 fields· 2 refsendpoints →

The 30 MLB franchises, organized into the American and National Leagues with three divisions in each.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
league_team_idintegernullablemlb.teams108Official MLB team ID from statsapi.mlb.com
venue_idbigintnullablemlb.venues2
abbreviationstringLAA
activebooleantrue
citystringLos Angeles
divisionstringWest
ValuesWestEastCentral
full_namestringLos Angeles Angels
leaguestringAmerican League
ValuesAmerican LeagueNational League
logo_urlstringnullableURL to team logo image
namestringAngels
mlb.games31 fields· 5 refsendpoints →

Every scheduled and played MLB game — spring training exhibitions, the 162-game regular season, the Wild Card Series, the Division and Championship Series, and the World Series.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
away_team_idbigintmlb.teams38
home_team_idbigintmlb.teams33
league_game_idintegernullablemlb.games745080Official MLB gamePk from statsapi.mlb.com
league_idstringnullableOfficial MLB game identifier
losing_pitcher_idbigintnullable1177Losing pitcher of record
save_pitcher_idbigintnullable1415Save pitcher (if any)
season_idbigintmlb.seasons2025
venue_idbigintnullablemlb.venues16
winning_pitcher_idbigintnullable272Winning pitcher of record
attendanceintegernullable
away_team_scoreinteger3
channelstringnullableMLBN (out-of-market only)
dayinteger20180317
day_nightstringnullableD=Day, N=Night
doubleheaderbooleanfalse
Valuesfalsetrue
duration_minutesintegernullableTotal game duration in minutes
end_timetimestamptznullable
game_labelstringnullableRegular Season Game 1
game_numberinteger1For doubleheaders: 1 or 2
game_timetimestamptz2018-03-17T17:05:00.000ZCanonical game start time (use this over start_time)
game_typestringRR=Regular, S=Spring, F=Wild Card, D=Division, L=League, W=World Series, E=Exhibition, A=All-Star
ValuesRSDFLW
home_team_scoreinteger4
if_necessarybooleannullablefalse
neutral_venuebooleanfalse
postponed_statusstringnullable
season_typestringregular_seasonCanonical season phase. Postseason round detail (Wild Card/Division/LCS/World Series) is in the league-native `game_type` code.
Valuesregular_seasonspring_trainingpostseason
series_game_numberstringnullable1
series_namestringnullableRegular Season
ValuesRegular SeasonSpring TrainingNL Division SeriesAL Division SeriesAL Championship SeriesWorld SeriesAL Wild Card SeriesNL Wild Card SeriesNL Championship Series
series_textstringnullable1-0
Values1-02-12-01-13-03-12-24-00-03-23-34-34-15-04-2
statusstringFinalFinal, Live, Scheduled, Postponed, Suspended, Cancelled
ValuesFinalCompleted EarlyCancelled
mlb.players29 fields· 2 refsendpoints →

Every individual who has played in Major League Baseball — current 26-man and 40-man rosters, minor-league call-ups, players on the injured list, free agents, and retired players.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
league_idstringnullableOfficial MLB player identifier
league_player_idintegermlb.players613534Official MLB player ID from statsapi.mlb.com
team_idbigintnullablemlb.teams16
batsstringnullableR
ValuesRLS
birth_citystringnullableSanto Domingo
birth_countrystringnullableUSA
birth_datedatenullable1994-07-14T04:00:00.000Z
birth_statestringnullableCA
debut_datetimestamptznullable2023-03-30T00:00:00.000Z
display_fi_laststringnullableR. Rodríguez
display_last_comma_firststringnullableDavis, Jonathan
draft_numberstringnullable
draft_roundstringnullable
draft_yearstringnullable2019
first_namestringRyan
full_namestringLuis Ortiz
full_position_liststringnullablePitcher
ValuesPitcherOutfielderCatcherSecond BaseThird BaseFirst BaseShortstopOutfieldDesignated HitterInfieldTwo-Way Player
heightintegernullable74
jerseystringnullable52
last_namestringRodriguez
league_slugstringnullableaustin-adams-613534
position_categorystringnullablePitcher
ValuesPitcherInfielderOutfielderCatcherUtility
primary_positionstringP
profile_pic_urlstringnullableURL to player profile picture image
roster_statusstringnullableActiveCanonical roster status, shared across leagues. Derived from team_player_rosters: "active" (26-man), "non_roster" (on the 40-man but optioned), "injured_reserve" (IL); "inactive"/"free_agent" off-roster. The "on a team now" set is {active, injured_reserve, non_roster}.
ValuesActiveInactive
schoolstringnullable
throwsstringnullableR
ValuesRLS
weightintegernullable215

Plays

mlb.innings10 fields· 1 refsendpoints →

Each half-inning of every MLB game — runs scored, hits, errors, base traffic, plate appearances, who pitched, and how the offense ended each frame.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games357
away_team_errorsinteger0
away_team_hitsinteger0
away_team_runsinteger0
home_team_errorsinteger0
home_team_hitsinteger0
home_team_runsinteger0
inning_halfstringTOP
ValuesTOPBOTTOM
inning_numberinteger1
mlb.pitches72 fields· 1 refsendpoints →

Every individual pitch thrown in every MLB game — the pitch type, velocity, location, movement, spin, and the result (called strike, swinging strike, foul, ball, hit, walk).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
at_bat_idbigint1494
batter_idbigint306
game_idbigintmlb.games84
pitcher_idbigint267
play_idbigint12
air_outbooleanfalseWhether this pitch resulted in an air out
ballbooleanfalse
Valuesfalsetrue
barrelbooleannullablefalseOptimal combination of exit velocity and launch angle
Valuesfalsetrue
break_anglefloatnullable1.2
break_lengthfloatnullable3.6
break_yfloatnullable24
breaking_ballbooleannullablefalseBreaking ball (curveball, slider, knuckleball)
Valuesfalsetrue
callstringBall
ValuesBallFoulCalled StrikeIn play, out(s)Swinging StrikeIn play, no outIn play, run(s)Ball In DirtFoul TipSwinging Strike (Blocked)Hit By PitchFoul BuntPitchoutMissed Bunt
catchers_interferencebooleanfalseWhether this pitch resulted in catchers interference
chasebooleannullabletrueWhether batter swung at pitch outside zone
doublebooleanfalseWhether this pitch resulted in a double
Valuesfalsetrue
effective_speedfloatnullable85.3Perceived speed to batter (mph)
expected_batting_avgdecimalnullablexBA based on exit velocity and launch angle
expected_wobadecimalnullablexwOBA based on exit velocity and launch angle
extensionfloatnullable7.015639833312882
fastballbooleannullabletrueFastball variant (4-seam, 2-seam, sinker, cutter)
Valuestruefalse
flare_burnerbooleannullablefalseLaunch angle 10-25 AND exit velocity < 95
Valuesfalsetrue
fly_outbooleanfalseWhether this pitch resulted in a fly out
Valuesfalsetrue
ground_into_double_playbooleanfalseWhether this pitch resulted in grounding into double play
ground_into_triple_playbooleanfalseWhether this pitch resulted in grounding into triple play
ground_outbooleanfalseWhether this pitch resulted in a ground out
Valuesfalsetrue
hard_hitbooleannullablefalseExit velocity >= 95 MPH
Valuesfalsetrue
hit_by_pitchbooleanfalseWhether this pitch resulted in hit by pitch
Valuesfalsetrue
hit_coord_xfloatnullable153.39Hit coordinate X (feet from home plate)
hit_coord_yfloatnullable167.3Hit coordinate Y (feet from home plate)
hit_distanceintegernullable4Distance of batted ball (feet)
hit_exit_velocityfloatnullable103.4Exit velocity of batted ball (mph)
hit_launch_anglefloatnullable5Launch angle of batted ball (degrees)
home_runbooleanfalseWhether this pitch resulted in a home run
Valuesfalsetrue
in_playbooleanfalse
Valuesfalsetrue
in_strike_zonebooleannullablefalseWhether pitch was in the strike zone
Valuesfalsetrue
intentional_walkbooleanfalseWhether this pitch resulted in an intentional walk
launch_speed_angle_zoneintegernullable31=Weak, 2=Topped, 3=Under, 4=Flare/Burner, 5=Solid, 6=Barrel
line_outbooleanfalseWhether this pitch resulted in a line out
Valuesfalsetrue
offspeedbooleannullablefalseOffspeed pitch (changeup, splitter, forkball)
Valuesfalsetrue
pitch_numberinteger1
pitch_speedfloatnullable92.6
pitch_typestringnullableFF
ValuesFFSISLCHFCSTCUFSKCSVFA
pitch_xfloatnullable0.36271081581727094
pitch_yfloatnullable155.85
pitch_zfloatnullable3.5469804155056193
pitch_zoneintegernullable14
plate_xfloatnullable125.18
plate_zfloatnullable155.85
pop_outbooleanfalseWhether this pitch resulted in a pop out
Valuesfalsetrue
release_speedfloatnullable92.6Speed at release point (mph)
resultstringBall
ValuesBallFoulCalled StrikeIn play, out(s)Swinging StrikeIn play, no outIn play, run(s)Ball In DirtFoul TipSwinging Strike (Blocked)Hit By PitchFoul BuntPitchoutMissed Bunt
sacrifice_flybooleanfalseWhether this pitch resulted in a sacrifice fly
Valuesfalsetrue
sacrifice_hitbooleanfalseWhether this pitch resulted in a sacrifice bunt
Valuesfalsetrue
singlebooleanfalseWhether this pitch resulted in a single
Valuesfalsetrue
solid_contactbooleannullablefalseLaunch angle 20-25 AND exit velocity 95-100
Valuesfalsetrue
spin_axisfloatnullableSpin axis (degrees)
spin_directionfloatnullable211
spin_ratefloatnullable2190
spray_anglefloatnullable-6.1Horizontal angle from center field (degrees)
statcast_quality_scoredecimalnullableStatcast data quality score (0.0-1.0)
strikebooleanfalse
Valuesfalsetrue
strike_zone_bottomfloatnullable1.63
strike_zone_topfloatnullable3.51
strikeoutbooleanfalseWhether this pitch resulted in a strikeout
Valuesfalsetrue
sweet_spotbooleannullablefalseLaunch angle between 8-32 degrees
Valuesfalsetrue
toppedbooleannullablefalseLaunch angle < 10 AND exit velocity < 90
Valuesfalsetrue
tracking_confidencedecimalnullableConfidence in tracking data accuracy
triplebooleanfalseWhether this pitch resulted in a triple
Valuesfalsetrue
underbooleannullablefalseLaunch angle less than 10 degrees
Valuesfalsetrue
walkbooleanfalseWhether this pitch resulted in a walk
Valuesfalsetrue
mlb.at_bats35 fields· 2 refsendpoints →

Every plate appearance in every MLB game — the batter, the pitcher, the count, the pitch sequence, and the outcome (single, double, home run, strikeout, walk, hit-by-pitch, etc.).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
batter_idbigint996
game_idbigintmlb.games69
inning_idbigintmlb.innings908
pitcher_idbigint174
at_bat_numberinteger0
ballsinteger0
end_outsinteger2
end_runnersinteger0
expected_batting_avgdecimalnullable0.0050
expected_wobadecimalnullable0.0000
hit_coord_xfloatnullable104.05
hit_coord_yfloatnullable149.88
hit_distanceintegernullable4
hit_exit_velocityfloatnullable98.4
hit_launch_anglefloatnullable5
hit_locationstringnullableground_ball
Valuesground_ballfly_ballline_drivepopupbunt_grounderbunt_popup
hit_typestringnullableground_ball
Valuesground_ballfly_ballline_drivepopupbunt_grounderbunt_popup
is_barrelbooleannullablefalse
Valuesfalsetrue
is_flare_burnerbooleannullablefalseLaunch angle 10-25 AND exit velocity < 95
Valuesfalsetrue
is_hard_hitbooleannullablefalse
Valuesfalsetrue
is_solid_contactbooleannullablefalseLaunch angle 20-25 AND exit velocity 95-100
Valuesfalsetrue
is_sweet_spotbooleannullablefalseLaunch angle between 8-32 degrees
Valuesfalsetrue
is_toppedbooleannullablefalseLaunch angle < 10 AND exit velocity < 90
Valuesfalsetrue
is_underbooleannullablefalseLaunch angle less than 10 degrees
Valuesfalsetrue
launch_speed_angle_zoneintegernullable3
pitch_countinteger4
resultstringStrikeout
runs_scoredinteger0
spray_anglefloatnullable-6Horizontal angle from center field (degrees)
start_outsinteger1
start_runnersinteger0
statcast_quality_scoredecimalnullable1.0000Statcast data quality score (0.0-1.0)
strikesinteger2
tracking_confidencedecimalnullableConfidence in tracking data accuracy
mlb.play_by_plays22 fields· 4 refsendpoints →

Every individual play of every MLB game — every plate appearance, baserunning event, defensive play, and substitution with the inning, outs, base state, and score at the moment.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
at_bat_idbigintnullable1
batter_idbigintnullable996
catcher_idbigintnullable
first_base_runner_idbigintnullable996
game_idbigintmlb.games69
inning_idbigintmlb.innings908
pitcher_idbigintnullable174
play_idbigint0
player_idbigintnullablemlb.players996
second_base_runner_idbigintnullable996
team_idbigintmlb.teams19
third_base_runner_idbigintnullable996
count_ballsinteger0
count_strikesinteger2
event_sub_typeinteger0
event_typeinteger8
hit_locationstringnullableground_ball
Valuesground_ballfly_ballline_drivepopupbunt_grounderbunt_popup
hit_typestringnullableground_ball
Valuesground_ballfly_ballline_drivepopupbunt_grounderbunt_popup
mlb_event_numinteger0
outsinteger1
runners_on_baseinteger0

Stats

mlb.park_factors18 fields· 2 refsendpoints →

How each MLB ballpark inflates or suppresses run-scoring categories — runs, home runs, doubles, triples, and batting average relative to a neutral park, computed per season.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
season_idbigintmlb.seasons2024
venue_idbigintmlb.venues12
basic_park_factordecimal1.2200Overall park factor for runs (1.0 = neutral)
double_factordecimal1.2600Park factor for doubles
fly_ball_factordecimalnullablePark factor for fly balls
ground_ball_factordecimalnullablePark factor for ground balls
handedness_factordecimal1.1600Park effect on handedness advantage
home_run_factordecimal1.3300Park factor for home runs (1.0 = neutral)
left_handed_factordecimal1.1400Park factor for left-handed batters
right_handed_factordecimal1.1800Park factor for right-handed batters
run_factordecimalnullablePark factor for total runs
single_factordecimal1.1100Park factor for singles
strikeout_factordecimal0.8900Park factor for strikeouts
triple_factordecimal1.4200Park factor for triples
updated_datetimestamptz2026-04-12T02:04:46.363Z
walk_factordecimal1.0100Park factor for walks
years_of_datainteger3Number of years used to calculate factors
mlb.season_run_environments10 fields· 1 refsendpoints →

League-wide offensive context per MLB season — average runs per game, league batting line, ERA, and the offensive baseline used to normalize player and team stats across eras.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
season_idbigintmlb.seasons2021
batting_average_on_balls_in_playdecimal0.2930League average BABIP
fip_constantdecimal3.1340FIP constant to scale FIP to ERA
home_run_per_fly_balldecimal0.1390League average HR/FB rate
runs_per_outdecimal0.2810League average runs per out made
runs_per_plate_appearancedecimal0.1250League average runs per plate appearance
strikeout_ratedecimal0.2440League average strikeout rate
updated_datetimestamptz2026-04-12T02:04:46.337Z
walk_ratedecimal0.0890League average walk rate
mlb.woba_weights12 fields· 1 refsendpoints →

The weighted on-base average coefficients for each MLB season — the run values assigned to walks, singles, doubles, triples, and home runs, used to compute wOBA and wRC+.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
season_idbigintmlb.seasons2021
double_weightdecimal1.2710Weight for doubles (w2B)
hit_by_pitch_weightdecimal0.7230Weight for hit by pitch (wHBP)
home_run_weightdecimal2.1010Weight for home runs (wHR)
league_obpdecimal0.3180League average OBP for calibration
league_wobadecimal0.3180League average wOBA for the season
single_weightdecimal0.8950Weight for singles (w1B)
triple_weightdecimal1.5520Weight for triples (w3B)
updated_datetimestamptz2026-04-12T02:04:46.328ZWhen these weights were last updated
walk_weightdecimal0.6920Weight for unintentional walks (wBB)
woba_scaledecimal1.2160Scale factor to convert wOBA to runs
mlb.operator_team_lookups6 fields· 3 refsendpoints →

How each sportsbook and fantasy operator names every MLB team — the mapping from each operator's team code to the unified franchise record.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
operator_idbigintmain.operatorsOperator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_team_idstringmlb.teamsExternal team ID from operator
team_idbigintmlb.teamsInternal mlb.teams.id reference
abbreviationstringnullableTeam abbreviation for reconciliation
team_namestringnullableTeam name for reconciliation
mlb.season_team_stats36 fields· 2 refsendpoints →

Season totals for each MLB team — wins and losses, runs scored and allowed, batting and pitching aggregates, fielding stats, and advanced team metrics (BaseRuns, pythagorean expectation, run differential).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
season_idbigintmlb.seasons2024
team_idbigintmlb.teams16
at_batsinteger5522
batting_averagedecimal0.2440
blown_savesinteger28
caught_stealinginteger30
complete_gamesinteger0
double_playsinteger125
doublesinteger264
earned_run_averagedecimal3.7800
earned_runsinteger596
errorsinteger97
fielding_percentagedecimal0.9860
games_playedinteger162
hitsinteger1423
holdsinteger83
home_runsinteger182
innings_pitcheddecimal1442.0000Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
lossesinteger72
on_base_percentagedecimal0.3150
on_base_plus_sluggingdecimal0.7070
runs_allowedinteger699
runs_batted_ininteger655
runs_scoredinteger769
save_opportunitiesinteger64
savesinteger40
shutoutsinteger8
slugging_percentagedecimal0.3910
stolen_basesinteger88
strikeoutsinteger1461
tiesinteger0
triplesinteger18
walksinteger478
whipdecimal1.2400
winsinteger90
mlb.game_player_batter_stats42 fields· 3 refsendpoints →

Each batter's box-score stat line for each MLB game — at-bats, hits, doubles, triples, home runs, RBIs, walks, strikeouts, stolen bases, and runs scored.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games64
player_idbigintmlb.players604
team_idbigintmlb.teams41
air_outsinteger0
at_batsinteger3
at_bats_per_home_rundecimal0.0000
babipdecimal0.0000
balls_in_playinteger0
batting_averagedecimal0.0000
catchers_interferenceinteger0
caught_stealinginteger0
double_playsinteger0
doublesinteger0
fly_outsinteger0
ground_into_double_playinteger0
ground_into_triple_playinteger0
ground_outsinteger0
hit_by_pitchinteger0
hitsinteger0
home_runsinteger0
intentional_walksinteger0
isolated_powerdecimal0.0000
left_on_baseinteger0
line_outsinteger0
on_base_percentagedecimal0.0000
on_base_plus_sluggingdecimal0.0000
pickoffsinteger0
plate_appearancesinteger4
pop_outsinteger0
runsinteger0
runs_batted_ininteger0
sacrifice_fliesinteger0
sacrificesinteger0
singlesinteger0
slugging_percentagedecimal0.0000
stolen_basesinteger0
strikeoutsinteger0
total_basesinteger0
triplesinteger0
walksinteger0
wobadecimal0.0000
mlb.game_player_pitching_stats68 fields· 3 refsendpoints →

Each pitcher's box-score stat line for each MLB game — innings pitched, hits and runs allowed, earned runs, walks, strikeouts, home runs allowed, and pitches thrown.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games64
player_idbigintmlb.players1382
team_idbigintmlb.teams33
air_outsinteger0
babipdecimal0.0000
balksinteger0
ballsinteger0
balls_in_playinteger0
batters_facedinteger3
blown_saveinteger0
catchers_interferenceinteger0
complete_gamesinteger0
double_playsinteger0
doubles_allowedinteger0
earned_run_averagedecimal0.0000
earned_runsinteger0
fipdecimal3.1000
fly_outsinteger0
games_finishedinteger0
games_pitchedinteger1
games_startedinteger0
grand_slams_allowedinteger0
ground_into_double_playinteger0
ground_outsinteger0
hit_by_pitchinteger0
hits_allowedinteger0
holdinteger0
home_runs_allowedinteger0
home_runs_per_ninedecimal0.0000
inherited_runnersinteger0
inherited_runners_scoredinteger0
inning_startedinteger0
innings_pitcheddecimal1.0000Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
intentional_walksinteger0
left_on_basedecimal0.0000
line_outsinteger0
lossinteger0
no_hittersinteger0
on_base_percentagedecimal0.0000
on_base_plus_sluggingdecimal0.0000
outsinteger3
perfect_gamesinteger0
pickoffsinteger0
pitches_throwninteger0
plate_appearancesinteger0
pop_outsinteger0
quality_startsinteger0
runs_allowedinteger0
runs_scored_per_ninedecimal0.0000
sacrifice_flies_allowedinteger0
sacrifices_allowedinteger0
saveinteger0
shutoutsinteger0
singles_allowedinteger0
slugging_percentagedecimal0.0000
strike_percentagedecimal0.0000
strikeouts_per_ninedecimal0.0000
strikeouts_pitchedinteger0
strikesinteger0
total_bases_allowedinteger0
triples_allowedinteger0
walks_allowedinteger0
walks_per_ninedecimal0.0000
whipdecimal0.0000
wild_pitchesinteger0
wininteger0
wobadecimal0.0000
mlb.game_team_stats37 fields· 2 refsendpoints →

Each MLB team's stat line for each game — runs, hits, errors, batting averages, pitching lines, broken out per game with home/away context.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games1454
team_idbigintmlb.teams27
assistsinteger9
balksinteger0
batters_facedinteger36
batting_averagedecimal0.2440
caught_stealinginteger0
double_plays_turnedinteger0
doublesinteger1
earned_run_averagedecimal3.7700
earned_runsinteger2
errorsinteger0
grounded_into_double_playinteger0
hit_by_pitchinteger0
hitsinteger7
home_runsinteger1
innings_pitcheddecimal9.0000Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
left_on_baseinteger6
lossinteger0
on_base_percentagedecimal0.3150
on_base_plus_sluggingdecimal0.7240
passed_ballsinteger0
pitches_throwninteger143
putoutsinteger27
runsinteger3
runs_batted_ininteger2
sacrifice_fliesinteger0
sacrifice_hitsinteger0
slugging_percentagedecimal0.4070
stolen_basesinteger0
strikeoutsinteger8
strikesinteger93
triplesinteger0
walksinteger2
wild_pitchesinteger0
wininteger0
mlb.operator_player_lookups6 fields· 3 refsendpoints →

How each sportsbook and fantasy operator names every MLB player — the mapping from each operator's player identifier to a unified player record.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
operator_idbigintmain.operators2240Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_player_idstringmlb.players671096External player ID from operator
player_idbigintmlb.players1589Internal mlb.players.id reference
player_namestringnullableMax MuncyPlayer name for reconciliation
positionstringnullablePPosition for reconciliation
ValuesPCLF2BSSRFCF3B1BSPRPDHOFTWP
mlb.season_player_stats69 fields· 2 refsendpoints →

Season totals for each MLB player — the full batting line (AVG, OBP, SLG, OPS), counting stats (HR, RBI, SB, R), and pitching line (W, L, ERA, WHIP, K, BB). Advanced run-value metrics (wRC+, FIP, WAR) are not carried here. Scope is not split by season type.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
player_idbigintmlb.players1439
season_idbigintmlb.seasons2024
assistsinteger0
at_batsinteger0
ballsintegernullable0
batters_facedinteger0
batting_averagedecimal0.0000
blown_savesinteger0
caught_stealinginteger0
caught_stealing_byinteger0
complete_gamesinteger0
double_playsinteger0
doublesinteger0
earned_run_averagedecimal0.0000
earned_runsinteger0
errorsinteger0
fielding_gamesinteger0
fielding_games_startedinteger0
fielding_percentagedecimal0.0000
fielding_positionstringP
ValuesPC2BLFRFCF3B1BSSXDH
games_pitchedinteger0
games_playedinteger0
games_startedinteger0
games_started_pitchinginteger0
grounded_into_double_playinteger0
hit_by_pitchinteger0
hitsinteger0
hits_allowedinteger0
hits_per_ninedecimal0.0000
holdsinteger0
home_runsinteger0
home_runs_allowedinteger0
home_runs_per_ninedecimal0.0000
innings_pitcheddecimal0.0000Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
intentional_walksintegernullable0
left_on_baseintegernullable0
lossesinteger0
on_base_percentagedecimal0.0000
on_base_plus_sluggingdecimal0.0000
passed_ballsinteger0
pitches_thrownintegernullable0
plate_appearancesinteger0
putoutsinteger0
quality_startsintegernullable0
runsinteger0
runs_allowedinteger0
runs_batted_ininteger0
sacrifice_fliesinteger0
sacrifice_hitsinteger0
save_opportunitiesinteger0
savesinteger0
shutoutsinteger0
singlesintegernullable0Derivable from hits - doubles - triples - home_runs
slugging_percentagedecimal0.0000
stolen_basesinteger0
stolen_bases_allowedinteger0
strikeoutsinteger0
strikeouts_per_ninedecimal0.0000
strikeouts_pitchedinteger0
strikesintegernullable0
total_basesintegernullable0Derivable: 1B + 2*2B + 3*3B + 4*HR
total_chancesinteger0
triplesinteger0
walksinteger0
walks_allowedinteger0
walks_per_ninedecimal0.0000
whipdecimal0.0000
winsinteger0

Odds

mlb.series_odds11 fields· 4 refsendpoints →

Series-level odds for postseason MLB matchups — who wins each series and how many games it goes, with the price updating game by game as the series unfolds. MLB playoff series are best-of-5 (LDS/WC) or best-of-7 (LCS/WS).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
away_team_idbigintmlb.teams
home_team_idbigintmlb.teams
operator_idbigintmain.operators
season_idbigintmlb.seasons
away_oddsintegerAmerican odds for away team to win series
captured_attimestamptz
games_playedintegernullable
home_oddsintegerAmerican odds for home team to win series
series_namestringALDS, NLDS, ALCS, NLCS, World Series, Wild Card
series_scorestringnullableCurrent series score (e.g., "3-2" home-away)
mlb.game_alt_lines6 fields· 2 refsendpoints →

Alternate MLB game lines — the full ladder of run-line and total offerings at non-standard prices that sportsbooks publish alongside the headline line.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games
operator_idbigintmain.operators
alt_spreadsjsonbnullableArray of {line, home_odds, away_odds}
alt_totalsjsonbnullableArray of {line, over_odds, under_odds}
captured_attimestamptz
mlb.game_lines18 fields· 3 refsendpoints →

MLB game betting lines — moneylines, run lines (the baseball point-spread equivalent), and over/under totals from sportsbooks, captured over time as the lines move from opening to closing. In MLB, spread = run line (typically +/- 1.5).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games162977
operator_idbigintmain.operators6Data source (consensus, DraftKings, FanDuel, etc.)
season_idbigintmlb.seasons2026Denormalized for efficient season-level queries
captured_attimestamptz2026-06-21T16:09:37.291ZWhen this snapshot was captured
implied_away_scoredecimalnullable5.0000
implied_away_win_pctdecimalnullable0.4785
implied_home_scoredecimalnullable3.5000Calculated from spread + total
implied_home_win_pctdecimalnullable0.5122From moneyline, 0-1
is_openingbooleanfalseTrue if this is the opening line
Valuesfalsetrue
moneyline_awayintegernullable109American odds for away team win
moneyline_homeintegernullable-105American odds for home team win
over_oddsintegernullable-110American odds for over
spreaddecimalnullable1.5000Home team run line (e.g., -1.5 means home favored by 1.5 runs)
spread_away_oddsintegernullable-110American odds for away run line
spread_home_oddsintegernullable-110American odds for home run line (e.g., -130)
totaldecimalnullable8.5000Combined run total line (e.g., 8.5)
under_oddsintegernullable-110American odds for under
mlb.game_period_lines17 fields· 3 refsendpoints →

Period-specific MLB betting lines — first-five-innings markets (F5), individual-inning bets, and other partial-game spreads, moneylines, and totals. Each row is a time-series snapshot - only captured when values change.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games
operator_idbigintmain.operatorsData source (consensus, DraftKings, FanDuel, etc.)
season_idbigintmlb.seasonsDenormalized for efficient season-level queries
captured_attimestamptz
implied_away_win_pctdecimalnullable
implied_home_win_pctdecimalnullable
is_openingboolean
moneyline_awayintegernullable
moneyline_homeintegernullable
over_oddsintegernullable
period_codestringMarket period code (F5 = first 5 innings, F3, F7)
spreaddecimalnullableHome team run line for this period
spread_away_oddsintegernullable
spread_home_oddsintegernullable
totaldecimalnullableCombined run total line for this period
under_oddsintegernullable
mlb.game_player_props18 fields· 4 refsendpoints →

MLB player prop bets for each game — hits, runs, RBIs, total bases, home runs, strikeouts (for pitchers), and other player-statistic markets offered by sportsbooks.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games
operator_idbigintmain.operators
player_idbigintmlb.players
season_idbigintmlb.seasonsDenormalized for efficient season-level queries
book_countintegerNumber of curated books contributing to this consensus value
captured_attimestamptz
categorystringCanonical category. Pitcher props: - strikeouts_pitcher, hits_allowed, walks_allowed, - earned_runs, outs_recorded, pitching_outs, win, quality_start Batter props: - hits, home_runs, rbis, total_bases, runs, walks, - stolen_bases, strikeouts_batter, hits_runs_rbis
is_openingboolean
linedecimalnullableProp line for over/under markets (e.g., 5.5 strikeouts)
market_keystringRaw market key from source API (e.g., pitcher_strikeouts)
no_oddsintegernullable
outcome_typestringou | yes_no
over_oddsintegernullable
period_codestringnullableOptional period code (F5)
subcategorystringnullableOptional subtype (alternate, boosted, etc.)
under_oddsintegernullable
yes_oddsintegernullable

Lineups & Roster

mlb.game_team_rosters10 fields· 3 refsendpoints →

The active gameday roster for each MLB team in each game — the 26 players in uniform that day, with positions and any pre-game lineup designations.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games14259
player_idbigintmlb.players1365
team_idbigintmlb.teams27
batting_orderintegernullable9
commentstringnullable
dayinteger20180929
positionstringnullableP
ValuesPC2BLF1BCF3BRFSSPHDHPR
starterbooleanfalse
Valuesfalsetrue
statusstringnullableActive
mlb.team_player_rosters9 fields· 3 refsendpoints →

Day-by-day player-to-team affiliations across the MLB season — who was on each 40-man roster, who was on the IL, who was optioned to the minors, and who was designated for assignment.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
player_idbigintmlb.players165
season_idbigintmlb.seasons2024
team_idbigintmlb.teams30
dayinteger172
positionstringnullableP
ValuesPCRF3BLF2B1BCFSSDHOFIFTWP
position_depthintegernullable1
position_groupstringnullablePitcher
ValuesPitcherInfielderOutfielderCatcherHitterTwo-Way Player
roster_typestring40Man
Values40ManactivefullSeason
mlb.team_starting_lineup_batters5 fields· 1 refsendpoints →

Each batter in each MLB starting lineup — position in the order (1 through 9), defensive position, and batting handedness for the day.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
player_idbigintmlb.players1040
team_starting_lineup_idbigint1
batting_orderstring1
positionstringSS
ValuesSS3BRF2BCF1BLFCDHPPHPR
mlb.team_starting_lineups6 fields· 2 refsendpoints →

Each MLB team's starting lineup for each game — the nine batters in batting order plus the starting pitcher (and DH where applicable).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games64
pitcher_idbigintnullable50028
team_idbigintmlb.teams27
batter_statusinteger1
pitcher_statusinteger1

Misc

mlb.venues21 fields· 1 refsendpoints →

MLB ballparks — current home stadiums and historical venues, with dimensions, surface, capacity, and roof type.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
league_venue_idintegernullablemlb.venues2523Official MLB venue ID from statsapi.mlb.com
addressstringnullable
capacityintegernullable14014
citystringWest Sacramento
closed_datetimestamptznullable
countrystringnullableUSA
ValuesUSACAN
descriptionstringnullable
elevationfloatnullable596Elevation in feet above sea level
hr_factordecimalnullableHistorical home run park factor (1.0 = neutral)
image_urlstringnullableURL to aerial/overview image of ballpark
latitudefloatnullable27.9778
longitudefloatnullable-82.5055
namestringSutter Health Park
opened_datetimestamptznullable2000-05-15T04:00:00.000Z
orientationfloatnullable45Field orientation in degrees (0-360). Direction home plate faces. 0/360=North, 90=East, 180=South, 270=West
roof_typestringnullableOpenOpen, Dome, Retractable
ValuesOpenRetractableClosed
statestringnullableCA
ValuesCAFLILOHTXMONYPAAZGAMDMACOMIWIMNWAONDC
surfacestringnullableGrass
ValuesGrassArtificial TurfNatural Grass
team_namestringnullableTampa Bay Rays
timezonestringnullableIANA timezone (e.g., America/New_York)
mlb.umpires11 fields· 1 refsendpoints →

MLB umpires — the four-person crew of home-plate, first-base, second-base, and third-base umpires who work each game (six in the postseason with outfield umpires added).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
mlb_umpire_idintegermlb.umpires427044
activebooleantrue
birth_citystringnullable
birth_countrystringnullable
birth_datedatenullable
birth_statestringnullable
experienceintegernullable
first_namestringMike
full_namestringCB Bucknor
last_namestringJimenez
mlb.venue_dimensions21 fields· 2 refsendpoints →

Outfield dimensions and wall heights for each MLB ballpark — distances to left field, center field, right field, and the power alleys, plus the height of the outfield walls.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
mlb_venue_idintegermlb.venues1
venue_idbigintmlb.venues2
altitude_ftfloatnullableVenue altitude in feet (denormalized from venue for query convenience)
backstop_distancefloatnullableDistance from home plate to backstop (feet)
center_fieldfloat400
center_field_fence_heightfloat8
descriptionstringnullable
fair_territory_sq_ftfloatnullable113800
foul_territory_ratingdecimalnullableRelative foul territory size (1.0 = average, >1 = large)
foul_territory_sq_ftfloatnullable21500
left_center_fieldfloatnullable385
left_fieldfloat330
left_field_fence_heightfloat8
orientationfloat45
right_center_fieldfloatnullable375
right_fieldfloat330
right_field_fence_heightfloat8
total_territory_sq_ftfloatnullable137000
venue_namestringnullableAngel Stadium
yearinteger2000
mlb.broadcasters12 fields· 2 refsendpoints →

Networks, regional sports networks, and streaming services that air MLB games — Apple TV+, ESPN, FOX, TBS, MLB Network, MLB.TV, plus team-local RSNs.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
broadcaster_idintegermlb.broadcasters
broadcaster_team_idintegermlb.teams
region_idinteger
broadcaster_abbreviationstring
broadcaster_descriptionstringnullable
broadcaster_displaystring
broadcaster_mediastring
broadcaster_rankinginteger
broadcaster_scopestring
broadcaster_video_linkstringnullable
tape_delay_commentsstringnullable
mlb.playoffs12 fields· 3 refsendpoints →

The MLB postseason bracket — Wild Card Series, Division Series, League Championship Series, and the World Series, tracked as the seeded matchups and outcomes.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
away_team_idbigintmlb.teams44
home_team_idbigintmlb.teams27
season_idbigintmlb.seasons2020
series_idbigint401
away_team_winsinteger2
games_playedinteger5
home_team_winsinteger3
max_gamesinteger5
series_namestringAL Division Series
ValuesAL Division SeriesNL Division SeriesAL Wild Card SeriesNL Wild Card SeriesWorld SeriesNL Championship SeriesAL Championship SeriesNL Wild Card GameAL Wild Card Game
series_textstringLAD won 4-3
statusstringCompleted
mlb.game_broadcasters4 fields· 2 refsendpoints →

Which networks broadcast each MLB game — the national TV partner, regional carriers, radio calls, and streaming providers.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
broadcaster_idbigintmlb.broadcasters
game_idbigintmlb.games
broadcaster_typestring
mlb.game_umpires4 fields· 2 refsendpoints →

The umpiring crew assigned to each MLB game — who worked home plate, who worked each base.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games1454
umpire_idbigintmlb.umpires46
positionstringnullableHome Plate
ValuesHome PlateFirst BaseSecond BaseThird Base
mlb.player_awards8 fields· 3 refsendpoints →

MLB player awards — MVP, Cy Young, Rookie of the Year, Gold Gloves, Silver Sluggers, All-Star selections, and other end-of-season honors.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
player_idbigintmlb.players1369
season_idbigintmlb.seasons2019
team_idbigintnullablemlb.teams41
award_datedatenullable2025-11-13T05:00:00.000ZDate the award was announced
award_namestringAll-MLB First Team
award_typestringMLBAFIRST
is_winnerbooleantruestatsapi publishes recipients (winners) only — always true
mlb.player_injuries16 fields· 3 refsendpoints →

The ongoing injury record for each MLB player — body part, severity, IL designation (10-day, 15-day, 60-day), and expected return timeline.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
player_idbigintmlb.players636
season_idbigintmlb.seasons2026
team_idbigintmlb.teams42
body_partstringElbow
descriptionstringnullableno
end_datetimestamptznullable
expected_return_datetimestamptznullable2027-02-01T05:00:00.000Z
games_missedintegernullable
injury_typestringSurgery
ValuesSurgeryStrainNot SpecifiedInflammationSorenessFracturePinched NerveSprainUnknownBruiseConcussionTendinitisSpasmsPlantar FasciitisCrampsBone SpurInfectionDislocated
is_surgery_requiredbooleannullable
sidestringnullableRight
ValuesRightLeftNot Specified
sourcestringnullableespn
start_datetimestamptz2026-05-08T11:02:00.000Z
statusstring60-Day-IL
Values60-Day-ILDay-To-Day15-Day-IL10-Day-ILOut7-Day ILdevelopmental listsuspension7-day ilBereavementpaternity
updated_datetimestamptz2026-06-29T11:01:04.968Z
mlb.player_news17 fields· 2 refsendpoints →

News about MLB players — trades, IL placements, lineup decisions, suspensions, and general beat-reporter updates, unified from beat-writer scrapers, operator feeds, and AI summarization.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
external_idstringsportsdata-197163Source-specific unique identifier
player_idbigintnullablemlb.players459
team_idbigintnullablemlb.teams
ai_processedbooleanfalse
analysisstringnullable
authorstringnullableStaff
categorystringnullableinjuryinjury, transaction, lineup, general
Valuesinjurytransactionlineupgeneral
contentstringnullableMilwaukee Brewers first baseman/outfielder Jake Bauers is posting strong numbers at the plate recen…
descriptionstringnullableMilwaukee Brewers first baseman/outfielder Jake Bauers is posting strong numbers at the plate recen…
linkstringnullablehttps://www.rotoballer.com/player-news/jake-bauers-is-becoming-a-must-have-player/1871934
news_timetimestamptz2026-06-07T01:57:06.000Z
priorityinteger10
processed_attimestamptznullable
situational_impactjsonbnullable
sourcestringsportsdataNews source identifier (cbs, espn, rotoworld, sportsdata, etc.)
titlestringJake Bauers is Becoming a Must-Have Player
mlb.venue_weathers27 fields· 2 refsendpoints →

On-field weather throughout each MLB game — temperature, wind direction and speed, humidity, and precipitation captured at fixed intervals from first pitch.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintmlb.games1454
venue_idbigintmlb.venues14
air_densityfloatnullableCalculated air density (lb/ft³)
ball_carry_factordecimalnullableEstimated ball carry factor (1.0 = neutral, >1 = carries more)
cloud_coverfloatnullable
dew_pointfloatnullable
feels_like_temperaturefloatnullable
humidityfloatnullable
is_domebooleannullablefalse
Valuesfalsetrue
precipitationfloatnullable
precipitation_probabilityfloatnullable
pressurefloatnullable
recorded_attimestamptznullable2018-09-30T19:10:00.000Z
roof_statusstringnullableClosedopen, closed, retractable_open, retractable_closed
ValuesClosedOpen
temperaturefloatnullable72
time_minutesinteger0Minutes from game start (0, 30, 60, 90, 120, 150, 180 for 3-hour game)
uv_indexfloatnullable
visibilityfloatnullable
weather_conditionstringnullablePartly Cloudy
ValuesPartly CloudyClearCloudyRoof ClosedSunnyOvercastDomeRainDrizzleSnow
weather_descriptionstringnullableNone
ValuesNoneOut To CFL To RR To LOut To LFOut To RFIn From RFIn From CFIn From LFVariesCalm
wind_blowing_outbooleannullabletrueTrue if wind is blowing from home plate toward outfield
Valuestruefalse
wind_component_outfloatnullableWind speed component blowing out to CF (mph, negative = blowing in)
wind_directionfloatnullable
wind_direction_relativefloatnullableWind direction relative to batter's box (degrees)
wind_gustfloatnullable
wind_speedfloatnullable0