Baselight

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

Matches Team Results
@kaggle.marcinmc_nba_players_statistics_seasonal_and_matchbymatch.matches_team_results

  • 3.13 MB
  • 146042 rows
  • 25 columns
game_id

GAME ID

team_id

TEAM ID

team_abbreviation

TEAM ABBREVIATION

pts

PTS

reb

REB

ast

AST

stl

STL

blk

BLK

to

TO

fgm

FGM

fga

FGA

fg3m

FG3M

fg3a

FG3A

ftm

FTM

fta

FTA

min

MIN

pf

PF

oreb

OREB

dreb

DREB

fg_pct

FG PCT

fg3_pct

FG3 PCT

ft_pct

FT PCT

game_date

GAME DATE

season

SEASON

match_type

MATCH TYPE

103000011610612742DAL853820941834762815303412260.44736842105263160.250.5Sun Oct 05 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000011610612762UTA90412384183270172534269320.45714285714285710.14285714285714280.7352941176470589Sun Oct 05 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000021610612749MIL9443209424327521328402611320.42666666666666670.15384615384615380.7Mon Oct 06 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000021610612763MEM105482518725408141521343514340.49382716049382710.26666666666666660.6176470588235294Mon Oct 06 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000031610612739CLE10052251072538774620293312400.49350649350649350.66666666666666660.6896551724137931Tue Oct 07 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000031610612765DET9637191531334874924402712250.39080459770114940.44444444444444440.6Tue Oct 07 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000041610612742DAL995220951740821618273015370.48780487804878050.16666666666666660.6666666666666666Tue Oct 07 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000041610612753ORL762914951925616182024246230.40983606557377050.33333333333333330.8333333333333334Tue Oct 07 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000051610612745HOU7834109229306441214212512220.468750.33333333333333330.6666666666666666Tue Oct 07 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan
103000051610612757POR10232211731538703723352210220.54285714285714280.42857142857142850.6571428571428571Tue Oct 07 2003 00:00:00 GMT+0000 (Coordinated Universal Time)2003-04nan

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
);