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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
league_id	stringnullable	—	—	Official MLB season identifier
end_date	timestamptznullable	—	2018-10-28T04:00:00.000Z	—
post_season_start_date	timestamptznullable	—	2018-10-02T04:00:00.000Z	—
regular_season_start_date	timestamptznullable	—	2018-03-29T04:00:00.000Z	—
start_date	timestamptz	—	2018-02-21T05:00:00.000Z	—
start_year	integer	—	2018	—

mlb.teams11 fields· 1 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
league_team_id	integernullable	—	108	Official MLB team ID from statsapi.mlb.com
venue_id	bigintnullable	→ mlb.venues	2	—
abbreviation	string	—	LAA	—
active	boolean	—	true	—
city	string	—	Los Angeles	—
division	string	—	West	— Values`WestEastCentral`
full_name	string	—	Los Angeles Angels	—
league	string	—	American League	— Values`American LeagueNational League`
logo_url	stringnullable	—	—	URL to team logo image
name	string	—	Angels	—

mlb.players29 fields· 1 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
league_id	stringnullable	—	—	Official MLB player identifier
league_player_id	integer	—	613534	Official MLB player ID from statsapi.mlb.com
team_id	bigintnullable	→ mlb.teams	16	—
bats	stringnullable	—	R	— Values`RLS`
birth_city	stringnullable	—	Santo Domingo	—
birth_country	stringnullable	—	USA	—
birth_date	datenullable	—	1994-07-14	—
birth_state	stringnullable	—	CA	—
debut_date	timestamptznullable	—	2023-03-30T00:00:00.000Z	—
display_fi_last	stringnullable	—	J. Rodríguez	—
display_last_comma_first	stringnullable	—	Davis, Jonathan	—
draft_number	stringnullable	—	—	—
draft_round	stringnullable	—	—	—
draft_year	stringnullable	—	2019	—
first_name	string	—	Ryan	—
full_name	string	—	Luis Ortiz	—
full_position_list	stringnullable	—	Pitcher	— Values`PitcherOutfielderCatcherSecond BaseThird BaseFirst BaseShortstopOutfieldDesignated HitterInfieldTwo-Way Player`
height	integernullable	—	74	—
jersey	stringnullable	—	52	—
last_name	string	—	Rodriguez	—
league_slug	stringnullable	—	austin-adams-613534	—
position_category	stringnullable	—	Pitcher	— Values`PitcherInfielderOutfielderCatcherUtility`
primary_position	string	—	P	—
profile_pic_url	stringnullable	—	—	URL to player profile picture image
roster_status	stringnullable	—	inactive	Canonical 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}. Values`inactiveactivenon_rosterinjured_reserve`
school	stringnullable	—	—	—
throws	stringnullable	—	R	— Values`RLS`
weight	integernullable	—	215	—

mlb.games31 fields· 7 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
away_team_id	bigint	→ mlb.teams	38	—
home_team_id	bigint	→ mlb.teams	33	—
league_game_id	integernullable	—	745080	Official MLB gamePk from statsapi.mlb.com
league_id	stringnullable	—	—	Official MLB game identifier
losing_pitcher_id	bigintnullable	→ mlb.players	1177	Losing pitcher of record
save_pitcher_id	bigintnullable	→ mlb.players	1415	Save pitcher (if any)
season_id	bigint	→ mlb.seasons	2025	—
venue_id	bigintnullable	→ mlb.venues	16	—
winning_pitcher_id	bigintnullable	→ mlb.players	272	Winning pitcher of record
attendance	integernullable	—	—	—
away_team_score	integer	—	3	—
channel	stringnullable	—	MLBN (out-of-market only)	—
day	integer	—	20180317	—
day_night	stringnullable	—	—	D=Day, N=Night
doubleheader	boolean	—	false	— Values`falsetrue`
duration_minutes	integernullable	—	—	Total game duration in minutes
end_time	timestamptznullable	—	—	—
game_label	stringnullable	—	Regular Season Game 1	—
game_number	integer	—	1	For doubleheaders: 1 or 2
game_time	timestamptz	—	2018-03-17T17:05:00.000Z	Canonical game start time. The ONLY one on any games table — nba and nfl carried a duplicate `start_time` until 2026-08-27 and nhl carried `date_time` and `date_time_utc`; all four sports now expose `game_time` alone.
game_type	string	—	R	R=Regular, S=Spring, F=Wild Card, D=Division, L=League, W=World Series, E=Exhibition, A=All-Star Values`RSDFLW`
home_team_score	integer	—	4	—
if_necessary	booleannullable	—	false	—
neutral_venue	boolean	—	false	—
postponed_status	stringnullable	—	—	—
season_type	string	—	regular_season	Canonical season phase. Postseason round detail (Wild Card/Division/LCS/World Series) is in the league-native `game_type` code. Values`regular_seasonspring_trainingpostseason`
series_game_number	stringnullable	—	1	—
series_name	stringnullable	—	Regular Season	— Values`Regular SeasonSpring TrainingNL Division SeriesAL Division SeriesAL Championship SeriesWorld SeriesAL Wild Card SeriesNL Wild Card SeriesNL Championship Series`
series_text	stringnullable	—	1-0	— Values`1-02-12-01-13-03-12-24-00-03-23-34-34-15-04-2`
status	string	—	Final	Final, Live, Scheduled, Postponed, Suspended, Cancelled Values`FinalCompleted EarlyCancelled`

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	357	—
away_team_errors	integer	—	0	—
away_team_hits	integer	—	0	—
away_team_runs	integer	—	0	—
home_team_errors	integer	—	0	—
home_team_hits	integer	—	0	—
home_team_runs	integer	—	0	—
inning_half	string	—	TOP	— Values`TOPBOTTOM`
inning_number	integer	—	1	—

