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
);
CREATE TABLE stats_2009 (
"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_2010 (
"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_2011 (
"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_2012 (
"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_2013 (
"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_2014 (
"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_2015 (
"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_2016 (
"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_2017 (
"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_2018 (
"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_2019 (
"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_2020 (
"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_2021 (
"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_2022 (
"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 withratings_stats_2004 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2005 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2006 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2007 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2008 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2009 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2010 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2011 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2012 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2013 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2014 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2015 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2016 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2017 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2018 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2019 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2020 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2021 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
CREATE TABLE withratings_stats_2022 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"rk" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" BIGINT,
"fg" BIGINT,
"fga" BIGINT,
"fgpc" DOUBLE,
"tp" BIGINT,
"tpa" BIGINT,
"tppc" DOUBLE,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"n_2ppc" DOUBLE,
"efgpc" DOUBLE,
"ft" BIGINT,
"fta" BIGINT,
"ftpc" DOUBLE,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"per" DOUBLE,
"tspc" DOUBLE,
"tpar" DOUBLE,
"ftr" DOUBLE,
"orbpc" DOUBLE,
"drbpc" DOUBLE,
"trbpc" DOUBLE,
"astpc" DOUBLE,
"stlpc" DOUBLE,
"blkpc" DOUBLE,
"tovpc" DOUBLE,
"usgpc" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"drbpg" DOUBLE,
"drbpgrating" BIGINT,
"bpg" DOUBLE,
"bpgrating" BIGINT,
"spg" DOUBLE,
"spgrating" BIGINT,
"ppg" DOUBLE,
"ppgrating" BIGINT,
"apg" DOUBLE,
"apgrating" BIGINT,
"orbpg" DOUBLE,
"orbpgrating" BIGINT,
"stlpcrating" BIGINT,
"blkpcrating" BIGINT,
"dwsrating" BIGINT,
"dbpmrating" BIGINT,
"astpcrating" BIGINT,
"owsrating" BIGINT,
"tspcrating" BIGINT,
"perrating" BIGINT,
"obpmrating" BIGINT,
"ptsrating" BIGINT,
"vorprating" BIGINT,
"usgpcrating" BIGINT,
"tparrating" BIGINT,
"defensiverating" BIGINT,
"offensiverating" BIGINT,
"scaleddefensiverating" BIGINT,
"scaledoffensiverating" BIGINT,
"playerrating" BIGINT
);
Anyone who has the link will be able to view this.