NBA All Stars: 20 Year Per Game Stats
NBA All-Stars Stats From 2001-2021
@kaggle.andrew1456_nba_all_stars_20_year_per_game_stats
NBA All-Stars Stats From 2001-2021
@kaggle.andrew1456_nba_all_stars_20_year_per_game_stats
Per game data from Basketball Reference and cleaned by reference of all-star selection including injured and replacements from Wikipedia. Removed data breakdowns for players traded mid-year. Players traded mid-year teams will shows a "TOT".
Player - Player Name
Pos - Primary Position Played (PG, SG, SF, PF, C)
Age - Age of Player
Tm - Team Played For (TOT = total of multiple teams in a year. Removed partial season data.)
G - Games Played
GS - Games Started
MP - Minutes Played
FG - Field Goals Made
FGA - Field Goals Attempted
FG% - Field Goal Percentage
3P - Three Pointers Made
3PA - Three Pointers Attempted
3P% - Three Point Percentage
2P - Two Pointers Mades
2PA - Two Pointers Attempted
2P%- Two Point Percentage
eFG% - Effective Field Goal Percentage
FT - Free Throws Made
FTA - Free Throws Attempted
FT% - Free Throw Percentage
ORB - Offensive Rebounds
DRB - Defensive Rebounds
TRB - Total Rebounds
AST - Assists
STL - Steals
BLK - Blocks
TOV -Turnovers
PF -Personal Fouls
PTS -Points
CREATE TABLE n_2002_03_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2003_04_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2004_05_nba_sheet1_1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2005_06_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2006_07_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2007_08_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2008_09_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2009_10_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2010_11_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2011_12_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2012_13_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2013_14_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2014_15_nba_sheet1_1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2015_16_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2016_17_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2017_18_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2018_19_nba_sheet1_1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2019_20_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2020_21_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
CREATE TABLE n_2021_22_nba_sheet1 (
"player" VARCHAR,
"pos" VARCHAR,
"age" BIGINT,
"tm" VARCHAR,
"g" BIGINT,
"gs" BIGINT,
"mp" DOUBLE,
"fg" DOUBLE,
"fga" DOUBLE,
"fg_51ab2d" DOUBLE -- FG%,
"n_3p" DOUBLE -- 3P,
"n_3pa" DOUBLE -- 3PA,
"n_3p_d87a85" DOUBLE -- 3P%,
"n_2p" DOUBLE -- 2P,
"n_2pa" DOUBLE -- 2PA,
"n_2p_c8658d" DOUBLE -- 2P%,
"efg" DOUBLE -- EFG%,
"ft" DOUBLE,
"fta" DOUBLE,
"ft_ba25d5" DOUBLE -- FT%,
"orb" DOUBLE,
"drb" DOUBLE,
"trb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE
);
Anyone who has the link will be able to view this.