mlb.at_bats39 fields· 4 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.).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
batter_id	bigint	→ mlb.players	996	—
game_id	bigint	→ mlb.games	69	—
inning_id	bigint	→ mlb.innings	908	—
pitcher_id	bigint	→ mlb.players	174	—
at_bat_number	integer	—	0	—
balls	integer	—	0	—
bat_side	stringnullable	—	—	Batter side for this matchup (L/R) — per-PA truth, resolves switch hitters (statsapi matchup.batSide.code)
end_outs	integer	—	2	—
end_runners	integer	—	0	—
end_time	timestamptznullable	—	—	Wall-clock end of the plate appearance (statsapi about.endTime)
expected_batting_avg	decimalnullable	—	0.0050	—
expected_woba	decimalnullable	—	0.0000	—
hit_coord_x	floatnullable	—	104.05	—
hit_coord_y	floatnullable	—	149.88	—
hit_distance	integernullable	—	4	—
hit_exit_velocity	floatnullable	—	98.4	—
hit_launch_angle	floatnullable	—	5	—
hit_location	stringnullable	—	ground_ball	— Values`ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup`
hit_type	stringnullable	—	ground_ball	— Values`ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup`
is_barrel	booleannullable	—	false	— Values`falsetrue`
is_flare_burner	booleannullable	—	false	Launch angle 10-25 AND exit velocity < 95 Values`falsetrue`
is_hard_hit	booleannullable	—	false	— Values`falsetrue`
is_solid_contact	booleannullable	—	false	Launch angle 20-25 AND exit velocity 95-100 Values`falsetrue`
is_sweet_spot	booleannullable	—	false	Launch angle between 8-32 degrees Values`falsetrue`
is_topped	booleannullable	—	false	Launch angle < 10 AND exit velocity < 90 Values`falsetrue`
is_under	booleannullable	—	false	Launch angle less than 10 degrees Values`falsetrue`
launch_speed_angle_zone	integernullable	—	3	—
pitch_count	integer	—	4	—
pitch_hand	stringnullable	—	—	Pitcher hand for this matchup (L/R) (statsapi matchup.pitchHand.code)
result	string	—	Strikeout	—
runs_scored	integer	—	0	—
spray_angle	floatnullable	—	-6	Horizontal angle from center field (degrees)
start_outs	integer	—	1	—
start_runners	integer	—	0	—
start_time	timestamptznullable	—	—	Wall-clock start of the plate appearance (statsapi about.startTime)
statcast_quality_score	decimalnullable	—	1.0000	Statcast data quality score (0.0-1.0)
strikes	integer	—	2	—
tracking_confidence	decimalnullable	—	—	Confidence in tracking data accuracy

mlb.pitches73 fields· 4 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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
at_bat_id	bigint	→ mlb.at_bats	1494	—
batter_id	bigint	→ mlb.players	306	—
game_id	bigint	→ mlb.games	84	—
pitcher_id	bigint	→ mlb.players	267	—
play_id	bigint	—	12	—
air_out	boolean	—	false	Whether this pitch resulted in an air out
ball	boolean	—	false	— Values`falsetrue`
barrel	booleannullable	—	false	Optimal combination of exit velocity and launch angle Values`falsetrue`
break_angle	floatnullable	—	1.2	—
break_length	floatnullable	—	3.6	—
break_y	floatnullable	—	24	—
breaking_ball	booleannullable	—	false	Breaking ball (curveball, slider, knuckleball) Values`falsetrue`
call	string	—	Ball	— Values`BallFoulCalled StrikeIn play, out(s)Swinging StrikeIn play, no outIn play, run(s)Ball In DirtFoul TipSwinging Strike (Blocked)Hit By PitchFoul BuntPitchoutMissed Bunt`
catchers_interference	boolean	—	false	Whether this pitch resulted in catchers interference
chase	booleannullable	—	true	Whether batter swung at pitch outside zone
double	boolean	—	false	Whether this pitch resulted in a double Values`falsetrue`
effective_speed	floatnullable	—	85.3	Perceived speed to batter (mph)
expected_batting_avg	decimalnullable	—	—	xBA based on exit velocity and launch angle
expected_woba	decimalnullable	—	—	xwOBA based on exit velocity and launch angle
extension	floatnullable	—	7.015639833312882	—
fastball	booleannullable	—	true	Fastball variant (4-seam, 2-seam, sinker, cutter) Values`truefalse`
flare_burner	booleannullable	—	false	Launch angle 10-25 AND exit velocity < 95 Values`falsetrue`
fly_out	boolean	—	false	Whether this pitch resulted in a fly out Values`falsetrue`
ground_into_double_play	boolean	—	false	Whether this pitch resulted in grounding into double play
ground_into_triple_play	boolean	—	false	Whether this pitch resulted in grounding into triple play
ground_out	boolean	—	false	Whether this pitch resulted in a ground out Values`falsetrue`
hard_hit	booleannullable	—	false	Exit velocity >= 95 MPH Values`falsetrue`
hit_by_pitch	boolean	—	false	Whether this pitch resulted in hit by pitch Values`falsetrue`
hit_coord_x	floatnullable	—	153.39	Hit coordinate X (feet from home plate)
hit_coord_y	floatnullable	—	167.3	Hit coordinate Y (feet from home plate)
hit_distance	integernullable	—	4	Distance of batted ball (feet)
hit_exit_velocity	floatnullable	—	103.4	Exit velocity of batted ball (mph)
hit_launch_angle	floatnullable	—	5	Launch angle of batted ball (degrees)
home_run	boolean	—	false	Whether this pitch resulted in a home run Values`falsetrue`
in_play	boolean	—	false	— Values`falsetrue`
in_strike_zone	booleannullable	—	false	Whether pitch was in the strike zone Values`falsetrue`
intentional_walk	boolean	—	false	Whether this pitch resulted in an intentional walk
launch_speed_angle_zone	integernullable	—	3	1=Weak, 2=Topped, 3=Under, 4=Flare/Burner, 5=Solid, 6=Barrel
line_out	boolean	—	false	Whether this pitch resulted in a line out Values`falsetrue`
offspeed	booleannullable	—	false	Offspeed pitch (changeup, splitter, forkball) Values`falsetrue`
pitch_number	integer	—	1	—
pitch_speed	floatnullable	—	92.6	—
pitch_type	stringnullable	—	FF	— Values`FFSISLCHFCSTCUFSKCSVFA`
pitch_x	floatnullable	—	0.36271081581727094	—
pitch_y	floatnullable	—	155.85	—
pitch_z	floatnullable	—	3.5469804155056193	—
pitch_zone	integernullable	—	14	—
plate_x	floatnullable	—	125.18	—
plate_z	floatnullable	—	155.85	—
pop_out	boolean	—	false	Whether this pitch resulted in a pop out Values`falsetrue`
release_speed	floatnullable	—	92.6	Speed at release point (mph)
result	string	—	Ball	— Values`BallFoulCalled StrikeIn play, out(s)Swinging StrikeIn play, no outIn play, run(s)Ball In DirtFoul TipSwinging Strike (Blocked)Hit By PitchFoul BuntPitchoutMissed Bunt`
sacrifice_fly	boolean	—	false	Whether this pitch resulted in a sacrifice fly Values`falsetrue`
sacrifice_hit	boolean	—	false	Whether this pitch resulted in a sacrifice bunt Values`falsetrue`
single	boolean	—	false	Whether this pitch resulted in a single Values`falsetrue`
solid_contact	booleannullable	—	false	Launch angle 20-25 AND exit velocity 95-100 Values`falsetrue`
spin_axis	floatnullable	—	—	Spin axis (degrees)
spin_direction	floatnullable	—	211	—
spin_rate	floatnullable	—	2190	—
spray_angle	floatnullable	—	-6.1	Horizontal angle from center field (degrees)
start_time	timestamptznullable	—	—	Wall-clock time of the pitch (statsapi playEvents startTime)
statcast_quality_score	decimalnullable	—	—	Statcast data quality score (0.0-1.0)
strike	boolean	—	false	— Values`falsetrue`
strike_zone_bottom	floatnullable	—	1.63	—
strike_zone_top	floatnullable	—	3.51	—
strikeout	boolean	—	false	Whether this pitch resulted in a strikeout Values`falsetrue`
sweet_spot	booleannullable	—	false	Launch angle between 8-32 degrees Values`falsetrue`
topped	booleannullable	—	false	Launch angle < 10 AND exit velocity < 90 Values`falsetrue`
tracking_confidence	decimalnullable	—	—	Confidence in tracking data accuracy
triple	boolean	—	false	Whether this pitch resulted in a triple Values`falsetrue`
under	booleannullable	—	false	Launch angle less than 10 degrees Values`falsetrue`
walk	boolean	—	false	Whether this pitch resulted in a walk Values`falsetrue`

