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

assists Assists	evgoals EvGoals	evpoints EvPoints	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
163	38	143	6	80	52	Gretzky	1	46	8447400	71	215	2.6875	C	11	54	19851986	3	18	0.14857	L	350	Wayne Gretzky	EDM
120	68	147	12	80	92	Gretzky		26	8447400	80	212	2.65	C	18	57	19811982	6	8	0.24864	L	370	Wayne Gretzky	EDM
135	54	146	7	80	73	Gretzky		52	8447400	100	208	2.6	C	8	44	19841985	11	18	0.20621	L	354	Wayne Gretzky	EDM
118	55	135	11	74	87	Gretzky		39	8447400	78	205	2.77027	C	20	47	19831984	12	23	0.26687	L	326	Wayne Gretzky	EDM
114	41	102	8	76	85	Lemieux	1	100	8448782	41	199	2.61842	C	31	79	19881989	13	18	0.27156	R	313	Mario Lemieux	PIT
125	47	132	9	80	71	Gretzky		59	8447400	61	196	2.45	C	18	54	19821983	6	10	0.20402	L	348	Wayne Gretzky	EDM
121	42	124	4	79	62	Gretzky		28	8447400	69	183	2.31645	C	13	46	19861987	7	13	0.21527	L	288	Wayne Gretzky	EDM
98	38	74	7	77	70	Lemieux	2	92	8448782	23	168	2.18181	C	22	80	19871988	10	14	0.18324	R	382	Mario Lemieux	PIT
114	38	100	5	78	54	Gretzky		26	8447400	15	168	2.15384	C	11	53	19881989	5	15	0.17821	L	303	Wayne Gretzky	LAK
90	45	101	7	80	65	Yzerman	2	61	8452578	17	155	1.9375	C	17	46	19881989	3	8	0.16752	R	388	Steve Yzerman	DET


CREATE TABLE all_skaters_1981_1990 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" VARCHAR,
  "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" VARCHAR
);