Getting full team box score per game

[ianclim]

Hi, was just wondering if this script is supposed to also log playoff data from current and past seasons? It seems like all of the data is cut off at regular season only. Is there a way to include playoff data?

Update: found the regular season flags, resolved!

New question: how can I pull the full team box score (total points, 3p%, etc) for each game?

[mpope9]

I actually forgot there was an option to get non-regular season games. Glad you found it.

As for team related stats, I don't think we ever hooked into those endpoints. I feel like they can be calculated on the fly in a materialized view, but could consider this a feature request.

[mpope9]

I'm closing this, it is easily calculatable by doing something like:

SELECT pgl.game_id, SUM(pgl.fg3) FROM player_game_log pgl 
JOIN ON game WHERE game.game_id = pgl.game_id
JOIN ON team WHERE team.team_id = pgl.team_id
WHERE pgl.nickname = "Hawks"
GROUP BY pgl.game_id