Dataset: NBA Stats (1947-present)

About this Dataset

NBA Stats (1947-present)

Context

When I set out to gather data for my first NBA-related project, I used the IMPORTHTML function from Google Sheets repeatedly on Basketball-Reference's Play Index (now Stathead), which was...not ideal to say the least. So I decided to learn how to web-scrape and compile this historical data for everyone to use (in the mold of Lahman's Baseball Database).

Content

There are 3 leagues represented: the National Basketball Association (1950-present), the NBA's predecessor in the Basketball Association of America (1947-1949) and the NBA's past competitor in the American Basketball Association (1968-1976)

There are three informational files: Player Season Info, Player Career Info & Team Abbrevs. Each player was given a unique player ID to facilitate aggregation into career stats.

On the team side, there are 7 files:

totals & opponent totals
per game & opponent per game statistics
per 100 possessions & opponent per 100 possessions statistics (starting from 1974)
team summaries

On the player side, there are 10 files:

player totals
player per game stats
player per 36 minute stats
player per 100 possessions stats (starting from 1974)
player advanced stats
player play by play stats (starting from 1997) - percentage of time spent at different positions, fouls drawn & committed, etc
player shooting stats (starting from 1997) - success rate and attempt rate from different shot distances
end of season teams (All-Defense, All-Rookie, All-League)
end of season team voting (All-League)
all-star selections
awards voting results (Rookie of the Year, Sixth Man of the Year, Most Valuable Player, Defensive Player of the Year, Most Improved Player)

For explanations about a certain stat, I'd suggest checking out Basketball-Reference's glossary.

Acknowledgements

Basketball-Reference for being the greatest comprehensive basketball stats site (in my humble opinion)

Robert Frey and David Schoch for determining how Basketball-Reference formats its pages

Photo by TJ Dragotta on Unsplash

Tables

Advanced

@kaggle.sumitrodatta_nba_aba_baa_stats.advanced

1.2 MB
32392 rows
32 columns


CREATE TABLE advanced (
  "seas_id" BIGINT,
  "season" BIGINT,
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" DOUBLE,
  "experience" BIGINT,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "g" BIGINT,
  "mp" DOUBLE,
  "per" DOUBLE,
  "ts_percent" DOUBLE,
  "x3p_ar" DOUBLE,
  "f_tr" DOUBLE,
  "orb_percent" DOUBLE,
  "drb_percent" DOUBLE,
  "trb_percent" DOUBLE,
  "ast_percent" DOUBLE,
  "stl_percent" DOUBLE,
  "blk_percent" DOUBLE,
  "tov_percent" DOUBLE,
  "usg_percent" DOUBLE,
  "ows" DOUBLE,
  "dws" DOUBLE,
  "ws" DOUBLE,
  "ws_48" DOUBLE,
  "obpm" DOUBLE,
  "dbpm" DOUBLE,
  "bpm" DOUBLE,
  "vorp" DOUBLE
);

All Star Selections

@kaggle.sumitrodatta_nba_aba_baa_stats.all_star_selections

13.14 KB
2000 rows
5 columns


CREATE TABLE all_star_selections (
  "player" VARCHAR,
  "team" VARCHAR,
  "lg" VARCHAR,
  "season" BIGINT,
  "replaced" BOOLEAN
);

End Of Season Teams Voting

@kaggle.sumitrodatta_nba_aba_baa_stats.end_of_season_teams_voting

88.9 KB
4412 rows
16 columns


CREATE TABLE end_of_season_teams_voting (
  "season" BIGINT,
  "lg" VARCHAR,
  "type" VARCHAR,
  "number_tm" VARCHAR,
  "position" VARCHAR,
  "player" VARCHAR,
  "age" BIGINT,
  "tm" VARCHAR,
  "pts_won" DOUBLE,
  "pts_max" DOUBLE,
  "share" DOUBLE,
  "x1st_tm" DOUBLE,
  "x2nd_tm" DOUBLE,
  "x3rd_tm" DOUBLE,
  "seas_id" BIGINT,
  "player_id" BIGINT
);

