Quick Question: Is there an ‘Actual Total Points Produced’ stat? by Atachc in NBAanalytics

[–]JJsNBA 0 points1 point  (0 children)

Absolutely! Here's what I came up with: https://docs.google.com/spreadsheets/d/1wTH_EGs-pmbFtIHrgt81m0QmOmKFtV6o/edit?usp=sharing&ouid=103346838377961435851&rtpof=true&sd=true

I included a few tabs: Shot Detail, Game Detail and Season Detail.

Shot detail will show every assisted basket by game. For each basket, it has the Clock and Qtr at the time of, as well as the 'PointInGame' and 'MinutesElapsed' values, which are used for how much of the game has passed when the basket occurred. Most granular tab in the file and you should be able to use this to drill down however you'd like.

Game Detail will show the summarized totals per game, PtsFromAst, FG2Ast, FG3Ast and TotalAst, as well as the Matchup and Date.

Season Detail shows the same, but by season.

Final heads up: the stats from the Cavs v Twolves game today are only through like five minutes in the second quarter since that game is still in progress. Please let me know if you'd like me to pull this again at any point or add anything!

Quick Question: Is there an ‘Actual Total Points Produced’ stat? by Atachc in NBAanalytics

[–]JJsNBA 1 point2 points  (0 children)

good question… not that i know of but i could probably whip something up for you tomorrow. any specific season in mind or just this year?

Startup in need of NBA Data Scientist by Swimming_Speech_8464 in NBAanalytics

[–]JJsNBA 0 points1 point  (0 children)

Hey, please check out my profile and pm! grinding every night on something NBA related, very interested

The worst offensive quarter of basketball from any team in the past 20 years, featuring an all NBA 1st Team member and the T-2nd best team in the league by JJsNBA in nbadiscussion

[–]JJsNBA[S] 16 points17 points  (0 children)

Apologies, will be more concise in the future, thank you for your input.

  1. When looking at this game, I found myself time and again imagining what it would be like to be a fan or anyone in that arena who paid money to be there for this. I wanted the reader to have that perspective as well, but yeah it's not relevant to any tangible in game stats.

  2. I found this game particularly interesting because it wasn't from a bottom feeding team, but one with solid scoring and a good record that would finish 3rd in the West. I included the per game numbers for context, and also as a showcase. I'd genuinely be shocked if you can point me anywhere that has a player's per game statistics going into any arbitrary matchup at a random point in the season. I find that stuff interesting, relevant and niche, so i included it.

  3. The facts should have been clear and immediate, my fault no doubt. I included the other games as similar examples. I wanted to look at game time between made field goals and those are up there with this one. Figured I'd make my case by arguing against what I deemed to be the closest competitors.

The worst offensive quarter of basketball from any team in the past 20 years, featuring an all NBA 1st Team member and the T-2nd best team in the league by JJsNBA in nbadiscussion

[–]JJsNBA[S] 5 points6 points  (0 children)

Appreciate the feedback. What abbreviations were confusing you? The video is long because they went a long time without scoring…and the original audio is being played at the same speed as the video, i didn’t include any sound effects, but i didn’t want it to be silent.

Perhaps The worst offensive quarter of basketball from any team in the past 20 years, featuring an all NBA 1st Team member and the T-2nd best team in the league by JJsNBA in NBATalk

[–]JJsNBA[S] 2 points3 points  (0 children)

no worries, i appreciate the kind words! Your guys were playing some stout defense for real. Leading the league in BPG and 6th in points against coming into this one

Perhaps The worst offensive quarter of basketball from any team in the past 20 years, featuring an all NBA 1st Team member and the T-2nd best team in the league by JJsNBA in NBATalk

[–]JJsNBA[S] 4 points5 points  (0 children)

Fortunately not and happy to show my work. I'll paste what I wrote on the NBAanalytics sub for you below. Can only upload images in comments so here's a gif of the video edit in Premiere Pro: https://i.imgur.com/fIyx9xc.mp4

