The blog post is interesting, but for anyone who wants to play with the data themselves, instructions are here:
https://docs.timescale.com/timescaledb/latest/tutorials/nfl-...
Hack NFL data using Postgres (and maybe win your fantasy draft)
11–17 of 17 posts
Re: Hack NFL data using Postgres (and maybe win your fantasy draft)
#12Cool dataset! I wish there was a similar dataset for Premier League football (or even international soccer). Does anyone know of a good resource?
Re: Hack NFL data using Postgres (and maybe win your fantasy draft)
#13Earlier quoted context omitted.
What's the most interesting conclusion you were able to find using the advanced data that you wouldn't be able to see with the basic stats like QBR or yards per carry?
Should add, I’m a big fan of all the football metrics providers and follow them all religiously during the season. The NFL dataset we found isn’t as comprehensive, but it’s still really fun!
What are some of the other football data providers
Re: Hack NFL data using Postgres (and maybe win your fantasy draft)
#14Earlier quoted context omitted.
Should add, I’m a big fan of all the football metrics providers and follow them all religiously during the season. The NFL dataset we found isn’t as comprehensive, but it’s still really fun!
What are some of the other football data providers
It’s not time-series data, but my favorite is Pro Football Focus: https://www.pff.com/subscribe
If the NFL made its data available weekly, you could probably join it with PFF data for some interesting insight. There’s a ton of power in joining time-series metrics with purely relational data.
Re: Hack NFL data using Postgres (and maybe win your fantasy draft)
#15Cool dataset! I wish there was a similar dataset for Premier League football (or even international soccer). Does anyone know of a good resource?
Yep that was my thought too. This one (open data commons license) seems to end at 2019 https://datahub.io/sports-data/english-premier-league and that originated from a gambling site that has later data and lots of leagues... Not sure it will include plays, assists etc. Would work wonders for fantasy football errmmm I mean soccer. There must be something around 20:20 cricket surely :)
Re: Hack NFL data using Postgres (and maybe win your fantasy draft)
#16has anyone found a data set that has all years? football it seems kinda protected. its really easy to get all baseball data
You can get 2020 data from the same source that the NFL tutorial uses but that's only two years. It must exist I guess?
Re: Hack NFL data using Postgres (and maybe win your fantasy draft)
#17has anyone found a data set that has all years? football it seems kinda protected. its really easy to get all baseball data
You can get 2020 data from the same source that the NFL tutorial uses but that's only two years. It must exist I guess?
This tool looks promising to keep it up to date.
> The lack of publicly available National Football League (NFL) data sources has been a major obstacle in the creation of modern, reproducible research in football analytics. While clean play-by-play data is available via open-source software packages in other sports (e.g. nhlscrapr for hockey; PitchF/x data in baseball; the Basketball Reference for basketball), the equivalent datasets are not freely available for researchers interested in the statistical analysis of the NFL. To solve this issue, a group of Carnegie Mellon University statistical researchers including Maksim Horowitz, Ron Yurko, and Sam Ventura, built and released nflscrapR an R package which uses an API maintained by the NFL to scrape, clean, parse, and output clean datasets at the individual play, player, game, and season levels.