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

player_id PLAYER ID	player_name PLAYER NAME	nickname NICKNAME	team_id TEAM ID	team_abbreviation TEAM ABBREVIATION	age AGE	gp GP	w W	l L	w_pct W PCT	min MIN	fgm FGM	fga FGA	fg_pct FG PCT	fg3m FG3M	fg3a FG3A	fg3_pct FG3 PCT	ftm FTM	fta FTA	ft_pct FT PCT	oreb OREB	dreb DREB	reb REB	ast AST	tov TOV	stl STL	blk BLK	blka BLKA	pf PF	pfd PFD	pts PTS	plus_minus PLUS MINUS	nba_fantasy_pts NBA FANTASY PTS	dd2 DD2	wnba_fantasy_pts WNBA FANTASY PTS	gp_rank GP RANK	w_rank W RANK	l_rank L RANK	w_pct_rank W PCT RANK	min_rank MIN RANK	fgm_rank FGM RANK	fga_rank FGA RANK	fg_pct_rank FG PCT RANK	fg3m_rank FG3M RANK	fg3a_rank FG3A RANK	fg3_pct_rank FG3 PCT RANK	ftm_rank FTM RANK	fta_rank FTA RANK	ft_pct_rank FT PCT RANK	oreb_rank OREB RANK	dreb_rank DREB RANK	reb_rank REB RANK	ast_rank AST RANK	tov_rank TOV RANK	stl_rank STL RANK	blk_rank BLK RANK	blka_rank BLKA RANK	pf_rank PF RANK	pfd_rank PFD RANK	pts_rank PTS RANK	plus_minus_rank PLUS MINUS RANK	nba_fantasy_pts_rank NBA FANTASY PTS RANK	dd2_rank DD2 RANK	td3_rank TD3 RANK	wnba_fantasy_pts_rank WNBA FANTASY PTS RANK	year YEAR
920	A.C. Green	A.C.	1610612742	DAL	34	82	20	62	0.244	2645.5066666666667	242	534	0.453		4		116	162	0.716	219	449	668	123	68	78	27	33	157	2	600	-381	1833.1	14	1601	1	259	422	366	48	151	156	163	274	266	274	152	155	245	22	17	21	155	215	83	133	288	280	51	164	420	101	53	13	121	1997-98
243	Aaron McKie	Aaron	1610612755	PHI	25	81	34	47	0.42	1812.5416666666667	139	381	0.365	12	63	0.19	42	55	0.764	58	173	231	175	76	101	13	35	164	1	332	25	1137.7		978	52	169	378	299	142	236	209	379	163	141	250	277	293	170	189	156	167	114	202	42	215	297	293	96	245	143	189	207	13	201	1997-98
1425	Aaron Williams	Aaron	1610612760	SEA	26	65	49	16	0.754	756.795	116	221	0.525		1		66	85	0.776	49	99	148	14	50	19	38	25	119	1	298	63	617.6		574	202	55	111	30	276	250	269	34	274	331	274	223	236	152	214	248	243	356	258	293	97	238	219	96	252	113	272	207	13	271	1997-98
228	Adam Keefe	Adam	1610612762	UTA	28	80	61	19	0.763	2047.0916666666667	229	424	0.54				162	200	0.81	179	259	438	89	71	52	24	52	172	2	620	428	1436.1	5	1299	73	6	134	24	121	161	193	20	274	366	274	104	114	95	47	88	69	186	210	171	150	366	302	51	159	18	143	100	13	154	1997-98
1502	Adonal Foyle	Adonal	1610612744	GSW	23	55	9	46	0.164	657.3683333333333	69	170	0.406		1		27	62	0.435	73	111	184	14	50	13	52	19	94	1	165	-168	551.8		493	264	354	370	410	292	295	294	312	274	331	274	318	277	408	159	233	203	356	258	326	69	204	171	96	297	375	280	207	13	280	1997-98
154	Adrian Caldwell	Adrian	1610612742	DAL	31	1	1		1	2.716666666666667																									435	422	1	1	439	434	438	434	274	366	274	421	425	421	429	435	438	427	434	423	400	1	1	197	435	192	438	207	13	439	1997-98
673	Alan Henderson	Alan	1610612737	ATL	25	69	42	27	0.609	2006.3433333333328	365	753	0.485	3	6	0.5	253	388	0.652	200	242	442	73	110	40	36	77	175	1	986	90	1743.9	12	1656	182	94	231	137	123	74	85	88	209	247	4	46	33	313	31	100	66	216	122	207	109	422	308	96	75	102	119	61	13	112	1997-98
275	Allan Houston	Allan	1610612752	NYK	27	82	43	39	0.524	2849.353333333333	571	1277	0.447	82	213	0.385	285	335	0.851	43	231	274	212	200	63	24	64	207	1	1509	129	2216.8	1	2251	1	87	335	216	28	15	16	182	46	55	67	31	43	53	230	105	141	85	24	128	150	399	368	96	20	81	62	153	13	44	1997-98
947	Allen Iverson	Allen	1610612755	PHI	23	80	31	49	0.388	3152.1966666666667	649	1407	0.461	70	235	0.298	390	535	0.729	86	210	296	494	244	176	25	107	200		1758	-93	3213.2	12	3020	73	188	387	312	10	8	5	139	58	41	194	10	8	220	133	125	132	14	13	5	143	435	356	197	7	342	11	61	13	10	1997-98
297	Alonzo Mourning	Alonzo	1610612748	MIA	28	58	39	19	0.672	1939.3166666666664	404	733	0.551				309	465	0.665	194	365	559	52	179	40	130	58	208	7	1117	427	2196.8	24	2068	240	118	134	96	131	62	93	15	274	366	274	24	16	305	39	43	39	253	41	207	18	386	369	2	58	20	64	26	13	59	1997-98


