Interrogator 7

[gstelmack]

Interrogator (http://www.gstelmack.com/Interrogator/publish.htm)

This is intended to complement, not replace, the FOF exported data. This brings back most of the old Solevision data that DBUpdater/Interrogator used to provide for FOF2k7. You will get 3 new files into your league's exported data folder:


drive_info.csv - Data on every drive for every game.
game_information_extra.csv - Complements the game_information.csv, adds lots of additional box score information (such as attendance figures, but also additional team stats like directional running and passing by distance).
player_season_extra_YYYY.csv - Complements the player_season_YYYY.csv, one per season just like that file set. Additional stats for the players that we can pull by having the play data. Note that "HasKeyCoverage" may not really be that, although it comes close. This file's sort does NOT match FOF's, I can do some extra work to make it match if it becomes an issue for anyone.


As always, it's a first release, let me know what bugs/issues/suggestions you have.

[aston217]

Ohhhhhhhhhhhhhhhhh

greg, you the man.

[Taco]

Hi Greg,

First of all, thanks so much for bringing this back!

I have noticed something strange with player_season_extra_YYYY.csv. This is with the WOOF data (player_season_extra_2013.csv).

There is a row with a Player_ID = -590186900.

Also, Player_ID = 3205 has two rows in the file for week 1 which seems wrong. There may be other duplicates as well, but this is the first one I found.

Any ideas?

Thanks in advance!

[gstelmack]

I'd have to debug. I don't know if Ben is using this for WOOF yet, although my initial testing of the tool was for WOOF. In general it sounds like it had trouble reading one of the Solevision files, though - it could be you have a corrupt one, or there is a corrupt one in the archives, or I have a bug in my code.

[sjshaw]

Great to have you back!