THIS PROJECT IS UNMAINTAINED.
nfldb is a relational database bundled with a Python module to quickly and conveniently query and update the database with data from active games. Data is imported from nflgame, which in turn gets its data from a JSON feed on NFL.com's live GameCenter pages. This data includes, but is not limited to, game schedules, scores, rosters and play-by-play data for every preseason, regular season and postseason game dating back to 2009.
It can also be used with nflvid to search for and watch video of plays. Please see the nfldb wiki for more details on how to get that working.
Here is a small teaser that shows how to use nfldb to find the top five passers in the 2012 regular season:
import nfldb
db = nfldb.connect()
q = nfldb.Query(db)
q.game(season_year=2012, season_type='Regular')
for pp in q.sort('passing_yds').limit(5).as_aggregate():
print pp.player, pp.passing_ydsAnd the output is:
[andrew@Liger ~] python2 top-five.py
Drew Brees (NO, QB) 5177
Matthew Stafford (DET, QB) 4965
Tony Romo (DAL, QB) 4903
Tom Brady (NE, QB) 4799
Matt Ryan (ATL, QB) 4719Documentation and getting help
nfldb has comprehensive API documentation. Tutorials, more examples and a description of the data model can be found on the nfldb wiki.
If you need any help or have found a bug, please
open a new issue on nfldb's issue
tracker
or join us at our IRC channel #nflgame on FreeNode.
Installation and dependencies
nfldb depends on the following Python packages available in PyPI: nflgame, psycopg2, pytz and enum34. nfldb also needs PostgreSQL installed with an available empty database.
I've only tested nfldb with Python 2.7 on a Linux system. In theory, nfldb
should be able to work on Windows and Mac systems as long as you can get
PostgreSQL running. It is not Python 3 compatible (yet, mostly because of
the nflgame dependency).
Please see the installation guide on the nfldb wiki for instructions on how to setup nfldb.
Entity-relationship diagram
Here's a condensed version that excludes play and player statistics:
There is also a full PDF version that includes every column in the database.
The nfldb wiki has a description of the data model.
The most recent version of the nfldb PostgreSQL database is available here: http://burntsushi.net/stuff/nfldb/nfldb.sql.zip.