End Of Season Teams

@kaggle.sumitrodatta_nba_aba_baa_stats.end_of_season_teams

40.86 KB
2190 rows
11 columns


CREATE TABLE end_of_season_teams (
  "season" BIGINT,
  "lg" VARCHAR,
  "type" VARCHAR,
  "number_tm" VARCHAR,
  "player" VARCHAR,
  "position" VARCHAR,
  "seas_id" BIGINT,
  "player_id" BIGINT,
  "birth_year" DOUBLE,
  "tm" VARCHAR,
  "age" BIGINT
);

Opponent Stats Per 100 Poss

@kaggle.sumitrodatta_nba_aba_baa_stats.opponent_stats_per_100_poss

65.53 KB
1432 rows
28 columns


CREATE TABLE opponent_stats_per_100_poss (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "abbreviation" VARCHAR,
  "playoffs" BOOLEAN,
  "g" BIGINT,
  "mp" BIGINT,
  "opp_fg_per_100_poss" DOUBLE,
  "opp_fga_per_100_poss" DOUBLE,
  "opp_fg_percent" DOUBLE,
  "opp_x3p_per_100_poss" DOUBLE,
  "opp_x3pa_per_100_poss" DOUBLE,
  "opp_x3p_percent" DOUBLE,
  "opp_x2p_per_100_poss" DOUBLE,
  "opp_x2pa_per_100_poss" DOUBLE,
  "opp_x2p_percent" DOUBLE,
  "opp_ft_per_100_poss" DOUBLE,
  "opp_fta_per_100_poss" DOUBLE,
  "opp_ft_percent" DOUBLE,
  "opp_orb_per_100_poss" DOUBLE,
  "opp_drb_per_100_poss" DOUBLE,
  "opp_trb_per_100_poss" DOUBLE,
  "opp_ast_per_100_poss" DOUBLE,
  "opp_stl_per_100_poss" DOUBLE,
  "opp_blk_per_100_poss" DOUBLE,
  "opp_tov_per_100_poss" DOUBLE,
  "opp_pf_per_100_poss" DOUBLE,
  "opp_pts_per_100_poss" DOUBLE
);

Opponent Stats Per Game

@kaggle.sumitrodatta_nba_aba_baa_stats.opponent_stats_per_game

75.9 KB
1876 rows
28 columns


CREATE TABLE opponent_stats_per_game (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "abbreviation" VARCHAR,
  "playoffs" BOOLEAN,
  "g" DOUBLE,
  "mp_per_game" DOUBLE,
  "opp_fg_per_game" DOUBLE,
  "opp_fga_per_game" DOUBLE,
  "opp_fg_percent" DOUBLE,
  "opp_x3p_per_game" DOUBLE,
  "opp_x3pa_per_game" DOUBLE,
  "opp_x3p_percent" DOUBLE,
  "opp_x2p_per_game" DOUBLE,
  "opp_x2pa_per_game" DOUBLE,
  "opp_x2p_percent" DOUBLE,
  "opp_ft_per_game" DOUBLE,
  "opp_fta_per_game" DOUBLE,
  "opp_ft_percent" DOUBLE,
  "opp_orb_per_game" DOUBLE,
  "opp_drb_per_game" DOUBLE,
  "opp_trb_per_game" DOUBLE,
  "opp_ast_per_game" DOUBLE,
  "opp_stl_per_game" DOUBLE,
  "opp_blk_per_game" DOUBLE,
  "opp_tov_per_game" DOUBLE,
  "opp_pf_per_game" DOUBLE,
  "opp_pts_per_game" DOUBLE
);

Opponent Totals

@kaggle.sumitrodatta_nba_aba_baa_stats.opponent_totals

129.21 KB
1876 rows
28 columns


