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	plateappearances PlateAppearances	totalbases TotalBases	babip Babip	extrabasehits ExtraBaseHits	walksperplateappearance WalksPerPlateAppearance	strikeoutsperplateappearance StrikeoutsPerPlateAppearance	homerunsperplateappearance HomeRunsPerPlateAppearance	walksperstrikeout WalksPerStrikeout	iso Iso	gamesplayed GamesPlayed	runs Runs	doubles Doubles	triples Triples	homeruns HomeRuns	strikeouts StrikeOuts	baseonballs BaseOnBalls	hits Hits	avg Avg	atbats AtBats	slg Slg	rbi Rbi	atbatsperhomerun AtBatsPerHomeRun	pitchesperplateappearance PitchesPerPlateAppearance	stolenbasepercentage StolenBasePercentage	groundoutstoairouts GroundOutsToAirouts
1876	115339	George Hall	player	1	George Hall	George	Hall	George	G Hall	173	PHN	Philadelphia Athletics	Athletics	NL	104	X	Unknown	LF	276	146	.359	25	.029	.014	.018	2.000	0.179	60	51	7	13	5	4	8	98	0.366	268	0.545	45	53.60	nan	nan	nan
1876	116670	Charley Jones	player	2	Charley Jones	Charles	Jones	Charley	C Jones	204	CIN	Cincinnati Reds	Reds	NL	104	X	Unknown	LF	283	116	.294	25	.025	.060	.014	.412	0.134	64	40	17	4	4	17	7	79	0.286	276	0.42	38	69.00	nan	nan	nan
1876	110284	Cap Anson	player	3	Cap Anson	Adrian	Anson	Cap	C Anson	112	CHI	Chicago White Stockings	White Stockings	NL	104	3B	Third Base	1B	321	139	.361	18	.037	.025	.006	1.500	0.094	66	63	9	7	2	8	12	110	0.356	309	0.45	59	154.50	nan	nan	nan
1876	111570	Lew Brown	player	3	Lew Brown	Lewis	Brown	Lew	L Brown	144	BSN	Boston Red Caps	Red Caps	NL	104	C	Catcher	C	198	65	.228	14	.015	.111	.010	.136	0.123	45	23	6	6	2	22	3	41	0.21	195	0.333	21	97.50	nan	nan	nan
1876	114714	Joe Gerhardt	player	3	Joe Gerhardt	John	Gerhardt	Joe	J Gerhardt	132	LOU	Louisville Grays	Grays	NL	104	1B	First Base	2B	295	98	.260	15	.010	.017	.007	.600	0.075	65	33	10	3	2	5	3	76	0.26	292	0.336	18	146.00	nan	nan	nan
1876	115364	Jimmy Hallinan	player	3	Jimmy Hallinan	James	Hallinan	Jimmy	J Hallinan	155	NYM	New York Mutuals	Mutuals	NL	104	SS	Shortstop	SS	242	92	.278	15	.008	.017	.008	.500	0.104	54	45	7	6	2	4	2	67	0.279	240	0.383	36	120.00	nan	nan	nan
1876	115966	Paul Hines	player	3	Paul Hines	Paul	Hines	Paul	P Hines	112	CHI	Chicago White Stockings	White Stockings	NL	104	X	Unknown	CF	306	134	.330	26	.003	.010	.007	.333	0.108	64	62	21	3	2	3	1	101	0.331	305	0.439	59	152.50	nan	nan	nan
1876	118245	Jack Manning	player	3	Jack Manning	John	Manning	Jack	J Manning	144	BSN	Boston Red Caps	Red Caps	NL	104	X	Unknown	RF	295	95	.263	15	.024	.017	.007	1.400	0.066	70	52	13		2	5	7	76	0.264	288	0.33	25	144.00	nan	nan	nan
1876	119540	Tim Murnane	player	3	Tim Murnane	Timothy	Murnane	Tim	T Murnane	144	BSN	Boston Red Caps	Red Caps	NL	104	1B	First Base	1B	316	103	.289	9	.025	.038	.006	.667	0.052	69	60	4	3	2	12	8	87	0.282	308	0.334	34	154.00	nan	nan	nan
1876	120054	Jim O'Rourke	player	3	Jim O'Rourke	James	O'Rourke	Jim	J O'Rourke	144	BSN	Boston Red Caps	Red Caps	NL	104	X	Unknown	LF	327	131	.341	22	.046	.052	.006	.882	0.093	70	61	17	3	2	17	15	102	0.327	312	0.42	43	156.00	nan	nan	nan


CREATE TABLE hitting_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,
  "plateappearances" BIGINT,
  "totalbases" BIGINT,
  "babip" VARCHAR,
  "extrabasehits" BIGINT,
  "walksperplateappearance" VARCHAR,
  "strikeoutsperplateappearance" VARCHAR,
  "homerunsperplateappearance" VARCHAR,
  "walksperstrikeout" VARCHAR,
  "iso" DOUBLE,
  "gamesplayed" BIGINT,
  "runs" BIGINT,
  "doubles" BIGINT,
  "triples" BIGINT,
  "homeruns" BIGINT,
  "strikeouts" DOUBLE,
  "baseonballs" BIGINT,
  "hits" BIGINT,
  "avg" DOUBLE,
  "atbats" BIGINT,
  "slg" DOUBLE,
  "rbi" DOUBLE,
  "atbatsperhomerun" VARCHAR,
  "numberofpitches" DOUBLE,
  "pitchesperplateappearance" VARCHAR,
  "caughtstealing" DOUBLE,
  "stolenbases" DOUBLE,
  "stolenbasepercentage" VARCHAR,
  "hitbypitch" DOUBLE,
  "obp" DOUBLE,
  "ops" DOUBLE,
  "sacbunts" DOUBLE,
  "gidp" DOUBLE,
  "groundintodoubleplay" DOUBLE,
  "sacflies" DOUBLE,
  "intentionalwalks" DOUBLE,
  "leftonbase" DOUBLE,
  "gidpopp" DOUBLE,
  "reachedonerror" DOUBLE,
  "walkoffs" DOUBLE,
  "flyouts" DOUBLE,
  "totalswings" DOUBLE,
  "swingandmisses" DOUBLE,
  "ballsinplay" DOUBLE,
  "popouts" DOUBLE,
  "lineouts" DOUBLE,
  "groundouts" DOUBLE,
  "flyhits" DOUBLE,
  "pophits" DOUBLE,
  "linehits" DOUBLE,
  "groundhits" DOUBLE,
  "airouts" DOUBLE,
  "groundoutstoairouts" VARCHAR,
  "catchersinterference" DOUBLE
);