MLB GraphQL Reference

Every MLB game from spring training through the World Series — the 162-game regular season, the postseason bracket, plus the players, ballparks, umpires, weather, Statcast metrics, and pitch-by-pitch detail.

Every GraphQL type, relation, argument, and field — generated from the served schema, so it can never disagree with the API. Each column is documented inline; relations and foreign keys link straight to the type they resolve to. Root fields take the same filters as REST; requests are metered by rows resolved, nested lists included.

Main

seasonsMLBSeasons

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.

REST endpoint →Open in playground →

Fields (9)

idBigIntkey

Primary Key

league_idStringnullable

Official MLB season identifier

start_dateString

ex: 2018-03-29T00:00:00.000Z

end_dateStringnullable

ex: 2018-10-28T00:00:00.000Z

start_yearInt

ex: 2018

regular_season_start_dateStringnullable

ex: 2018-03-29T00:00:00.000Z

post_season_start_dateStringnullable

ex: 2018-10-02T00:00:00.000Z

created_atString

updated_atString

Relations (11)

game_lines[MLBGameLines!]!→ MLBGameLines

mlb.game_lines rows whose season_id references this row.

games[MLBGames!]!→ MLBGames

mlb.games rows whose season_id references this row.

park_factors[MLBParkFactors!]!→ MLBParkFactors

mlb.park_factors rows whose season_id references this row.

player_awards[MLBPlayerAwards!]!→ MLBPlayerAwards

mlb.player_awards rows whose season_id references this row.

player_injuries[MLBPlayerInjuries!]!→ MLBPlayerInjuries

mlb.player_injuries rows whose season_id references this row.

playoffs[MLBPlayoffs!]!→ MLBPlayoffs

mlb.playoffs rows whose season_id references this row.

season_player_stats[MLBSeasonPlayerStats!]!→ MLBSeasonPlayerStats

mlb.season_player_stats rows whose season_id references this row.

season_run_environments[MLBSeasonRunEnvironments!]!→ MLBSeasonRunEnvironments

mlb.season_run_environments rows whose season_id references this row.

season_team_stats[MLBSeasonTeamStats!]!→ MLBSeasonTeamStats

mlb.season_team_stats rows whose season_id references this row.

team_player_rosters[MLBTeamPlayerRosters!]!→ MLBTeamPlayerRosters

mlb.team_player_rosters rows whose season_id references this row.

woba_weights[MLBWobaWeights!]!→ MLBWobaWeights

mlb.woba_weights rows whose season_id references this row.

Arguments (2)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.

teamsMLBTeams

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

REST endpoint →Open in playground →

Fields (13)

idBigIntkey

Primary Key

abbreviationString

ex: LAA

cityString

ex: Los Angeles

league_team_idIntnullable→ MLBTeams

Official MLB team ID from statsapi.mlb.com

ex: 108

leagueString

ex: American LeagueValues:American LeagueNational League

divisionString

ex: WestValues:WestEastCentral

full_nameString

ex: Los Angeles Angels

nameString

ex: Angels

activeBoolean

ex: true

venue_idBigIntnullable→ MLBVenues

ex: 2

logo_urlStringnullable

URL to team logo image

created_atString

updated_atString

Relations (17)

venueMLBVenues→ MLBVenues

The mlb.venues row referenced by venue_id; null when unlinked.

game_player_batter_stats[MLBGamePlayerBatterStats!]!→ MLBGamePlayerBatterStats

mlb.game_player_batter_stats rows whose team_id references this row.

game_player_pitching_stats[MLBGamePlayerPitchingStats!]!→ MLBGamePlayerPitchingStats

mlb.game_player_pitching_stats rows whose team_id references this row.

game_team_rosters[MLBGameTeamRosters!]!→ MLBGameTeamRosters

mlb.game_team_rosters rows whose team_id references this row.

game_team_stats[MLBGameTeamStats!]!→ MLBGameTeamStats

mlb.game_team_stats rows whose team_id references this row.

games_by_away_team_id[MLBGames!]!→ MLBGames

mlb.games rows whose away_team_id references this row.

games_by_home_team_id[MLBGames!]!→ MLBGames

mlb.games rows whose home_team_id references this row.

