Baselight
Sign In

MLB Game Data

Pitch and other game data for 2016-present

@kaggle.josephvm_mlb_game_data

Loading...
Loading...

About this Dataset

MLB Game Data

Content

This dataset currently contains data from the start of the 2016 season through the end of the 2021 postseason. I plan to update it roughly weekly.

pitches.csv is one of the main files. It contains information about each pitch (as found on ESPN, I've noticed some games that are missing some at-bats, with the newest being from 2019 I believe). games.csv and events.csv are two other files of note.

Some of the other files contain information that can be gleamed from the other files. Over time I may try to cut down on this to reduce the number of files. I may also try to reduce the overall size of the dataset by changing several fields to use IDs instead of strings (just a heads-up).

Files

  • games.csv - general game info

  • hittersByGame.csv - how each player did in each game

  • pitchersByGame.csv - how each player did in each game

  • plays.csv - batter events - batter singled, batter struck out, etc

  • events.csv - general events - Have event id (per game) to join with next

  • pitches.csv - one row per pitch per game

  • inningScore.csv - score per inning

  • inningHighlights.csv - # of runs, hits, and errors per inning

  • hittingNotes.csv

  • pitchingNotes.csv

  • baserunningNotes.csv

  • fieldingNotes.csv

  • letterNotes.csv - for notes attached to batters (and maybe pitchers)

  • awards directory
    -- one file per award

Links

Inspiration

  • Which pitchers are best at getting out of a 3-2 count?
  • What hitters have the highest likelihood of scoring the runner on third if there is one?
  • What is the highest number of pitches each team has thrown in one inning over the last few years?-

Tables

Baserunningnotes

@kaggle.josephvm_mlb_game_data.baserunningnotes
  • 407.8 KB
  • 15195 rows
  • 4 columns
Loading... 

CREATE TABLE baserunningnotes (
  "game" BIGINT,
  "team" VARCHAR,
  "stat" VARCHAR,
  "data" VARCHAR
);

Events

@kaggle.josephvm_mlb_game_data.events
  • 17.35 MB
  • 1410131 rows
  • 8 columns
Loading... 

CREATE TABLE events (
  "game" BIGINT,
  "pitching_team" VARCHAR,
  "batting_team" VARCHAR,
  "inning" VARCHAR,
  "event_id" BIGINT,
  "events" VARCHAR,
  "away" VARCHAR,
  "home" VARCHAR
);

Fieldingnotes

@kaggle.josephvm_mlb_game_data.fieldingnotes
  • 570.09 KB
  • 32602 rows
  • 4 columns
Loading... 

CREATE TABLE fieldingnotes (
  "game" BIGINT,
  "team" VARCHAR,
  "stat" VARCHAR,
  "data" VARCHAR
);

Games

@kaggle.josephvm_mlb_game_data.games
  • 1.12 MB
  • 13439 rows
  • 43 columns
Loading... 

CREATE TABLE games (
  "game" BIGINT,
  "away" VARCHAR,
  "away_record" VARCHAR,
  "awayaway_record" VARCHAR,
  "home" VARCHAR,
  "home_record" VARCHAR,
  "homehome_record" VARCHAR,
  "away_score" DOUBLE,
  "home_score" DOUBLE,
  "postseason_info" VARCHAR,
  "walks_issued_away" DOUBLE,
  "walks_issued_home" DOUBLE,
  "stolen_bases_away" DOUBLE,
  "stolen_bases_home" DOUBLE,
  "strikeouts_thrown_away" DOUBLE,
  "strikeouts_thrown_home" DOUBLE,
  "total_bases_away" DOUBLE,
  "total_bases_home" DOUBLE,
  "stadium" VARCHAR,
  "date" VARCHAR,
  "location" VARCHAR,
  "odds" VARCHAR,
  "o_u" VARCHAR,
  "attendance" DOUBLE,
  "capacity" DOUBLE,
  "duration" VARCHAR,
  "umpires" VARCHAR,
  "win_pitcher_stats" VARCHAR,
  "win_pitcher_id" DOUBLE,
  "win_pitcher_name" VARCHAR,
  "win_pitcher_abbrname" VARCHAR,
  "win_pitcher_record" VARCHAR,
  "loss_pitcher_stats" VARCHAR,
  "loss_pitcher_id" DOUBLE,
  "loss_pitcher_name" VARCHAR,
  "loss_pitcher_abbrname" VARCHAR,
  "loss_pitcher_record" VARCHAR,
  "save_pitcher_stats" VARCHAR,
  "save_pitcher_id" DOUBLE,
  "save_pitcher_name" VARCHAR,
  "save_pitcher_abbrname" VARCHAR,
  "save_pitcher_record" VARCHAR,
  "extra_innings" VARCHAR
);

Hittersbygame

@kaggle.josephvm_mlb_game_data.hittersbygame
  • 4.53 MB
  • 361864 rows
  • 16 columns
Loading... 

CREATE TABLE hittersbygame (
  "hitters" VARCHAR,
  "h_ab" VARCHAR,
  "ab" VARCHAR,
  "r" VARCHAR,
  "h" VARCHAR,
  "rbi" VARCHAR,
  "bb" VARCHAR,
  "k" VARCHAR,
  "n__p" VARCHAR,
  "avg" VARCHAR,
  "obp" VARCHAR,
  "slg" VARCHAR,
  "game" BIGINT,
  "team" VARCHAR,
  "position" VARCHAR,
  "hitter_id" VARCHAR
);

Hittingnotes

@kaggle.josephvm_mlb_game_data.hittingnotes
  • 3.25 MB
  • 163667 rows
  • 4 columns
Loading... 

CREATE TABLE hittingnotes (
  "game" BIGINT,
  "team" VARCHAR,
  "stat" VARCHAR,
  "data" VARCHAR
);

Inninghighlights

@kaggle.josephvm_mlb_game_data.inninghighlights
  • 355.64 KB
  • 238483 rows
  • 5 columns
Loading... 

CREATE TABLE inninghighlights (
  "inning" VARCHAR,
  "runs" BIGINT,
  "hits" BIGINT,
  "errors" BIGINT,
  "game" BIGINT
);

Inningscore

@kaggle.josephvm_mlb_game_data.inningscore
  • 269.23 KB
  • 26868 rows
  • 24 columns
Loading... 

CREATE TABLE inningscore (
  "team" VARCHAR,
  "n_1" BIGINT,
  "n_2" BIGINT,
  "n_3" BIGINT,
  "n_4" BIGINT,
  "n_5" BIGINT,
  "n_6" VARCHAR,
  "n_7" VARCHAR,
  "n_8" VARCHAR,
  "n_9" VARCHAR,
  "r" BIGINT,
  "h" BIGINT,
  "e" BIGINT,
  "game" BIGINT,
  "n_10" DOUBLE,
  "n_11" DOUBLE,
  "n_12" DOUBLE,
  "n_13" DOUBLE,
  "n_14" DOUBLE,
  "n_15" DOUBLE,
  "n_16" DOUBLE,
  "n_17" DOUBLE,
  "n_18" DOUBLE,
  "n_19" DOUBLE
);

Letternotes

@kaggle.josephvm_mlb_game_data.letternotes
  • 545.92 KB
  • 30454 rows
  • 4 columns
Loading... 

CREATE TABLE letternotes (
  "game" BIGINT,
  "player_id" BIGINT,
  "player_note_id" BIGINT,
  "note" VARCHAR
);

Pitchersbygame

@kaggle.josephvm_mlb_game_data.pitchersbygame
  • 1.85 MB
  • 143687 rows
  • 15 columns
Loading... 

CREATE TABLE pitchersbygame (
  "pitchers" VARCHAR,
  "ip" DOUBLE,
  "h" BIGINT,
  "r" BIGINT,
  "er" BIGINT,
  "bb" BIGINT,
  "k" BIGINT,
  "hr" BIGINT,
  "pc_st" VARCHAR,
  "era" VARCHAR,
  "pc" VARCHAR,
  "game" BIGINT,
  "team" VARCHAR,
  "extra" VARCHAR,
  "pitcher_id" VARCHAR
);

Pitches

@kaggle.josephvm_mlb_game_data.pitches
  • 28.31 MB
  • 3953197 rows
  • 13 columns
Loading... 

CREATE TABLE pitches (
  "num" BIGINT,
  "pitch" VARCHAR,
  "type" VARCHAR,
  "mph" VARCHAR,
  "play_hitzone" VARCHAR,
  "play_bases" DOUBLE,
  "play_field" VARCHAR,
  "pitcher" VARCHAR,
  "pitching_team" VARCHAR,
  "batting_team" VARCHAR,
  "inning" VARCHAR,
  "event_id" BIGINT,
  "game" BIGINT
);

Pitchingnotes

@kaggle.josephvm_mlb_game_data.pitchingnotes
  • 3.15 MB
  • 126421 rows
  • 4 columns
Loading... 

CREATE TABLE pitchingnotes (
  "game" BIGINT,
  "team" VARCHAR,
  "stat" VARCHAR,
  "data" VARCHAR
);

Plays

@kaggle.josephvm_mlb_game_data.plays
  • 15.72 MB
  • 1061113 rows
  • 5 columns
Loading... 

CREATE TABLE plays (
  "game" BIGINT,
  "team" VARCHAR,
  "batter_id" VARCHAR,
  "batter" VARCHAR,
  "event" VARCHAR
);

Share link

Anyone who has the link will be able to view this.