MLB Batting Stats By Game 1901-2021

Game-by-game batting stats for all players with a PA in the regular season.

@kaggle.darinhawley_mlb_batting_stats_by_game_19012021

Table List

1 table(59.7 MB)

Mlbbatting1901–2021

@kaggle.darinhawley_mlb_batting_stats_by_game_19012021.mlbbatting1901_2021

59.7 MB
4285629 rows
31 columns

id ID	player Player	date Date	tm Tm	opp Opp	rslt Rslt	pa PA	ab AB	r R	h H	n_2b 2B	rbi RBI	bb BB	so SO	sb SB	bop BOP	pos_summary Pos Summary
crossmo01	Monte Cross	1901-04-18	PHI	BRO	L 7-12	5	4	2	2	1	1	1			8	SS
dahlebi01	Bill Dahlen	1901-04-18	BRO	PHI	W 12-7	5	4	2	3			1	1	2	7	SS
dalyto01	Tom Daly	1901-04-18	BRO	PHI	W 12-7	5	5	1	2	1	3		1		6	2B
davisle01	Lefty Davis	1901-04-18	BRO	PHI	W 12-7	5	5	1	1						1	LF
delahed01	Ed Delahanty	1901-04-18	PHI	BRO	L 7-12	5	4	1	2			1			3	1B
dolanjo02	Joe Dolan	1901-04-18	PHI	BRO	L 7-12	5	5		1		1				7	2B
donovbi01	Bill Donovan	1901-04-18	BRO	PHI	W 12-7	5	5		1		1		2		9	P
dugglbi01	Bill Duggleby	1901-04-18	PHI	BRO	L 7-12	5	5	1	3	1	1		1		9	P
flickel01	Elmer Flick	1901-04-18	PHI	BRO	L 7-12	5	4				1	1			4	RF
keelewi01	Willie Keeler	1901-04-18	BRO	PHI	W 12-7	5	5	1	2	2	1				2	RF


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