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