NFL Data Expansion: Injuries

Spring has sprung and with it comes a new data table that has been at the top of the ‘most requested new feature’ list for some time: Injuries.

We’ve gone back and recorded the 5,000+ entries from official reports in 2015 and we will be updating this data weekly in 2016 onwards.

That’s not all that’s new though. Back by popular demand: a detailed change-log (available online) that will serve to keep you fully informed on the latest expansions; updates and corrections to historical and 2016 data.

Here is a quick summary of the latest changes:

CHART: 26,058 plays have now been charted for 2015
GAME: Corrected a games ‘wdir’ and ‘wspd’ values from the 2015 season
INJURY [new]: Added new ‘injury’ table with complete data from 2015
PLAYER: Corrected draft position (dpos) values for 2 players
PLAYER: Changed player IM-0300 to have a primary position (pos1) of ‘TE”

All support files have also been updated to reflect the new Injury table. Also: 2 field types were changed in the Setup.sql file for ‘charts’. They were QBA and INCD which should be VARCHAR(8).

Stay tuned for more exciting news this Spring.

Dennis Erny
Founder
Armchair Analysis.com

2015 Season Data now Available!

You now officially have 697,176 reasons to purchase a Casual data plan: we’ve just updated our historical data set to include the 2015 season.

Much of this season was spent making our virtual statistician that much more accurate and we are pleased to announce that every single play over the past 16 years has now officially been documented.

Please also say a warm hello to the new ‘Touchdowns’ table. There have been over 20,000 of them in the past 16 years and they await your analysis.

Until next time…

Historical NFL Database (2000-2014) Overhaul

Further proof that good things come in large packages too

We’ve been pretty busy combing through 651,312 NFL plays and the results of this work was uploaded last night. Some of the major aspects of this update to our Historical NFL database include:

  • Inclusion of a couple of hundred missing shared tackles.
  • Some small errors affecting yardage listed for kneel downs and spiked balls have been fixed.
  • Instances of extra yardage gained after an “own recovery” fumble not being added have been corrected.
  • Errors on roughly 150 plays where a penalty on the offense adjusted the net rushing or passing yards, and, we did not take this into consideration, have been updated.

These errors where caught mostly thru automated processes. This stage of our analysis is largely complete, which means, the next step is a lengthy manual review of all 651,000 plays to remove the last inconsistencies.

Our goal is to have data 100% aligned with official records by the Spring of 2016. The 2015 season is already achieving 100% accuracy thanks, in part, to input from many of you.

For those of you who are interested, we are offering $0.25 US per-play for any details on an error, either with the key details of the play description or any of the fields that are derived from the description (i.e, yardage gained; passer id; pass target id; tacklers; punt/koff returners) and so on. Plays that are completely missing from our records (there are roughly 100) are also eligible. Plays that contain any form of a lateral are not.

There is a limit of $0.25US payout on each play so an error in the description that perhaps caused errors in 2 different fields still nets you $0.25US.

If $0.25US per play doesn’t sound like much — keep in mind that there are still an estimated 2,500 – 5,000 issues, from incorrect clock times to incorrectly labelled players. There is money to be made here, especially for those of you who can come up with a way to automate certain checks against official league records.

The best current official reference is the individual play-by-plays for each game, available at NFL.com (season 2001 – 2015). These play-by-play listings appear to include stat corrections (changes the NFL scorers make well after the game) which do account for some of the existing errors.

If you are interested in getting involved with this latest exciting project, drop us an email!!

Not Your Dad’s NFL Stats

If you want to build something different it starts with innovative data

We don’t scrape and regurgitate readily available NFL data because that’s just plain boring. Our goal at ArmchairAnalysis.com has always been to provide cutting-edge NFL stats that can be used to build innovative NFL-related applications that push the boundaries of grid-iron analysis.

Take our breakdown of NFL penalties as one example.

Here’s a fun little fact: Between the 2000 and 2013 there were roughly 50,064 penalties called in the NFL with a total of over 352,500 penalty yards being assessed in the process.

That’s no small number and it adds up to a huge impact on hundreds of game outcomes.

