Data For Fantasy Football Players Gets an Update

The Biggest just got Bigger

Exciting news people! Data in our Player, Offense and Defense tables just got a whole lot more interesting, especially for those of you who use our data to engage in Fantasy Football related pursuits.

Starting in the 2015 season, we will now be providing the following 3 pieces of information in the aforementioned tables:

  • Position Detailed (POSD) – More granular than POS1 and POS2 (i.e., Linebackers are broken down into MLB, LILB, ROLB and so on).
  • Jersey Number – 1 thru 99.
  • Depth Chart Position – Value of 1-3 (1-5 in the pre-season).

What this means for application developers is that you can now accurately build a team’s complete roster within your app and easily link to the wealth of information we provide across all of our other data tables.

For NFL Fantasy Football players, the implications are clear: Point totals can now be analyzed within the context of where a player sat on the depth chart and their specific role on offense or defense prior to the game.

In order to achieve this level of detail, we now update the PLAYER table on a daily basis so the information that is recorded in the OFFENSE and DEFENSE tables will be based on the latest information provided by teams on game day.

Stay tuned for news on more exciting changes coming in the next couple of weeks!

2 thoughts on “Data For Fantasy Football Players Gets an Update

  1. Just subscribed today so I am very green at this time. Can you forward me the mySQL script to build the table “PBP” (play by play)? This table script is missing from your file “setup.sql” found under the “support” directory.

    Also, now that I have loaded all of the data for 2015 to date, what is the best way to insert only the new entries for the past week? Will I be able to download the CSV files just for that week? OR will I just delete all rows in each table and then upload a set of full up-to-date CSVs again?

    Haven’t had time to work on implementing calls using your API.


    1. Hey Pat… We do have an additional ‘loader’ file which works hand-in-hand with Setup.sql to get you up-and-running. I will send this to you shortly. The same script can be run weekly after it’s setup. The queries are set to add the newest data while updating existing rows if required.

Leave a Reply

Your email address will not be published. Required fields are marked *