NBA Player Statistics

Advanced NBA player performance data from 2011-2022

@kaggle.marcsperzel_nba_player_statistics

Table List

1 table(26.1 MB)

Player Data

@kaggle.marcsperzel_nba_player_statistics.player_data

26.1 MB
255914 rows
115 columns
Only the first 100 columns are shown

n__id Id	game_id GAME ID	game_date GAME DATE	team_id TEAM ID	team_abbreviation TEAM ABBREVIATION	team_city TEAM CITY	player_id PLAYER ID	player_name PLAYER NAME	nickname NICKNAME	start_position START POSITION	pct_fga_2pt PCT FGA 2PT	pct_ast_2pm PCT AST 2PM	pct_pts_2pt PCT PTS 2PT	ast_pct AST PCT	pct_fg3m PCT FG3M	pct_blka PCT BLKA	fg3_pct FG3 PCT	pct_pts PCT PTS	pct_fgm PCT FGM	pct_reb PCT REB	pct_fga PCT FGA	e_usg_pct E USG PCT	reb_pct REB PCT	pct_pts_off_tov PCT PTS OFF TOV	pct_dreb PCT DREB	opp_oreb_pct OPP OREB PCT	pct_uast_3pm PCT UAST 3PM	pct_tov PCT TOV	dreb_pct DREB PCT	pct_ftm PCT FTM	opp_tov_pct OPP TOV PCT	pct_uast_2pm PCT UAST 2PM	pct_ast_3pm PCT AST 3PM	usg_pct USG PCT	pct_ast PCT AST	fg_pct FG PCT	efg_pct EFG PCT	ts_pct TS PCT	pct_oreb PCT OREB	pct_pts_2pt_mr PCT PTS 2PT MR	pct_pf PCT PF	ft_pct FT PCT	pct_pts_paint PCT PTS PAINT	pct_pts_ft PCT PTS FT	pct_pfd PCT PFD	pct_fga_3pt PCT FGA 3PT	opp_efg_pct OPP EFG PCT	cfg_pct CFG PCT	tm_tov_pct TM TOV PCT	pct_uast_fgm PCT UAST FGM	pct_pts_3pt PCT PTS 3PT	oreb_pct OREB PCT	pct_pts_fb PCT PTS FB	pct_ast_fgm PCT AST FGM	ufg_pct UFG PCT	pct_fg3a PCT FG3A	pct_stl PCT STL	dfg_pct DFG PCT	oreb OREB	ast AST	reb REB	dfga DFGA	sast SAST	opp_pts_2nd_chance OPP PTS 2ND CHANCE	pfd PFD	to TO	fg3a FG3A	stl STL	poss POSS	pass PASS	ufgm UFGM	fg3m FG3M	pts PTS	ufga UFGA	drbc DRBC	opp_pts_paint OPP PTS PAINT	ftm FTM	orbc ORBC	blka BLKA	pts_fb PTS FB	cfga CFGA	pts_paint PTS PAINT	tchs TCHS	cfgm CFGM	plus_minus PLUS MINUS	dfgm DFGM	opp_pts_off_tov OPP PTS OFF TOV	pts_off_tov PTS OFF TOV	fga FGA	fta FTA	pts_2nd_chance PTS 2ND CHANCE	fgm FGM	pf PF	dreb DREB	rbc RBC	opp_pts_fb OPP PTS FB	ftast FTAST	e_off_rating E OFF RATING
6257e8a35ccc080408fc781f	21500395	Fri Dec 18 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612762	UTA	Utah	202353	Tibor Pleiss	Tibor	nan
6257e8a35ccc080408fc7814	21500395	Fri Dec 18 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612762	UTA	Utah	1626168	Trey Lyles	Trey	F	1	0.333	1	0.071				0.118	0.176	0.3	0.154	0.135	0.122	0.333	0.313	0.385		0.143	0.185		0.149	0.667		0.135	0.143	0.5	0.5	0.5	0.25	0.667	0.091		0.333		0.083		0.477	1	12.5	0.667		0.045		0.333	0.25			0.8	1	1	6	5		11	1	1			47	42	1		6	4	8	24		2			2	2	50	2	-3	4	9	2	6		2	3	1	5	10	2		106.9
6257e8a35ccc080408fc7815	21500395	Fri Dec 18 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612762	UTA	Utah	202324	Derrick Favors	Derrick	C	1	0.5	0.571			0.5		0.093	0.074	0.31	0.145	0.159	0.134		0.25	0.333		0.143	0.158	0.25	0.141	0.5		0.157		0.25	0.25	0.343	0.6	0.286	0.364	0.6	0.286	0.429	0.286		0.45	0.333	9.1	0.5		0.103		0.5	0.2		0.2	0.6	3		9	5	1	11	4	1		1	64	68	1		7	5	11	30	3	7	1		3	2	82	1	7	3	9		8	5		2	4	6	17	2	1	117.1
6257e8a35ccc080408fc7807	21500395	Fri Dec 18 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612743	DEN	Denver	201568	Danilo Gallinari	Danilo	F	0.6	0.5	0.364	0.095	0.2		0.25	0.169	0.125	0.031	0.167	0.162	0.015	0.182	0.048	0.16			0.036	0.333	0.094	0.5	1	0.158	0.167	0.299	0.35	0.468		0.182	0.067	1	0.182	0.364	0.4	0.4	0.575	0.6		0.333	0.273			0.667		0.211		1		2	1	2		6	4		4		64	21		1	11	5	2	24	4	1			5	2	37	3	-11	2	8	2	10	4		3	1	1	3	4		102.9
6257e8a35ccc080408fc7810	21500395	Fri Dec 18 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612743	DEN	Denver	203123	Kostas Papanikolaou	Kostas	nan								0.048		0.2	0.067	0.161	0.095		0.286	0.125		0.4	0.2	0.125	0.248			0.16				0.266				0.5		1	0.125	1	0.5		50							0.167	0.333				2	1		2	1	2	1	1	22	13			1	1	2	8	1						17				6		1	2				2	2	4	1	96.2
6257e8a35ccc080408fc783a	41800152	Tue Apr 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612759	SAS	San Antonio	200746	LaMarcus Aldridge	LaMarcus	F	0.9	0.75	0.667	0.167		0.5		0.324	0.308	0.205	0.317	0.318	0.103	0.083	0.219	0.135		0.111	0.175	0.421	0.052	0.25		0.31	0.2	0.4	0.4	0.492	0.143	0.25	0.235	0.8	0.417	0.333	0.444	0.1	0.529	0.429	3.4	0.25		0.026		0.75	0.385	0.167		0.5	1	3	8	4		6	8	1	2		76	33	5		24	13	9	32	8	6	1		7	10	60	3	-12	2	13	2	20	10		8	4	7	14	18		99.1
6257e8a35ccc080408fc784b	41800152	Tue Apr 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612743	DEN	Denver	1628420	Monte Morris	Monte	nan	0.9	0.6	0.909	0.353				0.186	0.227	0.05	0.208	0.183	0.02	0.182	0.067	0.25			0.045	0.111	0.083	0.4		0.182	0.4	0.5	0.5	0.527		0.364		1	0.545	0.091	0.143	0.1	0.547	1		0.4			0.455	0.6	0.286	0.071	0.5	1		6	1	1		4	1		1	1	49	43	2		11	7	1	32	1	1		5	3	6	54	3		1	2	2	10	1		5		1	2		1	118.7
6257e8a35ccc080408fc7850	41800152	Tue Apr 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612743	DEN	Denver	1626168	Trey Lyles	Trey	nan
6257e8a35ccc080408fc7883	22100681	Thu Jan 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612752	NYK	New York	1630193	Immanuel Quickley	Immanuel	nan	0.308		0.286	0.455	0.286		0.222	0.28	0.267	0.154	0.351	0.352	0.091		0.211		0.5	0.444	0.2	0.308	0.183	1	0.5	0.339	0.455	0.307	0.385	0.474			0.071	1	0.286	0.286	0.231	0.692	0.417	0.5	16.7	0.75	0.429			0.25	0.222	0.391	0.75	1		5	4	2	2	3	3	4	9	3	46	41	2	2	14	9	4	12	4				4	4	64	2	15	2	10		13	4	3	4	1	4	4	6		106.6
6257e8a35ccc080408fc7823	21801141	Sat Mar 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1610612748	MIA	Miami	201609	Goran Dragic	Goran	G	0.5	0.5	0.4	0.4	0.286	0.2	0.286	0.13	0.138	0.05	0.2	0.207	0.024	0.5	0.067	0.167		0.333	0.051		0.202	0.5	1	0.202	0.455	0.285	0.357	0.357		0.2	0.125		0.2			0.5	0.475	0.333	17.2	0.25	0.6		0.2	0.75	0.25	0.28				10	2		1	8		5	7		79	57	2	2	10	8	2	32		3	1	2	6	2	76	2	3		12	5	14		3	4	2	2	5	6		94.4


