ESPN, etc., always have crazy stats - yesterday Kevin Durant and Russell Westbrook were the first duo to each score 40 points in a game twice in the same season since I don’t know when.
I understand that keeping stats like that are easy, but how are they FOUND? How would you search for such a statistic? Are there database programs that will accepts such specific queries, given that such statistics come in virtually all flavors imaginable. It’s hard for me to imagine that such a flexible method exists.
I can’t speak to basketball specifically, but I often snag my baseball stats from Baseball Reference. It has a searchable database that’s extremely flexible.
Most broadcast sports use the Elias Sports Bureau. They’ve been gathering sports statistics for almost a century, and have every sports database you can imagine.
I assume someone from Elias is in the Broadcast booth with a computer logged in to the database. He can search for anything that happens in the game. He also prepares for particular records to be broken and has them all ready to go if necessary. If, say, a pitcher has won his previous two games, they will look up instances where that pitcher had won two games in a row before the game starts.
Yup, it’s called SQL. Almost every business in the world uses it. It’s exactly how Stats Inc, Elias and ESPN Stats find this things. Something interesting happens, then the database professionals/analysts start punching queries into the database of past results. Those past results are organized and cross referenced in a way to make it easy to search for details like that.
Here’s a sample of what the SQL code would look like for the case mentioned in the OP. Syntax varies between software brands, but it’s all pretty similar.
SELECT * FROM NBA_GAME_RESULTS WHERE playerScore >= 40 GROUP BY gameDate, playerTeam
That’s overly simplified and you’d have to sift through the results to find cases where the gameDeate is repeated but the Query can be expanded to do that work for you. Without knowing the Schema and straining my brain I’m not going to try and do that./
This is a link to a database of everything Olympics. There are links in the upper right to other sports, including baseball, football, hockey, and basketball. The Olympic one is silly in the amount of info it has, including birth, death, results, name spelled in native language, etc.
SELECT Player_Score, Team_name, Game_ID, Count(Player_Name)
FROM tblNBA_GAME_RESULTS
GROUP BY tblNBA_GAME_RESULTS.Player_Score, tblNBA_GAME_RESULTS.Game_ID, tblNBA_GAME_RESULTS.Team_name
HAVING (((tblNBA_GAME_RESULTS.Player_Score)>=40) AND ((Count(Player_Name))>1));
That should do it. I tested it on a database I’m working on and it worked correctly, at least.
For simplicity, often times news reporters are given a media guide every year with the historical statistics for the team they report on. I know Ive seen news articles about them here and there - Mike Boone of the Montreal Gazette has writen about it for sure.
Thanks - that’s exactly what I was curious about. I know about Elias, etc., and SQL, but couldn’t quite piece together how such a query would work. I don’t know SQL but can make sense of the queries you guys posted.