mpope9 / nba-sql

:basketball: An application to build an NBA database backed by MySQL, Postgres, or SQLite
Apache License 2.0
176 stars 20 forks source link

Investigate event_msg_action_type #12

Open mpope9 opened 3 years ago

mpope9 commented 3 years ago

play_by_play has a event_msg_action_type field. These map to the event_msg_type. Understanding what these mean and adding them to a const table will greatly increase the queriability of the play_by_play table, possibly. The nba_api docs go into a bit of detail, but generating a solid mapping of id -> understandable value is still needed.

Some existing actions from this reddit thread?

EVENTMSGACTIONTYPE 1 - Jumpshot 2 - Lost ball Turnover 3 - ? 4 - Traveling Turnover / Off Foul 5 - Layup 7 - Dunk 10 - Free throw 1-1 11 - Free throw 1-2 12 - Free throw 2-2 40 - out of bounds 41 - Block/Steal 42 - Driving Layup 50 - Running Dunk 52 - Alley Oop Dunk 55 - Hook Shot 57 - Driving Hook Shot 58 - Turnaround hook shot 66 - Jump Bank Shot 71 - Finger Roll Layup 72 - Putback Layup 108 - Cutting Dunk Shot