CREATE TABLE player_data (
  "n__id" VARCHAR,
  "game_id" BIGINT,
  "game_date" TIMESTAMP,
  "team_id" BIGINT,
  "team_abbreviation" VARCHAR,
  "team_city" VARCHAR,
  "player_id" BIGINT,
  "player_name" VARCHAR,
  "nickname" VARCHAR,
  "start_position" VARCHAR,
  "pct_fga_2pt" DOUBLE,
  "pct_ast_2pm" DOUBLE,
  "pct_pts_2pt" DOUBLE,
  "ast_pct" DOUBLE,
  "pct_fg3m" DOUBLE,
  "pct_blka" DOUBLE,
  "pct_blk" DOUBLE,
  "fg3_pct" DOUBLE,
  "pct_pts" DOUBLE,
  "pct_fgm" DOUBLE,
  "pct_reb" DOUBLE,
  "pct_fga" DOUBLE,
  "e_usg_pct" DOUBLE,
  "reb_pct" DOUBLE,
  "pct_pts_off_tov" DOUBLE,
  "pct_dreb" DOUBLE,
  "opp_oreb_pct" DOUBLE,
  "pct_uast_3pm" DOUBLE,
  "pct_tov" DOUBLE,
  "dreb_pct" DOUBLE,
  "pct_ftm" DOUBLE,
  "opp_tov_pct" DOUBLE,
  "pct_uast_2pm" DOUBLE,
  "pct_ast_3pm" DOUBLE,
  "usg_pct" DOUBLE,
  "pct_ast" DOUBLE,
  "fg_pct" DOUBLE,
  "efg_pct" DOUBLE,
  "ts_pct" DOUBLE,
  "pct_oreb" DOUBLE,
  "pct_pts_2pt_mr" DOUBLE,
  "pct_pf" DOUBLE,
  "ft_pct" DOUBLE,
  "pct_pts_paint" DOUBLE,
  "pct_pts_ft" DOUBLE,
  "pct_pfd" DOUBLE,
  "pct_fga_3pt" DOUBLE,
  "opp_efg_pct" DOUBLE,
  "cfg_pct" DOUBLE,
  "tm_tov_pct" DOUBLE,
  "pct_uast_fgm" DOUBLE,
  "pct_pts_3pt" DOUBLE,
  "oreb_pct" DOUBLE,
  "pct_pts_fb" DOUBLE,
  "pct_ast_fgm" DOUBLE,
  "ufg_pct" DOUBLE,
  "pct_fg3a" DOUBLE,
  "pct_stl" DOUBLE,
  "dfg_pct" DOUBLE,
  "oreb" BIGINT,
  "ast" BIGINT,
  "reb" BIGINT,
  "dfga" BIGINT,
  "sast" BIGINT,
  "opp_pts_2nd_chance" BIGINT,
  "pfd" BIGINT,
  "to" BIGINT,
  "fg3a" BIGINT,
  "stl" BIGINT,
  "poss" BIGINT,
  "pass" BIGINT,
  "ufgm" BIGINT,
  "fg3m" BIGINT,
  "pts" BIGINT,
  "ufga" BIGINT,
  "drbc" BIGINT,
  "opp_pts_paint" BIGINT,
  "ftm" BIGINT,
  "orbc" BIGINT,
  "blka" BIGINT,
  "pts_fb" BIGINT,
  "cfga" BIGINT,
  "pts_paint" BIGINT,
  "tchs" BIGINT,
  "cfgm" BIGINT,
  "plus_minus" BIGINT,
  "dfgm" BIGINT,
  "opp_pts_off_tov" BIGINT,
  "pts_off_tov" BIGINT,
  "fga" BIGINT,
  "fta" BIGINT,
  "pts_2nd_chance" BIGINT,
  "fgm" BIGINT,
  "pf" BIGINT,
  "dreb" BIGINT,
  "blk" BIGINT,
  "rbc" BIGINT,
  "opp_pts_fb" BIGINT,
  "ftast" BIGINT,
  "e_off_rating" DOUBLE
);