mlb.play_by_plays26 fields· 11 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
at_bat_id	bigintnullable	→ mlb.at_bats	1	—
batter_id	bigintnullable	→ mlb.players	996	—
catcher_id	bigintnullable	→ mlb.players	—	—
first_base_runner_id	bigintnullable	→ mlb.players	996	—
game_id	bigint	→ mlb.games	69	—
inning_id	bigint	→ mlb.innings	908	—
pitcher_id	bigintnullable	→ mlb.players	174	—
play_id	bigint	—	0	—
player_id	bigintnullable	→ mlb.players	996	—
second_base_runner_id	bigintnullable	→ mlb.players	996	—
team_id	bigint	→ mlb.teams	19	—
third_base_runner_id	bigintnullable	→ mlb.players	996	—
away_score	integernullable	—	—	—
count_balls	integer	—	0	—
count_strikes	integer	—	2	—
end_time	timestamptznullable	—	—	Wall-clock end of the play (statsapi about.endTime)
event_sub_type	integer	—	0	—
event_type	integer	—	8	—
hit_location	stringnullable	—	ground_ball	— Values`ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup`
hit_type	stringnullable	—	ground_ball	— Values`ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup`
home_score	integernullable	—	—	—
mlb_event_num	integer	—	0	—
outs	integer	—	1	—
runners_on_base	integer	—	0	—
start_time	timestamptznullable	—	—	Wall-clock start of the play (statsapi about.startTime)

