-
Notifications
You must be signed in to change notification settings - Fork 264
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
SQL DB from NFLDB #54
Comments
Could you describe your query in English? It looks like this could be much simpler if you use the |
I was trying to pull in every statistic recorded, other than tackles. I was trying to tie every play to public.play_player so that I would have all recorded statistics, however based on what I've seen and played with, the public.play_player may not be 100% accurate. I'm had thought you had written before that there was another way to get more accurate statistical data. On a football level... I have to mentally get over the Jets loss on Sunday... it was very... Jetlike. |
There is no way to freely access 100% accurate data. If you really need 100%, then you've got to pay Stats, Inc. for it. I don't have a figure on the accuracy of nfldb's data, but a very rough guess is >95%. There are some ideas I have for future work on increasing accuracy, but they will not happen any time soon. I will try to respond again when I have more time to actually answer your question here. :-) |
Hi all, this is less of an "issue" and more of a question, but I'm not quite sure of the best place to put it. I created a query to include most plays/results of the games. But I wanted to confirm that I'm pulling the data the best way possible. This is the (rather long) query I've made.
You'll see that I pull from PlayPlayer, and then pull the other data from there. Is this the best place to get the most accurate information?
Thanks,
Eric
The text was updated successfully, but these errors were encountered: