NHL NBA,MLB,NBA Salaries + Statistics (1876-2024)

year Year	playerid PlayerId	playername PlayerName	type Type	rank Rank	playerfullname PlayerFullName	playerfirstname PlayerFirstName	playerlastname PlayerLastName	playerusename PlayerUseName	playerinitlastname PlayerInitLastName	teamid TeamId	teamabbrev TeamAbbrev	teamname TeamName	teamshortname TeamShortName	leaguename LeagueName	leagueid LeagueId	positionabbrev PositionAbbrev	position Position	primarypositionabbrev PrimaryPositionAbbrev	winningpercentage WinningPercentage	runsscoredper9 RunsScoredPer9	battersfaced BattersFaced	strikeoutsper9 StrikeoutsPer9	baseonballsper9 BaseOnBallsPer9	homerunsper9 HomeRunsPer9	hitsper9 HitsPer9	strikesoutstowalks StrikesoutsToWalks	gamesfinished GamesFinished	wildpitches WildPitches	walksperplateappearance WalksPerPlateAppearance	strikeoutsperplateappearance StrikeoutsPerPlateAppearance	homerunsperplateappearance HomeRunsPerPlateAppearance	walksperstrikeout WalksPerStrikeout	gamesplayed GamesPlayed	gamesstarted GamesStarted	runs Runs	homeruns HomeRuns	strikeouts StrikeOuts	baseonballs BaseOnBalls	hits Hits	era Era	inningspitched InningsPitched	wins Wins	losses Losses	saves Saves	earnedruns EarnedRuns	whip Whip	outs Outs	gamespitched GamesPitched	completegames CompleteGames	shutouts Shutouts	winpercentage WinPercentage	strikeoutwalkratio StrikeoutWalkRatio	strikeoutsper9inn StrikeoutsPer9Inn	walksper9inn WalksPer9Inn	hitsper9inn HitsPer9Inn	strikepercentage StrikePercentage	pitchesperinning PitchesPerInning	stolenbasepercentage StolenBasePercentage	babip Babip
1876	118419	Bobby Mathews	player	1	Bobby Mathews	Robert	Mathews	Bobby	B Mathews	155	NYM	New York Mutuals	Mutuals	NL	104	P	Pitcher	P	.382	6.89	24	0.65	0.42	0.14	12.09	1.54		3	1.000	1.542	.333	.649	56	56	395	8	37	24	693	2.86	516	21	34		164	1.39	1548	56	55	2	.382	1.54	0.65	0.42	12.09	nan	nan	nan	nan
1876	114181	Cherokee Fisher	player	2	Cherokee Fisher	William	Fisher	Cherokee	C Fisher	204	CIN	Cincinnati Reds	Reds	NL	104	P	Pitcher	P	.167	8.08	6	1.14	0.24	0.24	11.54	4.83	4	6	1.000	4.833	1.000	.207	28	24	206	6	29	6	294	3.02	229.1	4	20		77	1.31	688	28	22		.167	4.83	1.14	0.24	11.54	nan	nan	nan	nan
1876	122558	Al Spalding	player	2	Al Spalding	Albert	Spalding	Al	A Spalding	112	CHI	Chicago White Stockings	White Stockings	NL	104	P	Pitcher	P	.797	3.85	26	0.66	0.44	0.10	9.23	1.50	2	1	1.000	1.500	.231	.667	61	60	226	6	39	26	542	1.75	528.2	47	12		103	1.07	1586	61	53	8	.797	1.50	0.66	0.44	9.23	nan	nan	nan	nan
1876	111231	Joe Borden	player	4	Joe Borden	Joseph	Borden	Joe	J Borden	144	BSN	Boston Red Caps	Red Caps	NL	104	P	Pitcher	P	.478	6.39	51	1.40	2.10	0.16	10.59	0.67	6	21	1.000	.667	.078	1.500	29	24	155	4	34	51	257	2.89	218.1	11	12	1	70	1.41	655	29	16	2	.478	0.67	1.40	2.10	10.59	nan	nan	nan	nan
1876	111343	George Bradley	player	5	George Bradley	George	Bradley	George	G Bradley	195	STL	St. Louis Brown Stockings	Brown Stockings	NL	104	P	Pitcher	P	.703	3.60	38	1.62	0.60	0.05	7.38	2.71		34	1.000	2.711	.079	.369	64	64	229	3	103	38	470	1.23	573	45	19		78	0.89	1719	64	63	16	.703	2.71	1.62	0.60	7.38	nan	nan	nan	nan
1876	113313	Jim Devlin	player	5	Jim Devlin	James	Devlin	Jim	J Devlin	132	LOU	Louisville Grays	Grays	NL	104	P	Pitcher	P	.462	4.47	37	1.77	0.54	0.04	8.19	3.30		14	1.000	3.297	.081	.303	68	68	309	3	122	37	566	1.56	622	30	35		108	0.97	1866	68	66	5	.462	3.30	1.77	0.54	8.19	nan	nan	nan	nan
1876	111186	Tommy Bond	player	7	Tommy Bond	Thomas	Bond	Tommy	T Bond	123	HAR	Hartford Dark Blues	Dark Blues	NL	104	P	Pitcher	P	.705	3.62	13	1.94	0.29	0.04	7.83	6.77		8	1.000	6.769	.154	.148	45	45	164	2	88	13	355	1.68	408	31	13		76	0.90	1224	45	45	6	.705	6.77	1.94	0.29	7.83	nan	nan	nan	nan
1876	124760	George Zettlein	player	7	George Zettlein	George	Zettlein	George	G Zettlein	173	PHN	Philadelphia Athletics	Athletics	NL	104	P	Pitcher	P	.167	8.15	6	0.38	0.23	0.08	13.77	1.67	4	4	1.000	1.667	.333	.600	28	25	212	2	10	6	358	3.88	234	4	20	2	101	1.56	702	28	23	1	.167	1.67	0.38	0.23	13.77	nan	nan	nan	nan
1876	111342	Foghorn Bradley	player	9	Foghorn Bradley	George	Bradley	Foghorn	F Bradley	144	BSN	Boston Red Caps	Red Caps	NL	104	P	Pitcher	P	.474	6.02	16	0.83	0.83	0.05	10.44	1.00	1	7	1.000	1.000	.063	1.000	22	21	116	1	16	16	201	2.49	173.1	9	10	1	48	1.25	520	22	16	1	.474	1.00	0.83	0.83	10.44	nan	nan	nan	nan
1876	113166	Dory Dean	player	9	Dory Dean	Charles	Dean	Dory	D Dean	204	CIN	Cincinnati Reds	Reds	NL	104	P	Pitcher	P	.133	9.18	24	0.75	0.82	0.03	13.60	0.92	1	17	1.000	.917	.042	1.091	30	30	268	1	22	24	397	3.73	262.2	4	26		109	1.60	788	30	26		.133	0.92	0.75	0.82	13.60	nan	nan	nan	nan


