MLB Data Dictionary
Main
mlb.seasons7 fieldsendpoints →
Each MLB season — spring training, the 162-game regular season, the Wild Card Series, the Division Series, the League Championship Series, and the World Series.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| league_id | stringnullable | — | — | Official MLB season identifier |
| end_date | timestamptznullable | — | 2018-10-28T00:00:00.000Z | — |
| post_season_start_date | timestamptznullable | — | 2018-10-02T00:00:00.000Z | — |
| regular_season_start_date | timestamptznullable | — | 2018-03-29T00:00:00.000Z | — |
| start_date | timestamptz | — | 2018-03-29T00:00:00.000Z | — |
| start_year | integer | — | 2018 | — |
mlb.teams11 fields· 2 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 | → mlb.teams | 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.games31 fields· 5 refsendpoints →
Every scheduled and played MLB game — spring training exhibitions, the 162-game regular season, the Wild Card Series, the Division and Championship Series, and the World Series.
| 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 | → mlb.games | 745080 | Official MLB gamePk from statsapi.mlb.com |
| league_id | stringnullable | — | — | Official MLB game identifier |
| losing_pitcher_id | bigintnullable | — | 1177 | Losing pitcher of record |
| save_pitcher_id | bigintnullable | — | 1415 | Save pitcher (if any) |
| season_id | bigint | → mlb.seasons | 2025 | — |
| venue_id | bigintnullable | → mlb.venues | 16 | — |
| winning_pitcher_id | bigintnullable | — | 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 (use this over start_time) |
| 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 |
mlb.players29 fields· 2 refsendpoints →
Every individual who has played in Major League Baseball — current 26-man and 40-man rosters, minor-league call-ups, players on the injured list, free agents, and retired players.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| league_id | stringnullable | — | — | Official MLB player identifier |
| league_player_id | integer | → mlb.players | 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-14T04:00:00.000Z | — |
| birth_state | stringnullable | — | CA | — |
| debut_date | timestamptznullable | — | 2023-03-30T00:00:00.000Z | — |
| display_fi_last | stringnullable | — | R. 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 | — | Active | 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 ActiveInactive |
| school | stringnullable | — | — | — |
| throws | stringnullable | — | R | — Values RLS |
| weight | integernullable | — | 215 | — |
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.pitches72 fields· 1 refsendpoints →
Every individual pitch thrown in every MLB game — the pitch type, velocity, location, movement, spin, and the result (called strike, swinging strike, foul, ball, hit, walk).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| at_bat_id | bigint | — | 1494 | — |
| batter_id | bigint | — | 306 | — |
| game_id | bigint | → mlb.games | 84 | — |
| pitcher_id | bigint | — | 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) |
| 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.at_bats35 fields· 2 refsendpoints →
Every plate appearance in every MLB game — the batter, the pitcher, the count, the pitch sequence, and the outcome (single, double, home run, strikeout, walk, hit-by-pitch, etc.).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| batter_id | bigint | — | 996 | — |
| game_id | bigint | → mlb.games | 69 | — |
| inning_id | bigint | → mlb.innings | 908 | — |
| pitcher_id | bigint | — | 174 | — |
| at_bat_number | integer | — | 0 | — |
| balls | integer | — | 0 | — |
| end_outs | integer | — | 2 | — |
| end_runners | integer | — | 0 | — |
| 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 | — |
| 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 | — |
| 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.play_by_plays22 fields· 4 refsendpoints →
Every individual play of every MLB game — every plate appearance, baserunning event, defensive play, and substitution with the inning, outs, base state, and score at the moment.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| at_bat_id | bigintnullable | — | 1 | — |
| batter_id | bigintnullable | — | 996 | — |
| catcher_id | bigintnullable | — | — | — |
| first_base_runner_id | bigintnullable | — | 996 | — |
| game_id | bigint | → mlb.games | 69 | — |
| inning_id | bigint | → mlb.innings | 908 | — |
| pitcher_id | bigintnullable | — | 174 | — |
| play_id | bigint | — | 0 | — |
| player_id | bigintnullable | → mlb.players | 996 | — |
| second_base_runner_id | bigintnullable | — | 996 | — |
| team_id | bigint | → mlb.teams | 19 | — |
| third_base_runner_id | bigintnullable | — | 996 | — |
| count_balls | integer | — | 0 | — |
| count_strikes | integer | — | 2 | — |
| 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 |
| mlb_event_num | integer | — | 0 | — |
| outs | integer | — | 1 | — |
| runners_on_base | integer | — | 0 | — |
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 |
mlb.operator_team_lookups6 fields· 3 refsendpoints →
How each sportsbook and fantasy operator names every MLB team — the mapping from each operator's team code to the unified franchise record.
| 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 | → mlb.teams | — | 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.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 | — | 28 | — |
| caught_stealing | integer | — | 30 | — |
| complete_games | integer | — | 0 | — |
| double_plays | integer | — | 125 | — |
| doubles | integer | — | 264 | — |
| earned_run_average | decimal | — | 3.7800 | — |
| earned_runs | integer | — | 596 | — |
| errors | integer | — | 97 | — |
| fielding_percentage | decimal | — | 0.9860 | — |
| games_played | integer | — | 162 | — |
| hits | integer | — | 1423 | — |
| holds | integer | — | 83 | — |
| home_runs | integer | — | 182 | — |
| innings_pitched | decimal | — | 1442.0000 | Innings pitched in MLB notation (6.2 = 6 and 2/3 innings) |
| losses | integer | — | 72 | — |
| on_base_percentage | decimal | — | 0.3150 | — |
| on_base_plus_slugging | decimal | — | 0.7070 | — |
| runs_allowed | integer | — | 699 | — |
| runs_batted_in | integer | — | 655 | — |
| runs_scored | integer | — | 769 | — |
| save_opportunities | integer | — | 64 | — |
| saves | integer | — | 40 | — |
| shutouts | integer | — | 8 | — |
| slugging_percentage | decimal | — | 0.3910 | — |
| stolen_bases | integer | — | 88 | — |
| strikeouts | integer | — | 1461 | — |
| ties | integer | — | 0 | — |
| triples | integer | — | 18 | — |
| walks | integer | — | 478 | — |
| whip | decimal | — | 1.2400 | — |
| wins | integer | — | 90 | — |
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 | — |
mlb.operator_player_lookups6 fields· 3 refsendpoints →
How each sportsbook and fantasy operator names every MLB player — the mapping from each operator's player identifier to a unified player record.
| 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 | → mlb.players | 671096 | External player ID from operator |
| player_id | bigint | → mlb.players | 1589 | Internal mlb.players.id reference |
| player_name | stringnullable | — | Max Muncy | Player name for reconciliation |
| position | stringnullable | — | P | Position for reconciliation Values PCLF2BSSRFCF3B1BSPRPDHOFTWP |
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 + 2*2B + 3*3B + 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 | — |
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 | 162977 | — |
| 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.5122 | 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 | — | -105 | 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.game_team_rosters10 fields· 3 refsendpoints →
The active gameday roster for each MLB team in each game — the 26 players in uniform that day, with positions and any pre-game lineup designations.
| 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 | — | — | — |
| day | integer | — | 20180929 | — |
| position | stringnullable | — | P | — Values PC2BLF1BCF3BRFSSPHDHPR |
| starter | boolean | — | false | — Values falsetrue |
| status | stringnullable | — | Active | — |
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 | — | 172 | — |
| 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_lineup_batters5 fields· 1 refsendpoints →
Each batter in each MLB starting lineup — position in the order (1 through 9), defensive position, and batting handedness for the day.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| player_id | bigint | → mlb.players | 1040 | — |
| team_starting_lineup_id | bigint | — | 1 | — |
| batting_order | string | — | 1 | — |
| position | string | — | SS | — Values SS3BRF2BCF1BLFCDHPPHPR |
mlb.team_starting_lineups6 fields· 2 refsendpoints →
Each MLB team's starting lineup for each game — the nine batters in batting order plus the starting pitcher (and DH where applicable).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → mlb.games | 64 | — |
| pitcher_id | bigintnullable | — | 50028 | — |
| team_id | bigint | → mlb.teams | 27 | — |
| batter_status | integer | — | 1 | — |
| pitcher_status | integer | — | 1 | — |
Misc
mlb.venues21 fields· 1 refsendpoints →
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 | → mlb.venues | 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.umpires11 fields· 1 refsendpoints →
MLB umpires — the four-person crew of home-plate, first-base, second-base, and third-base umpires who work each game (six in the postseason with outfield umpires added).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| mlb_umpire_id | integer | → mlb.umpires | 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· 2 refsendpoints →
Outfield dimensions and wall heights for each MLB ballpark — distances to left field, center field, right field, and the power alleys, plus the height of the outfield walls.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| mlb_venue_id | integer | → mlb.venues | 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.broadcasters12 fields· 2 refsendpoints →
Networks, regional sports networks, and streaming services that air MLB games — Apple TV+, ESPN, FOX, TBS, MLB Network, MLB.TV, plus team-local RSNs.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| broadcaster_id | integer | → mlb.broadcasters | — | — |
| broadcaster_team_id | integer | → mlb.teams | — | — |
| 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.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.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.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-13T05:00:00.000Z | 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 SurgeryStrainNot SpecifiedInflammationSorenessFracturePinched NerveSprainUnknownBruiseConcussionTendinitisSpasmsPlantar FasciitisCrampsBone SpurInfectionDislocated |
| 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 ilBereavementpaternity |
| updated_date | timestamptz | — | 2026-06-29T11:01:04.968Z | — |
mlb.player_news17 fields· 2 refsendpoints →
News about MLB players — trades, IL placements, lineup decisions, suspensions, and general beat-reporter updates, unified from beat-writer scrapers, operator feeds, and AI summarization.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| external_id | string | — | sportsdata-197163 | Source-specific unique identifier |
| player_id | bigintnullable | → mlb.players | 459 | — |
| team_id | bigintnullable | → mlb.teams | — | — |
| ai_processed | boolean | — | false | — |
| analysis | stringnullable | — | — | — |
| author | stringnullable | — | Staff | — |
| category | stringnullable | — | injury | injury, transaction, lineup, general Values injurytransactionlineupgeneral |
| content | stringnullable | — | Milwaukee Brewers first baseman/outfielder Jake Bauers is posting strong numbers at the plate recen… | — |
| description | stringnullable | — | Milwaukee Brewers first baseman/outfielder Jake Bauers is posting strong numbers at the plate recen… | — |
| link | stringnullable | — | https://www.rotoballer.com/player-news/jake-bauers-is-becoming-a-must-have-player/1871934 | — |
| news_time | timestamptz | — | 2026-06-07T01:57:06.000Z | — |
| priority | integer | — | 10 | — |
| processed_at | timestamptznullable | — | — | — |
| situational_impact | jsonbnullable | — | — | — |
| source | string | — | sportsdata | News source identifier (cbs, espn, rotoworld, sportsdata, etc.) |
| title | string | — | Jake Bauers is Becoming a Must-Have Player | — |
mlb.venue_weathers27 fields· 2 refsendpoints →
On-field weather throughout each MLB game — temperature, wind direction and speed, humidity, and precipitation captured at fixed intervals from first pitch.
| 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 | — |