Stats

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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
season_id	bigint	→ mlb.seasons	2024	—
team_id	bigint	→ mlb.teams	16	—
at_bats	integer	—	5522	—
batting_average	decimal	—	0.2440	—
blown_saves	integer	—	22	—
caught_stealing	integer	—	30	—
complete_games	integer	—	1	—
double_plays	integer	—	125	—
doubles	integer	—	245	—
earned_run_average	decimal	—	3.7400	—
earned_runs	integer	—	596	—
errors	integer	—	97	—
fielding_percentage	decimal	—	0.9840	—
games_played	integer	—	162	—
hits	integer	—	1423	—
holds	integer	—	83	—
home_runs	integer	—	190	—
innings_pitched	decimal	—	1442.0000	Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
losses	integer	—	84	—
on_base_percentage	decimal	—	0.3150	—
on_base_plus_slugging	decimal	—	0.7500	—
runs_allowed	integer	—	697	—
runs_batted_in	integer	—	670	—
runs_scored	integer	—	716	—
save_opportunities	integer	—	64	—
saves	integer	—	44	—
shutouts	integer	—	8	—
slugging_percentage	decimal	—	0.3970	—
stolen_bases	integer	—	88	—
strikeouts	integer	—	1461	—
ties	integer	—	0	—
triples	integer	—	18	—
walks	integer	—	478	—
whip	decimal	—	1.2400	—
wins	integer	—	90	—

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ mlb.players	1439	—
season_id	bigint	→ mlb.seasons	2024	—
assists	integer	—	0	—
at_bats	integer	—	0	—
balls	integernullable	—	0	—
batters_faced	integer	—	0	—
batting_average	decimal	—	0.0000	—
blown_saves	integer	—	0	—
caught_stealing	integer	—	0	—
caught_stealing_by	integer	—	0	—
complete_games	integer	—	0	—
double_plays	integer	—	0	—
doubles	integer	—	0	—
earned_run_average	decimal	—	0.0000	—
earned_runs	integer	—	0	—
errors	integer	—	0	—
fielding_games	integer	—	0	—
fielding_games_started	integer	—	0	—
fielding_percentage	decimal	—	0.0000	—
fielding_position	string	—	P	— Values`PC2BLFRFCF3B1BSSXDH`
games_pitched	integer	—	0	—
games_played	integer	—	0	—
games_started	integer	—	0	—
games_started_pitching	integer	—	0	—
grounded_into_double_play	integer	—	0	—
hit_by_pitch	integer	—	0	—
hits	integer	—	0	—
hits_allowed	integer	—	0	—
hits_per_nine	decimal	—	0.0000	—
holds	integer	—	0	—
home_runs	integer	—	0	—
home_runs_allowed	integer	—	0	—
home_runs_per_nine	decimal	—	0.0000	—
innings_pitched	decimal	—	0.0000	Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
intentional_walks	integernullable	—	0	—
left_on_base	integernullable	—	0	—
losses	integer	—	0	—
on_base_percentage	decimal	—	0.0000	—
on_base_plus_slugging	decimal	—	0.0000	—
passed_balls	integer	—	0	—
pitches_thrown	integernullable	—	0	—
plate_appearances	integer	—	0	—
putouts	integer	—	0	—
quality_starts	integernullable	—	0	—
runs	integer	—	0	—
runs_allowed	integer	—	0	—
runs_batted_in	integer	—	0	—
sacrifice_flies	integer	—	0	—
sacrifice_hits	integer	—	0	—
save_opportunities	integer	—	0	—
saves	integer	—	0	—
shutouts	integer	—	0	—
singles	integernullable	—	0	Derivable from hits - doubles - triples - home_runs
slugging_percentage	decimal	—	0.0000	—
stolen_bases	integer	—	0	—
stolen_bases_allowed	integer	—	0	—
strikeouts	integer	—	0	—
strikeouts_per_nine	decimal	—	0.0000	—
strikeouts_pitched	integer	—	0	—
strikes	integernullable	—	0	—
total_bases	integernullable	—	0	Derivable: 1B + 22B + 33B + 4*HR
total_chances	integer	—	0	—
triples	integer	—	0	—
walks	integer	—	0	—
walks_allowed	integer	—	0	—
walks_per_nine	decimal	—	0.0000	—
whip	decimal	—	0.0000	—
wins	integer	—	0	—

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	64	—
player_id	bigint	→ mlb.players	604	—
team_id	bigint	→ mlb.teams	41	—
air_outs	integer	—	0	—
at_bats	integer	—	3	—
at_bats_per_home_run	decimal	—	0.0000	—
babip	decimal	—	0.0000	—
balls_in_play	integer	—	0	—
batting_average	decimal	—	0.0000	—
catchers_interference	integer	—	0	—
caught_stealing	integer	—	0	—
double_plays	integer	—	0	—
doubles	integer	—	0	—
fly_outs	integer	—	0	—
ground_into_double_play	integer	—	0	—
ground_into_triple_play	integer	—	0	—
ground_outs	integer	—	0	—
hit_by_pitch	integer	—	0	—
hits	integer	—	0	—
home_runs	integer	—	0	—
intentional_walks	integer	—	0	—
isolated_power	decimal	—	0.0000	—
left_on_base	integer	—	0	—
line_outs	integer	—	0	—
on_base_percentage	decimal	—	0.0000	—
on_base_plus_slugging	decimal	—	0.0000	—
pickoffs	integer	—	0	—
plate_appearances	integer	—	4	—
pop_outs	integer	—	0	—
runs	integer	—	0	—
runs_batted_in	integer	—	0	—
sacrifice_flies	integer	—	0	—
sacrifices	integer	—	0	—
singles	integer	—	0	—
slugging_percentage	decimal	—	0.0000	—
stolen_bases	integer	—	0	—
strikeouts	integer	—	0	—
total_bases	integer	—	0	—
triples	integer	—	0	—
walks	integer	—	0	—
woba	decimal	—	0.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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	64	—
player_id	bigint	→ mlb.players	1382	—
team_id	bigint	→ mlb.teams	33	—
air_outs	integer	—	0	—
babip	decimal	—	0.0000	—
balks	integer	—	0	—
balls	integer	—	0	—
balls_in_play	integer	—	0	—
batters_faced	integer	—	3	—
blown_save	integer	—	0	—
catchers_interference	integer	—	0	—
complete_games	integer	—	0	—
double_plays	integer	—	0	—
doubles_allowed	integer	—	0	—
earned_run_average	decimal	—	0.0000	—
earned_runs	integer	—	0	—
fip	decimal	—	3.1000	—
fly_outs	integer	—	0	—
games_finished	integer	—	0	—
games_pitched	integer	—	1	—
games_started	integer	—	0	—
grand_slams_allowed	integer	—	0	—
ground_into_double_play	integer	—	0	—
ground_outs	integer	—	0	—
hit_by_pitch	integer	—	0	—
hits_allowed	integer	—	0	—
hold	integer	—	0	—
home_runs_allowed	integer	—	0	—
home_runs_per_nine	decimal	—	0.0000	—
inherited_runners	integer	—	0	—
inherited_runners_scored	integer	—	0	—
inning_started	integer	—	0	—
innings_pitched	decimal	—	1.0000	Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
intentional_walks	integer	—	0	—
left_on_base	decimal	—	0.0000	—
line_outs	integer	—	0	—
loss	integer	—	0	—
no_hitters	integer	—	0	—
on_base_percentage	decimal	—	0.0000	—
on_base_plus_slugging	decimal	—	0.0000	—
outs	integer	—	3	—
perfect_games	integer	—	0	—
pickoffs	integer	—	0	—
pitches_thrown	integer	—	0	—
plate_appearances	integer	—	0	—
pop_outs	integer	—	0	—
quality_starts	integer	—	0	—
runs_allowed	integer	—	0	—
runs_scored_per_nine	decimal	—	0.0000	—
sacrifice_flies_allowed	integer	—	0	—
sacrifices_allowed	integer	—	0	—
save	integer	—	0	—
shutouts	integer	—	0	—
singles_allowed	integer	—	0	—
slugging_percentage	decimal	—	0.0000	—
strike_percentage	decimal	—	0.0000	—
strikeouts_per_nine	decimal	—	0.0000	—
strikeouts_pitched	integer	—	0	—
strikes	integer	—	0	—
total_bases_allowed	integer	—	0	—
triples_allowed	integer	—	0	—
walks_allowed	integer	—	0	—
walks_per_nine	decimal	—	0.0000	—
whip	decimal	—	0.0000	—
wild_pitches	integer	—	0	—
win	integer	—	0	—
woba	decimal	—	0.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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	1454	—
team_id	bigint	→ mlb.teams	27	—
assists	integer	—	9	—
balks	integer	—	0	—
batters_faced	integer	—	36	—
batting_average	decimal	—	0.2440	—
caught_stealing	integer	—	0	—
double_plays_turned	integer	—	0	—
doubles	integer	—	1	—
earned_run_average	decimal	—	3.7700	—
earned_runs	integer	—	2	—
errors	integer	—	0	—
grounded_into_double_play	integer	—	0	—
hit_by_pitch	integer	—	0	—
hits	integer	—	7	—
home_runs	integer	—	1	—
innings_pitched	decimal	—	9.0000	Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)
left_on_base	integer	—	6	—
loss	integer	—	0	—
on_base_percentage	decimal	—	0.3150	—
on_base_plus_slugging	decimal	—	0.7240	—
passed_balls	integer	—	0	—
pitches_thrown	integer	—	143	—
putouts	integer	—	27	—
runs	integer	—	3	—
runs_batted_in	integer	—	2	—
sacrifice_flies	integer	—	0	—
sacrifice_hits	integer	—	0	—
slugging_percentage	decimal	—	0.4070	—
stolen_bases	integer	—	0	—
strikeouts	integer	—	8	—
strikes	integer	—	93	—
triples	integer	—	0	—
walks	integer	—	2	—
wild_pitches	integer	—	0	—
win	integer	—	0	—

