We should have scraped boxscore json files too. So let's do that. Eventually, write the SQL insert statements to insert info from boxscore json into the SQLite3 database.
Schema-wise, we'll need a new table called playergames that's keyed on game_id and player_id, in which each record is a player-game instance with data on every player's game stats. There might be other useful meta data from these files, but a playergames table is absolutely essential.
We should have scraped boxscore json files too. So let's do that. Eventually, write the SQL insert statements to insert info from boxscore json into the SQLite3 database.
Schema-wise, we'll need a new table called
playergamesthat's keyed ongame_idandplayer_id, in which each record is a player-game instance with data on every player's game stats. There might be other useful meta data from these files, but aplayergamestable is absolutely essential.