CREATE TABLE opponent_totals (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "abbreviation" VARCHAR,
  "playoffs" BOOLEAN,
  "g" DOUBLE,
  "mp" DOUBLE,
  "opp_fg" DOUBLE,
  "opp_fga" DOUBLE,
  "opp_fg_percent" DOUBLE,
  "opp_x3p" DOUBLE,
  "opp_x3pa" DOUBLE,
  "opp_x3p_percent" DOUBLE,
  "opp_x2p" DOUBLE,
  "opp_x2pa" DOUBLE,
  "opp_x2p_percent" DOUBLE,
  "opp_ft" DOUBLE,
  "opp_fta" DOUBLE,
  "opp_ft_percent" DOUBLE,
  "opp_orb" DOUBLE,
  "opp_drb" DOUBLE,
  "opp_trb" DOUBLE,
  "opp_ast" DOUBLE,
  "opp_stl" DOUBLE,
  "opp_blk" DOUBLE,
  "opp_tov" DOUBLE,
  "opp_pf" DOUBLE,
  "opp_pts" DOUBLE
);

Per 100 Poss

@kaggle.sumitrodatta_nba_aba_baa_stats.per_100_poss

1.11 MB
26745 rows
36 columns


CREATE TABLE per_100_poss (
  "seas_id" BIGINT,
  "season" BIGINT,
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" BIGINT,
  "experience" BIGINT,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "g" BIGINT,
  "gs" DOUBLE,
  "mp" BIGINT,
  "fg_per_100_poss" DOUBLE,
  "fga_per_100_poss" DOUBLE,
  "fg_percent" DOUBLE,
  "x3p_per_100_poss" DOUBLE,
  "x3pa_per_100_poss" DOUBLE,
  "x3p_percent" DOUBLE,
  "x2p_per_100_poss" DOUBLE,
  "x2pa_per_100_poss" DOUBLE,
  "x2p_percent" DOUBLE,
  "ft_per_100_poss" DOUBLE,
  "fta_per_100_poss" DOUBLE,
  "ft_percent" DOUBLE,
  "orb_per_100_poss" DOUBLE,
  "drb_per_100_poss" DOUBLE,
  "trb_per_100_poss" DOUBLE,
  "ast_per_100_poss" DOUBLE,
  "stl_per_100_poss" DOUBLE,
  "blk_per_100_poss" DOUBLE,
  "tov_per_100_poss" DOUBLE,
  "pf_per_100_poss" DOUBLE,
  "pts_per_100_poss" DOUBLE,
  "o_rtg" DOUBLE,
  "d_rtg" DOUBLE
);

Per 36 Minutes

@kaggle.sumitrodatta_nba_aba_baa_stats.per_36_minutes

1.22 MB
32392 rows
34 columns


CREATE TABLE per_36_minutes (
  "seas_id" BIGINT,
  "season" BIGINT,
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" DOUBLE,
  "experience" BIGINT,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "g" BIGINT,
  "gs" DOUBLE,
  "mp" DOUBLE,
  "fg_per_36_min" DOUBLE,
  "fga_per_36_min" DOUBLE,
  "fg_percent" DOUBLE,
  "x3p_per_36_min" DOUBLE,
  "x3pa_per_36_min" DOUBLE,
  "x3p_percent" DOUBLE,
  "x2p_per_36_min" DOUBLE,
  "x2pa_per_36_min" DOUBLE,
  "x2p_percent" DOUBLE,
  "ft_per_36_min" DOUBLE,
  "fta_per_36_min" DOUBLE,
  "ft_percent" DOUBLE,
  "orb_per_36_min" DOUBLE,
  "drb_per_36_min" DOUBLE,
  "trb_per_36_min" DOUBLE,
  "ast_per_36_min" DOUBLE,
  "stl_per_36_min" DOUBLE,
  "blk_per_36_min" DOUBLE,
  "tov_per_36_min" DOUBLE,
  "pf_per_36_min" DOUBLE,
  "pts_per_36_min" DOUBLE
);

Player Award Shares

