Michael Jordan, Kobe Bryant And Lebron James Stats
Who is statistically better? Let's analyze it!
@kaggle.xvivancos_michael_jordan_kobe_bryant_and_lebron_james_stats
Who is statistically better? Let's analyze it!
@kaggle.xvivancos_michael_jordan_kobe_bryant_and_lebron_james_stats
CREATE TABLE advanced_stats (
"season" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"lg" VARCHAR,
"pos" VARCHAR,
"g" BIGINT,
"mp" BIGINT,
"per" DOUBLE,
"ts" DOUBLE,
"n_3par" DOUBLE,
"ftr" DOUBLE,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"usg" DOUBLE,
"ows" DOUBLE,
"dws" DOUBLE,
"ws" DOUBLE,
"ws_48" DOUBLE,
"obpm" DOUBLE,
"dbpm" DOUBLE,
"bpm" DOUBLE,
"vorp" DOUBLE,
"player" VARCHAR,
"rsorpo" VARCHAR
);
CREATE TABLE allgames_stats (
"g" BIGINT,
"date" TIMESTAMP,
"tm" VARCHAR,
"x" VARCHAR,
"opp" VARCHAR,
"result" VARCHAR,
"gs" BIGINT,
"mp" VARCHAR,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE,
"n_3p" BIGINT,
"n_3pa" BIGINT,
"n_3p_d87a85" DOUBLE,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" BIGINT,
"ast" BIGINT,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" BIGINT,
"pf" BIGINT,
"pts" DOUBLE,
"gmsc" DOUBLE,
"player" VARCHAR,
"rsorpo" VARCHAR
);
CREATE TABLE allstar_games_stats (
"season" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"lg" VARCHAR,
"pos" VARCHAR,
"g" DOUBLE,
"gs" DOUBLE,
"mp" VARCHAR,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE,
"n_3p" DOUBLE,
"n_3pa" DOUBLE,
"n_3p_d87a85" DOUBLE,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE,
"orb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE,
"player" VARCHAR
);
CREATE TABLE game_highs_stats (
"season" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"lg" VARCHAR,
"mp" VARCHAR,
"fg" BIGINT,
"fga" BIGINT,
"n_3p" BIGINT,
"n_3pa" BIGINT,
"n_2p" BIGINT,
"n_2pa" BIGINT,
"ft" BIGINT,
"fta" BIGINT,
"orb" BIGINT,
"drb" BIGINT,
"trb" BIGINT,
"ast" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"tov" BIGINT,
"pf" BIGINT,
"pts" BIGINT,
"gmsc" DOUBLE,
"player" VARCHAR,
"rsorpo" VARCHAR
);
CREATE TABLE per_game_stats (
"season" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"lg" VARCHAR,
"pos" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE,
"n_3p" DOUBLE,
"n_3pa" DOUBLE,
"n_3p_d87a85" DOUBLE,
"n_2p" DOUBLE,
"n_2pa" DOUBLE,
"n_2p_c8658d" DOUBLE,
"efg" DOUBLE,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE,
"player" VARCHAR,
"rsorpo" VARCHAR
);
CREATE TABLE salaries (
"season" VARCHAR,
"team" VARCHAR,
"lg" VARCHAR,
"salary" VARCHAR,
"player" VARCHAR
);
CREATE TABLE totals_stats (
"season" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"lg" VARCHAR,
"pos" 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,
"player" VARCHAR,
"rsorpo" VARCHAR
);
Anyone who has the link will be able to view this.