Game gsis_id = 2017111911 missing in schedule.json (Ochawkeye issue #298)

[MargareeMan]

@ochawkeye provided a link to his schedule.json file in issue #298. This was greatly appreciated and allowed me to reinstall and update my nfldb installation.

However, his schedule.json file is missing an entry for gsis_id 2017111911 (TB at MIA) .

When nfldb-update is run with this incomplete schedule.json file, the data for this game is not inserted into the game, drive, play, or play_player tables and the agg_play table is not updated to contain the aggregate stats.

The relevant game data is:

[ "2017111911", { "away": "TB", "day": 19, "eid": "2017111911", "gamekey": "57241", "home": "MIA", "month": 11, "season_type": "REG", "time": "1:00", "wday": "Sun", "week": 11, "year": 2017 } ],

If you insert this into your schedule.json file and run nfldb-update, the game record is inserted into nfldb; but no game data is updated.

Therefore, I am providing the necessary files to insert into nfldb. (if you already updated schedule.json and run nfldb-update; then first delete the empty game record with:

DELETE FROM game WHERE gsis_id = '2017111911'

Then import the data from the .tsv files at: " https://github.com/MargareeMan/Data-for-nfldb-gsis_id-2017111911"

(As I seem to be having trouble with the link, I am uploading the files here. I had trouble importing the last drive of the game (drive_id 25) due to a null value. So, one of the files is a SQL INSERT for this record.

drive_id__ 25 FROM_drive__WHERE_gsis_id__2017111911.txt FROM_agg_play__WHERE_gsis_id__2017111911.txt FROM_drive__WHERE__gsis_id__2017111911.txt FROM_game__WHERE_gsis_id__2017111911.txt FROM_play__WHERE_gsis_id__20171119110.txt FROM_play_player__WHERE_gsis_id__2017111911.txt

INSERT for drive_id 25.txt