@kaggle.sumitrodatta_nba_aba_baa_stats.player_award_shares

70.87 KB
3376 rows
12 columns


CREATE TABLE player_award_shares (
  "season" BIGINT,
  "award" VARCHAR,
  "player" VARCHAR,
  "age" BIGINT,
  "tm" VARCHAR,
  "first" DOUBLE,
  "pts_won" DOUBLE,
  "pts_max" DOUBLE,
  "share" DOUBLE,
  "winner" VARCHAR,
  "seas_id" BIGINT,
  "player_id" BIGINT
);

Player Career Info

@kaggle.sumitrodatta_nba_aba_baa_stats.player_career_info

108.35 KB
5286 rows
7 columns


CREATE TABLE player_career_info (
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "hof" BOOLEAN,
  "num_seasons" BIGINT,
  "first_seas" BIGINT,
  "last_seas" BIGINT
);

Player Directory

@kaggle.sumitrodatta_nba_aba_baa_stats.player_directory

192.53 KB
5285 rows
10 columns


CREATE TABLE player_directory (
  "player" VARCHAR,
  "from" BIGINT,
  "to" BIGINT,
  "pos" VARCHAR,
  "ht_in_in" BIGINT,
  "wt" DOUBLE,
  "birth_date" TIMESTAMP,
  "colleges" VARCHAR,
  "hof" BOOLEAN,
  "slug" VARCHAR
);

Player Per Game

@kaggle.sumitrodatta_nba_aba_baa_stats.player_per_game

1.22 MB
32392 rows
35 columns


CREATE TABLE player_per_game (
  "seas_id" BIGINT,
  "season" BIGINT,
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" DOUBLE,
  "experience" BIGINT,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "g" BIGINT,
  "gs" DOUBLE,
  "mp_per_game" DOUBLE,
  "fg_per_game" DOUBLE,
  "fga_per_game" DOUBLE,
  "fg_percent" DOUBLE,
  "x3p_per_game" DOUBLE,
  "x3pa_per_game" DOUBLE,
  "x3p_percent" DOUBLE,
  "x2p_per_game" DOUBLE,
  "x2pa_per_game" DOUBLE,
  "x2p_percent" DOUBLE,
  "e_fg_percent" DOUBLE,
  "ft_per_game" DOUBLE,
  "fta_per_game" DOUBLE,
  "ft_percent" DOUBLE,
  "orb_per_game" DOUBLE,
  "drb_per_game" DOUBLE,
  "trb_per_game" DOUBLE,
  "ast_per_game" DOUBLE,
  "stl_per_game" DOUBLE,
  "blk_per_game" DOUBLE,
  "tov_per_game" DOUBLE,
  "pf_per_game" DOUBLE,
  "pts_per_game" DOUBLE
);

Player Play By Play

@kaggle.sumitrodatta_nba_aba_baa_stats.player_play_by_play

562.27 KB
17307 rows
28 columns


CREATE TABLE player_play_by_play (
  "seas_id" DOUBLE,
  "season" BIGINT,
  "player_id" DOUBLE,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" BIGINT,
  "experience" DOUBLE,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "g" BIGINT,
  "mp" BIGINT,
  "pg_percent" DOUBLE,
  "sg_percent" DOUBLE,
  "sf_percent" DOUBLE,
  "pf_percent" DOUBLE,
  "c_percent" DOUBLE,
  "on_court_plus_minus_per_100_poss" DOUBLE,
  "net_plus_minus_per_100_poss" DOUBLE,
  "bad_pass_turnover" BIGINT,
  "lost_ball_turnover" BIGINT,
  "shooting_foul_committed" BIGINT,
  "offensive_foul_committed" BIGINT,
  "shooting_foul_drawn" BIGINT,
  "offensive_foul_drawn" DOUBLE,
  "points_generated_by_assists" BIGINT,
  "and1" BIGINT,
  "fga_blocked" BIGINT
);

Player Season Info