Advanced 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
season_id	bigint	→ mlb.seasons	2024	—
venue_id	bigint	→ mlb.venues	12	—
basic_park_factor	decimal	—	1.2200	Overall park factor for runs (1.0 = neutral)
double_factor	decimal	—	1.2600	Park factor for doubles
fly_ball_factor	decimalnullable	—	—	Park factor for fly balls
ground_ball_factor	decimalnullable	—	—	Park factor for ground balls
handedness_factor	decimal	—	1.1600	Park effect on handedness advantage
home_run_factor	decimal	—	1.3300	Park factor for home runs (1.0 = neutral)
left_handed_factor	decimal	—	1.1400	Park factor for left-handed batters
right_handed_factor	decimal	—	1.1800	Park factor for right-handed batters
run_factor	decimalnullable	—	—	Park factor for total runs
single_factor	decimal	—	1.1100	Park factor for singles
strikeout_factor	decimal	—	0.8900	Park factor for strikeouts
triple_factor	decimal	—	1.4200	Park factor for triples
updated_date	timestamptz	—	2026-04-12T02:04:46.363Z	—
walk_factor	decimal	—	1.0100	Park factor for walks
years_of_data	integer	—	3	Number 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
season_id	bigint	→ mlb.seasons	2021	—
batting_average_on_balls_in_play	decimal	—	0.2930	League average BABIP
fip_constant	decimal	—	3.1340	FIP constant to scale FIP to ERA
home_run_per_fly_ball	decimal	—	0.1390	League average HR/FB rate
runs_per_out	decimal	—	0.2810	League average runs per out made
runs_per_plate_appearance	decimal	—	0.1250	League average runs per plate appearance
strikeout_rate	decimal	—	0.2440	League average strikeout rate
updated_date	timestamptz	—	2026-04-12T02:04:46.337Z	—
walk_rate	decimal	—	0.0890	League 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+.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
season_id	bigint	→ mlb.seasons	2021	—
double_weight	decimal	—	1.2710	Weight for doubles (w2B)
hit_by_pitch_weight	decimal	—	0.7230	Weight for hit by pitch (wHBP)
home_run_weight	decimal	—	2.1010	Weight for home runs (wHR)
league_obp	decimal	—	0.3180	League average OBP for calibration
league_woba	decimal	—	0.3180	League average wOBA for the season
single_weight	decimal	—	0.8950	Weight for singles (w1B)
triple_weight	decimal	—	1.5520	Weight for triples (w3B)
updated_date	timestamptz	—	2026-04-12T02:04:46.328Z	When these weights were last updated
walk_weight	decimal	—	0.6920	Weight for unintentional walks (wBB)
woba_scale	decimal	—	1.2160	Scale factor to convert wOBA to runs

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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
away_team_id	bigint	→ mlb.teams	—	—
home_team_id	bigint	→ mlb.teams	—	—
operator_id	bigint	→ main.operators	—	—
season_id	bigint	→ mlb.seasons	—	—
away_odds	integer	—	—	American odds for away team to win series
captured_at	timestamptz	—	—	—
games_played	integernullable	—	—	—
home_odds	integer	—	—	American odds for home team to win series
series_name	string	—	—	ALDS, NLDS, ALCS, NLCS, World Series, Wild Card
series_score	stringnullable	—	—	Current 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	—	—
operator_id	bigint	→ main.operators	—	—
alt_spreads	jsonbnullable	—	—	Array of {line, home_odds, away_odds}
alt_totals	jsonbnullable	—	—	Array of {line, over_odds, under_odds}
captured_at	timestamptz	—	—	—

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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	168105	—
operator_id	bigint	→ main.operators	6	Data source (consensus, DraftKings, FanDuel, etc.)
season_id	bigint	→ mlb.seasons	2026	Denormalized for efficient season-level queries
captured_at	timestamptz	—	2026-06-21T16:09:37.291Z	When this snapshot was captured
implied_away_score	decimalnullable	—	5.0000	—
implied_away_win_pct	decimalnullable	—	0.4785	—
implied_home_score	decimalnullable	—	3.5000	Calculated from spread + total
implied_home_win_pct	decimalnullable	—	0.5671	From moneyline, 0-1
is_opening	boolean	—	false	True if this is the opening line Values`falsetrue`
moneyline_away	integernullable	—	109	American odds for away team win
moneyline_home	integernullable	—	-131	American odds for home team win
over_odds	integernullable	—	-110	American odds for over
spread	decimalnullable	—	1.5000	Home team run line (e.g., -1.5 means home favored by 1.5 runs)
spread_away_odds	integernullable	—	-110	American odds for away run line
spread_home_odds	integernullable	—	-110	American odds for home run line (e.g., -130)
total	decimalnullable	—	8.5000	Combined run total line (e.g., 8.5)
under_odds	integernullable	—	-110	American 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	—	—
operator_id	bigint	→ main.operators	—	Data source (consensus, DraftKings, FanDuel, etc.)
season_id	bigint	→ mlb.seasons	—	Denormalized for efficient season-level queries
captured_at	timestamptz	—	—	—
implied_away_win_pct	decimalnullable	—	—	—
implied_home_win_pct	decimalnullable	—	—	—
is_opening	boolean	—	—	—
moneyline_away	integernullable	—	—	—
moneyline_home	integernullable	—	—	—
over_odds	integernullable	—	—	—
period_code	string	—	—	Market period code (F5 = first 5 innings, F3, F7)
spread	decimalnullable	—	—	Home team run line for this period
spread_away_odds	integernullable	—	—	—
spread_home_odds	integernullable	—	—	—
total	decimalnullable	—	—	Combined run total line for this period
under_odds	integernullable	—	—	—

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	—	—
operator_id	bigint	→ main.operators	—	—
player_id	bigint	→ mlb.players	—	—
season_id	bigint	→ mlb.seasons	—	Denormalized for efficient season-level queries
book_count	integer	—	—	Number of curated books contributing to this consensus value
captured_at	timestamptz	—	—	—
category	string	—	—	Canonical 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_opening	boolean	—	—	—
line	decimalnullable	—	—	Prop line for over/under markets (e.g., 5.5 strikeouts)
market_key	string	—	—	Raw market key from source API (e.g., pitcher_strikeouts)
no_odds	integernullable	—	—	—
outcome_type	string	—	—	ou \| yes_no
over_odds	integernullable	—	—	—
period_code	stringnullable	—	—	Optional period code (F5)
subcategory	stringnullable	—	—	Optional subtype (alternate, boosted, etc.)
under_odds	integernullable	—	—	—
yes_odds	integernullable	—	—	—

