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 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.