@kaggle.sumitrodatta_nba_aba_baa_stats.player_season_info

466.68 KB
32392 rows
10 columns


CREATE TABLE player_season_info (
  "season" BIGINT,
  "seas_id" BIGINT,
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" DOUBLE,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "experience" BIGINT
);

Player Shooting

@kaggle.sumitrodatta_nba_aba_baa_stats.player_shooting

777.12 KB
17307 rows
34 columns


CREATE TABLE player_shooting (
  "seas_id" BIGINT,
  "season" BIGINT,
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" BIGINT,
  "experience" BIGINT,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "g" BIGINT,
  "mp" BIGINT,
  "fg_percent" DOUBLE,
  "avg_dist_fga" DOUBLE,
  "percent_fga_from_x2p_range" DOUBLE,
  "percent_fga_from_x0_3_range" DOUBLE,
  "percent_fga_from_x3_10_range" DOUBLE,
  "percent_fga_from_x10_16_range" DOUBLE,
  "percent_fga_from_x16_3p_range" DOUBLE,
  "percent_fga_from_x3p_range" DOUBLE,
  "fg_percent_from_x2p_range" DOUBLE,
  "fg_percent_from_x0_3_range" DOUBLE,
  "fg_percent_from_x3_10_range" DOUBLE,
  "fg_percent_from_x10_16_range" DOUBLE,
  "fg_percent_from_x16_3p_range" DOUBLE,
  "fg_percent_from_x3p_range" DOUBLE,
  "percent_assisted_x2p_fg" DOUBLE,
  "percent_assisted_x3p_fg" DOUBLE,
  "percent_dunks_of_fga" DOUBLE,
  "num_of_dunks" BIGINT,
  "percent_corner_3s_of_3pa" DOUBLE,
  "corner_3_point_percent" DOUBLE,
  "num_heaves_attempted" BIGINT,
  "num_heaves_made" BIGINT
);

Player Totals

@kaggle.sumitrodatta_nba_aba_baa_stats.player_totals

1.44 MB
32392 rows
35 columns


CREATE TABLE player_totals (
  "seas_id" BIGINT,
  "season" BIGINT,
  "player_id" BIGINT,
  "player" VARCHAR,
  "birth_year" DOUBLE,
  "pos" VARCHAR,
  "age" DOUBLE,
  "experience" BIGINT,
  "lg" VARCHAR,
  "tm" VARCHAR,
  "g" BIGINT,
  "gs" DOUBLE,
  "mp" DOUBLE,
  "fg" BIGINT,
  "fga" BIGINT,
  "fg_percent" DOUBLE,
  "x3p" DOUBLE,
  "x3pa" DOUBLE,
  "x3p_percent" DOUBLE,
  "x2p" BIGINT,
  "x2pa" BIGINT,
  "x2p_percent" DOUBLE,
  "e_fg_percent" DOUBLE,
  "ft" BIGINT,
  "fta" BIGINT,
  "ft_percent" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" BIGINT,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" BIGINT,
  "pts" BIGINT
);

Team Abbrev

@kaggle.sumitrodatta_nba_aba_baa_stats.team_abbrev

8.38 KB
1871 rows
5 columns


CREATE TABLE team_abbrev (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "playoffs" BOOLEAN,
  "abbreviation" VARCHAR
);

Team Stats Per 100 Poss

@kaggle.sumitrodatta_nba_aba_baa_stats.team_stats_per_100_poss

65.67 KB
1432 rows
28 columns