Lineups & Roster

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ mlb.players	165	—
season_id	bigint	→ mlb.seasons	2024	—
team_id	bigint	→ mlb.teams	30	—
day	integer	—	20260621	—
position	stringnullable	—	P	— Values`PCRF3BLF2B1BCFSSDHOFIFTWP`
position_depth	integernullable	—	1	—
position_group	stringnullable	—	Pitcher	— Values`PitcherInfielderOutfielderCatcherHitterTwo-Way Player`
roster_type	string	—	40Man	— Values`40ManactivefullSeason`

mlb.team_starting_lineups6 fields· 3 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	64	—
pitcher_id	bigintnullable	→ mlb.players	50028	—
team_id	bigint	→ mlb.teams	27	—
batter_status	integer	—	1	—
pitcher_status	integer	—	1	—

mlb.game_team_rosters9 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	14259	—
player_id	bigint	→ mlb.players	1365	—
team_id	bigint	→ mlb.teams	27	—
batting_order	integernullable	—	9	—
comment	stringnullable	—	—	—
position	stringnullable	—	P	— Values`PC2BLF1BCF3BRFSSPHDHPR`
starter	boolean	—	false	— Values`falsetrue`
status	stringnullable	—	Active	—

mlb.team_starting_lineup_batters5 fields· 2 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ mlb.players	1040	—
team_starting_lineup_id	bigint	→ mlb.team_starting_lineups	1	—
batting_order	string	—	1	—
position	string	—	SS	— Values`SS3BRF2BCF1BLFCDHPPHPR`

Misc

mlb.venues21 fieldsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
league_venue_id	integernullable	—	2523	Official MLB venue ID from statsapi.mlb.com
address	stringnullable	—	—	—
capacity	integernullable	—	14014	—
city	string	—	West Sacramento	—
closed_date	timestamptznullable	—	—	—
country	stringnullable	—	USA	— Values`USACAN`
description	stringnullable	—	—	—
elevation	floatnullable	—	596	Elevation in feet above sea level
hr_factor	decimalnullable	—	—	Historical home run park factor (1.0 = neutral)
image_url	stringnullable	—	—	URL to aerial/overview image of ballpark
latitude	floatnullable	—	27.9778	—
longitude	floatnullable	—	-82.5055	—
name	string	—	Sutter Health Park	—
opened_date	timestamptznullable	—	2000-05-15T04:00:00.000Z	—
orientation	floatnullable	—	45	Field orientation in degrees (0-360). Direction home plate faces. 0/360=North, 90=East, 180=South, 270=West
roof_type	stringnullable	—	Open	Open, Dome, Retractable Values`OpenRetractableClosed`
state	stringnullable	—	CA	— Values`CAFLILOHTXMONYPAAZGAMDMACOMIWIMNWAONDC`
surface	stringnullable	—	Grass	— Values`GrassArtificial TurfNatural Grass`
team_name	stringnullable	—	Tampa Bay Rays	—
timezone	stringnullable	—	—	IANA timezone (e.g., America/New_York)

mlb.broadcasters11 fieldsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
broadcaster_team_id	integer	—	—	—
region_id	integer	—	—	—
broadcaster_abbreviation	string	—	—	—
broadcaster_description	stringnullable	—	—	—
broadcaster_display	string	—	—	—
broadcaster_media	string	—	—	—
broadcaster_ranking	integer	—	—	—
broadcaster_scope	string	—	—	—
broadcaster_video_link	stringnullable	—	—	—
tape_delay_comments	stringnullable	—	—	—

