Raw MLB Player Data

@kaggle.chriscoxen_raw_mlb_player_data

Table List

3 tables(209.24 KB)

Top 100 Active Mlb Players

@kaggle.chriscoxen_raw_mlb_player_data.top_100_active_mlb_players

46.14 KB
100 rows
43 columns

rk Rk	player Player	war WAR	from From	to To	age Age	g G	pa PA	ab AB	r R	h H	n_1b 1B	n_2b 2B	n_3b 3B	hr HR	rbi RBI	sb SB	cs CS	bb BB	so SO	ba BA	obp OBP	slg SLG	ops OPS	ops_342c99 OPS+	tb TB	gidp GIDP	hbp HBP	sh SH	sf SF	ibb IBB	war_1 WAR.1	waa WAA	owar OWAR	dwar DWAR	rbat Rbat	rdp Rdp	rbaser Rbaser	rbaser_rdp Rbaser + Rdp	rfield Rfield	pos Pos	team Team	player_additional Player-additional
1	Mike Trout	86.3	2011	2024	19-32	1511	6617	5488	1120	1645	904	311	54	376	951	211	37	973	1477	0.3	0.411	0.582	0.992	173	3192	68	100		55	120	86.3	64.4	86.3	2.9	562	9	36	45	-4	*87D9H	LAA	troutmi01
2	Mookie Betts	67	2014	2024	21-31	1289	5870	5137	1020	1518	872	353	35	258	775	177	37	634	813	0.296	0.375	0.529	0.904	139	2715	62	48	4	47	31	67	48.6	50.6	14.3	295	6	40	46	156	*9846HD	BOSLAD	bettsmo01
3	Joey Votto	64.5	2007	2023	23-39	2056	8746	7252	1171	2135	1298	459	22	356	1144	80	29	1365	1640	0.294	0.409	0.511	0.92	144	3706	168	81		48	147	64.5	37.7	59.6	-7	473	-5	-32	-37	49	*3DH/7	CIN	vottojo01
4	Paul Goldschmidt	61.1	2011	2024	23-36	1795	7730	6598	1140	1923	1147	413	22	341	1130	158	35	1014	1732	0.291	0.387	0.516	0.903	141	3403	149	48		53	115	61.1	37.3	55.4	-4.6	391	-12	27	16	59	*3DH	ARISTL	goldspa01
5	Nolan Arenado	54.7	2013	2024	22-33	1550	6538	5914	881	1694	965	370	33	326	1072	26	22	511	965	0.286	0.343	0.526	0.869	122	3108	179	36	5	71	74	54.7	34	38.5	19.4	169	-19		-20	158	*5DH	COLSTL	arenano01
6	Manny Machado	55	2012	2024	19-31	1607	6979	6312	929	1762	1091	336	18	317	956	88	36	572	1202	0.279	0.339	0.489	0.828	125	3085	187	26	14	55	63	55	32.1	45.3	13.8	198	-18	-1	-19	90	*56DH	BALLADSDP	machama01
7	Freddie Freeman	56.2	2010	2024	20-34	1909	8204	7103	1229	2139	1309	479	29	322	1156	90	28	947	1555	0.301	0.388	0.513	0.901	142	3642	149	100		54	127	56.2	31	56.6	-11	414	-4	3	-1		*3H5/D	ATLLAD	freemfr01
8	Aaron Judge	41.8	2016	2024	24-32	857	3719	3087	621	861	455	142	4	260	583	44	16	577	1067	0.279	0.394	0.58	0.974	162	1791	83	24		25	49	41.8	29.6	35.6	3.3	271	-9	-1	-11	59	98DH	NYY	judgeaa01
9	José Ramírez	45.9	2013	2024	20-31	1314	5499	4849	799	1349	762	329	39	219	764	203	48	548	658	0.278	0.353	0.498	0.85	128	2413	71	36	19	47	77	45.9	27.6	42.9	5.7	171	12	33	45	26	546D7H	CLE	ramirjo01
10	Jose Altuve	50.7	2011	2024	21-34	1691	7465	6759	1078	2080	1427	408	31	214	754	296	84	563	927	0.308	0.365	0.472	0.837	130	3192	182	70	26	47	43	50.7	26.6	57.4	-1.7	266	-6	14	8	-70	*4DH/6	HOU	altuvjo01


CREATE TABLE top_100_active_mlb_players (
  "rk" BIGINT,
  "player" VARCHAR,
  "war" DOUBLE,
  "from" BIGINT,
  "to" BIGINT,
  "age" VARCHAR,
  "g" BIGINT,
  "pa" BIGINT,
  "ab" BIGINT,
  "r" BIGINT,
  "h" BIGINT,
  "n_1b" BIGINT,
  "n_2b" BIGINT,
  "n_3b" BIGINT,
  "hr" BIGINT,
  "rbi" BIGINT,
  "sb" BIGINT,
  "cs" BIGINT,
  "bb" BIGINT,
  "so" BIGINT,
  "ba" DOUBLE,
  "obp" DOUBLE,
  "slg" DOUBLE,
  "ops" DOUBLE,
  "ops_342c99" BIGINT,
  "tb" BIGINT,
  "gidp" BIGINT,
  "hbp" BIGINT,
  "sh" BIGINT,
  "sf" BIGINT,
  "ibb" BIGINT,
  "war_1" DOUBLE,
  "waa" DOUBLE,
  "owar" DOUBLE,
  "dwar" DOUBLE,
  "rbat" BIGINT,
  "rdp" BIGINT,
  "rbaser" BIGINT,
  "rbaser_rdp" BIGINT,
  "rfield" BIGINT,
  "pos" VARCHAR,
  "team" VARCHAR,
  "player_additional" VARCHAR
);