Baselight
Sign In

MLB Game Data

Pitch and other game data for 2016-present

@kaggle.josephvm_mlb_game_data

Games
@kaggle.josephvm_mlb_game_data.games

  • 1.12 MB
  • 13439 rows
  • 43 columns
game

Game

away

Away

away_record

Away-record

awayaway_record

Awayaway-record

home

Home

home_record

Home-record

homehome_record

Homehome-record

away_score

Away-score

home_score

Home-score

postseason_info

Postseason Info

walks_issued_away

Walks Issued - Away

walks_issued_home

Walks Issued - Home

stolen_bases_away

Stolen Bases - Away

stolen_bases_home

Stolen Bases - Home

strikeouts_thrown_away

Strikeouts Thrown - Away

strikeouts_thrown_home

Strikeouts Thrown - Home

total_bases_away

Total Bases - Away

total_bases_home

Total Bases - Home

stadium

Stadium

date

Date

location

Location

odds

Odds

o_u

O/U

attendance

Attendance

capacity

Capacity

duration

Duration

umpires

Umpires

win_pitcher_stats

WIN - Pitcher - Stats

win_pitcher_id

WIN - Pitcher - Id

win_pitcher_name

WIN - Pitcher - Name

win_pitcher_abbrname

WIN - Pitcher - AbbrName

win_pitcher_record

WIN - Pitcher - Record

loss_pitcher_stats

LOSS - Pitcher - Stats

loss_pitcher_id

LOSS - Pitcher - Id

loss_pitcher_name

LOSS - Pitcher - Name

loss_pitcher_abbrname

LOSS - Pitcher - AbbrName

loss_pitcher_record

LOSS - Pitcher - Record

save_pitcher_stats

SAVE - Pitcher - Stats

save_pitcher_id

SAVE - Pitcher - Id

save_pitcher_name

SAVE - Pitcher - Name

save_pitcher_abbrname

SAVE - Pitcher - AbbrName

save_pitcher_record

SAVE - Pitcher - Record

extra_innings

Extra Innings