All penalties are not created equal; however, and our goal is to provide you with the metrics that will help you determine what does, and doesn’t, matter when it comes to game outcomes; fantasy point totals — you name it.

Over the past few seasons, we’ve come up with the following 7 categories that account for 99.6% of all flags thrown in the NFL.

#1 False Start Penalties (Offense)

This is one of the most common of all penalty calls and deserves it’s very own category

#2 Offensive Holding Penalties

This category consists mostly of holding calls on the Offensive Line.

Most common flags: Offensive Holding, Offensive Pass Interference & Illegal Use of Hands.

#3 Playbook Execution Penalties

This is my favourite category. These tend to occur more often at the start of the season, and, against teams that try and skimp on headsets for the coaching staff (had you going there, right?).

Most common flags: Illegal Formations, Passes, Substitutions, Procedures and Motion; Intentional Grounding, 12 On Field, Delay of Game.

#4 Defensive Line Penalties

It’s all about the timing. And, not drinking excessive amounts of caffeine too close to game time.

Most common flags: Defensive Offside, Encroachment, Neutral Zone Infractions.

#5 Defensive Secondary Penalties

Cornerbacks and Safeties have a tough job, but, some just do it better than others.

Most common flags: Defensive Holding, Defensive Pass Interference, Illegal Contact & Use of Hands.

#6 Dumb Penalties

Teams that are overly aggressive on defense (I’m looking at you Ravens) are more likely to draw these types of flags. Emotion aside, some of these really are just plain stupid.

Most common flags: Taunting, Roughing the Passer/Kicker, Face Masks, Unsportsmanlike Conduct.

#7 Poor Fundamentals

This is a category of penalties where the quality of a team’s defensive coach and staff can be measured. Some like tripping, border on dumb. But, if you need to trip someone in the first place it’s usually because you’re not doing your job very well.

Most common flags: Illegal Blocks, Crackbacks, Tripping, Horsecollars, Clipping.

Here is our list shown in a handy table, revealing the actual number of penalties for each category and the average yards-per-call.

Category #Flags Yards Avg
False Starts 9,363 45,890 4.90
Offensive Holding 10,842 85,514 7.89
Playbook Execution 6,652 28,477 4.28
Defensive Line 5,662 22,126 3.91
Defensive Secondary 7,506 61,916 8.25
Dumb/Aggressive 7,343 85,067 11.58
Poor Fundamentals 2,493 22,442 9.00

This is just one example of our quest to innovate and present NFL data that is just plain fun to explore. Stay tuned for many more examples to come!

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!

Daily NFL Roster Updates in 2015!

We are happy to announce that we will be starting to offer daily roster updates for the 2015 season. Any changes to the 90-man pre-season rosters as well as the regular season 53-man roster (plus practice squads) will reflected in our database within 24 hours of any transaction.

In addition, player jersey numbers will now be part of the Players table.

Look for these changes to be implemented by the start of this year’s pre-season (Week 1), Thursday, August 13th, 2015. Daily updates will occur at approximately 9am EST and both our API and static files (CSV and MySQL) will be updated at the same time.

Are you ready for some FOOTBALL?

The Wait for a Decent NFL API is Over

Great news NFL fans: our NFL API is now ready for consumption.

The API is built from the ground up to power complex NFL client-side apps and was designed by developers who also happen to love the game of Pro Football.

It gives you instant access to all the custom statistics that users of our SQL-based databases have come to know and love.

The best part is: it won’t stop here. We are working hard on a process that will allow us to release our game-charted statistics on a weekly basis this coming September. Stay tuned for more details in the next couple of months.

Are you ready for some (statistically nerdy) Football?

2014 NFL Data Is Now Available

Great news NFL fans: our historical NFL data-set has been updated to include all plays from the 2014 season bringing the grand total to 651,765 spanning the past 15 NFL seasons.

Also new in this update: JSON formatted data that can easily be imported into MongoDB or any other NoSQL database of your choice.

Stay tuned for more exciting changes to come in what is sure to be a busy off-season at ArmchairAnalysis.com!