NBA Players Stats And Rating (Timeseries)
Analyze NBA players performance over time The best players in the NBA, accordin
@kaggle.thedevastator_nba_players_stats_and_rating_timeseries
Analyze NBA players performance over time The best players in the NBA, accordin
@kaggle.thedevastator_nba_players_stats_and_rating_timeseries
.
CREATE TABLE fr_2004 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2005 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2006 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2007 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2008 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2009 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2010 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2011 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2012 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2013 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2014 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2015 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2016 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2017 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2018 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2019 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2020 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2021 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE fr_2022 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE ratingsovertime (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);CREATE TABLE stats_2004 (
"unnamed_0" BIGINT -- Unnamed: 0,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" BIGINT -- 3P,
"n_3pa" BIGINT -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" BIGINT -- 2P,
"n_2pa" BIGINT -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE -- FT%,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE -- TS%,
"n_3par" DOUBLE -- 3PAr,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE -- ORB%,
"drb_f91726" DOUBLE -- DRB%,
"trb_08d3e9" DOUBLE -- TRB%,
"ast_d11618" DOUBLE -- AST%,
"stl_d4de98" DOUBLE -- STL%,
"blk_d028d3" DOUBLE -- BLK%,
"tov_8a121e" DOUBLE -- TOV%,
"usg" DOUBLE -- USG%,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);CREATE TABLE stats_2005 (
"unnamed_0" BIGINT -- Unnamed: 0,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" BIGINT -- 3P,
"n_3pa" BIGINT -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" BIGINT -- 2P,
"n_2pa" BIGINT -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE -- FT%,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE -- TS%,
"n_3par" DOUBLE -- 3PAr,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE -- ORB%,
"drb_f91726" DOUBLE -- DRB%,
"trb_08d3e9" DOUBLE -- TRB%,
"ast_d11618" DOUBLE -- AST%,
"stl_d4de98" DOUBLE -- STL%,
"blk_d028d3" DOUBLE -- BLK%,
"tov_8a121e" DOUBLE -- TOV%,
"usg" DOUBLE -- USG%,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);CREATE TABLE stats_2006 (
"unnamed_0" BIGINT -- Unnamed: 0,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" BIGINT -- 3P,
"n_3pa" BIGINT -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" BIGINT -- 2P,
"n_2pa" BIGINT -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE -- FT%,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE -- TS%,
"n_3par" DOUBLE -- 3PAr,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE -- ORB%,
"drb_f91726" DOUBLE -- DRB%,
"trb_08d3e9" DOUBLE -- TRB%,
"ast_d11618" DOUBLE -- AST%,
"stl_d4de98" DOUBLE -- STL%,
"blk_d028d3" DOUBLE -- BLK%,
"tov_8a121e" DOUBLE -- TOV%,
"usg" DOUBLE -- USG%,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);CREATE TABLE stats_2007 (
"unnamed_0" BIGINT -- Unnamed: 0,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" BIGINT -- 3P,
"n_3pa" BIGINT -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" BIGINT -- 2P,
"n_2pa" BIGINT -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE -- FT%,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE -- TS%,
"n_3par" DOUBLE -- 3PAr,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE -- ORB%,
"drb_f91726" DOUBLE -- DRB%,
"trb_08d3e9" DOUBLE -- TRB%,
"ast_d11618" DOUBLE -- AST%,
"stl_d4de98" DOUBLE -- STL%,
"blk_d028d3" DOUBLE -- BLK%,
"tov_8a121e" DOUBLE -- TOV%,
"usg" DOUBLE -- USG%,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);CREATE TABLE stats_2008 (
"unnamed_0" BIGINT -- Unnamed: 0,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" BIGINT -- 3P,
"n_3pa" BIGINT -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" BIGINT -- 2P,
"n_2pa" BIGINT -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE -- FT%,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE -- TS%,
"n_3par" DOUBLE -- 3PAr,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE -- ORB%,
"drb_f91726" DOUBLE -- DRB%,
"trb_08d3e9" DOUBLE -- TRB%,
"ast_d11618" DOUBLE -- AST%,
"stl_d4de98" DOUBLE -- STL%,
"blk_d028d3" DOUBLE -- BLK%,
"tov_8a121e" DOUBLE -- TOV%,
"usg" DOUBLE -- USG%,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);Anyone who has the link will be able to view this.