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
Table List
- 4 tables(28.9 MB)
Matches Player Stats
@kaggle.marcinmc_nba_players_statistics_seasonal_and_matchbymatch.matches_player_stats
- 23.86 MB
- 1644751 rows
- 28 columns
game_idGAME ID | team_idTEAM ID | team_abbreviationTEAM ABBREVIATION | team_cityTEAM CITY | player_idPLAYER ID | player_namePLAYER NAME | minMIN | fgmFGM | fgaFGA | fg_pctFG PCT | fg3mFG3M | fg3aFG3A | fg3_pctFG3 PCT | ftmFTM | ftaFTA | ft_pctFT PCT | orebOREB | drebDREB | rebREB | astAST | stlSTL | blkBLK | toTO | pfPF | ptsPTS | game_dateGAME DATE | seasonSEASON | match_typeMATCH TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24600001 | 1610610035 | HUS | Toronto | 77035 | Adolph Hoefer | 2 | 4 | 4 | 1 | 5 | 8 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 76720 | Bob Fitzgerald | 1 | 2 | 2 | 1 | 1 | 4 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 76719 | Dick Fitzgerald | 3 | 3 | 1 | 6 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 78050 | Ed Sadowski | 8 | 2 | 6 | 0.333 | 6 | 18 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 76762 | Frank Fucarino | 1 | 1 | 1 | 1 | 1 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | ||||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 77734 | George Nostrand | 7 | 2 | 7 | 0.285 | 3 | 16 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 76161 | Hank Biasatti | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 77600 | Harry Miller | 1 | 1 | 1 | 1 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 77503 | Mike McCarron | 1 | 4 | 5 | 0.8 | 5 | 6 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular | |||||||||||||
| 24600001 | 1610610035 | HUS | Toronto | 78494 | Ray Wertis | 3 | 3 | 6 | Fri Nov 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time) | 1946-47 | Regular |
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
);