This project downloads NFL gamebooks and parses them and inserts them into a db. It is used in conjunction with @Burntsushi's https://github.com/BurntSushi/nfldb project.

To get started

1. Install NFLDB
2. Run the DB migrations with psql -U nfldb nfldb < ./db_migrations/create-gamebook-drive-table.sql psql -U nfldb nfldb < ./db_migrations/create-gamebook-table.sql psql -U nfldb nfldb < ./stadiums/create-stadium-table.sql

optional additional data

psql -U nfldb nfldb < ./coaches/create-coach-table.sql psql -U nfldb nfldb < ./team-data/create-team-data.sql 3. Edit line ~511 of parse-and-insert-gamebooks.py to years = range(2002, 2016) and comment out line ~512 years = [2016] 4. Edit line ~514 to read xml_filenames = get_filenames(gamebooks_path, str(year), ".xml") 5. Run python parse-and-insert-gamebooks.py 6. Once complete you can edit back the changes in steps 3-4 to perform a weekly update

Notes: There's still lots of data in the gamebooks xml I have not finished parsing from the xml. I welcome pull requests. This project is not nearly as complete or polished as @burntsushi's NFLDB. Occasionally the stadium names are typod in the gamebooks and you will need to modify stadium.py to add the alias or wait for an update from myself.