mlb.umpires11 fieldsendpoints →

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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
mlb_umpire_id	integer	—	427044	—
active	boolean	—	true	—
birth_city	stringnullable	—	—	—
birth_country	stringnullable	—	—	—
birth_date	datenullable	—	—	—
birth_state	stringnullable	—	—	—
experience	integernullable	—	—	—
first_name	string	—	Mike	—
full_name	string	—	CB Bucknor	—
last_name	string	—	Jimenez	—

mlb.venue_dimensions21 fields· 1 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
mlb_venue_id	integer	—	1	—
venue_id	bigint	→ mlb.venues	2	—
altitude_ft	floatnullable	—	—	Venue altitude in feet (denormalized from venue for query convenience)
backstop_distance	floatnullable	—	—	Distance from home plate to backstop (feet)
center_field	float	—	400	—
center_field_fence_height	float	—	8	—
description	stringnullable	—	—	—
fair_territory_sq_ft	floatnullable	—	113800	—
foul_territory_rating	decimalnullable	—	—	Relative foul territory size (1.0 = average, >1 = large)
foul_territory_sq_ft	floatnullable	—	21500	—
left_center_field	floatnullable	—	385	—
left_field	float	—	330	—
left_field_fence_height	float	—	8	—
orientation	float	—	45	—
right_center_field	floatnullable	—	375	—
right_field	float	—	330	—
right_field_fence_height	float	—	8	—
total_territory_sq_ft	floatnullable	—	137000	—
venue_name	stringnullable	—	Angel Stadium	—
year	integer	—	2000	—

mlb.operator_team_lookups6 fields· 2 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
operator_id	bigint	→ main.operators	—	Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_team_id	string	—	—	External team ID from operator
team_id	bigint	→ mlb.teams	—	Internal mlb.teams.id reference
abbreviation	stringnullable	—	—	Team abbreviation for reconciliation
team_name	stringnullable	—	—	Team name for reconciliation

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
away_team_id	bigint	→ mlb.teams	44	—
home_team_id	bigint	→ mlb.teams	27	—
season_id	bigint	→ mlb.seasons	2020	—
series_id	bigint	—	401	—
away_team_wins	integer	—	2	—
games_played	integer	—	5	—
home_team_wins	integer	—	3	—
max_games	integer	—	5	—
series_name	string	—	AL Division Series	— Values`AL Division SeriesNL Division SeriesAL Wild Card SeriesNL Wild Card SeriesWorld SeriesNL Championship SeriesAL Championship SeriesNL Wild Card GameAL Wild Card Game`
series_text	string	—	LAD won 4-3	—
status	string	—	Completed	—

mlb.operator_player_lookups9 fields· 2 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
operator_id	bigint	→ main.operators	2240	Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_player_id	string	—	598286	External player ID from operator
player_id	bigintnullable	→ mlb.players	1589	Internal mlb.players.id reference
decided_at	timestamptznullable	—	—	When the pin or block was decided.
decided_reason	stringnullable	—	—	Evidence behind a pinned or blocked decision.
decision	stringnullable	—	derived	How this mapping was decided: 'derived' (finder answer, overwritable), 'pinned' (decided on evidence, trigger-protected), 'blocked' (no player we hold is this id; player_id NULL, never retried). DB default 'derived'; a BEFORE UPDATE trigger preserves non-derived rows.
player_name	stringnullable	—	Max Muncy	Player name for reconciliation
position	stringnullable	—	P	Position for reconciliation

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ mlb.players	1369	—
season_id	bigint	→ mlb.seasons	2019	—
team_id	bigintnullable	→ mlb.teams	41	—
award_date	datenullable	—	2025-11-13	Date the award was announced
award_name	string	—	All-MLB First Team	—
award_type	string	—	MLBAFIRST	—
is_winner	boolean	—	true	statsapi 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ mlb.players	636	—
season_id	bigint	→ mlb.seasons	2026	—
team_id	bigint	→ mlb.teams	42	—
body_part	string	—	Elbow	—
description	stringnullable	—	no	—
end_date	timestamptznullable	—	—	—
expected_return_date	timestamptznullable	—	2027-02-01T05:00:00.000Z	—
games_missed	integernullable	—	—	—
injury_type	string	—	Surgery	— Values`SurgeryStrainInflammationNot SpecifiedSorenessFracturePinched NerveUnknownSprainBruiseConcussionTendinitisSpasmsPlantar FasciitisCrampsBone SpurAbrasionLacerationInfectionDislocated`
is_surgery_required	booleannullable	—	—	—
side	stringnullable	—	Right	— Values`RightLeftNot Specified`
source	stringnullable	—	espn	—
start_date	timestamptz	—	2026-05-08T11:02:00.000Z	—
status	string	—	60-Day-IL	— Values`60-Day-ILDay-To-Day15-Day-IL10-Day-ILOut7-Day ILdevelopmental listsuspension7-day ilpaternitybereavementBereavementPaternitySuspension`
updated_date	timestamptz	—	2026-08-04T11:19:23.925Z	—

mlb.game_broadcasters4 fields· 2 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
broadcaster_id	bigint	→ mlb.broadcasters	—	—
game_id	bigint	→ mlb.games	—	—
broadcaster_type	string	—	—	—

mlb.game_umpires4 fields· 2 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	1454	—
umpire_id	bigint	→ mlb.umpires	46	—
position	stringnullable	—	Home Plate	— Values`Home PlateFirst BaseSecond BaseThird Base`