CREATE TABLE totals_nba (
  "player_id" BIGINT,
  "player_name" VARCHAR,
  "nickname" VARCHAR,
  "team_id" BIGINT,
  "team_abbreviation" VARCHAR,
  "age" DOUBLE,
  "gp" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "w_pct" DOUBLE,
  "min" DOUBLE,
  "fgm" BIGINT,
  "fga" BIGINT,
  "fg_pct" DOUBLE,
  "fg3m" BIGINT,
  "fg3a" BIGINT,
  "fg3_pct" DOUBLE,
  "ftm" BIGINT,
  "fta" BIGINT,
  "ft_pct" DOUBLE,
  "oreb" BIGINT,
  "dreb" BIGINT,
  "reb" BIGINT,
  "ast" BIGINT,
  "tov" BIGINT,
  "stl" BIGINT,
  "blk" BIGINT,
  "blka" BIGINT,
  "pf" BIGINT,
  "pfd" BIGINT,
  "pts" BIGINT,
  "plus_minus" BIGINT,
  "nba_fantasy_pts" DOUBLE,
  "dd2" BIGINT,
  "td3" BIGINT,
  "wnba_fantasy_pts" DOUBLE,
  "gp_rank" BIGINT,
  "w_rank" BIGINT,
  "l_rank" BIGINT,
  "w_pct_rank" BIGINT,
  "min_rank" BIGINT,
  "fgm_rank" BIGINT,
  "fga_rank" BIGINT,
  "fg_pct_rank" BIGINT,
  "fg3m_rank" BIGINT,
  "fg3a_rank" BIGINT,
  "fg3_pct_rank" BIGINT,
  "ftm_rank" BIGINT,
  "fta_rank" BIGINT,
  "ft_pct_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "reb_rank" BIGINT,
  "ast_rank" BIGINT,
  "tov_rank" BIGINT,
  "stl_rank" BIGINT,
  "blk_rank" BIGINT,
  "blka_rank" BIGINT,
  "pf_rank" BIGINT,
  "pfd_rank" BIGINT,
  "pts_rank" BIGINT,
  "plus_minus_rank" BIGINT,
  "nba_fantasy_pts_rank" BIGINT,
  "dd2_rank" BIGINT,
  "td3_rank" BIGINT,
  "wnba_fantasy_pts_rank" BIGINT,
  "year" VARCHAR
);