360403123STL0-10-1 AwayPIT1-01-0 Home14nan55514513 PNC Park Coverage: ESPN 2016-04-03T17:00ZPittsburgh, Pennsylvania 15212nannan39500383623:02Home Plate Umpire - Jerry Layne, First Base Umpire - Hunter Wendelstedt, Second Base Umpire - Tripp Gibson, Third Base Umpire - Clint Fagan6.0 IP, 0 ER, 10 K, 5 BB6211Francisco LirianoF. Liriano(1-0)6.0 IP, 3 ER, 3 K, 3 BB5403Adam WainwrightA. Wainwright(0-1)nannannannannan
360403130TOR1-01-0 AwayTB0-10-1 Home53nan137161111 Tropicana Field Coverage: ESPN2 2016-04-03T20:00ZSt. Petersburg, Florida 33705nannan31042310422:51Home Plate Umpire - Mike Everitt, First Base Umpire - Paul Emmel, Second Base Umpire - Tim Timmons, Third Base Umpire - Laz Diaz8.0 IP, 3 ER, 5 K, 1 BB32815Marcus StromanM. Stroman(1-0)5.0 IP, 2 ER, 12 K, 3 BB31003Chris ArcherC. Archer(0-1)1.0 IP, 0 ER, 2 K, 0 BB32693Roberto OsunaR. Osuna(1)nan
360403107NYM0-10-1 AwayKC1-01-0 Home34nan2613989 Kauffman Stadium Coverage: ESPN 2016-04-04T00:30ZKansas City, Missouri 64129nannan40030379033:13Home Plate Umpire - Gerry Davis, First Base Umpire - Sam Holbrook, Second Base Umpire - Rob Drake, Third Base Umpire - Carlos Torres6.0 IP, 0 ER, 5 K, 3 BB6401Edinson VolquezE. Volquez(1-0)5.2 IP, 3 ER, 2 K, 2 BB31214Matt HarveyM. Harvey(0-1)1.0 IP, 0 ER, 2 K, 1 BB28957Wade DavisW. Davis(1)nan
360404108SF1-01-0 AwayMIL0-10-1 Home123nan5511033014 Miller Park 2016-04-04T18:10ZMilwaukee, Wisconsin 53295nannan443183:35Home Plate Umpire - Brian Gorman, First Base Umpire - Mark Carlson, Second Base Umpire - Mike DiMuro, Third Base Umpire - Quinn Wolcott5.0 IP, 3 ER, 6 K, 5 BB29949Madison BumgarnerM. Bumgarner(1-0)4.0 IP, 4 ER, 2 K, 2 BB31140Wily PeraltaW. Peralta(0-1)nannannannannan
360404101MIN0-10-1 AwayBAL1-01-0 Home23nan5110101013 Oriole Park at Camden Yards 2016-04-04T19:05ZBaltimore, Maryland 21201nannan45785459712:48Home Plate Umpire - Mike Winters, First Base Umpire - Mark Wegner, Second Base Umpire - Marty Foster, Third Base Umpire - Mike Muchlinski1.0 IP, 0 ER, 0 K, 0 BB31054Zack BrittonZ. Britton(1-0)0.2 IP, 1 ER, 1 K, 1 BB29265Kevin JepsenK. Jepsen(0-1)nannannannannan
360404113SEA0-10-1 AwayTEX1-01-0 Home23nan6311011101 Globe Life Park in Arlington Coverage: ESPN 2016-04-04T20:00ZArlington, Texas 76096nannan49289481142:38Home Plate Umpire - Jim Joyce, First Base Umpire - Marvin Hudson, Second Base Umpire - James Hoye, Third Base Umpire - Chad Fairchild7.0 IP, 2 ER, 8 K, 3 BB6216Cole HamelsC. Hamels(1-0)6.0 IP, 1 ER, 6 K, 5 BB6194Felix HernandezF. Hernandez(0-1)1.0 IP, 0 ER, 2 K, 0 BB31886Shawn TollesonS. Tolleson(1)nan
360404115WSH1-01-0 AwayATL0-10-1 Home43nan55111111510 Center Parc Stadium 2016-04-04T20:10ZAtlanta, Georgia 39901nannan48282497433:23Home Plate Umpire - Jerry Meals, First Base Umpire - Ron Kulpa, Second Base Umpire - Paul Nauert, Third Base Umpire - Chris Conroy1.0 IP, 0 ER, 1 K, 1 BB32185Blake TreinenB. Treinen(1-0)0.1 IP, 0 ER, 0 K, 0 BB28549Eric O'FlahertyE. O'Flaherty(0-1)1.0 IP, 0 ER, 1 K, 0 BB6373Jonathan PapelbonJ. Papelbon(1)True
360404117PHI0-10-1 AwayCIN1-01-0 Home26nan31710109 Great American Ball Park 2016-04-04T20:10ZCincinnati, Ohio 45202nannan43683423192:56Home Plate Umpire - Bill Miller, First Base Umpire - Tony Randazzo, Second Base Umpire - Brian Knight, Third Base Umpire - Todd Tichenor0.1 IP, 0 ER, 1 K, 0 BB28695Ross OhlendorfR. Ohlendorf(1-0)0.0 IP, 3 ER, 0 K, 2 BB30058David HernandezD. Hernandez(0-1)nannannannannan
360404125LAD1-01-0 AwaySD0-10-1 Home15nan241010265 Petco Park Coverage: ESPN 2016-04-04T23:00ZSan Diego, California 92101nannan44317411643:10Home Plate Umpire - Gary Cederstrom, First Base Umpire - Eric Cooper, Second Base Umpire - Jim Wolf, Third Base Umpire - Adrian Johnson7.0 IP, 0 ER, 9 K, 1 BB28963Clayton KershawC. Kershaw(1-0)5.1 IP, 7 ER, 5 K, 1 BB30099Tyson RossT. Ross(0-1)nannannannannan
360404130TOR2-02-0 AwayTB0-20-2 Home53nan421991712 Tropicana Field 2016-04-04T23:10ZSt. Petersburg, Florida 33705nannan15116310422:58Home Plate Umpire - Paul Emmel, First Base Umpire - Tim Timmons, Second Base Umpire - Laz Diaz, Third Base Umpire - Mike Everitt5.0 IP, 3 ER, 3 K, 2 BB4695R.A. DickeyR.A. Dickey(1-0)6.2 IP, 5 ER, 5 K, 1 BB31816Drew SmylyD. Smyly(0-1)1.0 IP, 0 ER, 0 K, 0 BB32693Roberto OsunaR. Osuna(2)nan

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

Share link

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