mlb.game_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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ mlb.games	1454	—
venue_id	bigint	→ mlb.venues	14	—
air_density	floatnullable	—	—	Calculated air density (lb/ft³)
ball_carry_factor	decimalnullable	—	—	Estimated ball carry factor (1.0 = neutral, >1 = carries more)
cloud_cover	floatnullable	—	—	—
dew_point	floatnullable	—	—	—
feels_like_temperature	floatnullable	—	—	—
humidity	floatnullable	—	—	—
is_dome	booleannullable	—	false	— Values`falsetrue`
precipitation	floatnullable	—	—	—
precipitation_probability	floatnullable	—	—	—
pressure	floatnullable	—	—	—
recorded_at	timestamptznullable	—	2018-09-30T19:10:00.000Z	—
roof_status	stringnullable	—	Closed	open, closed, retractable_open, retractable_closed Values`ClosedOpen`
temperature	floatnullable	—	72	—
time_minutes	integer	—	0	Minutes from game start (0, 30, 60, 90, 120, 150, 180 for 3-hour game)
uv_index	floatnullable	—	—	—
visibility	floatnullable	—	—	—
weather_condition	stringnullable	—	Partly Cloudy	— Values`Partly CloudyClearCloudyRoof ClosedSunnyOvercastDomeRainDrizzleSnow`
weather_description	stringnullable	—	None	— Values`NoneOut To CFL To RR To LOut To LFOut To RFIn From RFIn From CFIn From LFVariesCalm`
wind_blowing_out	booleannullable	—	true	True if wind is blowing from home plate toward outfield Values`truefalse`
wind_component_out	floatnullable	—	—	Wind speed component blowing out to CF (mph, negative = blowing in)
wind_direction	floatnullable	—	—	—
wind_direction_relative	floatnullable	—	—	Wind direction relative to batter's box (degrees)
wind_gust	floatnullable	—	—	—
wind_speed	floatnullable	—	0	—

mlb.player_news23 fields· 4 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
external_id	string	—	sportsdata-197163	Source-specific unique identifier
game_id	bigintnullable	→ mlb.games	169744	Associated game ID when this news item relates to a specific game.
opponent_team_id	bigintnullable	→ mlb.teams	16	Opponent team ID when this news item relates to an upcoming or active game matchup.
player_id	bigintnullable	→ mlb.players	1369	Player ID associated with the news report.
team_id	bigintnullable	→ mlb.teams	27	Team ID of the player at the time of publication.
ai_processed	boolean	—	false	Whether this story was generated or enriched via LLM summarization. Values`falsetrue`
analysis	stringnullable	—	—	Fantasy and tactical analysis of the news.
author	stringnullable	—	Staff	Reporter or author of the article.
category	stringnullable	—	injury	injury, transaction, lineup, general Values`injurygeneraltransactionlineupdepth_chartcontractsuspensionperformanceworkload`
content	stringnullable	—	Milwaukee Brewers first baseman/outfielder Jake Bauers is posting strong numbers at the plate recen…	Full text content of the news report.
description	stringnullable	—	San Francisco pitcher Sam Hentges is sidelined with a forearm injury and is expected to miss at lea…	Brief synopsis or summary of the news event.
first_reported_at	timestamptznullable	—	2026-09-07T01:25:32.000Z	Timestamp when this story was first reported before multi-source compaction.
link	stringnullable	—	https://www.rotoballer.com/player-news/jake-bauers-is-becoming-a-must-have-player/1871934	URL link to the original article or source video.
news_time	timestamptz	—	2026-09-01T04:00:00.000Z	Publication timestamp of the news story.
priority	integer	—	10	Display priority score (1-10).
processed_at	timestamptznullable	—	—	Timestamp when the story was processed.
situational_impact	jsonbnullable	—	[object Object]	Structured situational impact assessment and fantasy implications for the player.
source	string	—	cbs_sports	News source identifier (cbs, espn, rotoworld, sportsdata, etc.) Values`cbs_sportssportsdatarotoworldespnrotoql_sportsdata`
sources	jsonbnullable	—	[object Object]	Source citations with source name, URL, author, and published timestamp.
status_enum	stringnullable	—	ACTIVE	Standardized player status designation (RULED_OUT, DOUBTFUL, QUESTIONABLE, PROBABLE, CLEARED, MINUTES_LIMIT, MINUTES_LIFTED, STARTING, BENCHED, INACTIVE, ACTIVE, IR_PLACED, IR_ACTIVATED, TRADED, RELEASED, SIGNED, ROUTINE). Values`ACTIVEROUTINEIR_PLACEDBENCHEDINACTIVESTARTINGQUESTIONABLEIR_ACTIVATEDCLEAREDSIGNEDRULED_OUTRELEASEDPROBABLEMINUTES_LIMITTRADEDDOUBTFUL`
title	string	—	Robby Snelling Out Until at Least June 1 with Elbow Injury	Headline of the news report.
urgency	stringnullable	—	ROUTINE	Urgency level of the news event (BREAKING_GAME_TIME, HIGH, MEDIUM, ROUTINE). Values`ROUTINEHIGHMEDIUMBREAKING_GAME_TIME`

mlb.team_news12 fields· 3 refsendpoints →

News and updates about MLB teams — game previews, managerial changes, front-office moves, and beat reports.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
external_id	stringnullable	—	espn-mlb-2026-09-07-White Sox bullpen throws gem in 10-1 win	Canonical external identifier for deduplication.
game_id	bigintnullable	→ mlb.games	—	Associated game ID when news relates to a specific game.
opponent_team_id	bigintnullable	→ mlb.teams	—	Opponent team ID when news relates to an upcoming or completed game matchup.
team_id	bigint	→ mlb.teams	42	Team ID that this news event pertains to.
ai_processed	booleannullable	—	true	Whether this story was generated or enriched via LLM summarization.
category	stringnullable	—	game_preview	game_preview, coaching, transaction, general
news_time	timestamptz	—	2026-09-07T01:48:29.000Z	Publication timestamp of the team story.
sources	jsonbnullable	—	[object Object]	Source citations with publisher name, URL, author, and published timestamp.
summary	string	—	The White Sox defeated the Minnesota Twins 10-1 behind a dominant bullpen performance and a five-ru…	Concise journalistic summary of the team news event.
title	string	—	White Sox Bullpen Dominates in 10-1 Win Over Twins	Headline of the team news story.
urgency	stringnullable	—	ROUTINE	ROUTINE, MEDIUM, HIGH, BREAKING_GAME_TIME