nba-sql VS nba_api

I've searched for a good database to analyze NBA players and teams, and couldn't find one. So, I've been working on an app that builds a SQLite / Postgres / MySQL database for the NBA. You can get the Windows alpha here: https://github.com/mpope9/nba-sql/releases/tag/v0.0.6 For OSX / Linux, you need to run it from the commandline. This is very much in the alpha phase, but development is happening at a steady pace in my free time. I've been able to learn some interesting things already, there are examples in the wiki here. I have more advanced example queries that I'm still working on, and have yet to add them to the wiki if any are interested. I'd love some feedback, if anyone has experience with SQL or databases. nba-sql will build a SQLite database by default, but it also supports Postgres and MySQL. You run the application to build the database, then use something like DBeaver to query it.

This is what I've found - https://github.com/mpope9/nba-sql

I used the nba-sql database for this. That database has a table called shot_chart_detail. The table has alot of interesting data, but there are a few columns that are especially helpful: minutes_remaining, seconds_remaining, and shot_distance. Using those columns, the following graph can be made:

Thanks! I used Postgres and Apache Superset. I wrote a small wiki on how to use it https://github.com/mpope9/nba-sql/wiki/Data-Visualization-with-Superset. Superset doesn't work with SQLite sadly.

The latest Postgres dump can be found here: https://github.com/mpope9/nba-sql/releases/tag/v0.0.2. It is a compressed file, using xz. After decompressing it, you can run it using psql -U -P nba < nba.sql.

Thanks to the people putting together the open source nba_api, as well as the people at Basketball Reference and the NBA stats page.

NBA Stats API

Yea ref stuff is hard to acquire. NBA api could b helpful tho and this is prob a good place to start

I think you'll find this useful: https://github.com/swar/nba_api.

All data were collected using the nba_api. The dataset consists of per-game stat averages for all teams starting from the 1983-84 season through the 2021-22 season. In total: 1103 regular season teams, 624 of which made the playoffs in their respective years. Traditional stats include: PTS, FGM, FGA, FG_PCT, FG3M, FG3A, FG3_PCT, FTM, FTA, FT_PCT, OREB, DREB, REB, AST, STL, BLK, TOV, PF, PLUS_MINUS. Advanced stats include: NET_RATING, OFF_RATING, DEF_RATING, EFG_PCT, TS_PCT, PACE, OREB_PCT, DREB_PCT, REB_PCT, AST_PCT, AST_TO, AST_RATIO, TM_TOV_PCT. Note: for plus/minus and all of the advanced stats, I could only get data beginning from the 1997-98 season onwards, which resulted in 743 total regular season teams, 400 of which made the playoffs.

Is it not on the nba api? https://github.com/swar/nba_api/tree/master/docs/nba_api/stats/endpoints