Dataset: MLB Batting Stats By Game 1901-2021

About this Dataset

MLB Batting Stats By Game 1901-2021

Every game's batting stats for all players since 1901 thru 2021. Regular season only.

Data gathered from baseball-reference.com for every player with a PA (plate appearance) in a game.

This data was used to make this quiz (via SQL queries):
https://hugequiz.com/quizzes/mlb-teammates-choose-player/

Keep in mind the date field occasionally has a "(1)" or "(2)" or even "(3)" in it - this refers to the game # for that team on that day for a double or tripleheader (there were a few tripleheaders I believe).

Tables

Mlbbatting1901–2021

@kaggle.darinhawley_mlb_batting_stats_by_game_19012021.mlbbatting1901_2021

59.7 MB
4285629 rows
31 columns


CREATE TABLE mlbbatting1901_2021 (
  "id" VARCHAR,
  "player" VARCHAR,
  "date" VARCHAR,
  "tm" VARCHAR,
  "opp" VARCHAR,
  "rslt" VARCHAR,
  "pa" BIGINT,
  "ab" BIGINT,
  "r" BIGINT,
  "h" BIGINT,
  "n_2b" BIGINT,
  "n_3b" BIGINT,
  "hr" BIGINT,
  "rbi" DOUBLE,
  "bb" BIGINT,
  "ibb" DOUBLE,
  "so" BIGINT,
  "hbp" BIGINT,
  "sh" BIGINT,
  "sf" DOUBLE,
  "roe" DOUBLE,
  "gdp" DOUBLE,
  "sb" BIGINT,
  "cs" DOUBLE,
  "wpa" DOUBLE,
  "re24" DOUBLE,
  "ali" DOUBLE,
  "bop" BIGINT,
  "pos_summary" VARCHAR,
  "dfs_dk" DOUBLE,
  "dfs_fd" DOUBLE
);