CREATE TABLE pitching_mlb (
  "year" BIGINT,
  "playerid" BIGINT,
  "playername" VARCHAR,
  "type" VARCHAR,
  "rank" BIGINT,
  "playerfullname" VARCHAR,
  "playerfirstname" VARCHAR,
  "playerlastname" VARCHAR,
  "playerusename" VARCHAR,
  "playerinitlastname" VARCHAR,
  "teamid" BIGINT,
  "teamabbrev" VARCHAR,
  "teamname" VARCHAR,
  "teamshortname" VARCHAR,
  "leaguename" VARCHAR,
  "leagueid" BIGINT,
  "positionabbrev" VARCHAR,
  "position" VARCHAR,
  "primarypositionabbrev" VARCHAR,
  "winningpercentage" VARCHAR,
  "runsscoredper9" VARCHAR,
  "battersfaced" DOUBLE,
  "strikeoutsper9" VARCHAR,
  "baseonballsper9" VARCHAR,
  "homerunsper9" VARCHAR,
  "hitsper9" VARCHAR,
  "strikesoutstowalks" VARCHAR,
  "gamesfinished" DOUBLE,
  "wildpitches" DOUBLE,
  "walksperplateappearance" VARCHAR,
  "strikeoutsperplateappearance" VARCHAR,
  "homerunsperplateappearance" VARCHAR,
  "walksperstrikeout" VARCHAR,
  "gamesplayed" BIGINT,
  "gamesstarted" BIGINT,
  "runs" BIGINT,
  "homeruns" DOUBLE,
  "strikeouts" BIGINT,
  "baseonballs" BIGINT,
  "hits" BIGINT,
  "era" VARCHAR,
  "inningspitched" DOUBLE,
  "wins" BIGINT,
  "losses" BIGINT,
  "saves" BIGINT,
  "earnedruns" BIGINT,
  "whip" VARCHAR,
  "outs" BIGINT,
  "gamespitched" BIGINT,
  "completegames" BIGINT,
  "shutouts" BIGINT,
  "winpercentage" VARCHAR,
  "strikeoutwalkratio" VARCHAR,
  "strikeoutsper9inn" VARCHAR,
  "walksper9inn" VARCHAR,
  "hitsper9inn" VARCHAR,
  "balks" DOUBLE,
  "stolenbases" DOUBLE,
  "caughtstealing" DOUBLE,
  "pickoffs" DOUBLE,
  "strikepercentage" VARCHAR,
  "pitchesperinning" VARCHAR,
  "pitchesperplateappearance" DOUBLE,
  "stolenbasepercentage" VARCHAR,
  "numberofpitches" DOUBLE,
  "strikes" DOUBLE,
  "totalbases" DOUBLE,
  "babip" VARCHAR,
  "obp" DOUBLE,
  "hitbypitch" DOUBLE,
  "avg" DOUBLE,
  "atbats" DOUBLE,
  "hitbatsmen" DOUBLE,
  "slg" DOUBLE,
  "ops" DOUBLE,
  "iso" DOUBLE,
  "sacbunts" DOUBLE,
  "doubles" DOUBLE,
  "triples" DOUBLE,
  "gidp" DOUBLE,
  "groundintodoubleplay" DOUBLE,
  "intentionalwalks" DOUBLE,
  "sacflies" DOUBLE,
  "saveopportunities" DOUBLE,
  "blownsaves" DOUBLE,
  "inheritedrunners" DOUBLE,
  "inheritedrunnersscored" DOUBLE,
  "bequeathedrunners" DOUBLE,
  "bequeathedrunnersscored" DOUBLE,
  "qualitystarts" DOUBLE,
  "gidpopp" DOUBLE,
  "totalswings" DOUBLE,
  "swingandmisses" DOUBLE,
  "ballsinplay" DOUBLE,
  "runsupport" DOUBLE,
  "flyouts" DOUBLE,
  "popouts" DOUBLE,
  "lineouts" DOUBLE,
  "groundouts" DOUBLE,
  "flyhits" DOUBLE
);