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

assists Assists	evgoals EvGoals	evpoints EvPoints	faceoffwinpct FaceoffWinPct	gamewinninggoals GameWinningGoals	gamesplayed GamesPlayed	goals Goals	lastname LastName	otgoals OtGoals	penaltyminutes PenaltyMinutes	playerid PlayerId	plusminus PlusMinus	points Points	pointspergame PointsPerGame	positioncode PositionCode	ppgoals PpGoals	pppoints PpPoints	seasonid SeasonId	shgoals ShGoals	shpoints ShPoints	shootingpct ShootingPct	shootscatches ShootsCatches	shots Shots	skaterfullname SkaterFullName	teamabbrevs TeamAbbrevs	timeonicepergame TimeOnIcePerGame
96	18	72	0.51279	6	81	29	Thornton	1	61	8466138	31	125	1.5432	C	11	51	20052006		2	0.14871	L	195	Joe Thornton	BOS,SJS	1280.1975
69	30	71	0.16666	9	82	54	Jagr	2	72	8448208	34	123	1.5	R	24	52	20052006			0.14673	L	368	Jaromir Jagr	NYR	1324.5
84	23	59	0.49762	4	79	36	Crosby		60	8471675	10	120	1.51898	C	13	61	20062007			0.144	L	250	Sidney Crosby	PIT	1245.5443
92	12	60	0.51116	5	82	22	Thornton		44	8466138	24	114	1.39024	C	10	54	20062007			0.10328	L	213	Joe Thornton	SJS	1218.7439
78	19	70	0.42365	4	82	35	Malkin	2	80	8471215	17	113	1.37804	C	14	41	20082009	2	2	0.12068	L	290	Evgeni Malkin	PIT	1351.0243
47	43	75	0.38888	11	82	65	Ovechkin	2	40	8471214	28	112	1.36585	L	22	37	20072008			0.14573	R	446	Alex Ovechkin	WSH	1375.0609
83	23	83	0.49508	5	82	29	Sedin		48	8467876	35	112	1.36585	C	4	27	20092010	2	2	0.17469	L	166	Henrik Sedin	VAN	1181.2682
54	36	63	0.25	10	79	56	Ovechkin	2	72	8471214	8	110	1.3924	L	19	46	20082009	1	1	0.10606	R	528	Alex Ovechkin	WSH	1380.2784
58	36	72	0.5589	6	81	51	Crosby	1	71	8471675	15	109	1.34567	C	13	34	20092010	2	3	0.17114	L	298	Sidney Crosby	PIT	1317.2716
59	37	73	0.45454	7	72	50	Ovechkin		89	8471214	45	109	1.51388	L	13	36	20092010			0.13586	R	368	Alex Ovechkin	WSH	1307.8472


CREATE TABLE all_skaters_2001_2010 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" DOUBLE,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" BIGINT,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" BIGINT,
  "pppoints" BIGINT,
  "seasonid" BIGINT,
  "shgoals" BIGINT,
  "shpoints" BIGINT,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" BIGINT,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" DOUBLE
);