play_by_plays[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose team_id references this row.

player_awards[MLBPlayerAwards!]!→ MLBPlayerAwards

mlb.player_awards rows whose team_id references this row.

player_injuries[MLBPlayerInjuries!]!→ MLBPlayerInjuries

mlb.player_injuries rows whose team_id references this row.

player_news[MLBPlayerNews!]!→ MLBPlayerNews

mlb.player_news rows whose team_id references this row.

players[MLBPlayers!]!→ MLBPlayers

mlb.players rows whose team_id references this row.

season_team_stats[MLBSeasonTeamStats!]!→ MLBSeasonTeamStats

mlb.season_team_stats rows whose team_id references this row.

team_player_rosters[MLBTeamPlayerRosters!]!→ MLBTeamPlayerRosters

mlb.team_player_rosters rows whose team_id references this row.

team_starting_lineups[MLBTeamStartingLineups!]!→ MLBTeamStartingLineups

mlb.team_starting_lineups rows whose team_id references this row.

playoffs_by_home_team_id[MLBPlayoffs!]!→ MLBPlayoffs

mlb.playoffs rows whose home_team_id references this row.

playoffs_by_away_team_id[MLBPlayoffs!]!→ MLBPlayoffs

mlb.playoffs rows whose away_team_id references this row.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
activeBooleanFilter by active status (defaults to true to show only currently-active rows; pass active=false to include inactive).

gamesMLBGames

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.

REST endpoint →Open in playground →

Required filters: one of season_id.

Fields (33)

idBigIntkey

Primary Key

league_idStringnullable

Official MLB game identifier

season_idBigInt→ MLBSeasons

ex: 2025

game_timeString

Canonical game start time (use this over start_time)

ex: 2018-03-17T17:05:00.000Z

league_game_idIntnullable→ MLBGames

Official MLB gamePk from statsapi.mlb.com

ex: 745080

home_team_idBigInt→ MLBTeams

ex: 33

away_team_idBigInt→ MLBTeams

ex: 38

game_typeString

R=Regular, S=Spring, F=Wild Card, D=Division, L=League, W=World Series, E=Exhibition, A=All-Star

ex: RValues:RSDFLW

statusString

Final, Live, Scheduled, Postponed, Suspended, Cancelled

ex: FinalValues:FinalCompleted EarlyCancelled

end_timeStringnullable

season_typeString

Canonical season phase. Postseason round detail (Wild Card/Division/LCS/World Series) is in the league-native game_type code.

ex: regular_seasonValues:regular_seasonspring_trainingpostseason

dayInt

ex: 20180317

venue_idBigIntnullable→ MLBVenues

ex: 16

channelStringnullable

ex: MLBN (out-of-market only)

attendanceIntnullable

away_team_scoreInt

ex: 3

home_team_scoreInt

ex: 4

neutral_venueBoolean

ex: false

series_nameStringnullable

ex: Regular SeasonValues:Regular SeasonSpring TrainingNL Division SeriesAL Division SeriesAL Championship SeriesWorld SeriesAL Wild Card SeriesNL Wild Card SeriesNL Championship Series

if_necessaryBooleannullable

ex: false

series_game_numberStringnullable

ex: 1

game_labelStringnullable

ex: Regular Season Game 1

series_textStringnullable

ex: 1-0Values:1-02-12-01-13-03-12-24-00-03-23-34-34-15-04-2

postponed_statusStringnullable

doubleheaderBoolean

ex: falseValues:falsetrue

game_numberInt

For doubleheaders: 1 or 2

ex: 1

created_atString

updated_atString

winning_pitcher_idBigIntnullable

Winning pitcher of record

ex: 272

losing_pitcher_idBigIntnullable

Losing pitcher of record

ex: 1177

save_pitcher_idBigIntnullable

Save pitcher (if any)

ex: 1415

duration_minutesIntnullable

Total game duration in minutes

day_nightStringnullable

D=Day, N=Night

Relations (19)

away_teamMLBTeams→ MLBTeams

The mlb.teams row referenced by away_team_id; null when unlinked.

home_teamMLBTeams→ MLBTeams

The mlb.teams row referenced by home_team_id; null when unlinked.

losing_pitcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by losing_pitcher_id; null when unlinked.

save_pitcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by save_pitcher_id; null when unlinked.

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

venueMLBVenues→ MLBVenues

The mlb.venues row referenced by venue_id; null when unlinked.

winning_pitcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by winning_pitcher_id; null when unlinked.

at_bats[MLBAtBats!]!→ MLBAtBats

mlb.at_bats rows whose game_id references this row.

game_lines[MLBGameLines!]!→ MLBGameLines

mlb.game_lines rows whose game_id references this row.

game_player_batter_stats[MLBGamePlayerBatterStats!]!→ MLBGamePlayerBatterStats

mlb.game_player_batter_stats rows whose game_id references this row.

game_player_pitching_stats[MLBGamePlayerPitchingStats!]!→ MLBGamePlayerPitchingStats

mlb.game_player_pitching_stats rows whose game_id references this row.

game_team_rosters[MLBGameTeamRosters!]!→ MLBGameTeamRosters

mlb.game_team_rosters rows whose game_id references this row.

game_team_stats[MLBGameTeamStats!]!→ MLBGameTeamStats

mlb.game_team_stats rows whose game_id references this row.

game_umpires[MLBGameUmpires!]!→ MLBGameUmpires

mlb.game_umpires rows whose game_id references this row.

innings[MLBInnings!]!→ MLBInnings

mlb.innings rows whose game_id references this row.

pitches[MLBPitches!]!→ MLBPitches

mlb.pitches rows whose game_id references this row.

play_by_plays[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose game_id references this row.

team_starting_lineups[MLBTeamStartingLineups!]!→ MLBTeamStartingLineups

mlb.team_starting_lineups rows whose game_id references this row.

venue_weathers[MLBVenueWeathers!]!→ MLBVenueWeathers

mlb.venue_weathers rows whose game_id references this row.

Arguments (10)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
season_idIntFilter to a season. Defaults to the current season.
home_team_idIntFilter by home team.
away_team_idIntFilter by away team.
statusStringFilter by game status.
dayIntFilter by calendar day (YYYYMMDD integer, US Eastern) — e.g. day=20260609 for today's slate. season_id defaults to the current season; pass it explicitly for past-season days.
day__gteIntgte comparison on day.
day__lteIntlte comparison on day.
day__betweenStringRange filter on day — pass "lo,hi".

playersMLBPlayers

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.

REST endpoint →Open in playground →

Required filters: one of team_id | roster_status.

Fields (31)

idBigIntkey

Primary Key

league_idStringnullable

Official MLB player identifier

first_nameString

ex: Ryan

last_nameString

ex: Rodriguez

full_nameString

ex: Luis Ortiz

jerseyStringnullable

ex: 52

league_player_idInt→ MLBPlayers

Official MLB player ID from statsapi.mlb.com

ex: 613534

primary_positionString

ex: P

full_position_listStringnullable

ex: PitcherValues:PitcherOutfielderCatcherSecond BaseThird BaseFirst BaseShortstopOutfieldDesignated HitterInfieldTwo-Way Player

team_idBigIntnullable→ MLBTeams

ex: 16

league_slugStringnullable

ex: austin-adams-613534

position_categoryStringnullable

ex: PitcherValues:PitcherInfielderOutfielderCatcherUtility

heightIntnullable

ex: 74

weightIntnullable

ex: 215

birth_dateStringnullable

ex: 1994-07-14T04:00:00.000Z

birth_cityStringnullable

ex: Santo Domingo

birth_stateStringnullable

ex: CA

birth_countryStringnullable

ex: USA

schoolStringnullable

debut_dateStringnullable

ex: 2023-03-30T00:00:00.000Z

display_last_comma_firstStringnullable

ex: Davis, Jonathan

display_fi_lastStringnullable

ex: R. Rodríguez

batsStringnullable

ex: RValues:RLS

throwsStringnullable

ex: RValues:RLS

draft_yearStringnullable

ex: 2019

draft_roundStringnullable

draft_numberStringnullable

roster_statusStringnullable

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

ex: inactiveValues:inactiveactivenon_rosterinjured_reserve

profile_pic_urlStringnullable

URL to player profile picture image

created_atString

updated_atString

Relations (26)

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

at_bats_by_batter_id[MLBAtBats!]!→ MLBAtBats

mlb.at_bats rows whose batter_id references this row.

at_bats_by_pitcher_id[MLBAtBats!]!→ MLBAtBats

mlb.at_bats rows whose pitcher_id references this row.

game_player_batter_stats[MLBGamePlayerBatterStats!]!→ MLBGamePlayerBatterStats

mlb.game_player_batter_stats rows whose player_id references this row.

game_player_pitching_stats[MLBGamePlayerPitchingStats!]!→ MLBGamePlayerPitchingStats

mlb.game_player_pitching_stats rows whose player_id references this row.

game_team_rosters[MLBGameTeamRosters!]!→ MLBGameTeamRosters

mlb.game_team_rosters rows whose player_id references this row.

games_by_losing_pitcher_id[MLBGames!]!→ MLBGames

mlb.games rows whose losing_pitcher_id references this row.

games_by_save_pitcher_id[MLBGames!]!→ MLBGames

mlb.games rows whose save_pitcher_id references this row.

games_by_winning_pitcher_id[MLBGames!]!→ MLBGames

mlb.games rows whose winning_pitcher_id references this row.

operator_player_lookups[MLBOperatorPlayerLookups!]!→ MLBOperatorPlayerLookups

mlb.operator_player_lookups rows whose player_id references this row.

pitches_by_batter_id[MLBPitches!]!→ MLBPitches

mlb.pitches rows whose batter_id references this row.

pitches_by_pitcher_id[MLBPitches!]!→ MLBPitches

mlb.pitches rows whose pitcher_id references this row.

play_by_plays_by_batter_id[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose batter_id references this row.

play_by_plays_by_catcher_id[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose catcher_id references this row.

play_by_plays_by_first_base_runner_id[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose first_base_runner_id references this row.

play_by_plays_by_pitcher_id[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose pitcher_id references this row.

play_by_plays_by_player_id[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose player_id references this row.

play_by_plays_by_second_base_runner_id[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose second_base_runner_id references this row.

play_by_plays_by_third_base_runner_id[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose third_base_runner_id references this row.

player_awards[MLBPlayerAwards!]!→ MLBPlayerAwards

mlb.player_awards rows whose player_id references this row.

player_injuries[MLBPlayerInjuries!]!→ MLBPlayerInjuries

mlb.player_injuries rows whose player_id references this row.

player_news[MLBPlayerNews!]!→ MLBPlayerNews

mlb.player_news rows whose player_id references this row.

season_player_stats[MLBSeasonPlayerStats!]!→ MLBSeasonPlayerStats

mlb.season_player_stats rows whose player_id references this row.

team_player_rosters[MLBTeamPlayerRosters!]!→ MLBTeamPlayerRosters

mlb.team_player_rosters rows whose player_id references this row.

team_starting_lineup_batters[MLBTeamStartingLineupBatters!]!→ MLBTeamStartingLineupBatters

mlb.team_starting_lineup_batters rows whose player_id references this row.

team_starting_lineups[MLBTeamStartingLineups!]!→ MLBTeamStartingLineups

mlb.team_starting_lineups rows whose pitcher_id references this row.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
team_idIntFilter to players whose current team_id matches. Null team_id rows (free agents, retired) are excluded when this filter is applied.
roster_statusStringFilter by canonical roster status. The "on a team now" set is {active, injured_reserve, non_roster} (active 26-man, injured list, and 40-man-but-optioned); free_agent/retired/inactive are off-roster.

Plays

inningsMLBInnings

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (12)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 357

inning_numberInt

ex: 1

inning_halfString

ex: TOPValues:TOPBOTTOM

home_team_runsInt

ex: 0

away_team_runsInt

ex: 0

home_team_hitsInt

ex: 0

away_team_hitsInt

ex: 0

home_team_errorsInt

ex: 0

away_team_errorsInt

ex: 0

created_atString

updated_atString

Relations (3)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

at_bats[MLBAtBats!]!→ MLBAtBats

mlb.at_bats rows whose inning_id references this row.

play_by_plays[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose inning_id references this row.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.

pitchesMLBPitches

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (74)

idBigIntkey

Primary Key

play_idBigInt

ex: 12

game_idBigInt→ MLBGames

ex: 84

pitcher_idBigInt

ex: 267

batter_idBigInt

ex: 306

at_bat_idBigInt

ex: 1494

pitch_numberInt

ex: 1

pitch_typeStringnullable

ex: FFValues:FFSISLCHFCSTCUFSKCSVFA

pitch_speedFloatnullable

ex: 92.6

pitch_zoneIntnullable

ex: 14

strike_zone_topFloatnullable

ex: 3.51

strike_zone_bottomFloatnullable

ex: 1.63

pitch_xFloatnullable

ex: 0.36271081581727094

pitch_yFloatnullable

ex: 155.85

pitch_zFloatnullable

ex: 3.5469804155056193

plate_xFloatnullable

ex: 125.18

plate_zFloatnullable

ex: 155.85

extensionFloatnullable

ex: 7.015639833312882

break_angleFloatnullable

ex: 1.2

break_lengthFloatnullable

ex: 3.6

break_yFloatnullable

ex: 24

spin_rateFloatnullable

ex: 2190

spin_directionFloatnullable

ex: 211

resultString

ex: BallValues:BallFoulCalled StrikeIn play, out(s)Swinging StrikeIn play, no outIn play, run(s)Ball In DirtFoul TipSwinging Strike (Blocked)Hit By PitchFoul BuntPitchoutMissed Bunt

callString

ex: BallValues:BallFoulCalled StrikeIn play, out(s)Swinging StrikeIn play, no outIn play, run(s)Ball In DirtFoul TipSwinging Strike (Blocked)Hit By PitchFoul BuntPitchoutMissed Bunt

strikeBoolean

ex: falseValues:falsetrue

ballBoolean

ex: falseValues:falsetrue

in_playBoolean

ex: falseValues:falsetrue

singleBoolean

Whether this pitch resulted in a single

ex: falseValues:falsetrue

doubleBoolean

Whether this pitch resulted in a double

ex: falseValues:falsetrue

tripleBoolean

Whether this pitch resulted in a triple

ex: falseValues:falsetrue

home_runBoolean

Whether this pitch resulted in a home run

ex: falseValues:falsetrue

walkBoolean

Whether this pitch resulted in a walk

ex: falseValues:falsetrue

strikeoutBoolean

Whether this pitch resulted in a strikeout

ex: falseValues:falsetrue

hit_by_pitchBoolean

Whether this pitch resulted in hit by pitch

ex: falseValues:falsetrue

sacrifice_hitBoolean

Whether this pitch resulted in a sacrifice bunt

ex: falseValues:falsetrue

sacrifice_flyBoolean

Whether this pitch resulted in a sacrifice fly

ex: falseValues:falsetrue

intentional_walkBoolean

Whether this pitch resulted in an intentional walk

ex: false

ground_into_double_playBoolean

Whether this pitch resulted in grounding into double play

ex: false

ground_into_triple_playBoolean

Whether this pitch resulted in grounding into triple play

ex: false

fly_outBoolean

Whether this pitch resulted in a fly out

ex: falseValues:falsetrue

ground_outBoolean

Whether this pitch resulted in a ground out

ex: falseValues:falsetrue

line_outBoolean

Whether this pitch resulted in a line out

ex: falseValues:falsetrue

pop_outBoolean

Whether this pitch resulted in a pop out

ex: falseValues:falsetrue

air_outBoolean

Whether this pitch resulted in an air out

ex: false

catchers_interferenceBoolean

Whether this pitch resulted in catchers interference

ex: false

hit_exit_velocityFloatnullable

Exit velocity of batted ball (mph)

ex: 103.4

hit_launch_angleFloatnullable

Launch angle of batted ball (degrees)

ex: 5

hit_distanceIntnullable

Distance of batted ball (feet)

ex: 4

hit_coord_xFloatnullable

Hit coordinate X (feet from home plate)

ex: 153.39

hit_coord_yFloatnullable

Hit coordinate Y (feet from home plate)

ex: 167.3

spray_angleFloatnullable

Horizontal angle from center field (degrees)

ex: -6.1

hard_hitBooleannullable

Exit velocity >= 95 MPH

ex: falseValues:falsetrue

barrelBooleannullable

Optimal combination of exit velocity and launch angle

ex: falseValues:falsetrue

sweet_spotBooleannullable

Launch angle between 8-32 degrees

ex: falseValues:falsetrue

underBooleannullable

Launch angle less than 10 degrees

ex: falseValues:falsetrue

toppedBooleannullable

Launch angle < 10 AND exit velocity < 90

ex: falseValues:falsetrue

flare_burnerBooleannullable

Launch angle 10-25 AND exit velocity < 95

ex: falseValues:falsetrue

solid_contactBooleannullable

Launch angle 20-25 AND exit velocity 95-100

ex: falseValues:falsetrue

expected_batting_avgFloatnullable

xBA based on exit velocity and launch angle

expected_wobaFloatnullable

xwOBA based on exit velocity and launch angle

launch_speed_angle_zoneIntnullable

1=Weak, 2=Topped, 3=Under, 4=Flare/Burner, 5=Solid, 6=Barrel

ex: 3

statcast_quality_scoreFloatnullable

Statcast data quality score (0.0-1.0)

tracking_confidenceFloatnullable

Confidence in tracking data accuracy

in_strike_zoneBooleannullable

Whether pitch was in the strike zone

ex: falseValues:falsetrue

chaseBooleannullable

Whether batter swung at pitch outside zone

ex: true

fastballBooleannullable

Fastball variant (4-seam, 2-seam, sinker, cutter)

ex: trueValues:truefalse

breaking_ballBooleannullable

Breaking ball (curveball, slider, knuckleball)

ex: falseValues:falsetrue

offspeedBooleannullable

Offspeed pitch (changeup, splitter, forkball)

ex: falseValues:falsetrue

spin_axisFloatnullable

Spin axis (degrees)

release_speedFloatnullable

Speed at release point (mph)

ex: 92.6

effective_speedFloatnullable

Perceived speed to batter (mph)

ex: 85.3

created_atString

updated_atString

Relations (5)

at_batMLBAtBats→ MLBAtBats

The mlb.at_bats row referenced by at_bat_id; null when unlinked.

batterMLBPlayers→ MLBPlayers

The mlb.players row referenced by batter_id; null when unlinked.

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

pitcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by pitcher_id; null when unlinked.

playMLBPlayByPlays→ MLBPlayByPlays

The mlb.play_by_plays row referenced by play_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.

at_batsMLBAtBats

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (37)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 69

inning_idBigInt→ MLBInnings

ex: 908

pitcher_idBigInt

ex: 174

batter_idBigInt

ex: 996

at_bat_numberInt

ex: 0

start_outsInt

ex: 1

end_outsInt

ex: 2

start_runnersInt

ex: 0

end_runnersInt

ex: 0

runs_scoredInt

ex: 0

resultString

ex: Strikeout

pitch_countInt

ex: 4

ballsInt

ex: 0

strikesInt

ex: 2

hit_typeStringnullable

ex: ground_ballValues:ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup

hit_locationStringnullable

ex: ground_ballValues:ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup

hit_distanceIntnullable

ex: 4

hit_exit_velocityFloatnullable

ex: 98.4

hit_launch_angleFloatnullable

ex: 5

hit_coord_xFloatnullable

ex: 104.05

hit_coord_yFloatnullable

ex: 149.88

is_hard_hitBooleannullable

ex: falseValues:falsetrue

is_barrelBooleannullable

ex: falseValues:falsetrue

expected_batting_avgFloatnullable

ex: 0.0050

expected_wobaFloatnullable

ex: 0.0000

launch_speed_angle_zoneIntnullable

ex: 3

spray_angleFloatnullable

Horizontal angle from center field (degrees)

ex: -6

is_sweet_spotBooleannullable

Launch angle between 8-32 degrees

ex: falseValues:falsetrue

is_underBooleannullable

Launch angle less than 10 degrees

ex: falseValues:falsetrue

is_toppedBooleannullable

Launch angle < 10 AND exit velocity < 90

ex: falseValues:falsetrue

is_flare_burnerBooleannullable

Launch angle 10-25 AND exit velocity < 95

ex: falseValues:falsetrue

is_solid_contactBooleannullable

Launch angle 20-25 AND exit velocity 95-100

ex: falseValues:falsetrue

statcast_quality_scoreFloatnullable

Statcast data quality score (0.0-1.0)

ex: 1.0000

tracking_confidenceFloatnullable

Confidence in tracking data accuracy

created_atString

updated_atString

Relations (6)

batterMLBPlayers→ MLBPlayers

The mlb.players row referenced by batter_id; null when unlinked.

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

inningMLBInnings→ MLBInnings

The mlb.innings row referenced by inning_id; null when unlinked.

pitcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by pitcher_id; null when unlinked.

pitches[MLBPitches!]!→ MLBPitches

mlb.pitches rows whose at_bat_id references this row.

play_by_plays[MLBPlayByPlays!]!→ MLBPlayByPlays

mlb.play_by_plays rows whose at_bat_id references this row.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.

play_by_playsMLBPlayByPlays

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.

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (25)

idBigIntkey

Primary Key

play_idBigInt

ex: 0

mlb_event_numInt

ex: 0

game_idBigInt→ MLBGames

ex: 69

inning_idBigInt→ MLBInnings

ex: 908

player_idBigIntnullable→ MLBPlayers

ex: 996

team_idBigInt→ MLBTeams

ex: 19

event_typeInt

ex: 8

event_sub_typeInt

ex: 0

descriptionString

count_ballsInt

ex: 0

count_strikesInt

ex: 2

outsInt

ex: 1

runners_on_baseInt

ex: 0

pitcher_idBigIntnullable

ex: 174

batter_idBigIntnullable

ex: 996

catcher_idBigIntnullable

first_base_runner_idBigIntnullable

ex: 996

second_base_runner_idBigIntnullable

ex: 996

third_base_runner_idBigIntnullable

ex: 996

hit_locationStringnullable

ex: ground_ballValues:ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup

hit_typeStringnullable

ex: ground_ballValues:ground_ballfly_ballline_drivepopupbunt_grounderbunt_popup

at_bat_idBigIntnullable

ex: 1

created_atString

updated_atString

Relations (12)

at_batMLBAtBats→ MLBAtBats

The mlb.at_bats row referenced by at_bat_id; null when unlinked.

batterMLBPlayers→ MLBPlayers

The mlb.players row referenced by batter_id; null when unlinked.

catcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by catcher_id; null when unlinked.

first_base_runnerMLBPlayers→ MLBPlayers

The mlb.players row referenced by first_base_runner_id; null when unlinked.

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

inningMLBInnings→ MLBInnings

The mlb.innings row referenced by inning_id; null when unlinked.

pitcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by pitcher_id; null when unlinked.

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

second_base_runnerMLBPlayers→ MLBPlayers

The mlb.players row referenced by second_base_runner_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

third_base_runnerMLBPlayers→ MLBPlayers

The mlb.players row referenced by third_base_runner_id; null when unlinked.

pitches[MLBPitches!]!→ MLBPitches

mlb.pitches rows whose play_id references this row.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.

Stats

season_team_statsMLBSeasonTeamStats

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

REST endpoint →Open in playground →

Required filters: one of season_id.

Fields (38)

idBigIntkey

Primary Key

team_idBigInt→ MLBTeams

ex: 16

season_idBigInt→ MLBSeasons

ex: 2024

games_playedInt

ex: 162

winsInt

ex: 90

lossesInt

ex: 72

tiesInt

ex: 0

runs_scoredInt

ex: 769

runs_allowedInt

ex: 699

at_batsInt

ex: 5522

hitsInt

ex: 1423

doublesInt

ex: 264

triplesInt

ex: 12

home_runsInt

ex: 182

runs_batted_inInt

ex: 655

stolen_basesInt

ex: 88

caught_stealingInt

ex: 30

walksInt

ex: 478

strikeoutsInt

ex: 1461

batting_averageFloat

ex: 0.2440

on_base_percentageFloat

ex: 0.3150

slugging_percentageFloat

ex: 0.3960

on_base_plus_sluggingFloat

ex: 0.7070

innings_pitchedFloat

Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)

ex: 1442.0000

earned_runsInt

ex: 596

earned_run_averageFloat

ex: 3.7400

whipFloat

ex: 1.2400

complete_gamesInt

ex: 0

shutoutsInt

ex: 8

savesInt

ex: 40

save_opportunitiesInt

ex: 64

holdsInt

ex: 83

blown_savesInt

ex: 28

errorsInt

ex: 97

fielding_percentageFloat

ex: 0.9840

double_playsInt

ex: 125

created_atString

updated_atString

Relations (2)

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
season_idIntFilter to a season. Defaults to the current season.
team_idIntFilter by team.

game_player_batter_statsMLBGamePlayerBatterStats

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.

REST endpoint →Open in playground →

Required filters: one of game_id | player_id.

Fields (44)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 64

team_idBigInt→ MLBTeams

ex: 41

player_idBigInt→ MLBPlayers

ex: 604

at_batsInt

ex: 3

plate_appearancesInt

ex: 4

runsInt

ex: 0

hitsInt

ex: 0

singlesInt

ex: 0

doublesInt

ex: 0

triplesInt

ex: 0

home_runsInt

ex: 0

runs_batted_inInt

ex: 0

batting_averageFloat

ex: 0.0000

stolen_basesInt

ex: 0

caught_stealingInt

ex: 0

strikeoutsInt

ex: 0

walksInt

ex: 0

hit_by_pitchInt

ex: 0

sacrificesInt

ex: 0

sacrifice_fliesInt

ex: 0

ground_into_double_playInt

ex: 0

ground_into_triple_playInt

ex: 0

on_base_percentageFloat

ex: 0.0000

slugging_percentageFloat

ex: 0.0000

on_base_plus_sluggingFloat

ex: 0.0000

total_basesInt

ex: 0

fly_outsInt

ex: 0

ground_outsInt

ex: 0

line_outsInt

ex: 0

pop_outsInt

ex: 0

air_outsInt

ex: 0

intentional_walksInt

ex: 0

left_on_baseInt

ex: 0

balls_in_playInt

ex: 0

babipFloat

ex: 0.0000

isolated_powerFloat

ex: 0.0000

wobaFloat

ex: 0.0000

double_playsInt

ex: 0

catchers_interferenceInt

ex: 0

pickoffsInt

ex: 0

at_bats_per_home_runFloat

ex: 0.0000

created_atString

updated_atString

Relations (3)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.
player_idIntFilter to a single player.

game_player_pitching_statsMLBGamePlayerPitchingStats

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.

REST endpoint →Open in playground →

Required filters: one of game_id | player_id.

Fields (70)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 64

team_idBigInt→ MLBTeams

ex: 33

player_idBigInt→ MLBPlayers

ex: 1382

winInt

ex: 0

lossInt

ex: 0

saveInt

ex: 0

holdInt

ex: 0

blown_saveInt

ex: 0

innings_pitchedFloat

Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)

ex: 1.0000

hits_allowedInt

ex: 0

runs_allowedInt

ex: 0

earned_runsInt

ex: 0

walks_allowedInt

ex: 0

strikeouts_pitchedInt

ex: 0

home_runs_allowedInt

ex: 0

batters_facedInt

ex: 3

pitches_thrownInt

ex: 0

strikesInt

ex: 0

earned_run_averageFloat

ex: 0.0000

whipFloat

ex: 0.0000

singles_allowedInt

ex: 0

doubles_allowedInt

ex: 0

triples_allowedInt

ex: 0

grand_slams_allowedInt

ex: 0

hit_by_pitchInt

ex: 0

sacrifices_allowedInt

ex: 0

sacrifice_flies_allowedInt

ex: 0

ground_into_double_playInt

ex: 0

complete_gamesInt

ex: 0

shutoutsInt

ex: 0

no_hittersInt

ex: 0

perfect_gamesInt

ex: 0

plate_appearancesInt

ex: 0

total_bases_allowedInt

ex: 0

fly_outsInt

ex: 0

ground_outsInt

ex: 0

line_outsInt

ex: 0

pop_outsInt

ex: 0

air_outsInt

ex: 0

intentional_walksInt

ex: 0

balls_in_playInt

ex: 0

on_base_percentageFloat

ex: 0.0000

slugging_percentageFloat

ex: 0.0000

on_base_plus_sluggingFloat

ex: 0.0000

strikeouts_per_nineFloat

ex: 0.0000

walks_per_nineFloat

ex: 0.0000

home_runs_per_nineFloat

ex: 0.0000

runs_scored_per_nineFloat

ex: 0.0000

babipFloat

ex: 0.0000

wobaFloat

ex: 0.0000

double_playsInt

ex: 0

fipFloat

ex: 3.1000

quality_startsInt

ex: 0

inning_startedInt

ex: 0

left_on_baseFloat

ex: 0.0000

strike_percentageFloat

ex: 0.0000

ballsInt

ex: 0

balksInt

ex: 0

wild_pitchesInt

ex: 0

pickoffsInt

ex: 0

inherited_runnersInt

ex: 0

inherited_runners_scoredInt

ex: 0

games_pitchedInt

ex: 1

games_startedInt

ex: 0

games_finishedInt

ex: 0

outsInt

ex: 3

catchers_interferenceInt

ex: 0

created_atString

updated_atString

Relations (3)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.
player_idIntFilter to a single player.

game_team_statsMLBGameTeamStats

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (39)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 1454

team_idBigInt→ MLBTeams

ex: 27

winInt

ex: 0

lossInt

ex: 0

runsInt

ex: 3

hitsInt

ex: 7

errorsInt

ex: 0

left_on_baseInt

ex: 6

doublesInt

ex: 1

triplesInt

ex: 0

home_runsInt

ex: 1

runs_batted_inInt

ex: 2

stolen_basesInt

ex: 0

caught_stealingInt

ex: 0

walksInt

ex: 2

strikeoutsInt

ex: 8

hit_by_pitchInt

ex: 0

sacrifice_hitsInt

ex: 0

sacrifice_fliesInt

ex: 0

grounded_into_double_playInt

ex: 0

batting_averageFloat

ex: 0.2440

on_base_percentageFloat

ex: 0.3150

slugging_percentageFloat

ex: 0.4070

on_base_plus_sluggingFloat

ex: 0.7240

innings_pitchedFloat

Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)

ex: 9.0000

earned_runsInt

ex: 2

earned_run_averageFloat

ex: 3.7700

batters_facedInt

ex: 36

pitches_thrownInt

ex: 143

strikesInt

ex: 93

wild_pitchesInt

ex: 0

balksInt

ex: 0

putoutsInt

ex: 27

assistsInt

ex: 9

double_plays_turnedInt

ex: 0

passed_ballsInt

ex: 0

created_atString

updated_atString

Relations (2)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.
team_idIntFilter by team.

season_player_statsMLBSeasonPlayerStats

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.

REST endpoint →Open in playground →

Required filters: one of season_id | player_id.

Fields (71)

idBigIntkey

Primary Key

player_idBigInt→ MLBPlayers

ex: 1439

season_idBigInt→ MLBSeasons

ex: 2024

games_playedInt

ex: 0

games_startedInt

ex: 0

at_batsInt

ex: 0

plate_appearancesInt

ex: 0

hitsInt

ex: 0

doublesInt

ex: 0

triplesInt

ex: 0

home_runsInt

ex: 0

runsInt

ex: 0

runs_batted_inInt

ex: 0

stolen_basesInt

ex: 0

caught_stealingInt

ex: 0

walksInt

ex: 0

strikeoutsInt

ex: 0

hit_by_pitchInt

ex: 0

sacrifice_hitsInt

ex: 0

sacrifice_fliesInt

ex: 0

grounded_into_double_playInt

ex: 0

batting_averageFloat

ex: 0.0000

on_base_percentageFloat

ex: 0.0000

slugging_percentageFloat

ex: 0.0000

on_base_plus_sluggingFloat

ex: 0.0000

winsInt

ex: 0

lossesInt

ex: 0

games_pitchedInt

ex: 0

games_started_pitchingInt

ex: 0

complete_gamesInt

ex: 0

shutoutsInt

ex: 0

savesInt

ex: 0

save_opportunitiesInt

ex: 0

holdsInt

ex: 0

blown_savesInt

ex: 0

innings_pitchedFloat

Innings pitched in MLB notation (6.2 = 6 and 2/3 innings)

ex: 0.0000

hits_allowedInt

ex: 0

runs_allowedInt

ex: 0

earned_runsInt

ex: 0

walks_allowedInt

ex: 0

strikeouts_pitchedInt

ex: 0

home_runs_allowedInt

ex: 0

batters_facedInt

ex: 0

earned_run_averageFloat

ex: 0.0000

whipFloat

ex: 0.0000

strikeouts_per_nineFloat

ex: 0.0000

walks_per_nineFloat

ex: 0.0000

hits_per_nineFloat

ex: 0.0000

home_runs_per_nineFloat

ex: 0.0000

fielding_positionString

ex: PValues:PC2BLFRFCF3B1BSSXDH

fielding_gamesInt

ex: 0

fielding_games_startedInt

ex: 0

total_chancesInt

ex: 0

putoutsInt

ex: 0

assistsInt

ex: 0

errorsInt

ex: 0

double_playsInt

ex: 0

fielding_percentageFloat

ex: 0.0000

passed_ballsInt

ex: 0

stolen_bases_allowedInt

ex: 0

caught_stealing_byInt

ex: 0

created_atString

updated_atString

singlesIntnullable

Derivable from hits - doubles - triples - home_runs

ex: 0

total_basesIntnullable

Derivable: 1B + 2*2B + 3*3B + 4*HR

ex: 0

intentional_walksIntnullable

ex: 0

left_on_baseIntnullable

ex: 0

pitches_thrownIntnullable

ex: 0

strikesIntnullable

ex: 0

ballsIntnullable

ex: 0

quality_startsIntnullable

ex: 0

Relations (2)

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
season_idIntFilter to a season. Defaults to the current season.
player_idIntFilter to a single player.

Advanced Stats

park_factorsMLBParkFactors

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.

REST endpoint →Open in playground →

Required filters: one of venue_id.

Fields (20)

idBigIntkey

Primary Key

venue_idBigInt→ MLBVenues

ex: 12

season_idBigInt→ MLBSeasons

ex: 2024

home_run_factorFloat

Park factor for home runs (1.0 = neutral)

ex: 1.3300

single_factorFloat

Park factor for singles

ex: 1.1100

double_factorFloat

Park factor for doubles

ex: 1.2600

triple_factorFloat

Park factor for triples

ex: 1.4200

walk_factorFloat

Park factor for walks

ex: 1.0100

strikeout_factorFloat

Park factor for strikeouts

ex: 0.8900

left_handed_factorFloat

Park factor for left-handed batters

ex: 1.1400

right_handed_factorFloat

Park factor for right-handed batters

ex: 1.1800

basic_park_factorFloat

Overall park factor for runs (1.0 = neutral)

ex: 1.2200

handedness_factorFloat

Park effect on handedness advantage

ex: 1.1600

years_of_dataInt

Number of years used to calculate factors

ex: 3

updated_dateString

ex: 2026-04-12T02:04:46.363Z

created_atString

updated_atString

fly_ball_factorFloatnullable

Park factor for fly balls

ground_ball_factorFloatnullable

Park factor for ground balls

run_factorFloatnullable

Park factor for total runs

Relations (2)

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

venueMLBVenues→ MLBVenues

The mlb.venues row referenced by venue_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
venue_idIntFilter by venue.
season_idIntFilter to a season.

season_run_environmentsMLBSeasonRunEnvironments

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.

REST endpoint →Open in playground →

Required filters: one of season_id.

Fields (12)

idBigIntkey

Primary Key

season_idBigInt→ MLBSeasons

ex: 2021

runs_per_plate_appearanceFloat

League average runs per plate appearance

ex: 0.1250

runs_per_outFloat

League average runs per out made

ex: 0.2810

home_run_per_fly_ballFloat

League average HR/FB rate

ex: 0.1390

batting_average_on_balls_in_playFloat

League average BABIP

ex: 0.2930

strikeout_rateFloat

League average strikeout rate

ex: 0.2440

walk_rateFloat

League average walk rate

ex: 0.0890

fip_constantFloat

FIP constant to scale FIP to ERA

ex: 3.1340

updated_dateString

ex: 2026-04-12T02:04:46.337Z

created_atString

updated_atString

Relations (1)

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
season_idIntFilter to a season. Defaults to the current season.

woba_weightsMLBWobaWeights

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

REST endpoint →Open in playground →

Fields (14)

idBigIntkey

Primary Key

season_idBigInt→ MLBSeasons

ex: 2021

walk_weightFloat

Weight for unintentional walks (wBB)

ex: 0.6920

hit_by_pitch_weightFloat

Weight for hit by pitch (wHBP)

ex: 0.7230

single_weightFloat

Weight for singles (w1B)

ex: 0.8950

double_weightFloat

Weight for doubles (w2B)

ex: 1.2710

triple_weightFloat

Weight for triples (w3B)

ex: 1.5520

home_run_weightFloat

Weight for home runs (wHR)

ex: 2.1010

league_wobaFloat

League average wOBA for the season

ex: 0.3180

league_obpFloat

League average OBP for calibration

ex: 0.3180

woba_scaleFloat

Scale factor to convert wOBA to runs

ex: 1.2160

updated_dateString

When these weights were last updated

ex: 2026-04-12T02:04:46.328Z

created_atString

updated_atString

Relations (1)

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

Arguments (2)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.

Odds

game_linesMLBGameLines

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (20)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 162977

season_idBigInt→ MLBSeasons

Denormalized for efficient season-level queries

ex: 2026

operator_idBigInt→ ReferenceOperators

Data source (consensus, DraftKings, FanDuel, etc.)

ex: 6

spreadFloatnullable

Home team run line (e.g., -1.5 means home favored by 1.5 runs)

ex: 1.5000

spread_home_oddsIntnullable

American odds for home run line (e.g., -130)

ex: -110

spread_away_oddsIntnullable

American odds for away run line

ex: -110

moneyline_homeIntnullable

American odds for home team win

ex: -105

moneyline_awayIntnullable

American odds for away team win

ex: 109

totalFloatnullable

Combined run total line (e.g., 8.5)

ex: 8.5000

over_oddsIntnullable

American odds for over

ex: -110

under_oddsIntnullable

American odds for under

ex: -110

implied_home_scoreFloatnullable

Calculated from spread + total

ex: 3.5000

implied_away_scoreFloatnullable

ex: 5.0000

implied_home_win_pctFloatnullable

From moneyline, 0-1

ex: 0.5122

implied_away_win_pctFloatnullable

ex: 0.4785

captured_atString

When this snapshot was captured

ex: 2026-06-21T16:09:37.291Z

is_openingBoolean

True if this is the opening line

ex: falseValues:falsetrue

created_atString

updated_atString

Relations (3)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.

Lineups & Roster

game_team_rostersMLBGameTeamRosters

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.

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (12)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 14259

team_idBigInt→ MLBTeams

ex: 27

player_idBigInt→ MLBPlayers

ex: 1365

positionStringnullable

ex: PValues:PC2BLF1BCF3BRFSSPHDHPR

statusStringnullable

ex: Active

commentStringnullable

starterBoolean

ex: falseValues:falsetrue

dayInt

ex: 20180929

batting_orderIntnullable

ex: 9

created_atString

updated_atString

Relations (3)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.

team_player_rostersMLBTeamPlayerRosters

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.

REST endpoint →Open in playground →

Required filters: one of team_id.

Fields (11)

idBigIntkey

Primary Key

team_idBigInt→ MLBTeams

ex: 30

player_idBigInt→ MLBPlayers

ex: 165

season_idBigInt→ MLBSeasons

ex: 2024

positionStringnullable

ex: PValues:PCRF3BLF2B1BCFSSDHOFIFTWP

position_groupStringnullable

ex: PitcherValues:PitcherInfielderOutfielderCatcherHitterTwo-Way Player

roster_typeString

ex: 40ManValues:40ManactivefullSeason

position_depthIntnullable

ex: 1

dayInt

ex: 172

created_atString

updated_atString

Relations (3)

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
team_idIntFilter by team.

team_starting_lineup_battersMLBTeamStartingLineupBatters

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

REST endpoint →Open in playground →

Required filters: one of team_starting_lineup_id.

Fields (7)

idBigIntkey

Primary Key

team_starting_lineup_idBigInt

ex: 1

player_idBigInt→ MLBPlayers

ex: 1040

batting_orderString

ex: 1

positionString

ex: SSValues:SS3BRF2BCF1BLFCDHPPHPR

created_atString

updated_atString

Relations (2)

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

team_starting_lineupMLBTeamStartingLineups→ MLBTeamStartingLineups

The mlb.team_starting_lineups row referenced by team_starting_lineup_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
team_starting_lineup_idIntFilter to a single starting lineup.

team_starting_lineupsMLBTeamStartingLineups

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

REST endpoint →Open in playground →

Required filters: one of team_id | game_id.

Fields (8)

idBigIntkey

Primary Key

team_idBigInt→ MLBTeams

ex: 27

game_idBigInt→ MLBGames

ex: 64

pitcher_idBigIntnullable

ex: 50028

pitcher_statusInt

ex: 1

batter_statusInt

ex: 1

created_atString

updated_atString

Relations (4)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

pitcherMLBPlayers→ MLBPlayers

The mlb.players row referenced by pitcher_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

team_starting_lineup_batters[MLBTeamStartingLineupBatters!]!→ MLBTeamStartingLineupBatters

mlb.team_starting_lineup_batters rows whose team_starting_lineup_id references this row.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
team_idIntFilter by team.
game_idIntFilter to a single game.

Misc

venuesMLBVenues

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

REST endpoint →Open in playground →

Fields (23)

idBigIntkey

Primary Key

nameString

ex: Sutter Health Park

league_venue_idIntnullable→ MLBVenues

Official MLB venue ID from statsapi.mlb.com

ex: 2523

longitudeFloatnullable

ex: -82.5055

latitudeFloatnullable

ex: 27.9778

elevationFloatnullable

Elevation in feet above sea level

ex: 596

orientationFloatnullable

Field orientation in degrees (0-360). Direction home plate faces. 0/360=North, 90=East, 180=South, 270=West

ex: 45

descriptionStringnullable

cityString

ex: West Sacramento

stateStringnullable

ex: CAValues:CAFLILOHTXMONYPAAZGAMDMACOMIWIMNWAONDC

countryStringnullable

ex: USAValues:USACAN

capacityIntnullable

ex: 14014

surfaceStringnullable

ex: GrassValues:GrassArtificial TurfNatural Grass

roof_typeStringnullable

Open, Dome, Retractable

ex: OpenValues:OpenRetractableClosed

opened_dateStringnullable

ex: 2000-05-15T04:00:00.000Z

closed_dateStringnullable

team_nameStringnullable

ex: Tampa Bay Rays

timezoneStringnullable

IANA timezone (e.g., America/New_York)

addressStringnullable

image_urlStringnullable

URL to aerial/overview image of ballpark

hr_factorFloatnullable

Historical home run park factor (1.0 = neutral)

created_atString

updated_atString

Relations (5)

games[MLBGames!]!→ MLBGames

mlb.games rows whose venue_id references this row.

park_factors[MLBParkFactors!]!→ MLBParkFactors

mlb.park_factors rows whose venue_id references this row.

teams[MLBTeams!]!→ MLBTeams

mlb.teams rows whose venue_id references this row.

venue_dimensions[MLBVenueDimensions!]!→ MLBVenueDimensions

mlb.venue_dimensions rows whose venue_id references this row.

venue_weathers[MLBVenueWeathers!]!→ MLBVenueWeathers

mlb.venue_weathers rows whose venue_id references this row.

Arguments (2)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.

umpiresMLBUmpires

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

REST endpoint →Open in playground →

Fields (13)

idBigIntkey

Primary Key

first_nameString

ex: Mike

last_nameString

ex: Jimenez

full_nameString

ex: CB Bucknor

mlb_umpire_idInt→ MLBUmpires

ex: 427044

experienceIntnullable

activeBoolean

ex: true

birth_dateStringnullable

birth_cityStringnullable

birth_stateStringnullable

birth_countryStringnullable

created_atString

updated_atString

Relations (1)

game_umpires[MLBGameUmpires!]!→ MLBGameUmpires

mlb.game_umpires rows whose umpire_id references this row.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
activeBooleanFilter by active status (defaults to true to show only currently-active rows; pass active=false to include inactive).

venue_dimensionsMLBVenueDimensions

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.

REST endpoint →Open in playground →

Required filters: one of venue_id.

Fields (23)

idBigIntkey

Primary Key

mlb_venue_idInt→ MLBVenues

ex: 1

venue_nameStringnullable

ex: Angel Stadium

yearInt

ex: 2000

venue_idBigInt→ MLBVenues

ex: 2

foul_territory_sq_ftFloatnullable

ex: 21500

fair_territory_sq_ftFloatnullable

ex: 113800

total_territory_sq_ftFloatnullable

ex: 137000

descriptionStringnullable

orientationFloat

ex: 45

left_fieldFloat

ex: 330

left_center_fieldFloatnullable

ex: 385

center_fieldFloat

ex: 400

right_center_fieldFloatnullable

ex: 375

right_fieldFloat

ex: 330

left_field_fence_heightFloat

ex: 8

right_field_fence_heightFloat

ex: 8

center_field_fence_heightFloat

ex: 8

created_atString

updated_atString

backstop_distanceFloatnullable

Distance from home plate to backstop (feet)

foul_territory_ratingFloatnullable

Relative foul territory size (1.0 = average, >1 = large)

altitude_ftFloatnullable

Venue altitude in feet (denormalized from venue for query convenience)

Relations (1)

venueMLBVenues→ MLBVenues

The mlb.venues row referenced by venue_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
venue_idIntFilter by venue.

playoffsMLBPlayoffs

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

REST endpoint →Open in playground →

Fields (14)

idBigIntkey

Primary Key

season_idBigInt→ MLBSeasons

ex: 2020

series_idBigInt

ex: 401

series_nameString

ex: AL Division SeriesValues:AL Division SeriesNL Division SeriesAL Wild Card SeriesNL Wild Card SeriesWorld SeriesNL Championship SeriesAL Championship SeriesNL Wild Card GameAL Wild Card Game

home_team_idBigInt→ MLBTeams

ex: 27

away_team_idBigInt→ MLBTeams

ex: 44

home_team_winsInt

ex: 3

away_team_winsInt

ex: 2

games_playedInt

ex: 5

max_gamesInt

ex: 5

statusString

ex: Completed

series_textString

ex: LAD won 4-3

created_atString

updated_atString

Relations (3)

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

home_teamMLBTeams→ MLBTeams

The mlb.teams row referenced by home_team_id; null when unlinked.

away_teamMLBTeams→ MLBTeams

The mlb.teams row referenced by away_team_id; null when unlinked.

Arguments (2)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.

game_umpiresMLBGameUmpires

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (6)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 1454

umpire_idBigInt→ MLBUmpires

ex: 46

positionStringnullable

ex: Home PlateValues:Home PlateFirst BaseSecond BaseThird Base

created_atString

updated_atString

Relations (2)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

umpireMLBUmpires→ MLBUmpires

The mlb.umpires row referenced by umpire_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.

operator_player_lookupsMLBOperatorPlayerLookups

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

REST endpoint →Open in playground →

Required filters: one of operator_id.

Fields (8)

idBigIntkey

Primary Key

operator_idBigInt→ ReferenceOperators

Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.

ex: 2240

operator_player_idString→ MLBPlayers

External player ID from operator

ex: 671096

player_idBigInt→ MLBPlayers

Internal mlb.players.id reference

ex: 1589

player_nameStringnullable

Player name for reconciliation

ex: Max Muncy

positionStringnullable

Position for reconciliation

ex: PValues:PCLF2BSSCFRF3B1BSPRPDHOFTWP

created_atString

updated_atString

Relations (2)

operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

Arguments (3)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
operator_idIntFilter by operator.

player_awardsMLBPlayerAwards

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

REST endpoint →Open in playground →

Required filters: one of player_id.

Fields (10)

idBigIntkey

Primary Key

player_idBigInt→ MLBPlayers

ex: 1369

season_idBigInt→ MLBSeasons

ex: 2019

award_typeString

ex: MLBAFIRST

is_winnerBoolean

statsapi publishes recipients (winners) only — always true

ex: true

created_atString

updated_atString

award_nameString

ex: All-MLB First Team

award_dateStringnullable

Date the award was announced

ex: 2025-11-13T05:00:00.000Z

team_idBigIntnullable→ MLBTeams

ex: 41

Relations (3)

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
player_idIntFilter to a single player.
season_idIntFilter to a season.

player_injuriesMLBPlayerInjuries

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

REST endpoint →Open in playground →

Required filters: one of player_id.

Fields (18)

idBigIntkey

Primary Key

player_idBigInt→ MLBPlayers

ex: 636

team_idBigInt→ MLBTeams

ex: 42

season_idBigInt→ MLBSeasons

ex: 2026

start_dateString

ex: 2026-05-08T11:02:00.000Z

end_dateStringnullable

statusString

ex: 60-Day-ILValues:60-Day-ILDay-To-Day15-Day-IL10-Day-ILOut7-Day ILdevelopmental listsuspension7-day ilBereavementpaternity

body_partString

ex: Elbow

injury_typeString

ex: SurgeryValues:SurgeryStrainNot SpecifiedInflammationSorenessFracturePinched NerveSprainUnknownBruiseConcussionTendinitisSpasmsPlantar FasciitisCrampsBone SpurInfectionDislocated

sideStringnullable

ex: RightValues:RightLeftNot Specified

descriptionStringnullable

ex: no

is_surgery_requiredBooleannullable

expected_return_dateStringnullable

ex: 2027-02-01T05:00:00.000Z

games_missedIntnullable

updated_dateString

ex: 2026-06-29T11:01:04.968Z

sourceStringnullable

ex: espn

created_atString

updated_atString

Relations (3)

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

seasonMLBSeasons→ MLBSeasons

The mlb.seasons row referenced by season_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
player_idIntFilter to a single player.
team_idIntFilter by team.

player_newsMLBPlayerNews

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.

REST endpoint →Open in playground →

Required filters: one of player_id | team_id.

Fields (19)

idBigIntkey

Primary Key

player_idBigIntnullable→ MLBPlayers

ex: 459

team_idBigIntnullable→ MLBTeams

titleString

ex: Jake Bauers is Becoming a Must-Have Player

descriptionStringnullable

ex: Milwaukee Brewers first baseman/outfielder Jake Bauers is posting strong numbers at the plate recen…

analysisStringnullable

sourceString

News source identifier (cbs, espn, rotoworld, sportsdata, etc.)

ex: sportsdata

linkStringnullable

ex: https://www.rotoballer.com/player-news/jake-bauers-is-becoming-a-must-have-player/1871934

news_timeString

ex: 2026-06-07T01:57:06.000Z

priorityInt

ex: 10

created_atString

updated_atString

ai_processedBoolean

ex: false

situational_impactJSONnullable

contentStringnullable

ex: Milwaukee Brewers first baseman/outfielder Jake Bauers is posting strong numbers at the plate recen…

authorStringnullable

ex: Staff

categoryStringnullable

injury, transaction, lineup, general

ex: injuryValues:injurytransactionlineupgeneral

external_idString

Source-specific unique identifier

ex: sportsdata-197163

processed_atStringnullable

Relations (2)

playerMLBPlayers→ MLBPlayers

The mlb.players row referenced by player_id; null when unlinked.

teamMLBTeams→ MLBTeams

The mlb.teams row referenced by team_id; null when unlinked.

Arguments (8)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
player_idIntFilter to a single player.
team_idIntFilter by team.
news_timeStringFilter by publication time (ISO 8601). Use news_time__gte to poll for items since your last check.
news_time__gteStringgte comparison on news_time.
news_time__lteStringlte comparison on news_time.
news_time__betweenStringRange filter on news_time — pass "lo,hi".

venue_weathersMLBVenueWeathers

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (29)

idBigIntkey

Primary Key

game_idBigInt→ MLBGames

ex: 1454

venue_idBigInt→ MLBVenues

ex: 14

time_minutesInt

Minutes from game start (0, 30, 60, 90, 120, 150, 180 for 3-hour game)

ex: 0

temperatureFloatnullable

ex: 72

feels_like_temperatureFloatnullable

humidityFloatnullable

dew_pointFloatnullable

pressureFloatnullable

wind_speedFloatnullable

ex: 0

wind_directionFloatnullable

wind_gustFloatnullable

visibilityFloatnullable

uv_indexFloatnullable

cloud_coverFloatnullable

precipitationFloatnullable

precipitation_probabilityFloatnullable

weather_conditionStringnullable

ex: Partly CloudyValues:Partly CloudyClearCloudyRoof ClosedSunnyOvercastDomeRainDrizzleSnow

weather_descriptionStringnullable

ex: NoneValues:NoneOut To CFL To RR To LOut To LFOut To RFIn From RFIn From CFIn From LFVariesCalm

is_domeBooleannullable

ex: falseValues:falsetrue

roof_statusStringnullable

open, closed, retractable_open, retractable_closed

ex: ClosedValues:ClosedOpen

recorded_atStringnullable

ex: 2018-09-30T19:10:00.000Z

wind_direction_relativeFloatnullable

Wind direction relative to batter's box (degrees)

air_densityFloatnullable

Calculated air density (lb/ft³)

created_atString

updated_atString

wind_blowing_outBooleannullable

True if wind is blowing from home plate toward outfield

ex: trueValues:truefalse

wind_component_outFloatnullable

Wind speed component blowing out to CF (mph, negative = blowing in)

ball_carry_factorFloatnullable

Estimated ball carry factor (1.0 = neutral, >1 = carries more)

Relations (2)

gameMLBGames→ MLBGames

The mlb.games row referenced by game_id; null when unlinked.

venueMLBVenues→ MLBVenues

The mlb.venues row referenced by venue_id; null when unlinked.

Arguments (4)

firstIntPage size; clamped to the table's REST default/max limits.
afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_idIntFilter to a single game.
venue_idIntFilter by venue.