edavis25/fantasy-football-database

Fantasy football data scraping and projections.

fantasy-football-database's Issues

Player-Game Info Missing (GameID = 537)

It looks like we are missing info in the PlayerGame table for GameID 537. This was the season opener 9/5/13 between the Ravens and Broncos. Game and team stats exist in database, however, individual player stats are missing.

Matching URL: http://www.pro-football-reference.com/boxscores/201309050den.htm

2 Players, Same Name

Different players same names:

Robert Thomas - 2x

1. Currently active DT for Dolphins
2. Retired LB for Packers/Raiders (Player info scraped for this one)

---

Find them w/ SQL:
FROM Games, PlayerGame, Players WHERE Games.GameID = PlayerGame.GameID AND PlayerGame.PlayerID = Players.PlayerID AND Players.Name ='Robert Thomas';

Linking Stadiums

58 different stadium names under the Games table for the database.

- [ ] Update old stadium names to match current list of stadium names when only a renaming occurred.
(ex: Cleveland Browns Stadium -> FirstEnergy (nothing much changed other than the naming rights, making it pretty much the same stadium in terms of field surface/roof type)
- [ ] Add new entries to stadiums table for old stadiums that were different buildings as the current stadium. Include a new entry for any renamed stadium IF there was a change in field surface type/
(ex: Texans' current "NRG Stadium" was a rename of their old "Reliant Stadium" BUT the surface was changed from grass -> turf)

- [ ] Link teams somehow with associated stadiums.
(Record for each team that has ever played in a given stadium? Junction Table?)

Dome Temperature/Humidity

Temperature and Humidity for any games played in a dome are currently null. Change this to some sort of "room" temperature/humidity, or leave null?

Incorrect Team Mapping in TeamGame

There seems to be an issue with TeamIDs 14+15 (Colts, Jags). For some reason the TeamIDs from any games played by the Jaguars both were 15. This made the Jags have too many games in 2016 season and each of their opponents have too few. I then managed to make this problem worse when trying to manually update values and now all of the Jags games are under the Colts ID. These need manually fixed (thinking add a temporary auto-increment key to use as primary key when changing each value manually).

SQL Query Showing the Error (TeamID 14 = Colts)
SELECT *
FROM TeamGame, Teams, Games
WHERE TeamGame.TeamID = Teams.TeamID
AND Teams.TeamID = 14
AND TeamGame.GameID = Games.GameID
AND Games.Date > '2016-04-20'