NBA Players Statistics Seasonal And Match By Match
Statistics for each NBA player from each match and for each season they played
@kaggle.marcinmc_nba_players_statistics_seasonal_and_matchbymatch
Statistics for each NBA player from each match and for each season they played
@kaggle.marcinmc_nba_players_statistics_seasonal_and_matchbymatch
I've created a simple script to display statistics of MVPs through the years and it's available here.
CREATE TABLE matches_player_stats (
"game_id" BIGINT,
"team_id" BIGINT,
"team_abbreviation" VARCHAR,
"team_city" VARCHAR,
"player_id" BIGINT,
"player_name" VARCHAR,
"min" DOUBLE,
"fgm" DOUBLE,
"fga" DOUBLE,
"fg_pct" DOUBLE,
"fg3m" DOUBLE,
"fg3a" DOUBLE,
"fg3_pct" DOUBLE,
"ftm" DOUBLE,
"fta" DOUBLE,
"ft_pct" DOUBLE,
"oreb" DOUBLE,
"dreb" DOUBLE,
"reb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"to" DOUBLE,
"pf" DOUBLE,
"pts" DOUBLE,
"game_date" TIMESTAMP,
"season" VARCHAR,
"match_type" VARCHAR
);CREATE TABLE matches_team_results (
"game_id" BIGINT,
"team_id" BIGINT,
"team_abbreviation" VARCHAR,
"pts" DOUBLE,
"reb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"to" DOUBLE,
"fgm" DOUBLE,
"fga" DOUBLE,
"fg3m" DOUBLE,
"fg3a" DOUBLE,
"ftm" DOUBLE,
"fta" DOUBLE,
"min" DOUBLE,
"pf" DOUBLE,
"oreb" DOUBLE,
"dreb" DOUBLE,
"fg_pct" DOUBLE,
"fg3_pct" DOUBLE,
"ft_pct" DOUBLE,
"game_date" TIMESTAMP,
"season" VARCHAR,
"match_type" VARCHAR
);CREATE TABLE nba_seasons_dates (
"season" VARCHAR,
"regular_season_start" TIMESTAMP,
"regular_season_end" TIMESTAMP,
"playin_start" TIMESTAMP,
"playin_end" TIMESTAMP,
"playoffs_start" TIMESTAMP,
"playoffs_end" TIMESTAMP,
"finals_start" TIMESTAMP,
"finals_end" TIMESTAMP
);CREATE TABLE seasonal_stats_with_awards (
"season" VARCHAR,
"match_type" VARCHAR,
"player_name" VARCHAR,
"player_id" BIGINT,
"gp" BIGINT,
"w" BIGINT,
"l" BIGINT,
"min" DOUBLE,
"pts" DOUBLE,
"reb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"to" DOUBLE,
"fgm" DOUBLE,
"fga" DOUBLE,
"fg3m" DOUBLE,
"fg3a" DOUBLE,
"ftm" DOUBLE,
"fta" DOUBLE,
"fgm_2" DOUBLE,
"fg3m_2" DOUBLE,
"ftm_2" DOUBLE,
"dd" BIGINT,
"td" BIGINT,
"fp" DOUBLE,
"pie" DOUBLE,
"fg_pct" DOUBLE,
"fg3_pct" DOUBLE,
"ft_pct" DOUBLE,
"mvp" BIGINT,
"roy" BIGINT,
"dpoy" BIGINT,
"mip" BIGINT,
"n_6moy" BIGINT -- 6MOY,
"all_nba_team" BIGINT,
"all_defensive_team" BIGINT,
"all_rookie_team" BIGINT,
"all_star" BIGINT,
"all_star_mvp" BIGINT,
"finals_mvp" BIGINT,
"potw" BIGINT,
"potm" BIGINT,
"rotm" BIGINT,
"rookie_season" BOOLEAN
);Anyone who has the link will be able to view this.