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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"playername" VARCHAR,
"season" BIGINT,
"position" VARCHAR,
"age" BIGINT,
"team" VARCHAR,
"offensiverating" BIGINT,
"defensiverating" BIGINT,
"ratingsum" BIGINT,
"scaledratingsum" BIGINT
);
CREATE TABLE ratingsovertime (
"unnamed_0" BIGINT,
"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,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE,
"n_3p" BIGINT,
"n_3pa" BIGINT,
"n_3p_d87a85" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2p_c8658d" DOUBLE,
"efg" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE,
"n_3par" DOUBLE,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE,
"drb_f91726" DOUBLE,
"trb_08d3e9" DOUBLE,
"ast_d11618" DOUBLE,
"stl_d4de98" DOUBLE,
"blk_d028d3" DOUBLE,
"tov_8a121e" DOUBLE,
"usg" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);
CREATE TABLE stats_2005 (
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE,
"n_3p" BIGINT,
"n_3pa" BIGINT,
"n_3p_d87a85" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2p_c8658d" DOUBLE,
"efg" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE,
"n_3par" DOUBLE,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE,
"drb_f91726" DOUBLE,
"trb_08d3e9" DOUBLE,
"ast_d11618" DOUBLE,
"stl_d4de98" DOUBLE,
"blk_d028d3" DOUBLE,
"tov_8a121e" DOUBLE,
"usg" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);
CREATE TABLE stats_2006 (
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE,
"n_3p" BIGINT,
"n_3pa" BIGINT,
"n_3p_d87a85" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2p_c8658d" DOUBLE,
"efg" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE,
"n_3par" DOUBLE,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE,
"drb_f91726" DOUBLE,
"trb_08d3e9" DOUBLE,
"ast_d11618" DOUBLE,
"stl_d4de98" DOUBLE,
"blk_d028d3" DOUBLE,
"tov_8a121e" DOUBLE,
"usg" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);
CREATE TABLE stats_2007 (
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE,
"n_3p" BIGINT,
"n_3pa" BIGINT,
"n_3p_d87a85" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2p_c8658d" DOUBLE,
"efg" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE,
"n_3par" DOUBLE,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE,
"drb_f91726" DOUBLE,
"trb_08d3e9" DOUBLE,
"ast_d11618" DOUBLE,
"stl_d4de98" DOUBLE,
"blk_d028d3" DOUBLE,
"tov_8a121e" DOUBLE,
"usg" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE
);
CREATE TABLE stats_2008 (
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fg_51ab2d" DOUBLE,
"n_3p" BIGINT,
"n_3pa" BIGINT,
"n_3p_d87a85" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2p_c8658d" DOUBLE,
"efg" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ft_ba25d5" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"ts" DOUBLE,
"n_3par" DOUBLE,
"ftr" DOUBLE,
"orb_6d1d9b" DOUBLE,
"drb_f91726" DOUBLE,
"trb_08d3e9" DOUBLE,
"ast_d11618" DOUBLE,
"stl_d4de98" DOUBLE,
"blk_d028d3" DOUBLE,
"tov_8a121e" DOUBLE,
"usg" DOUBLE,
"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.