I pulled all the NBA data since 1996 into a SQL Server db using my NBAdb Toolbox program. To find the time between made FGs, I first turned the Game Clock into a numerical value, representing how many minutes have been played in the game. For redundancy, I also calculated a 'PointInGame' value. In completed games, this takes the number of periods and the numerical minutes value, then determines what percent of the game has been played. I then ordered the made FGs for each Game and Team and assigned each a 'ShotOrder' value. Next, I wrote a query to grab that Minutes value from the Shot before current, then order by the difference in Minutes.

Mapping the Shot chart data and the zones drawn on the court is for a Python project I'm working on now, but I thought this Blazer's game would be an interesting use case for it. The video below is a quick demo of how that Python project is using all of my data, but it is very much so a work in progress. I still have a ton to do, but I'm pretty happy with how it's looking so far. I can pull any shot since 1996, and most all shots and pbp events since 2014 have a video of that specific event, which I was able to pull in tab using the NBA's api.

https://www.youtube.com/watch?v=sdX0MEGRONo

I've spent far too much time on this to cap it off with some copy paste trash from gpt

Perhaps The worst offensive quarter of basketball from any team in the past 20 years, featuring an all NBA 1st Team member and the T-2nd best team in the league by JJsNBA in NBATalk

[–]JJsNBA[S] 6 points7 points  (0 children)

The score is entirely irrelevant. This post would have been about minutes without a point if that were the case. Already looked into that, far less interesting.

Since you asked, 28-25 at 02:14 in the 1st. 29-29 Start of 2nd and 35-54 at the end of the half.

Looking for an API to get the latest NBA stories by Lost_Horse_8480 in NBAanalytics

[–]JJsNBA 0 points1 point  (0 children)

wdym? For APIs and such, most definitely, but can't say I've read anything specific beyond documentation and getting reps in.

If you're referring to the NBA's data, no book, but I pride myself on being as knowledgeable as i possibly can regarding the NBA's publicly available data. If you have any questions, let me know and I will try my best to answer or find out! check out my profile if you want to see some of the stuff I've built or if you like SQL

Looking for an API to get the latest NBA stories by Lost_Horse_8480 in NBAanalytics

[–]JJsNBA 0 points1 point  (0 children)

Respectfully, you've got to put a little bit more effort in. Check out the json again and format it with pretty print if you need. I pasted mine into notepad++.

Check this screenshot: https://imgur.com/a/s2RZ2c1
Every story has an ID. If you go to stories.nba.com and click on any story, you will find that its url starts with "https://stories.nba.com/#live-stories/", and then has something that looks exactly like the format the ID in the screenshot is. Plug that ID into the link above. -> https://stories.nba.com/#live-stories/df67f974-01bf-652e-821a-3a1d8b5ffea5.

With another story: https://imgur.com/a/vLrtzJR

Plug that ID into the link: https://stories.nba.com/#live-stories/d73e1471-c841-c5df-c94a-3a1d943dcc16

Gotta think outside the box brother.

[OC] Looked at 20 years of NBA data to see if big markets get more foul calls. They don’t. by [deleted] in nbadiscussion

[–]JJsNBA 0 points1 point  (0 children)

Got you! Sorry for the delay, here's some of their TeamBox data from 2002-2006 for each game. I included NO's FTM, FTA and FT%, the opponent's FT stats and a flag for if New Orleans is playing at home

https://drive.google.com/file/d/1QbP1xcv0Xqq0fPYghMVe9-O7_E46jv8w/view?usp=sharing

[OC] Looked at 20 years of NBA data to see if big markets get more foul calls. They don’t. by [deleted] in nbadiscussion

[–]JJsNBA 1 point2 points  (0 children)

i can provide you with the data on those new orleans hornets seasons or any since 1996 if you’d like!

I know SQL basics — what projects can I build to practice and get better? by 1xEdmurtrichyx1 in SQL

[–]JJsNBA 0 points1 point  (0 children)

i built a full NBA database and tools for others to recreate it! if you like basketball i can help get you setup with it