CREATE TABLE team_stats_per_100_poss (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "abbreviation" VARCHAR,
  "playoffs" BOOLEAN,
  "g" BIGINT,
  "mp" BIGINT,
  "fg_per_100_poss" DOUBLE,
  "fga_per_100_poss" DOUBLE,
  "fg_percent" DOUBLE,
  "x3p_per_100_poss" DOUBLE,
  "x3pa_per_100_poss" DOUBLE,
  "x3p_percent" DOUBLE,
  "x2p_per_100_poss" DOUBLE,
  "x2pa_per_100_poss" DOUBLE,
  "x2p_percent" DOUBLE,
  "ft_per_100_poss" DOUBLE,
  "fta_per_100_poss" DOUBLE,
  "ft_percent" DOUBLE,
  "orb_per_100_poss" DOUBLE,
  "drb_per_100_poss" DOUBLE,
  "trb_per_100_poss" DOUBLE,
  "ast_per_100_poss" DOUBLE,
  "stl_per_100_poss" DOUBLE,
  "blk_per_100_poss" DOUBLE,
  "tov_per_100_poss" DOUBLE,
  "pf_per_100_poss" DOUBLE,
  "pts_per_100_poss" DOUBLE
);

Team Stats Per Game

@kaggle.sumitrodatta_nba_aba_baa_stats.team_stats_per_game

81.75 KB
1876 rows
28 columns


CREATE TABLE team_stats_per_game (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "abbreviation" VARCHAR,
  "playoffs" BOOLEAN,
  "g" DOUBLE,
  "mp_per_game" DOUBLE,
  "fg_per_game" DOUBLE,
  "fga_per_game" DOUBLE,
  "fg_percent" DOUBLE,
  "x3p_per_game" DOUBLE,
  "x3pa_per_game" DOUBLE,
  "x3p_percent" DOUBLE,
  "x2p_per_game" DOUBLE,
  "x2pa_per_game" DOUBLE,
  "x2p_percent" DOUBLE,
  "ft_per_game" DOUBLE,
  "fta_per_game" DOUBLE,
  "ft_percent" DOUBLE,
  "orb_per_game" DOUBLE,
  "drb_per_game" DOUBLE,
  "trb_per_game" DOUBLE,
  "ast_per_game" DOUBLE,
  "stl_per_game" DOUBLE,
  "blk_per_game" DOUBLE,
  "tov_per_game" DOUBLE,
  "pf_per_game" DOUBLE,
  "pts_per_game" DOUBLE
);

Team Summaries

@kaggle.sumitrodatta_nba_aba_baa_stats.team_summaries

110.51 KB
1876 rows
31 columns


CREATE TABLE team_summaries (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "abbreviation" VARCHAR,
  "playoffs" BOOLEAN,
  "age" DOUBLE,
  "w" DOUBLE,
  "l" DOUBLE,
  "pw" DOUBLE,
  "pl" DOUBLE,
  "mov" DOUBLE,
  "sos" DOUBLE,
  "srs" DOUBLE,
  "o_rtg" DOUBLE,
  "d_rtg" DOUBLE,
  "n_rtg" DOUBLE,
  "pace" DOUBLE,
  "f_tr" DOUBLE,
  "x3p_ar" DOUBLE,
  "ts_percent" DOUBLE,
  "e_fg_percent" DOUBLE,
  "tov_percent" DOUBLE,
  "orb_percent" DOUBLE,
  "ft_fga" DOUBLE,
  "opp_e_fg_percent" DOUBLE,
  "opp_tov_percent" DOUBLE,
  "opp_drb_percent" DOUBLE,
  "opp_ft_fga" DOUBLE,
  "arena" VARCHAR,
  "attend" DOUBLE,
  "attend_g" DOUBLE
);

Team Totals

@kaggle.sumitrodatta_nba_aba_baa_stats.team_totals

139.43 KB
1876 rows
28 columns


CREATE TABLE team_totals (
  "season" BIGINT,
  "lg" VARCHAR,
  "team" VARCHAR,
  "abbreviation" VARCHAR,
  "playoffs" BOOLEAN,
  "g" DOUBLE,
  "mp" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_percent" DOUBLE,
  "x3p" DOUBLE,
  "x3pa" DOUBLE,
  "x3p_percent" DOUBLE,
  "x2p" DOUBLE,
  "x2pa" DOUBLE,
  "x2p_percent" DOUBLE,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_percent" DOUBLE,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE
);