NFL Data Dictionary

FantasyData.com provides dozens of data feeds, and some of them return results containing hundreds of columns. Most columns are self-explanatory (e.g. Receptions, RushingYards), but some are not (e.g. Number, QuarterbackHits, TimesSackedPercentage). We hope you find this documentation to be complete, but it you think anything is unclear or information is missing, please contact customer support and we'll make plans to revise our documentation.

Choose League

Product

Timeframe  
Column Type Size Nullable Scrambled (?) Description
SeasonType integer 32 No No The season type of thie timeframe (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason)
Season integer 32 No No The league year of the timeframe (this gets incremented on the first day of the league year during free agency)
Week integer 32 Yes No The week of the timeframe (Regular Season=1 to 17, Preseason=1 to 4, Postseason=1 to4, Offseason=NULL)
Name string 50 No No The friendly name of the Timeframe
ShortName string 50 No No The shorter name of the Timeframe
StartDate datetime No No The start date/time of this Timeframe
EndDate datetime No No The end date/time of the Timeframe
FirstGameStart datetime Yes No The start date/time of the first game of the Timeframe (if no games then returns the StartDate)
FirstGameEnd datetime Yes No The end date/time of the first game of the Timeframe (if no games then returns the EndDate)
LastGameEnd datetime Yes No The end date/time of the last game of the Timeframe (if no games then returns the EndDate)
HasGames boolean No No Whether there are any games in this Timeframe
HasStarted boolean No No Whether this Timeframe has started
HasEnded boolean No No Whether this Timeframe has ended
HasFirstGameStarted boolean No No Whether the first game has started
HasFirstGameEnded boolean No No Whether the first game has ended
HasLastGameEnded boolean No No Whether the last game has ended
Season   (depracated, replaced by Timeframe)
Column Type Size Nullable Scrambled (?) Description
LastCompletedSeason integer 32 No No The most recently completed season. This value changes immediately after the Super Bowl.
CurrentSeason integer 32 No No The current NFL season. This value changes when the NFL releases the schedule for the upcoming season.
UpcomingSeason integer 32 No No The current NFL season if we are midseason. If we are in the offseason, then it's the next upcoming season. This value changes immediately after the Super Bowl.
Week   (depracated, replaced by Timeframe)
Column Type Size Nullable Scrambled (?) Description
LastCompletedWeek integer 32 No No The last completed week in the NFL season. This value changes immediately after the last game of the week is completed and the data is available. This is usually right after the Monday night game.
CurrentWeek integer 32 No No The current week of the NFL season. This value canges on Tuesday night / Wednesday morning at midnight EST.
UpcomingWeek integer 32 No No The upcoming week of the NFL season. This value changes immediately after the final game of the season is completed. This is always the week after LastCompletedWeek. We always consider the Upcoming Week to be the current week until it's completed.
Team  
Column Type Size Nullable Scrambled (?) Description
Key string 50 No No Abbreviation of the team (e.g. SD, PHI, NE, IND, etc.)
TeamID integer 32 No No The auto-generated unique ID of the Team.
PlayerID integer 32 No No The auto-generated unique ID of the Team, that avoids collisions with PlayerIDs. This is useful when combining players and fantasy defenses to create fantasy teams.
City string 50 No No The city/location of the team (e.g. San Diego, Philadelphia, New England, Indianapolis, etc.)
Name string 50 No No The mascot of the team (e.g. Chargers, Eagles, Patriots, Colts, etc.)
Conference string 50 Yes No The conference of the team (e.g. AFC or NFC)
Division string 50 Yes No The division of the team (e.g. East, North, South, West)
FullName string 50 Yes No The full name of the team (e.g. New England Patriots)
StadiumID integer 32 Yes No The unique ID of the team's current home stadium
ByeWeek integer 32 Yes No The bye week of the team in the upcoming regular season
AverageDraftPosition decimal 32 Yes No The average draft position of the team's fantasy defense (DST)
AverageDraftPositionPPR decimal 32 Yes No The average draft position in PPR leagues of the team's fantasy defense (DST)
HeadCoach string 50 Yes No The current head coach of the team
OffensiveCoordinator string 50 Yes No The current offensive coordinator of the team
DefensiveCoordinator string 50 Yes No The current defensive coordinator of the team
SpecialTeamsCoach string 50 Yes No The current special teams coach of the team
OffensiveScheme string 10 Yes No The offensive scheme this team runs (PRO, 2TE, 3WR). This is decided at our descretion.
DefensiveScheme string 10 Yes No The current defensive scheme this team runs (3-4, 4-3)
UpcomingSalary integer 32 Yes No The team's DEF/ST salary for the upcoming week in accordance with a $60,000 salary cap. This is used for daily fantasy sports salary cap contests. Salaries are currently those published by FanDuel.
UpcomingOpponentRank integer 32 Yes No The team's upcoming opponent's rank in DEF/ST fantasy points allowed.
UpcomingOpponentPositionRank integer 32 Yes No The team's upcoming opponent's rank in DEF/ST fantasy points allowed.
Stadium  
Column Type Size Nullable Scrambled (?) Description
StadiumID integer 32 No No The unique ID of the stadium
Name string 100 No No The full name of the stadium
City string 50 No No The city where the stadium is located
State string 10 Yes No The US state where the stadium is located (if Stadium is outside US, this value is NULL)
Country string 10 No No The 2-digit country code where the stadium is located
Capacity integer 32 Yes No The estimated seating capacity of the stadium
PlayingSurface string 50 Yes No The playing surface of the stadium (Grass, Artificial or Dome)
Score  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL season of the game
Week integer 32 No No The NFL week of the game (weeks 18-21 denote playoff games)
Date datetime No No The date/time of the game
AwayTeam string 50 Yes No The abbreviation of the Away Team
HomeTeam string 50 Yes No The abbreviation of the Home Team
AwayScore integer 32 No No The final score of the Away Team
HomeScore integer 32 No No The final score of the Home Team
Channel string 50 Yes No The television station broadcasting the game
PointSpread decimal 32 Yes No The oddsmaker Point Spread at game start from the perspective of the HomeTeam (negative numbers indicate the HomeTeam is favored, positive numbers indicate the AwayTeam is favored)
OverUnder decimal 32 Yes No The oddsmaker Over/Under at game start
Quarter string 50 Yes No The current quarter of the game (1, 2, 3, 4, Half, OT, F, F/OT or NULL if game has not yet started)
TimeRemaining string 50 Yes No The amount of time remaining in the current quarter (11:23, 5:34, NULL if game is not in progress or at halftime)
Possession string 50 Yes No The team that currently has possession of the ball (PHI, NE, NULL if game is not in progress or at halftime)
Down integer 32 Yes No The current down in the game (1, 2, 3, 4 or NULL)
Distance string 10 Yes No The yards to go for a first down (this can be any positive number or "Goal")
YardLine integer 32 Yes No The yard line that the ball is currently located, as of the most recently completed play
YardLineTerritory string 10 Yes No The team's territory that the ball is currently located ("SF", "BAL" or NULL)
RedZone string 10 Yes No The team that currently has the ball in the opponent's red zone ("SF", "BAL" or NULL)
AwayScoreQuarter1 integer 32 Yes No Points scored during Quarter 1
AwayScoreQuarter2 integer 32 Yes No Points scored during Quarter 2
AwayScoreQuarter3 integer 32 Yes No Points scored during Quarter 3
AwayScoreQuarter4 integer 32 Yes No Points scored during Quarter 4
AwayScoreOvertime integer 32 Yes No Points scored during Overtime
HomeScoreQuarter1 integer 32 Yes No Points scored during Quarter 1
HomeScoreQuarter2 integer 32 Yes No Points scored during Quarter 2
HomeScoreQuarter3 integer 32 Yes No Points scored during Quarter 3
HomeScoreQuarter4 integer 32 Yes No Points scored during Quarter 4
HomeScoreOvertime integer 32 Yes No Points scored during Overtime
HasStarted boolean No No Whether the game has started (true/false)
IsInProgress boolean No No Whether the game is currently in progress (true/false)
IsOver boolean No No Whether the game is over (true/false)
Has1stQuarterStarted boolean No No Whether the 1st quarter has started
Has2ndQuarterStarted boolean No No Whether the 2nd quarter has started
Has3rdQuarterStarted boolean No No Whether the 3rd quarter has started
Has4thQuarterStarted boolean No No Whether the 4th quarter has started
IsOvertime boolean No No Whether this game went into overtime
DownAndDistance string 50 Yes No Description of the down and distance for display purposes
QuarterDescription string 50 Yes No Description of the current quarter for display purposes
StadiumID integer 32 Yes No The unique ID of the team's current home stadium
LastUpdated datetime Yes No The date and time that this game was last updated (US Eastern Time)
Schedule  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 Yes No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam. This value will be NULL for bye weeks.
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL season of the game
Week integer 32 No No The NFL week of the game (weeks 18-21 denote playoff games)
Date datetime Yes No The date/time of the game
AwayTeam string 50 Yes No The abbreviation of the Away Team
HomeTeam string 50 Yes No The abbreviation of the Home Team
Channel string 50 Yes No The television station broadcasting the game
PointSpread decimal 32 Yes No The oddsmaker Point Spread at game start from the perspective of the HomeTeam (negative numbers indicate the HomeTeam is favored, positive numbers indicate the AwayTeam is favored)
OverUnder decimal 32 Yes No The oddsmaker Over/Under at game start
StadiumID integer 32 Yes No The unique ID of the stadium
Bye  
Column Type Size Nullable Scrambled (?) Description
Season integer 32 No No The NFL season during this bye week
Week integer 32 No No The NFL week during this bye week
Team string 50 Yes No The NFL team who is on bye during this week
Game  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
Date datetime No No The date/time of the game
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL season of the game
Week integer 32 No No The NFL week of the game (weeks 18-21 denote playoff games)
Stadium
from 2001
string 50 Yes No Stadium of the event
PlayingSurface string 50 Yes No Playing surface of the stadium
Temperature
from 2001
integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity
from 2001
integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed
from 2001
integer 32 Yes Yes Wind speed at game start (MPH)
AwayTeam string 50 Yes No The abbreviation of the Away Team
HomeTeam string 50 Yes No The abbreviation of the Home Team
AwayScore integer 32 No No The final score of the Away Team
HomeScore integer 32 No No The final score of the Home Team
TotalScore integer 32 Yes No The total score of both teams
OverUnder decimal 32 Yes No The oddsmaker Over/Under at game start
PointSpread decimal 32 Yes No The oddsmaker Point Spread at game start from the perspective of the HomeTeam (negative numbers indicate the HomeTeam is favored, positive numbers indicate the AwayTeam is favored)
AwayScoreQuarter1 integer 32 Yes No Points scored during Quarter 1
AwayScoreQuarter2 integer 32 Yes No Points scored during Quarter 2
AwayScoreQuarter3 integer 32 Yes No Points scored during Quarter 3
AwayScoreQuarter4 integer 32 Yes No Points scored during Quarter 4
AwayScoreOvertime integer 32 Yes No Points scored during Overtime
HomeScoreQuarter1 integer 32 Yes No Points scored during Quarter 1
HomeScoreQuarter2 integer 32 Yes No Points scored during Quarter 2
HomeScoreQuarter3 integer 32 Yes No Points scored during Quarter 3
HomeScoreQuarter4 integer 32 Yes No Points scored during Quarter 4
HomeScoreOvertime integer 32 Yes No Points scored during Overtime
AwayTimeOfPossession string 50 Yes Yes Time of Posession
HomeTimeOfPossession string 50 Yes Yes Time of Posession
AwayFirstDowns integer 32 Yes Yes Total First Downs
HomeFirstDowns integer 32 Yes Yes Total First Downs
AwayFirstDownsByRushing
from 2001
integer 32 Yes Yes Rushing First Downs
HomeFirstDownsByRushing
from 2001
integer 32 Yes Yes Rushing First Downs
AwayFirstDownsByPassing
from 2001
integer 32 Yes Yes Passing First Downs
HomeFirstDownsByPassing
from 2001
integer 32 Yes Yes Passing First Downs
AwayFirstDownsByPenalty
from 2001
integer 32 Yes Yes First Downs (via Penalty)
HomeFirstDownsByPenalty
from 2001
integer 32 Yes Yes First Downs (via Penalty)
AwayOffensivePlays integer 32 Yes Yes Number of offensive plays run
HomeOffensivePlays integer 32 Yes Yes Number of offensive plays run
AwayOffensiveYards integer 32 Yes Yes Number of offensive yards gained
HomeOffensiveYards integer 32 Yes Yes Number of offensive yards gained
AwayOffensiveYardsPerPlay decimal 32 Yes Yes Average yards gained per offensive play
HomeOffensiveYardsPerPlay decimal 32 Yes Yes Average yards gained per offensive play
AwayTouchdowns
from 2001
integer 32 Yes Yes Touchdowns scored
HomeTouchdowns
from 2001
integer 32 Yes Yes Touchdowns scored
AwayRushingAttempts integer 32 Yes Yes Number of rushing attempts
HomeRushingAttempts integer 32 Yes Yes Number of rushing attempts
AwayRushingYards integer 32 Yes Yes Number of rushing yards
HomeRushingYards integer 32 Yes Yes Number of rushing yards
AwayRushingYardsPerAttempt decimal 32 Yes Yes Average rushing yards gained per attempt
HomeRushingYardsPerAttempt decimal 32 Yes Yes Average rushing yards gained per attempt
AwayRushingTouchdowns
from 2001
integer 32 Yes Yes Rushing touchdowns scored
HomeRushingTouchdowns
from 2001
integer 32 Yes Yes Rushing touchdowns scored
AwayPassingAttempts integer 32 Yes Yes Number of passes thrown
HomePassingAttempts integer 32 Yes Yes Number of passes thrown
AwayPassingCompletions integer 32 Yes Yes Number of pass completions
HomePassingCompletions integer 32 Yes Yes Number of pass completions
AwayPassingYards integer 32 Yes Yes Number of passing yards
HomePassingYards integer 32 Yes Yes Number of passing yards
AwayPassingTouchdowns
from 2001
integer 32 Yes Yes Passing touchdowns scored
HomePassingTouchdowns
from 2001
integer 32 Yes Yes Passing touchdowns scored
AwayPassingInterceptions integer 32 Yes Yes Interceptions thrown
HomePassingInterceptions integer 32 Yes Yes Interceptions thrown
AwayPassingYardsPerAttempt decimal 32 Yes Yes Average passing yards gained per attempt
HomePassingYardsPerAttempt decimal 32 Yes Yes Average passing yards gained per attempt
AwayPassingYardsPerCompletion decimal 32 Yes Yes Average passing yards gained per completion
HomePassingYardsPerCompletion decimal 32 Yes Yes Average passing yards gained per completion
AwayCompletionPercentage decimal 32 Yes Yes Percentage of passes that were completed
HomeCompletionPercentage decimal 32 Yes Yes Percentage of passes that were completed
AwayPasserRating
from 2001
decimal 32 Yes Yes Passer rating
HomePasserRating
from 2001
decimal 32 Yes Yes Passer rating
AwayThirdDownAttempts
from 2001
integer 32 Yes Yes Third down attempts
HomeThirdDownAttempts
from 2001
integer 32 Yes Yes Third down attempts
AwayThirdDownConversions
from 2001
integer 32 Yes Yes Third down conversions
HomeThirdDownConversions
from 2001
integer 32 Yes Yes Third down conversions
AwayThirdDownPercentage
from 2001
decimal 32 Yes Yes Percentage of third downs converted
HomeThirdDownPercentage
from 2001
decimal 32 Yes Yes Percentage of third downs converted
AwayFourthDownAttempts
from 2001
integer 32 Yes Yes Fourth down attempts
HomeFourthDownAttempts
from 2001
integer 32 Yes Yes Fourth down attempts
AwayFourthDownConversions
from 2001
integer 32 Yes Yes Fourth down conversions
HomeFourthDownConversions
from 2001
integer 32 Yes Yes Fourth down conversions
AwayFourthDownPercentage
from 2001
decimal 32 Yes Yes Percentage of fourth downs converted
HomeFourthDownPercentage
from 2001
decimal 32 Yes Yes Percentage of fourth downs converted
AwayRedZoneAttempts
from 2001
integer 32 Yes Yes Red zone opportunities
HomeRedZoneAttempts
from 2001
integer 32 Yes Yes Red zone opportunities
AwayRedZoneConversions
from 2001
integer 32 Yes Yes Red zone opportunities converted to touchdowns
HomeRedZoneConversions
from 2001
integer 32 Yes Yes Red zone opportunities converted to touchdowns
AwayGoalToGoAttempts
from 2001
integer 32 Yes Yes 1st & Goal opportunities
HomeGoalToGoAttempts
from 2001
integer 32 Yes Yes 1st & Goal opportunities
AwayGoalToGoConversions
from 2001
integer 32 Yes Yes 1st & Goal opportunities converted to touchdowns
HomeGoalToGoConversions
from 2001
integer 32 Yes Yes 1st & Goal opportunities converted to touchdowns
AwayReturnYards integer 32 Yes Yes Total punt and defensive return yards
HomeReturnYards integer 32 Yes Yes Total punt and defensive return yards
AwayPenalties integer 32 Yes Yes Penalties committed
HomePenalties integer 32 Yes Yes Penalties committed
AwayPenaltyYards integer 32 Yes Yes Penalty yards enforced against the away team
HomePenaltyYards integer 32 Yes Yes Penalty yards enforced against the away team
AwayFumbles integer 32 Yes Yes Fumbles
HomeFumbles integer 32 Yes Yes Fumbles
AwayFumblesLost integer 32 Yes Yes Fumbles lost
HomeFumblesLost integer 32 Yes Yes Fumbles lost
AwayTimesSacked integer 32 Yes Yes Number of times the away team was sacked
HomeTimesSacked integer 32 Yes Yes Number of times the away team was sacked
AwayTimesSackedYards integer 32 Yes Yes Number of yards lost as a result of being sacked
HomeTimesSackedYards integer 32 Yes Yes Number of yards lost as a result of being sacked
AwaySafeties integer 32 Yes Yes Safeties scored
HomeSafeties integer 32 Yes Yes Safeties scored
AwayPunts integer 32 Yes Yes Number of punts
HomePunts integer 32 Yes Yes Number of punts
AwayPuntYards integer 32 Yes Yes Total punt yards
HomePuntYards integer 32 Yes Yes Total punt yards
AwayPuntAverage decimal 32 Yes Yes Average number of yards per punt
HomePuntAverage decimal 32 Yes Yes Average number of yards per punt
AwayGiveaways integer 32 Yes Yes Number of giveaways
HomeGiveaways integer 32 Yes Yes Number of giveaways
AwayTakeaways integer 32 Yes Yes Number of takeaways
HomeTakeaways integer 32 Yes Yes Number of takeaways
AwayTurnoverDifferential integer 32 Yes Yes Number of takeaways minus giveaways
HomeTurnoverDifferential integer 32 Yes Yes Number of takeaways minus giveaways
AwayKickoffs
from 2012
integer 32 Yes Yes Number of kickoffs
HomeKickoffs
from 2012
integer 32 Yes Yes Number of kickoffs
AwayKickoffsInEndZone
from 2012
integer 32 Yes Yes Number of kickoffs that went into the end zone
HomeKickoffsInEndZone
from 2012
integer 32 Yes Yes Number of kickoffs that went into the end zone
AwayKickoffTouchbacks
from 2012
integer 32 Yes Yes Number of kickoffs that resulted in touchbacks
HomeKickoffTouchbacks
from 2012
integer 32 Yes Yes Number of kickoffs that resulted in touchbacks
AwayPuntsHadBlocked
from 2012
integer 32 Yes Yes Number of punts that were blocked
HomePuntsHadBlocked
from 2012
integer 32 Yes Yes Number of punts that were blocked
AwayPuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
HomePuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
AwayExtraPointKickingAttempts
from 2012
integer 32 Yes Yes Extra point kick attempts
HomeExtraPointKickingAttempts
from 2012
integer 32 Yes Yes Extra point kick attempts
AwayExtraPointKickingConversions
from 2012
integer 32 Yes Yes Extra point kicks made
HomeExtraPointKickingConversions
from 2012
integer 32 Yes Yes Extra point kicks made
AwayExtraPointsHadBlocked
from 2012
integer 32 Yes Yes Extra point kick attempts that were blocked
HomeExtraPointsHadBlocked
from 2012
integer 32 Yes Yes Extra point kick attempts that were blocked
AwayExtraPointPassingAttempts
from 2012
integer 32 Yes Yes Two point conversion passing attempts
HomeExtraPointPassingAttempts
from 2012
integer 32 Yes Yes Two point conversion passing attempts
AwayExtraPointPassingConversions
from 2012
integer 32 Yes Yes Two point conversion passing conversions
HomeExtraPointPassingConversions
from 2012
integer 32 Yes Yes Two point conversion passing conversions
AwayExtraPointRushingAttempts
from 2012
integer 32 Yes Yes Two point conversion rushing attempts
HomeExtraPointRushingAttempts
from 2012
integer 32 Yes Yes Two point conversion rushing attempts
AwayExtraPointRushingConversions
from 2012
integer 32 Yes Yes Two point conversion rushing conversions
HomeExtraPointRushingConversions
from 2012
integer 32 Yes Yes Two point conversion rushing conversions
AwayFieldGoalAttempts
from 2012
integer 32 Yes Yes Field goal attempts
HomeFieldGoalAttempts
from 2012
integer 32 Yes Yes Field goal attempts
AwayFieldGoalsMade
from 2012
integer 32 Yes Yes Field goals made
HomeFieldGoalsMade
from 2012
integer 32 Yes Yes Field goals made
AwayFieldGoalsHadBlocked
from 2012
integer 32 Yes Yes Field goal attempts that were blocked
HomeFieldGoalsHadBlocked
from 2012
integer 32 Yes Yes Field goal attempts that were blocked
AwayPuntReturns
from 2012
integer 32 Yes Yes Punt returns
HomePuntReturns
from 2012
integer 32 Yes Yes Punt returns
AwayPuntReturnYards
from 2012
integer 32 Yes Yes Punt return yards
HomePuntReturnYards
from 2012
integer 32 Yes Yes Punt return yards
AwayKickReturns
from 2012
integer 32 Yes Yes Kickoff returns
HomeKickReturns
from 2012
integer 32 Yes Yes Kickoff returns
AwayKickReturnYards
from 2012
integer 32 Yes Yes Kickoff return yards
HomeKickReturnYards
from 2012
integer 32 Yes Yes Kickoff return yards
AwayInterceptionReturns
from 2012
integer 32 Yes Yes Defensive interceptions
HomeInterceptionReturns
from 2012
integer 32 Yes Yes Defensive interceptions
AwayInterceptionReturnYards
from 2012
integer 32 Yes Yes Interception return yards
HomeInterceptionReturnYards
from 2012
integer 32 Yes Yes Interception return yards
AwaySoloTackles integer 32 Yes Yes Defensive solo tackles
AwayAssistedTackles integer 32 Yes Yes Defensive assisted tackles
AwayQuarterbackHits integer 32 Yes Yes Defensive QB hits
AwayTacklesForLoss integer 32 Yes Yes Defensive tackles for a loss
AwaySacks integer 32 Yes Yes Defensive sacks
AwaySackYards integer 32 Yes Yes Defensive sack yards
AwayPassesDefended integer 32 Yes Yes Defensive passes defended
AwayFumblesForced integer 32 Yes Yes Defensive fumbles forced
AwayFumblesRecovered integer 32 Yes Yes Fumbles recovered that resulted in change of possession
AwayFumbleReturnYards integer 32 Yes Yes Fumble return yards
AwayFumbleReturnTouchdowns integer 32 Yes Yes Fumble return touchdowns
AwayInterceptionReturnTouchdowns integer 32 Yes Yes Defensive interceptions
AwayBlockedKicks integer 32 Yes Yes Total number of opponent's kicks that were blocked
AwayPuntReturnTouchdowns integer 32 Yes Yes Punt return touchdown
AwayPuntReturnLong integer 32 Yes Yes Longest punt return
AwayKickReturnTouchdowns integer 32 Yes Yes Kick return touchdown
AwayKickReturnLong integer 32 Yes Yes Longest kick return
AwayBlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
AwayBlockedKickReturnTouchdowns integer 32 Yes Yes Blocked kick recovery return touchdowns
AwayFieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
AwayFieldGoalReturnTouchdowns integer 32 Yes Yes Field goal return touchdowns (excluding blocked field goals)
AwayPuntNetYards integer 32 Yes Yes Net punt yards
HomeSoloTackles integer 32 Yes Yes Defensive solo tackles
HomeAssistedTackles integer 32 Yes Yes Defensive assisted tackles
HomeQuarterbackHits integer 32 Yes Yes Defensive QB hits
HomeTacklesForLoss integer 32 Yes Yes Defensive tackles for a loss
HomeSacks integer 32 Yes Yes Defensive sacks
HomeSackYards integer 32 Yes Yes Defensive sack yards
HomePassesDefended integer 32 Yes Yes Defensive passes defended
HomeFumblesForced integer 32 Yes Yes Defensive fumbles forced
HomeFumblesRecovered integer 32 Yes Yes Fumbles recovered that resulted in change of possession
HomeFumbleReturnYards integer 32 Yes Yes Fumble return yards
HomeFumbleReturnTouchdowns integer 32 Yes Yes Fumble return touchdowns
HomeInterceptionReturnTouchdowns integer 32 Yes Yes Defensive interceptions
HomeBlockedKicks integer 32 Yes Yes Total number of opponent's kicks that were blocked
HomePuntReturnTouchdowns integer 32 Yes Yes Punt return touchdown
HomePuntReturnLong integer 32 Yes Yes Longest punt return
HomeKickReturnTouchdowns integer 32 Yes Yes Kick return touchdown
HomeKickReturnLong integer 32 Yes Yes Longest kick return
HomeBlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
HomeBlockedKickReturnTouchdowns integer 32 Yes Yes Blocked kick recovery return touchdowns
HomeFieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
HomeFieldGoalReturnTouchdowns integer 32 Yes Yes Field goal return touchdowns (excluding blocked field goals)
HomePuntNetYards integer 32 Yes Yes Net punt yards
IsGameOver boolean Yes No Whether the game is over (true/false)
GameID integer 32 No No Auto generated unique ID for this game (subject to change). For a static ID, use GameKey.
StadiumID integer 32 Yes No The unique ID of the stadium
TeamGame  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
Date datetime Yes No The date/time of the game
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL season of the game
Week integer 32 Yes No The NFL week of the game (weeks 18-21 denote playoff games)
Team string 50 Yes No The abbreviation of the Team
Opponent string 50 Yes No The abbreviation of the Opponent
HomeOrAway string 50 Yes No Whether the Team is Home or Away
Score integer 32 No No The final score of the Team
OpponentScore integer 32 No No The final score of the Opponent
TotalScore integer 32 No No The total score of both teams
Stadium
from 2001
string 50 Yes No Stadium of the event
PlayingSurface string 50 Yes No Playing surface of the stadium
Temperature
from 2001
integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity
from 2001
integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed
from 2001
integer 32 Yes Yes Wind speed at game start (MPH)
OverUnder decimal 32 Yes No The oddsmaker Over/Under at game start
PointSpread decimal 32 Yes No The oddsmaker Point Spread at game start from the perspective of the Team (negative numbers indicate the Team is favored, positive numbers indicate the Opponent is favored)
ScoreQuarter1 integer 32 Yes No Points scored during Quarter 1 for the Team
ScoreQuarter2 integer 32 Yes No Points scored during Quarter 2 for the Team
ScoreQuarter3 integer 32 Yes No Points scored during Quarter 3 for the Team
ScoreQuarter4 integer 32 Yes No Points scored during Quarter 4 for the Team
ScoreOvertime integer 32 No No Points scored during Overtime for the Team
TimeOfPossessionMinutes integer 32 Yes Yes Time of posession minutes
TimeOfPossessionSeconds integer 32 Yes Yes Time of posession seconds
TimeOfPossession string 50 Yes Yes Time of posession
FirstDowns integer 32 Yes Yes Total first downs
FirstDownsByRushing
from 2001
integer 32 Yes Yes Total rushing first downs
FirstDownsByPassing
from 2001
integer 32 Yes Yes Total passing first downs
FirstDownsByPenalty
from 2001
integer 32 Yes Yes Total first downs by opponent's penalty
OffensivePlays integer 32 No Yes Number of offensive plays run
OffensiveYards integer 32 No Yes Number of offensive yards gained
OffensiveYardsPerPlay decimal 32 No Yes Average yards gained per offensive play
Touchdowns
from 2001
integer 32 Yes Yes Touchdowns scored
RushingAttempts integer 32 Yes Yes Number of rushing attempts
RushingYards integer 32 Yes Yes Number of rushing yards
RushingYardsPerAttempt decimal 32 No Yes Average rushing yards gained per attempt
RushingTouchdowns
from 2001
integer 32 Yes Yes Rushing touchdowns scored
PassingAttempts integer 32 Yes Yes Number of passes thrown
PassingCompletions integer 32 Yes Yes Number of pass completions
PassingYards integer 32 Yes Yes Number of passing yards
PassingTouchdowns
from 2001
integer 32 Yes Yes Passing touchdowns scored
PassingInterceptions integer 32 Yes Yes Interceptions thrown
PassingYardsPerAttempt decimal 32 No Yes Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Yes Average passing yards gained per completion
CompletionPercentage decimal 32 No Yes Percentage of passes that were completed
PasserRating
from 2001
decimal 32 Yes Yes Passer rating
ThirdDownAttempts
from 2001
integer 32 Yes Yes Third down attempts
ThirdDownConversions
from 2001
integer 32 Yes Yes Third down conversions
ThirdDownPercentage
from 2001
decimal 32 Yes Yes Percentage of third downs converted
FourthDownAttempts
from 2001
integer 32 Yes Yes Fourth down attempts
FourthDownConversions
from 2001
integer 32 Yes Yes Fourth down conversions
FourthDownPercentage
from 2001
decimal 32 Yes Yes Percentage of fourth downs converted
RedZoneAttempts
from 2001
integer 32 Yes Yes Red zone opportunities
RedZoneConversions
from 2001
integer 32 Yes Yes Red zone opportunities converted to touchdowns
GoalToGoAttempts
from 2001
integer 32 Yes Yes 1st & Goal opportunities
GoalToGoConversions
from 2001
integer 32 Yes Yes 1st & Goal opportunities converted to touchdowns
ReturnYards integer 32 Yes Yes Total punt and defensive return yards
Penalties integer 32 Yes Yes Penalties committed
PenaltyYards integer 32 Yes Yes Penalty yards enforced against team
Fumbles integer 32 Yes Yes Fumbles
FumblesLost integer 32 Yes Yes Fumbles lost
TimesSacked integer 32 Yes Yes Number of sacks allowed by Team
TimesSackedYards integer 32 Yes Yes Number of yards lost as a result of sacks allowed
QuarterbackHits
from 2006
integer 32 Yes Yes Number of times the opposing QB was hit (includes sacks)
TacklesForLoss
from 2008
integer 32 Yes Yes Number of times the opponent was tackled for a loss
Safeties integer 32 Yes Yes Safeties scored
Punts integer 32 Yes Yes Number of punts
PuntYards integer 32 Yes Yes Total punt yards
PuntAverage decimal 32 No Yes Average number of yards per punt
Giveaways integer 32 No Yes Number of giveaways
Takeaways integer 32 No Yes Number of takeaways
TurnoverDifferential integer 32 No Yes Number of takeaways minus giveaways
OpponentScoreQuarter1 integer 32 Yes No Points scored during Quarter 1 for the Team
OpponentScoreQuarter2 integer 32 Yes No Points scored during Quarter 2 for the Team
OpponentScoreQuarter3 integer 32 Yes No Points scored during Quarter 3 for the Team
OpponentScoreQuarter4 integer 32 Yes No Points scored during Quarter 4 for the Team
OpponentScoreOvertime integer 32 No No Points scored during Overtime for the Team
OpponentTimeOfPossessionMinutes integer 32 Yes Yes Time of posession minutes
OpponentTimeOfPossessionSeconds integer 32 Yes Yes Time of posession seconds
OpponentTimeOfPossession string 50 Yes Yes Time of posession
OpponentFirstDowns integer 32 Yes Yes Total first downs
OpponentFirstDownsByRushing
from 2001
integer 32 Yes Yes Total rushing first downs
OpponentFirstDownsByPassing
from 2001
integer 32 Yes Yes Total passing first downs
OpponentFirstDownsByPenalty
from 2001
integer 32 Yes Yes Total first downs by opponent's penalty
OpponentOffensivePlays integer 32 No Yes Number of offensive plays run
OpponentOffensiveYards integer 32 No Yes Number of offensive yards gained
OpponentOffensiveYardsPerPlay decimal 32 No Yes Average yards gained per offensive play
OpponentTouchdowns
from 2001
integer 32 Yes Yes Touchdowns scored
OpponentRushingAttempts integer 32 Yes Yes Number of rushing attempts
OpponentRushingYards integer 32 Yes Yes Number of rushing yards
OpponentRushingYardsPerAttempt decimal 32 No Yes Average rushing yards gained per attempt
OpponentRushingTouchdowns
from 2001
integer 32 Yes Yes Rushing touchdowns scored
OpponentPassingAttempts integer 32 Yes Yes Number of passes thrown
OpponentPassingCompletions integer 32 Yes Yes Number of pass completions
OpponentPassingYards integer 32 Yes Yes Number of passing yards
OpponentPassingTouchdowns
from 2001
integer 32 Yes Yes Passing touchdowns scored
OpponentPassingInterceptions integer 32 Yes Yes Interceptions thrown
OpponentPassingYardsPerAttempt decimal 32 No Yes Average passing yards gained per attempt
OpponentPassingYardsPerCompletion decimal 32 No Yes Average passing yards gained per completion
OpponentCompletionPercentage decimal 32 No Yes Percentage of passes that were completed
OpponentPasserRating
from 2001
decimal 32 Yes Yes Passer rating
OpponentThirdDownAttempts
from 2001
integer 32 Yes Yes Third down attempts
OpponentThirdDownConversions
from 2001
integer 32 Yes Yes Third down conversions
OpponentThirdDownPercentage
from 2001
decimal 32 Yes Yes Percentage of third downs converted
OpponentFourthDownAttempts
from 2001
integer 32 Yes Yes Fourth down attempts
OpponentFourthDownConversions
from 2001
integer 32 Yes Yes Fourth down conversions
OpponentFourthDownPercentage
from 2001
decimal 32 Yes Yes Percentage of fourth downs converted
OpponentRedZoneAttempts
from 2001
integer 32 Yes Yes Red zone opportunities
OpponentRedZoneConversions
from 2001
integer 32 Yes Yes Red zone opportunities converted to touchdowns
OpponentGoalToGoAttempts
from 2001
integer 32 Yes Yes 1st & Goal opportunities
OpponentGoalToGoConversions
from 2001
integer 32 Yes Yes 1st & Goal opportunities converted to touchdowns
OpponentReturnYards integer 32 Yes Yes Total punt and defensive return yards
OpponentPenalties integer 32 Yes Yes Penalties committed
OpponentPenaltyYards integer 32 Yes Yes Penalty yards enforced against the opponent
OpponentFumbles integer 32 Yes Yes Fumbles
OpponentFumblesLost integer 32 Yes Yes Fumbles lost
OpponentTimesSacked integer 32 Yes Yes Number of sacks allowed by Opponent
OpponentTimesSackedYards integer 32 Yes Yes Number of yards opponent lost as a result of being sacked
OpponentQuarterbackHits
from 2006
integer 32 Yes Yes Number of times our QB was hit but not sacked
OpponentTacklesForLoss
from 2008
integer 32 Yes Yes Number of times our ball carrier was tackled for a loss
OpponentSafeties
from 2001
integer 32 Yes Yes Safeties scored
OpponentPunts integer 32 Yes Yes Number of punts
OpponentPuntYards integer 32 Yes Yes Total punt yards
OpponentPuntAverage decimal 32 No Yes Average number of yards per punt
OpponentGiveaways integer 32 No Yes Number of giveaways
OpponentTakeaways integer 32 No Yes Number of takeaways
OpponentTurnoverDifferential integer 32 No Yes Number of takeaways minus giveaways
RedZonePercentage
from 2012
decimal 32 Yes Yes Percentage of red zone opportunities converted into touchdowns
GoalToGoPercentage
from 2012
decimal 32 Yes Yes Percentage of goal-to-go opportunities converted into touchdowns
QuarterbackHitsDifferential
from 2012
integer 32 Yes Yes The differential of hits on the opposing quarterback minus hits on own team's quarterback
TacklesForLossDifferential
from 2012
integer 32 Yes Yes The differential of tackles for loss minus opponent's tackles for loss
QuarterbackSacksDifferential
from 2012
integer 32 No Yes The Team's sack differential (similar to a turnover differential)
TacklesForLossPercentage
from 2012
decimal 32 Yes Yes Percentage of running plays defended that resulted in tackle for loss
QuarterbackHitsPercentage
from 2012
decimal 32 Yes Yes Percantage of opposing quarterback drop backs that resulted hitting the quarterback
TimesSackedPercentage
from 2012
decimal 32 No No Percentage of drop backs that resulted in a sack
OpponentRedZonePercentage
from 2012
decimal 32 Yes Yes Percentage of opponent's red zone opportunities converted into touchdowns
OpponentGoalToGoPercentage
from 2012
decimal 32 Yes Yes Percentage of opponent's goal-to-go opportunities converted into touchdowns
OpponentQuarterbackHitsDifferential
from 2012
integer 32 Yes Yes The inverse of QuarterbackHitsDifferential
OpponentTacklesForLossDifferential
from 2012
integer 32 Yes Yes The inverse of TacklesForLossDifferential
OpponentQuarterbackSacksDifferential
from 2012
integer 32 Yes Yes The inverse of QuarterbackSacksDifferential
OpponentTacklesForLossPercentage
from 2012
decimal 32 Yes Yes Percentage of running plays defended that resulted in tackle for loss
OpponentQuarterbackHitsPercentage
from 2012
decimal 32 Yes Yes Percantage of own team's quarterback drop backs that resulted in our quarterback getting hit
OpponentTimesSackedPercentage
from 2012
decimal 32 No Yes Percentage of drop backs that resulted in a sack
Kickoffs
from 2012
integer 32 Yes Yes Number of kickoffs
KickoffsInEndZone
from 2012
integer 32 Yes Yes Number of kickoffs that went into the end zone
KickoffTouchbacks
from 2012
integer 32 Yes Yes Number of kickoffs that resulted in touchbacks
PuntsHadBlocked
from 2012
integer 32 Yes Yes Number of punts that were blocked
PuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
ExtraPointKickingAttempts
from 2012
integer 32 Yes Yes Extra point kick attempts
ExtraPointKickingConversions
from 2012
integer 32 Yes Yes Extra point kicks made
ExtraPointsHadBlocked
from 2012
integer 32 Yes Yes Extra point kick attempts that were blocked
ExtraPointPassingAttempts
from 2012
integer 32 Yes Yes Two point conversion passing attempts
ExtraPointPassingConversions
from 2012
integer 32 Yes Yes Two point conversion passing conversions
ExtraPointRushingAttempts
from 2012
integer 32 Yes Yes Two point conversion rushing attempts
ExtraPointRushingConversions
from 2012
integer 32 Yes Yes Two point conversion rushing conversions
FieldGoalAttempts
from 2012
integer 32 Yes Yes Field goal attempts
FieldGoalsMade
from 2012
integer 32 Yes Yes Field goals made
FieldGoalsHadBlocked
from 2012
integer 32 Yes Yes Field goal attempts that were blocked
PuntReturns
from 2012
integer 32 Yes Yes Punt returns
PuntReturnYards
from 2012
integer 32 Yes Yes Punt return yards
KickReturns
from 2012
integer 32 Yes Yes Kickoff returns
KickReturnYards
from 2012
integer 32 Yes Yes Kickoff return yards
InterceptionReturns
from 2012
integer 32 Yes Yes Defensive interceptions
InterceptionReturnYards
from 2012
integer 32 Yes Yes Interception return yards
OpponentKickoffs
from 2012
integer 32 Yes Yes Number of kickoffs
OpponentKickoffsInEndZone
from 2012
integer 32 Yes Yes Number of kickoffs that went into the end zone
OpponentKickoffTouchbacks
from 2012
integer 32 Yes Yes Number of kickoffs that resulted in touchbacks
OpponentPuntsHadBlocked
from 2012
integer 32 Yes Yes Number of punts that were blocked
OpponentPuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
OpponentExtraPointKickingAttempts
from 2012
integer 32 Yes Yes Extra point kick attempts
OpponentExtraPointKickingConversions
from 2012
integer 32 Yes Yes Extra point kicks made
OpponentExtraPointsHadBlocked
from 2012
integer 32 Yes Yes Extra point kick attempts that were blocked
OpponentExtraPointPassingAttempts
from 2012
integer 32 Yes Yes Two point conversion passing attempts
OpponentExtraPointPassingConversions
from 2012
integer 32 Yes Yes Two point conversion passing conversions
OpponentExtraPointRushingAttempts
from 2012
integer 32 Yes Yes Two point conversion rushing attempts
OpponentExtraPointRushingConversions
from 2012
integer 32 Yes Yes Two point conversion rushing conversions
OpponentFieldGoalAttempts
from 2012
integer 32 Yes Yes Field goal attempts
OpponentFieldGoalsMade
from 2012
integer 32 Yes Yes Field goals made
OpponentFieldGoalsHadBlocked
from 2012
integer 32 Yes Yes Field goal attempts that were blocked
OpponentPuntReturns
from 2012
integer 32 Yes Yes Punt returns
OpponentPuntReturnYards
from 2012
integer 32 Yes Yes Punt return yards
OpponentKickReturns
from 2012
integer 32 Yes Yes Kickoff returns
OpponentKickReturnYards
from 2012
integer 32 Yes Yes Kickoff return yards
OpponentInterceptionReturns
from 2012
integer 32 Yes Yes Defensive interceptions
OpponentInterceptionReturnYards
from 2012
integer 32 Yes Yes Interception return yards
SoloTackles integer 32 Yes Yes Defensive solo tackles
AssistedTackles integer 32 Yes Yes Defensive assisted tackles
Sacks integer 32 Yes Yes Defensive sacks
SackYards integer 32 Yes Yes Defensive sack yards
PassesDefended integer 32 Yes Yes Defensive passes defended
FumblesForced integer 32 Yes Yes Defensive fumbles forced
FumblesRecovered integer 32 Yes Yes Fumbles recovered that resulted in change of possession
FumbleReturnYards integer 32 Yes Yes Fumble return yards
FumbleReturnTouchdowns integer 32 Yes Yes Fumble return touchdowns
InterceptionReturnTouchdowns integer 32 Yes Yes Defensive interceptions
BlockedKicks integer 32 Yes Yes Total number of opponent's kicks that were blocked
PuntReturnTouchdowns integer 32 Yes Yes Punt return touchdown
PuntReturnLong integer 32 Yes Yes Longest punt return
KickReturnTouchdowns integer 32 Yes Yes Kick return touchdown
KickReturnLong integer 32 Yes Yes Longest kick return
BlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
BlockedKickReturnTouchdowns integer 32 Yes Yes Blocked kick recovery return touchdowns
FieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
FieldGoalReturnTouchdowns integer 32 Yes Yes Field goal return touchdowns (excluding blocked field goals)
PuntNetYards integer 32 Yes Yes Net punt yards
OpponentSoloTackles integer 32 Yes Yes Defensive solo tackles
OpponentAssistedTackles integer 32 Yes Yes Defensive assisted tackles
OpponentSacks integer 32 Yes Yes Defensive sacks
OpponentSackYards integer 32 Yes Yes Defensive sack yards
OpponentPassesDefended integer 32 Yes Yes Defensive passes defended
OpponentFumblesForced integer 32 Yes Yes Defensive fumbles forced
OpponentFumblesRecovered integer 32 Yes Yes Fumbles recovered that resulted in change of possession
OpponentFumbleReturnYards integer 32 Yes Yes Fumble return yards
OpponentFumbleReturnTouchdowns integer 32 Yes Yes Fumble return touchdowns
OpponentInterceptionReturnTouchdowns integer 32 Yes Yes Defensive interceptions
OpponentBlockedKicks integer 32 Yes Yes Total number of opponent's kicks that were blocked
OpponentPuntReturnTouchdowns integer 32 Yes Yes Punt return touchdown
OpponentPuntReturnLong integer 32 Yes Yes Longest punt return
OpponentKickReturnTouchdowns integer 32 Yes Yes Kick return touchdown
OpponentKickReturnLong integer 32 Yes Yes Longest kick return
OpponentBlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
OpponentBlockedKickReturnTouchdowns integer 32 Yes Yes Blocked kick recovery return touchdowns
OpponentFieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
OpponentFieldGoalReturnTouchdowns integer 32 Yes Yes Field goal return touchdowns (excluding blocked field goals)
OpponentPuntNetYards integer 32 Yes Yes Net punt yards
IsGameOver boolean Yes No Whether the game is over (true/false)
TeamName string 50 Yes No The full name of the team (e.g. New England Patriots)
DayOfWeek string 50 Yes No The day of the week this game was played on (e.g. Sunday, Monday)
PassingDropbacks integer 32 Yes Yes The number of times the offense dropped back to pass
OpponentPassingDropbacks integer 32 Yes Yes The number of times the opponent dropped back to pass
TeamGameID integer 32 No No The unique identifier for this TeamGame record (subject to change). For a static ID, use a combination of GameKey and Team.
TeamSeason  
Column Type Size Nullable Scrambled (?) Description
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL regular season for which these totals apply
Team string 50 Yes No The abbreviation of the Team
Score integer 32 No No Total points scored
OpponentScore integer 32 No No Total points scored by opponents
TotalScore integer 32 No No Total points scored by both teams
Temperature
from 2001
integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity
from 2001
integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed
from 2001
integer 32 Yes Yes Wind speed at game start (MPH)
OverUnder decimal 32 Yes No The average Over/Under for the season
PointSpread decimal 32 Yes No The average Point Spread for the season (from the perspective of the Team)
ScoreQuarter1 integer 32 Yes No Points scored during Quarter 1 for the Team
ScoreQuarter2 integer 32 Yes No Points scored during Quarter 2 for the Team
ScoreQuarter3 integer 32 Yes No Points scored during Quarter 3 for the Team
ScoreQuarter4 integer 32 Yes No Points scored during Quarter 4 for the Team
ScoreOvertime integer 32 No No Points scored during Overtime for the Team
TimeOfPossession string 50 Yes Yes Time of posession
FirstDowns integer 32 Yes Yes Total first downs
FirstDownsByRushing
from 2001
integer 32 Yes Yes Total rushing first downs
FirstDownsByPassing
from 2001
integer 32 Yes Yes Total passing first downs
FirstDownsByPenalty
from 2001
integer 32 Yes Yes Total first downs by opponent's penalty
OffensivePlays integer 32 No Yes Number of offensive plays run
OffensiveYards integer 32 No Yes Number of offensive yards gained
OffensiveYardsPerPlay decimal 32 No Yes Average yards gained per offensive play
Touchdowns
from 2001
integer 32 Yes Yes Touchdowns scored
RushingAttempts integer 32 Yes Yes Number of rushing attempts
RushingYards integer 32 Yes Yes Number of rushing yards
RushingYardsPerAttempt decimal 32 No Yes Average rushing yards gained per attempt
RushingTouchdowns
from 2001
integer 32 Yes Yes Rushing touchdowns scored
PassingAttempts integer 32 Yes Yes Number of passes thrown
PassingCompletions integer 32 Yes Yes Number of pass completions
PassingYards integer 32 Yes Yes Number of passing yards
PassingTouchdowns
from 2001
integer 32 Yes Yes Passing touchdowns scored
PassingInterceptions integer 32 Yes Yes Interceptions thrown
PassingYardsPerAttempt decimal 32 No Yes Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Yes Average passing yards gained per completion
CompletionPercentage decimal 32 No Yes Percentage of passes that were completed
PasserRating
from 2001
decimal 32 Yes Yes Passer rating
ThirdDownAttempts
from 2001
integer 32 Yes Yes Third down attempts
ThirdDownConversions
from 2001
integer 32 Yes Yes Third down conversions
ThirdDownPercentage
from 2001
decimal 32 Yes Yes Percentage of third downs converted
FourthDownAttempts
from 2001
integer 32 Yes Yes Fourth down attempts
FourthDownConversions
from 2001
integer 32 Yes Yes Fourth down conversions
FourthDownPercentage
from 2001
decimal 32 Yes Yes Percentage of fourth downs converted
RedZoneAttempts
from 2001
integer 32 Yes Yes Red zone opportunities
RedZoneConversions
from 2001
integer 32 Yes Yes Red zone opportunities converted to touchdowns
GoalToGoAttempts
from 2001
integer 32 Yes Yes 1st & Goal opportunities
GoalToGoConversions
from 2001
integer 32 Yes Yes 1st & Goal opportunities converted to touchdowns
ReturnYards integer 32 Yes Yes Total punt and defensive return yards
Penalties integer 32 Yes Yes Penalties committed
PenaltyYards integer 32 Yes Yes Penalty yards enforced against the Team
Fumbles integer 32 Yes Yes Fumbles
FumblesLost integer 32 Yes Yes Fumbles lost
TimesSacked integer 32 Yes Yes Number of sacks allowed by Team
TimesSackedYards integer 32 Yes Yes Number of yards lost as a result of sacks allowed
QuarterbackHits
from 2006
integer 32 Yes Yes Number of times the opposing QB was hit but not sacked
TacklesForLoss
from 2008
integer 32 Yes Yes Number of times the opponent was tackled for a loss
Safeties
from 2001
integer 32 Yes Yes Safeties scored
Punts integer 32 Yes Yes Number of punts
PuntYards integer 32 Yes Yes Total punt yards
PuntAverage decimal 32 No Yes Average number of yards per punt
Giveaways integer 32 No Yes Number of giveaways
Takeaways integer 32 No Yes Number of takeaways
TurnoverDifferential integer 32 No Yes Number of takeaways minus giveaways
OpponentScoreQuarter1 integer 32 Yes No Points scored during Quarter 1 for the Team
OpponentScoreQuarter2 integer 32 Yes No Points scored during Quarter 2 for the Team
OpponentScoreQuarter3 integer 32 Yes No Points scored during Quarter 3 for the Team
OpponentScoreQuarter4 integer 32 Yes No Points scored during Quarter 4 for the Team
OpponentScoreOvertime integer 32 No No Points scored during Overtime for the Team
OpponentTimeOfPossession string 50 Yes Yes Time of posession
OpponentFirstDowns integer 32 Yes Yes Total first downs
OpponentFirstDownsByRushing
from 2001
integer 32 Yes Yes Total rushing first downs
OpponentFirstDownsByPassing
from 2001
integer 32 Yes Yes Total passing first downs
OpponentFirstDownsByPenalty
from 2001
integer 32 Yes Yes Total first downs by opponent's penalty
OpponentOffensivePlays integer 32 No Yes Number of offensive plays run
OpponentOffensiveYards integer 32 No Yes Number of offensive yards gained
OpponentOffensiveYardsPerPlay decimal 32 No Yes Average yards gained per offensive play
OpponentTouchdowns
from 2001
integer 32 Yes Yes Touchdowns scored
OpponentRushingAttempts integer 32 Yes Yes Number of rushing attempts
OpponentRushingYards integer 32 Yes Yes Number of rushing yards
OpponentRushingYardsPerAttempt decimal 32 No Yes Average rushing yards gained per attempt
OpponentRushingTouchdowns
from 2001
integer 32 Yes Yes Rushing touchdowns scored
OpponentPassingAttempts integer 32 Yes Yes Number of passes thrown
OpponentPassingCompletions integer 32 Yes Yes Number of pass completions
OpponentPassingYards integer 32 Yes Yes Number of passing yards
OpponentPassingTouchdowns
from 2001
integer 32 Yes Yes Passing touchdowns scored
OpponentPassingInterceptions integer 32 Yes Yes Interceptions thrown
OpponentPassingYardsPerAttempt decimal 32 No Yes Average passing yards gained per attempt
OpponentPassingYardsPerCompletion decimal 32 No Yes Average passing yards gained per completion
OpponentCompletionPercentage decimal 32 No Yes Percentage of passes that were completed
OpponentPasserRating
from 2001
decimal 32 Yes Yes Passer rating
OpponentThirdDownAttempts
from 2001
integer 32 Yes Yes Third down attempts
OpponentThirdDownConversions
from 2001
integer 32 Yes Yes Third down conversions
OpponentThirdDownPercentage
from 2001
decimal 32 Yes Yes Percentage of third downs converted
OpponentFourthDownAttempts
from 2001
integer 32 Yes Yes Fourth down attempts
OpponentFourthDownConversions
from 2001
integer 32 Yes Yes Fourth down conversions
OpponentFourthDownPercentage
from 2001
decimal 32 Yes Yes Percentage of fourth downs converted
OpponentRedZoneAttempts
from 2001
integer 32 Yes Yes Red zone opportunities
OpponentRedZoneConversions
from 2001
integer 32 Yes Yes Red zone opportunities converted to touchdowns
OpponentGoalToGoAttempts
from 2001
integer 32 Yes Yes 1st & Goal opportunities
OpponentGoalToGoConversions
from 2001
integer 32 Yes Yes 1st & Goal opportunities converted to touchdowns
OpponentReturnYards integer 32 Yes Yes Total punt and defensive return yards
OpponentPenalties integer 32 Yes Yes Penalties committed
OpponentPenaltyYards integer 32 Yes Yes Penalty yards enforced against the away team
OpponentFumbles integer 32 Yes Yes Fumbles
OpponentFumblesLost integer 32 Yes Yes Fumbles lost
OpponentTimesSacked integer 32 Yes Yes Number of sacks allowed by Opponent
OpponentTimesSackedYards integer 32 Yes Yes Number of yards opponent lost as a result of being sacked
OpponentQuarterbackHits
from 2006
integer 32 Yes Yes Number of times the opposing QB was hit but not sacked
OpponentTacklesForLoss
from 2008
integer 32 Yes Yes Number of times our ball carrier was tackled for a loss
OpponentSafeties
from 2001
integer 32 Yes Yes Safeties scored
OpponentPunts integer 32 Yes Yes Number of punts
OpponentPuntYards integer 32 Yes Yes Total punt yards
OpponentPuntAverage decimal 32 No Yes Average number of yards per punt
OpponentGiveaways integer 32 No Yes Number of giveaways
OpponentTakeaways integer 32 No Yes Number of takeaways
OpponentTurnoverDifferential integer 32 No Yes Number of takeaways minus giveaways
RedZonePercentage
from 2012
decimal 32 Yes Yes Percentage of red zone opportunities converted into touchdowns
GoalToGoPercentage
from 2012
decimal 32 Yes Yes Percentage of goal-to-go opportunities converted into touchdowns
QuarterbackHitsDifferential
from 2012
integer 32 Yes Yes The differential of hits on the opposing quarterback minus hits on own team's quarterback
TacklesForLossDifferential
from 2012
integer 32 Yes Yes The differential of tackles for loss minus opponent's tackles for loss
QuarterbackSacksDifferential
from 2012
integer 32 No Yes The Team's sack differential (similar to a turnover differential)
TacklesForLossPercentage
from 2012
decimal 32 Yes Yes Percentage of running plays defended that resulted in tackle for loss
QuarterbackHitsPercentage
from 2012
decimal 32 Yes Yes Percantage of opposing quarterback drop backs that resulted hitting the quarterback
TimesSackedPercentage
from 2012
decimal 32 No No Percentage of drop backs that resulted in a sack
OpponentRedZonePercentage
from 2012
decimal 32 Yes Yes Percentage of opponent's red zone opportunities converted into touchdowns
OpponentGoalToGoPercentage
from 2012
decimal 32 Yes Yes Percentage of opponent's goal-to-go opportunities converted into touchdowns
OpponentQuarterbackHitsDifferential
from 2012
integer 32 Yes Yes The inverse of QuarterbackHitsDifferential
OpponentTacklesForLossDifferential
from 2012
integer 32 Yes Yes The inverse of TacklesForLossDifferential
OpponentQuarterbackSacksDifferential
from 2012
integer 32 Yes Yes The inverse of QuarterbackSacksDifferential
OpponentTacklesForLossPercentage
from 2012
decimal 32 Yes Yes Percentage of running plays defended that resulted in tackle for loss
OpponentQuarterbackHitsPercentage
from 2012
decimal 32 Yes Yes Percantage of own team's quarterback drop backs that resulted in our quarterback getting hit
OpponentTimesSackedPercentage
from 2012
decimal 32 No Yes Percentage of drop backs that resulted in a sack
Kickoffs
from 2012
integer 32 Yes Yes Number of kickoffs
KickoffsInEndZone
from 2012
integer 32 Yes Yes Number of kickoffs that went into the end zone
KickoffTouchbacks
from 2012
integer 32 Yes Yes Number of kickoffs that resulted in touchbacks
PuntsHadBlocked
from 2012
integer 32 Yes Yes Number of punts that were blocked
PuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
ExtraPointKickingAttempts
from 2012
integer 32 Yes Yes Extra point kick attempts
ExtraPointKickingConversions
from 2012
integer 32 Yes Yes Extra point kicks made
ExtraPointsHadBlocked
from 2012
integer 32 Yes Yes Extra point kick attempts that were blocked
ExtraPointPassingAttempts
from 2012
integer 32 Yes Yes Two point conversion passing attempts
ExtraPointPassingConversions
from 2012
integer 32 Yes Yes Two point conversion passing conversions
ExtraPointRushingAttempts
from 2012
integer 32 Yes Yes Two point conversion rushing attempts
ExtraPointRushingConversions
from 2012
integer 32 Yes Yes Two point conversion rushing conversions
FieldGoalAttempts
from 2012
integer 32 Yes Yes Field goal attempts
FieldGoalsMade
from 2012
integer 32 Yes Yes Field goals made
FieldGoalsHadBlocked
from 2012
integer 32 Yes Yes Field goal attempts that were blocked
PuntReturns
from 2012
integer 32 Yes Yes Punt returns
PuntReturnYards
from 2012
integer 32 Yes Yes Punt return yards
KickReturns
from 2012
integer 32 Yes Yes Kickoff returns
KickReturnYards
from 2012
integer 32 Yes Yes Kickoff return yards
InterceptionReturns
from 2012
integer 32 Yes Yes Defensive interceptions
InterceptionReturnYards
from 2012
integer 32 Yes Yes Interception return yards
OpponentKickoffs
from 2012
integer 32 Yes Yes Number of kickoffs
OpponentKickoffsInEndZone
from 2012
integer 32 Yes Yes Number of kickoffs that went into the end zone
OpponentKickoffTouchbacks
from 2012
integer 32 Yes Yes Number of kickoffs that resulted in touchbacks
OpponentPuntsHadBlocked
from 2012
integer 32 Yes Yes Number of punts that were blocked
OpponentPuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
OpponentExtraPointKickingAttempts
from 2012
integer 32 Yes Yes Extra point kick attempts
OpponentExtraPointKickingConversions
from 2012
integer 32 Yes Yes Extra point kicks made
OpponentExtraPointsHadBlocked
from 2012
integer 32 Yes Yes Extra point kick attempts that were blocked
OpponentExtraPointPassingAttempts
from 2012
integer 32 Yes Yes Two point conversion passing attempts
OpponentExtraPointPassingConversions
from 2012
integer 32 Yes Yes Two point conversion passing conversions
OpponentExtraPointRushingAttempts
from 2012
integer 32 Yes Yes Two point conversion rushing attempts
OpponentExtraPointRushingConversions
from 2012
integer 32 Yes Yes Two point conversion rushing conversions
OpponentFieldGoalAttempts
from 2012
integer 32 Yes Yes Field goal attempts
OpponentFieldGoalsMade
from 2012
integer 32 Yes Yes Field goals made
OpponentFieldGoalsHadBlocked
from 2012
integer 32 Yes Yes Field goal attempts that were blocked
OpponentPuntReturns
from 2012
integer 32 Yes Yes Punt returns
OpponentPuntReturnYards
from 2012
integer 32 Yes Yes Punt return yards
OpponentKickReturns
from 2012
integer 32 Yes Yes Kickoff returns
OpponentKickReturnYards
from 2012
integer 32 Yes Yes Kickoff return yards
OpponentInterceptionReturns
from 2012
integer 32 Yes Yes Defensive interceptions
OpponentInterceptionReturnYards
from 2012
integer 32 Yes Yes Interception return yards
SoloTackles integer 32 Yes Yes Defensive solo tackles
AssistedTackles integer 32 Yes Yes Defensive assisted tackles
Sacks integer 32 Yes Yes Defensive sacks
SackYards integer 32 Yes Yes Defensive sack yards
PassesDefended integer 32 Yes Yes Defensive passes defended
FumblesForced integer 32 Yes Yes Defensive fumbles forced
FumblesRecovered integer 32 Yes Yes Fumbles recovered that resulted in change of possession
FumbleReturnYards integer 32 Yes Yes Fumble return yards
FumbleReturnTouchdowns integer 32 Yes Yes Fumble return touchdowns
InterceptionReturnTouchdowns integer 32 Yes Yes Defensive interceptions
BlockedKicks integer 32 Yes Yes Total number of opponent's kicks that were blocked
PuntReturnTouchdowns integer 32 Yes Yes Punt return touchdown
PuntReturnLong integer 32 Yes Yes Longest punt return
KickReturnTouchdowns integer 32 Yes Yes Kick return touchdown
KickReturnLong integer 32 Yes Yes Longest kick return
BlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
BlockedKickReturnTouchdowns integer 32 Yes Yes Blocked kick recovery return touchdowns
FieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
FieldGoalReturnTouchdowns integer 32 Yes Yes Field goal return touchdowns (excluding blocked field goals)
PuntNetYards integer 32 Yes Yes Net punt yards
OpponentSoloTackles integer 32 Yes Yes Defensive solo tackles
OpponentAssistedTackles integer 32 Yes Yes Defensive assisted tackles
OpponentSacks integer 32 Yes Yes Defensive sacks
OpponentSackYards integer 32 Yes Yes Defensive sack yards
OpponentPassesDefended integer 32 Yes Yes Defensive passes defended
OpponentFumblesForced integer 32 Yes Yes Defensive fumbles forced
OpponentFumblesRecovered integer 32 Yes Yes Fumbles recovered that resulted in change of possession
OpponentFumbleReturnYards integer 32 Yes Yes Fumble return yards
OpponentFumbleReturnTouchdowns integer 32 Yes Yes Fumble return touchdowns
OpponentInterceptionReturnTouchdowns integer 32 Yes Yes Defensive interceptions
OpponentBlockedKicks integer 32 Yes Yes Total number of opponent's kicks that were blocked
OpponentPuntReturnTouchdowns integer 32 Yes Yes Punt return touchdown
OpponentPuntReturnLong integer 32 Yes Yes Longest punt return
OpponentKickReturnTouchdowns integer 32 Yes Yes Kick return touchdown
OpponentKickReturnLong integer 32 Yes Yes Longest kick return
OpponentBlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
OpponentBlockedKickReturnTouchdowns integer 32 Yes Yes Blocked kick recovery return touchdowns
OpponentFieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
OpponentFieldGoalReturnTouchdowns integer 32 Yes Yes Field goal return touchdowns (excluding blocked field goals)
OpponentPuntNetYards integer 32 Yes Yes Net punt yards
TeamName string 50 Yes No The full name of the team (e.g. New England Patriots)
Games integer 32 Yes No Total number of regular season games played
PassingDropbacks integer 32 Yes Yes The number of times the offense dropped back to pass
OpponentPassingDropbacks integer 32 Yes Yes The number of times the opponent dropped back to pass
TeamSeasonID integer 32 No No The unique identifier for this TeamSeason record (subject to change). For a static ID, use a combination of SeasonType, Season and Team.
Standing  
Column Type Size Nullable Scrambled (?) Description
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL regular season for which these totals apply
Conference string 50 Yes No The conference of the team (e.g. AFC or NFC)
Division string 50 Yes No The division of the team (e.g. East, North, South, West)
Team string 50 Yes No The abbreviation of the Team
Name string 50 Yes No The full name of the team
Wins integer 32 No No Regular season wins
Losses integer 32 No No Regular season losses
Ties integer 32 No No Regular season ties
Percentage decimal 32 No Yes Winning percentage
PointsFor integer 32 No Yes Points scored during regular season games
PointsAgainst integer 32 No Yes Points allowed during regular season games
NetPoints integer 32 No No Difference between PointsFor and PointsAgainst
Touchdowns integer 32 Yes Yes Total touchdowns scored
DivisionWins integer 32 No No Regular season wins within the division
DivisionLosses integer 32 No No Regular season losses within the division
ConferenceWins integer 32 No No Regular season wins within the conference
ConferenceLosses integer 32 No No Regular season losses within the conference
FantasyPlayer  
Column Type Size Nullable Scrambled (?) Description
FantasyPlayerKey string 10 No No Unique identifier of this fantasy player. If this is a team defense, then this is the abbreviation of the team. This field contains both integers and strings and should be treated as a string. This value is guaranteed to be unique among all players and teams and can be used as the primary key for the FantasyPlayer table.
PlayerID integer 32 No No PlayerID of this FantasyPlayer. For players, this is the same as the PlayerID. For teams, this is the uniquely generated PlayerID on the Team table. This number is guaranteed to be unique among all players and teams and can be used as the primary key for the FantasyPlayer table.
Name string 50 No No The name of the player or team.
Team string 10 Yes No The abbreviation of the team this player is on. If player is a free agent, this field is NULL.
Position string 10 No No The fantasy position of this player or team (QB, RB, WR, TE, K, DEF)
AverageDraftPosition decimal 32 Yes No The average draft position of this player in re-draft leagues.
AverageDraftPositionPPR decimal 32 Yes No The average draft position of this player in PPR re-draft leagues.
ByeWeek integer 32 Yes No The bye week of the team this player is currently on.
LastSeasonFantasyPoints decimal 32 Yes No The fantasy points scored by this player or team last season.
ProjectedFantasyPoints decimal 32 Yes No The projected fantasy points this player will score this upcoming season.
Player  
Column Type Size Nullable Scrambled (?) Description
PlayerID integer 32 No No Unique ID assigned to each player that stays with them throughout their career
Team string 10 Yes No The abbreviation of the team this player is employed by, or if currently unemployed, the most recent team this player was employed by.
Number integer 32 Yes No Player's jersey number
FirstName string 50 Yes No Player's first name
LastName string 50 Yes No Player's last name
Position string 10 Yes No Player's most commonly played position
Status string 50 Yes No The player's current status. Possible values include Active, Inactive, Injured Reserve, Physically Unable to Perform, Practice Squad, Suspended and Non Football Injury. Inactive indicates that this player is a free agent. Active indicates that this player is on his team's active roster.
Height string 50 Yes No Height in feet, inches
Weight string 50 Yes Yes Weight in pounds
BirthDate datetime Yes No Date of birth
College string 50 Yes No College
Experience integer 32 Yes Yes Number of years experience. This number is incremented every year, in the Spring, when we load the rookies following the NFL Draft. Rookies will have Experience = Zero, while second year players will have Experience = 2.
FantasyPosition string 10 Yes Yes The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB)
Active boolean Yes No Whether the player is currently under contract with an NFL team
PositionCategory string 3 Yes No The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST)
Name string 50 Yes No Full name of the player (Cam Newton, Aaron Rodgers, etc.)
Age integer 32 Yes No The player's current age
ExperienceString string 50 Yes No The player's experience converted to a string
BirthDateString string 50 Yes No The player's date of birth converted to a string
PhotoUrl string 250 Yes No The url of the player's photo hosted on FantasyData.com (http://static.fantasydata.com/images/nfl/player/2593.jpg)
ByeWeek integer 32 Yes No The week the player is on Bye for the upcoming or current season
UpcomingGameOpponent string 50 Yes No The opponent the player is playing in the upcoming week
UpcomingGameWeek integer 32 No No The week of the player's upcoming game (this will be the upcoming week unless the player is on Bye that week, which would bump it to the next week)
ShortName string 50 Yes No A shortened version of the player's full name (C.Newton, A.Rodgers)
AverageDraftPosition decimal 32 Yes Yes The average draft position of the player for the upcoming season's fantasy football draft
DepthPositionCategory
from 2012
string 3 Yes No The category (Offense, Defense or Special Teams) of the players DepthPositionCategory (OFF, DEF, ST)
DepthPosition
from 2012
string 10 Yes No The position this player is listed at on his team's depth chart (e.g. QB, LWR, RDE, LILB)
DepthOrder
from 2012
integer 32 Yes Yes The order this player is at his position (1 = Starter, 2 = Backup, 3 = 3rd String)
DepthDisplayOrder
from 2012
integer 32 Yes No The display order of the positions (for display purposes)
CurrentTeam
from 2013
string 10 Yes No The team who currently employs this player. This value is null when this player is unemployed.
CollegeDraftTeam
from 2013
string 10 Yes No The team who drafted this player. If this player was an Undrafted Free Agent, then it's the team who first signed him as a rookie.
CollegeDraftYear
from 2013
integer 32 Yes No The year this player entered the NFL as rookie.
CollegeDraftRound
from 2013
integer 32 Yes Yes The round this player was drafted in.
CollegeDraftPick
from 2013
integer 32 Yes Yes The overall pick in the draft this player was selected.
IsUndraftedFreeAgent
from 2013
boolean No No Whether this player was an undrafted free agent. This value is True if the player was drafted.
HeightFeet integer 32 Yes No The feet component of a player's height (if player is 6'3", then this value would be 6)
HeightInches integer 32 Yes No The inches component of a player's height (if player is 6'3", then this value would be 3)
UpcomingOpponentRank integer 32 Yes No The player's upcoming opponent's rank in fantasy points allowed.
UpcomingOpponentPositionRank integer 32 Yes No The player's upcoming opponent's rank in fantasy points allowed to his fantasy position.
CurrentStatus string 50 Yes No The player's current status, aggregated from Status (Active, Suspended, Injured Reserve, etc) and Injury Status (Probably, Questionable, etc)
UpcomingSalary integer 32 Yes No The player's salary for the upcoming week in accordance with a $60,000 salary cap. This is used for daily fantasy sports salary cap contests. Salaries are currently those published by FanDuel.
FreeAgent  
Column Type Size Nullable Scrambled (?) Description
PlayerID integer 32 No No Unique ID assigned to each player that stays with them throughout their career
Team string 10 Yes No The abbreviation of the team this player is employed by, or if currently unemployed, the most recent team this player was employed by.
Number integer 32 Yes No Player's jersey number
FirstName string 50 Yes No Player's first name
LastName string 50 Yes No Player's last name
Position string 10 Yes No Player's most commonly played position
Status string 50 Yes No The player's current status. Possible values include Active, Inactive, Injured Reserve, Physically Unable to Perform, Practice Squad, Suspended and Non Football Injury. Inactive indicates that this player is a free agent. Active indicates that this player is on his team's active roster.
Height string 50 Yes No Height in feet, inches
Weight string 50 Yes Yes Weight in pounds
BirthDate datetime Yes No Date of birth
College string 50 Yes No College
Experience integer 32 Yes Yes Number of years experience. This number is incremented every year, in the Spring, when we load the rookies following the NFL Draft. Rookies will have Experience = Zero, while second year players will have Experience = 2.
FantasyPosition string 10 Yes Yes The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB)
Active boolean Yes No Whether the player is currently under contract with an NFL team
PositionCategory string 3 Yes No The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST)
Name string 50 Yes No Full name of the player (Cam Newton, Aaron Rodgers, etc.)
Age integer 32 Yes No The player's current age
ExperienceString string 50 Yes No The player's experience converted to a string
BirthDateString string 50 Yes No The player's date of birth converted to a string
PhotoUrl string 250 Yes No The url of the player's photo hosted on FantasyData.com (http://static.fantasydata.com/images/nfl/player/2593.jpg)
ByeWeek integer 32 Yes No The week the player is on Bye for the upcoming or current season
UpcomingGameOpponent string 50 Yes No The opponent the player is playing in the upcoming week
UpcomingGameWeek integer 32 No No The week of the player's upcoming game (this will be the upcoming week unless the player is on Bye that week, which would bump it to the next week)
ShortName string 50 Yes No A shortened version of the player's full name (C.Newton, A.Rodgers)
AverageDraftPosition decimal 32 Yes Yes The average draft position of the player for the upcoming season's fantasy football draft
DepthPositionCategory
from 2012
string 3 Yes No The category (Offense, Defense or Special Teams) of the players DepthPositionCategory (OFF, DEF, ST)
DepthPosition
from 2012
string 10 Yes No The position this player is listed at on his team's depth chart (e.g. QB, LWR, RDE, LILB)
DepthOrder
from 2012
integer 32 Yes Yes The order this player is at his position (1 = Starter, 2 = Backup, 3 = 3rd String)
DepthDisplayOrder
from 2012
integer 32 Yes No The display order of the positions (for display purposes)
CurrentTeam
from 2013
string 10 Yes No The team who currently employs this player. This value is null when this player is unemployed.
CollegeDraftTeam
from 2013
string 10 Yes No The team who drafted this player. If this player was an Undrafted Free Agent, then it's the team who first signed him as a rookie.
CollegeDraftYear
from 2013
integer 32 Yes No The year this player entered the NFL as rookie.
CollegeDraftRound
from 2013
integer 32 Yes Yes The round this player was drafted in.
CollegeDraftPick
from 2013
integer 32 Yes Yes The overall pick in the draft this player was selected.
IsUndraftedFreeAgent
from 2013
boolean No No Whether this player was an undrafted free agent. This value is True if the player was drafted.
HeightFeet integer 32 Yes No The feet component of a player's height (if player is 6'3", then this value would be 6)
HeightInches integer 32 Yes No The inches component of a player's height (if player is 6'3", then this value would be 3)
Injury   (from 2011)
Column Type Size Nullable Scrambled (?) Description
InjuryID integer 32 No No Unique ID of the injury status
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The season of the game that this injury leads up to
Week integer 32 No No The week of the game that this injury leads up to
PlayerID integer 32 No No The PlayerID of the injured player
Name string 50 Yes No The full name of the injured player
Position string 50 Yes No The position of the injured player
Number integer 32 No No The jersey number of the injured player
Team string 50 Yes No The team the injured player is on
Opponent string 50 Yes No The upcoming opponent of the injured player
BodyPart string 50 Yes No The body part that is injured (Knee, Groin, Calf, Hamstring, etc.)
Status string 50 Yes No Likelihood that player plays (Probably, Questionable, Doubtful, Out)
Practice string 50 Yes No Whether the player participated in practice (None, Limited, Full)
PracticeDescription string 50 Yes No Full description of whether the player participated in practice)
Updated datetime No No The date/time the injury status was updated
DeclaredInactive boolean Yes No Whether the player has been declared inactive. This value is updated in the hours leading up to game start time, as teams announce their inactive players. This is only updated for offensive skill position players (QB, RB, WR, TE)
PlayerGame  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
PlayerID integer 32 Yes No Unique ID assigned to each player that stays with them throughout their career
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL season of the game
GameDate datetime No No The date/time of the game
Week integer 32 No No The NFL week of the game (weeks 18-21 denote playoff games)
Team string 50 Yes No The abbreviation of the Team
Opponent string 50 Yes No The abbreviation of the Opponent
HomeOrAway string 50 Yes No Whether the player is Home or Away
Number integer 32 No No Player's jersey number
Name string 50 Yes No Player's name
Position string 50 Yes No Player's position in the starting lineup (if started), otherwise the position he substituted for
PositionCategory string 50 Yes No Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST)
Activated integer 32 No No Whether the player was Active at gametime
Played integer 32 No No Whether the player played in at least one play
Started integer 32 No No Whether the player started on offense or defense
PassingAttempts integer 32 No Yes Number of passes thrown
PassingCompletions integer 32 No Yes Number of pass completions
PassingYards integer 32 No Yes Number of passing yards
PassingCompletionPercentage decimal 32 No Yes Percentage of passes that were completed
PassingYardsPerAttempt decimal 32 No Yes Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Yes Average passing yards gained per completion
PassingTouchdowns integer 32 No Yes Passing touchdowns scored
PassingInterceptions integer 32 No Yes Interceptions thrown
PassingRating decimal 32 No Yes Passer rating
PassingLong integer 32 No Yes Longest completion
PassingSacks integer 32 No Yes Number of times sacked
PassingSackYards integer 32 No Yes Yards lost as a result of being sacked
RushingAttempts integer 32 No Yes Number of rushing attempts
RushingYards integer 32 No Yes Number of rushing yards
RushingYardsPerAttempt decimal 32 No Yes Average rushing yards gained per attempt
RushingTouchdowns integer 32 No Yes Rushing touchdowns scored
RushingLong integer 32 No Yes Longest rush
ReceivingTargets
from 2009
integer 32 Yes Yes Number of times targeted by passer
Receptions integer 32 No Yes Number of receptions
ReceivingYards integer 32 No Yes Total receiving yards
ReceivingYardsPerReception decimal 32 No Yes Average yards gained per reception
ReceivingTouchdowns integer 32 No Yes Receiving touchdowns
ReceivingLong integer 32 No Yes Longest reception
Fumbles integer 32 No Yes Times fumbled
FumblesLost
from 2003
integer 32 Yes Yes Number of fumbles recovered by opponent
PuntReturns integer 32 No Yes Number of punt return attempts
PuntReturnYards integer 32 No Yes Total return yards on punts
PuntReturnYardsPerAttempt decimal 32 No Yes Average yards gained per punt return
PuntReturnTouchdowns integer 32 No Yes Number of touchdowns on punt returns
PuntReturnLong integer 32 No Yes Longest punt return
KickReturns integer 32 No Yes Number of kick return attempts
KickReturnYards integer 32 No Yes Total return yards on kicks
KickReturnYardsPerAttempt decimal 32 No Yes Average yards gained per kick return
KickReturnTouchdowns integer 32 No Yes Number of touchdowns on kick returns
KickReturnLong integer 32 No Yes Longest kick return
SoloTackles integer 32 No Yes Solo, unassisted tackles
AssistedTackles integer 32 No Yes Assisted tackles (also called a half tackle)
TacklesForLoss
from 2008
integer 32 Yes Yes Tackles behind the opponent's line of scrimmage
Sacks decimal 32 No Yes Sacks of the opposing quarterback
SackYards integer 32 No Yes Yards lost as a result of sacking the opposing quarterback
QuarterbackHits
from 2006
integer 32 Yes Yes Number of times hitting an opposing quarterback without sacking him
PassesDefended integer 32 No Yes Passes defended or batted down
FumblesForced integer 32 No Yes Number of fumbles forced
FumblesRecovered integer 32 No Yes Number of fumbles recovered
FumbleReturnYards integer 32 No Yes Return yards from fumble recoveries
FumbleReturnTouchdowns integer 32 No Yes Return touchdowns from fumble recoveries
Interceptions integer 32 No Yes Number of interceptions
InterceptionReturnYards integer 32 No Yes Return yards from interceptions
InterceptionReturnTouchdowns integer 32 No Yes Return touchdowns from interceptions
BlockedKicks integer 32 No Yes Total nmber of field goals and punts blocked
SpecialTeamsSoloTackles integer 32 No Yes Solo tackles on kick and punt plays
SpecialTeamsAssistedTackles integer 32 No Yes Assisted tackles on kick and punt plays
MiscSoloTackles integer 32 No Yes Solo tackles when playing offense (after a turnover)
MiscAssistedTackles integer 32 No Yes Assisted tackles when playing offense (after a turnover)
Punts integer 32 No Yes Number of punts
PuntYards integer 32 No Yes Total number of punt yards
PuntAverage decimal 32 No Yes Average yards per punt
FieldGoalsAttempted integer 32 No Yes Number of field goal attempts
FieldGoalsMade integer 32 No Yes Number of successful field goal attempts
FieldGoalsLongestMade integer 32 No Yes Longest successful field goal attempt
ExtraPointsMade integer 32 No Yes Number of successful extra points
TwoPointConversionPasses integer 32 No Yes Successful two point conversion passes
TwoPointConversionRuns integer 32 No Yes Successful two point conversion runs
TwoPointConversionReceptions integer 32 No Yes Successful two point conversion receptions
FantasyPoints
from 2012
decimal 32 No Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
FantasyPointsPPR decimal 32 No Yes Fantasy points scored based on basic PPR fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
ReceptionPercentage
from 2012
decimal 32 No Yes Percentage of ReceivingTargets convert into Receptions
ReceivingYardsPerTarget
from 2012
decimal 32 No Yes Average yards gained per ReceivingTargets
Tackles
from 2012
integer 32 No Yes Sum of SoloTackles and AssistedTackles
OffensiveTouchdowns
from 2012
integer 32 No Yes Offensive touchdowns scored
DefensiveTouchdowns
from 2012
integer 32 No Yes Defensive touchdowns scored
SpecialTeamsTouchdowns
from 2012
integer 32 No Yes Special teams touchdowns scored
Touchdowns
from 2012
integer 32 No Yes Total touchdowns scored
FantasyPosition
from 2012
string 50 Yes Yes The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB)
FieldGoalPercentage
from 2012
decimal 32 No Yes Percentage of Field Goal attempts that we successful
PlayerGameID
from 2012
integer 32 No No Unique ID of PlayerGame record (subject to change). For a static ID, use a combination of GameKey and PlayerID.
FumblesOwnRecoveries
from 2012
integer 32 Yes Yes Own team's fumbles recovered (did not result in a turnover)
FumblesOutOfBounds
from 2012
integer 32 Yes Yes Fumbles by this player that went out of bounds (no one was awarded the recovery)
KickReturnFairCatches
from 2012
integer 32 Yes Yes Fair catches made on kickoffs
PuntReturnFairCatches
from 2012
integer 32 Yes Yes Fair catches made on punts
PuntTouchbacks
from 2012
integer 32 Yes Yes Punts by this player that were touchbacks
PuntInside20
from 2012
integer 32 Yes Yes Punts by this player that were downed inside the 20 yard line
PuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
ExtraPointsAttempted
from 2012
integer 32 Yes Yes Extra point kicks attempted
BlockedKickReturnTouchdowns
from 2012
integer 32 Yes Yes Blocked kicks that this player returned for touchdowns
FieldGoalReturnTouchdowns
from 2012
integer 32 Yes Yes Field goals that this player returned for touchdowns
Safeties integer 32 Yes Yes Defensive safeties (sacks in end zone, solo tackles in end zone, blocked kicks that went out of bounds in the end zone)
FieldGoalsHadBlocked integer 32 Yes Yes Field goal attempts that were blocked
PuntsHadBlocked integer 32 Yes Yes Punts that were blocked
ExtraPointsHadBlocked integer 32 Yes Yes Extra points that were blocked
PuntLong integer 32 Yes Yes Longest punt
BlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
PuntNetYards integer 32 Yes Yes Net punt yards
SpecialTeamsFumblesForced integer 32 Yes Yes Fumbles forced on special teams plays
SpecialTeamsFumblesRecovered integer 32 Yes Yes Fumbles recovered on special teams plays
MiscFumblesForced integer 32 Yes Yes Fumbles forced after a turnover on offensive plays
MiscFumblesRecovered integer 32 Yes Yes Fumbles recovered after a turnover on offensive plays
ShortName string 50 Yes No Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning)
PlayingSurface string 50 Yes No Playing surface of the stadium
IsGameOver boolean Yes No Whether the game is over (true/false)
SafetiesAllowed integer 32 Yes Yes Safeties allowed (tackled in end zone, sacked in end zone, ran out of bounds in end zone, or committed a penalty in end zone, e.g. Intentional Grounding or Offensive Holding)
Stadium string 50 Yes No Stadium of the event
Temperature integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Yes Wind speed at game start (MPH)
FanDuelSalary integer 32 Yes No The player's salary for FanDuel daily fantasy contests.
DraftKingsSalary integer 32 Yes No The player's salary for DraftKings daily fantasy contests.
FantasyDataSalary integer 32 Yes No The player's salary as calculated by FantasyData. Based on the same salary cap as FanDuel contests ($60,000).
PlayerSeason  
Column Type Size Nullable Scrambled (?) Description
PlayerID integer 32 Yes No Unique ID assigned to each player that stays with them throughout their career
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL regular season for which these totals apply
Team string 50 Yes No The abbreviation of the Team
Number integer 32 No No Player's jersey number
Name string 50 Yes No Player's name
Position string 50 Yes No Player's position in the starting lineup (if started), otherwise the position he substituted for
PositionCategory string 50 Yes No Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST)
Activated integer 32 No No Number of games player was Active on gameday
Played integer 32 No No Number of games played in
Started integer 32 No No Number of games started
PassingAttempts integer 32 No Yes Number of passes thrown
PassingCompletions integer 32 No Yes Number of pass completions
PassingYards integer 32 No Yes Number of passing yards
PassingCompletionPercentage decimal 32 No Yes Percentage of passes that were completed
PassingYardsPerAttempt decimal 32 No Yes Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Yes Average passing yards gained per completion
PassingTouchdowns integer 32 No Yes Passing touchdowns scored
PassingInterceptions integer 32 No Yes Interceptions thrown
PassingRating decimal 32 No Yes Passer rating
PassingLong integer 32 No Yes Longest completion
PassingSacks integer 32 No Yes Number of times sacked
PassingSackYards integer 32 No Yes Yards lost as a result of being sacked
RushingAttempts integer 32 No Yes Number of rushing attempts
RushingYards integer 32 No Yes Number of rushing yards
RushingYardsPerAttempt decimal 32 No Yes Average rushing yards gained per attempt
RushingTouchdowns integer 32 No Yes Rushing touchdowns scored
RushingLong integer 32 No Yes Longest rush
ReceivingTargets
from 2009
integer 32 Yes Yes Number of times targeted by passer
Receptions integer 32 No Yes Number of receptions
ReceivingYards integer 32 No Yes Total receiving yards
ReceivingYardsPerReception decimal 32 No Yes Average yards gained per reception
ReceivingTouchdowns integer 32 No Yes Receiving touchdowns
ReceivingLong integer 32 No Yes Longest reception
Fumbles integer 32 No Yes Times fumbled
FumblesLost
from 2003
integer 32 Yes Yes Number of fumbles recovered by opponent
PuntReturns integer 32 No Yes Number of punt return attempts
PuntReturnYards integer 32 No Yes Total return yards on punts
PuntReturnYardsPerAttempt decimal 32 No Yes Average yards gained per punt return
PuntReturnTouchdowns integer 32 No Yes Number of touchdowns on punt returns
PuntReturnLong integer 32 No Yes Longest punt return
KickReturns integer 32 No Yes Number of kick return attempts
KickReturnYards integer 32 No Yes Total return yards on kicks
KickReturnYardsPerAttempt decimal 32 No Yes Average yards gained per kick return
KickReturnTouchdowns integer 32 No Yes Number of touchdowns on kick returns
KickReturnLong integer 32 No Yes Longest kick return
SoloTackles integer 32 No Yes Solo, unassisted tackles
AssistedTackles integer 32 No Yes Assisted tackles (also called a half tackle)
TacklesForLoss
from 2008
integer 32 Yes Yes Tackles behind the opponent's line of scrimmage
Sacks decimal 32 No Yes Sacks of the opposing quarterback
SackYards integer 32 No Yes Yards lost as a result of sacking the opposing quarterback
QuarterbackHits
from 2006
integer 32 Yes Yes Number of times hitting an opposing quarterback without sacking him
PassesDefended integer 32 No Yes Passes defended or batted down
FumblesForced integer 32 No Yes Number of fumbles forced
FumblesRecovered integer 32 No Yes Number of fumbles recovered
FumbleReturnYards integer 32 No Yes Return yards from fumble recoveries
FumbleReturnTouchdowns integer 32 No Yes Return touchdowns from fumble recoveries
Interceptions integer 32 No Yes Number of interceptions
InterceptionReturnYards integer 32 No Yes Return yards from interceptions
InterceptionReturnTouchdowns integer 32 No Yes Return touchdowns from interceptions
BlockedKicks integer 32 No Yes Total nmber of field goals and punts blocked
SpecialTeamsSoloTackles integer 32 No Yes Solo tackles on kick and punt plays
SpecialTeamsAssistedTackles integer 32 No Yes Assisted tackles on kick and punt plays
MiscSoloTackles integer 32 No Yes Solo tackles when playing offense (after a turnover)
MiscAssistedTackles integer 32 No Yes Assisted tackles when playing offense (after a turnover)
Punts integer 32 No Yes Number of punts
PuntYards integer 32 No Yes Total number of punt yards
PuntAverage decimal 32 No Yes Average yards per punt
FieldGoalsAttempted integer 32 No Yes Number of field goal attempts
FieldGoalsMade integer 32 No Yes Number of successful field goal attempts
FieldGoalsLongestMade integer 32 No Yes Longest successful field goal attempt
ExtraPointsMade integer 32 No Yes Number of successful extra points
TwoPointConversionPasses integer 32 No Yes Successful two point conversion passes
TwoPointConversionRuns integer 32 No Yes Successful two point conversion runs
TwoPointConversionReceptions integer 32 No Yes Successful two point conversion receptions
FantasyPoints
from 2012
decimal 32 No Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
FantasyPointsPPR decimal 32 No Yes Fantasy points scored based on basic PPR fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
ReceptionPercentage
from 2012
decimal 32 No Yes Percentage of ReceivingTargets convert into Receptions
ReceivingYardsPerTarget
from 2012
decimal 32 No Yes Average yards gained per ReceivingTargets
Tackles
from 2012
integer 32 No Yes Sum of SoloTackles and AssistedTackles
OffensiveTouchdowns
from 2012
integer 32 No Yes Offensive touchdowns scored
DefensiveTouchdowns
from 2012
integer 32 No Yes Defensive touchdowns scored
SpecialTeamsTouchdowns
from 2012
integer 32 No Yes Special teams touchdowns scored
Touchdowns
from 2012
integer 32 No Yes Total touchdowns scored
FantasyPosition
from 2012
string 50 Yes Yes The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB)
FieldGoalPercentage
from 2012
decimal 32 No Yes Percentage of Field Goal attempts that we successful
PlayerSeasonID
from 2012
integer 32 No No Unique ID of PlayerSeason record (subject to change). For a static ID, use a combination of SeasonType, Season and PlayerID.
FumblesOwnRecoveries
from 2012
integer 32 Yes Yes Own team's fumbles recovered (did not result in a turnover)
FumblesOutOfBounds
from 2012
integer 32 Yes Yes Fumbles by this player that went out of bounds (no one was awarded the recovery)
KickReturnFairCatches
from 2012
integer 32 Yes Yes Fair catches made on kickoffs
PuntReturnFairCatches
from 2012
integer 32 Yes Yes Fair catches made on punts
PuntTouchbacks
from 2012
integer 32 Yes Yes Punts by this player that were touchbacks
PuntInside20
from 2012
integer 32 Yes Yes Punts by this player that were downed inside the 20 yard line
PuntNetAverage
from 2012
decimal 32 Yes Yes Net punt average (includes punt return yards as negative)
ExtraPointsAttempted
from 2012
integer 32 Yes Yes Extra point kicks attempted
BlockedKickReturnTouchdowns
from 2012
integer 32 Yes Yes Blocked kicks that this player returned for touchdowns
FieldGoalReturnTouchdowns
from 2012
integer 32 Yes Yes Field goals that this player returned for touchdowns
Safeties integer 32 Yes Yes Defensive safeties (sacks in end zone, solo tackles in end zone, blocked kicks that went out of bounds in the end zone)
FieldGoalsHadBlocked integer 32 Yes Yes Field goal attempts that were blocked
PuntsHadBlocked integer 32 Yes Yes Punts that were blocked
ExtraPointsHadBlocked integer 32 Yes Yes Extra points that were blocked
PuntLong integer 32 Yes Yes Longest punt
BlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
PuntNetYards integer 32 Yes Yes Net punt yards
SpecialTeamsFumblesForced integer 32 Yes Yes Fumbles forced on special teams plays
SpecialTeamsFumblesRecovered integer 32 Yes Yes Fumbles recovered on special teams plays
MiscFumblesForced integer 32 Yes Yes Fumbles forced after a turnover on offensive plays
MiscFumblesRecovered integer 32 Yes Yes Fumbles recovered after a turnover on offensive plays
ShortName string 50 Yes No Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning)
SafetiesAllowed integer 32 Yes Yes Safeties allowed (tackled in end zone, sacked in end zone, ran out of bounds in end zone, or committed a penalty in end zone, e.g. Intentional Grounding or Offensive Holding)
Temperature integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Yes Wind speed at game start (MPH)
ScoringPlay  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
ScoringPlayID integer 32 No No Unique id of the scoring play
Season integer 32 No No The NFL season of the game
Week integer 32 No No The NFL week of the game (weeks 18-21 denote playoff games)
AwayTeam string 10 No No The abbreviation of the away team
HomeTeam string 10 No No The abbreviation of the home team
Date datetime Yes No The date/time of the game
Sequence integer 32 Yes No The order in which the scoring play happened
Team string 10 Yes No The abbreviation of the team that scored
Quarter string 10 Yes No The quarter that the score occurred in
TimeRemaining string 10 Yes No The time remaining in the quarter when the score occurred
PlayDescription string 500 Yes No The detailed description of the play for display purposes
AwayScore integer 32 Yes No The away team's score as a result of the scoring play (includes point after)
HomeScore integer 32 Yes No The home team's score as a result of the scoring play (includes point after)
ScoringDetail  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
PlayerID integer 32 Yes No PlayerID of the player who scored
Team string 50 Yes No The team who the player played for
Season integer 32 No No The season during which the score happened
Week integer 32 No No The week during which the score happened
ScoringType string 50 Yes No The type of scoring play (e.g. BlockedFieldGoalReturnTouchdown, BlockedPuntReturnTouchdown, FieldGoalMade, FieldGoalMissed, FieldGoalReturnTouchdown, FumbleReturnTouchdown, InterceptionReturnTouchdown, KickoffReturnTouchdown, PassingTouchdown, PuntReturnTouchdown, ReceivingTouchdown, RushingTouchdown, Safety)
Length integer 32 No Yes The length in yards of the score
ScoringDetailID integer 32 No No Unique identifier of this scoring detail
PlayerGameID integer 32 No No PlayerGameID of the game that this scoring detail occurred
FantasyDefenseGame  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL season of the game
Week integer 32 Yes No The NFL week of the game (weeks 18-21 denote playoff games)
Date datetime Yes No The date/time of the game
Team string 50 Yes No The abbreviation of the Team
Opponent string 50 Yes No The abbreviation of the Opponent
PointsAllowed integer 32 No Yes Number of points allowed
TouchdownsScored integer 32 No Yes Defensive and special teams touchdowns scores
SoloTackles integer 32 No Yes Total number solo tackles
AssistedTackles integer 32 No Yes Total number assisted tackles
Sacks integer 32 No Yes Total number of sacks of the opposing quaterback
SackYards integer 32 No Yes Total number of yards lost when sacking the opposing quaterback
PassesDefended integer 32 No Yes Total number of passes defended
FumblesForced integer 32 No Yes Total number of fumbles forced
FumblesRecovered integer 32 No Yes Total number of fumbles recovered
FumbleReturnYards integer 32 No Yes Total return yards from fumbles recovered
FumbleReturnTouchdowns integer 32 No Yes Total touchdowns from fumbles recovered
Interceptions integer 32 No Yes Total number of interceptions
InterceptionReturnYards integer 32 No Yes Total number of interception return yards
InterceptionReturnTouchdowns integer 32 No Yes Total number of interception returns for touchdowns
BlockedKicks integer 32 No Yes Total number of blocked field goals and blocked punts
Safeties integer 32 No Yes Total safeties scored
PuntReturns integer 32 No Yes Total number of punt returns
PuntReturnYards integer 32 No Yes Total number of punt return yards
PuntReturnTouchdowns integer 32 No Yes Total number of punt returns for touchdowns
PuntReturnLong integer 32 No Yes Longest punt return
KickReturns integer 32 No Yes Total number of kick returns
KickReturnYards integer 32 No Yes Total number of kick return yards
KickReturnTouchdowns integer 32 No Yes Total number of kick returns for touchdowns
KickReturnLong integer 32 No Yes Longest kick return
BlockedKickReturnTouchdowns
from 2012
integer 32 Yes Yes Blocked kicks returned for a touchdown
FieldGoalReturnTouchdowns
from 2012
integer 32 Yes Yes Field goal returns for touchdowns
FantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing offensive players (QB, RB, WR and TE)
QuarterbackFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing quarterbacks
RunningbackFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing running backs
WideReceiverFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing wide receivers
TightEndFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing tight ends
KickerFantasyPointsAllowed decimal 32 Yes Yes Fantasy points allowed to opposing kickers
BlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
QuarterbackHits integer 32 Yes Yes Quarterback hits
TacklesForLoss integer 32 Yes Yes Tackles for a loss
DefensiveTouchdowns integer 32 Yes Yes Total touchdowns scored by the defense
SpecialTeamsTouchdowns integer 32 Yes Yes Total touchdowns scored by the special teams
IsGameOver boolean Yes No Whether the game is over (true/false)
FantasyPoints decimal 32 Yes Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
Stadium string 50 Yes No Stadium of the event
Temperature integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Yes Temperature at game start (Farenheit)
WindSpeed integer 32 Yes Yes Humidity at game start (Percentage)
ThirdDownAttempts integer 32 Yes No Opponent's third down attempts
ThirdDownConversions integer 32 Yes No Opponent's third down conversions
FourthDownAttempts integer 32 Yes No Opponent's fourth down attempts
FourthDownConversions integer 32 Yes No Opponent's fourth down conversions
PointsAllowedByDefenseSpecialTeams integer 32 Yes No Number of points allowed to opposing offense and special teams. This excludes points scored by the opponent's defense.
FanDuelSalary integer 32 Yes No The team's DEF/ST salary for FanDuel daily fantasy contests.
DraftKingsSalary integer 32 Yes No The team's DEF/ST salary for DraftKings daily fantasy contests.
FantasyDataSalary integer 32 Yes No The team's DEF/ST salary as calculated by FantasyData. Based on the same salary cap as FanDuel contests ($60,000).
FantasyDefenseSeason  
Column Type Size Nullable Scrambled (?) Description
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL regular season for which these totals apply
Team string 50 Yes No The abbreviation of the Team
PointsAllowed integer 32 No Yes Number of points allowed
TouchdownsScored integer 32 No Yes Defensive and special teams touchdowns scores
SoloTackles integer 32 No Yes Total number solo tackles
AssistedTackles integer 32 No Yes Total number assisted tackles
Sacks integer 32 No Yes Total number of sacks of the opposing quaterback
SackYards integer 32 No Yes Total number of yards lost when sacking the opposing quaterback
PassesDefended integer 32 No Yes Total number of passes defended
FumblesForced integer 32 No Yes Total number of fumbles forced
FumblesRecovered integer 32 No Yes Total number of fumbles recovered
FumbleReturnYards integer 32 No Yes Total return yards from fumbles recovered
FumbleReturnTouchdowns integer 32 No Yes Total touchdowns from fumbles recovered
Interceptions integer 32 No Yes Total number of interceptions
InterceptionReturnYards integer 32 No Yes Total number of interception return yards
InterceptionReturnTouchdowns integer 32 No Yes Total number of interception returns for touchdowns
BlockedKicks integer 32 No Yes Total number of blocked field goals and blocked punts
Safeties integer 32 No Yes Total safeties scored
PuntReturns integer 32 No Yes Total number of punt returns
PuntReturnYards integer 32 No Yes Total number of punt return yards
PuntReturnTouchdowns integer 32 No Yes Total number of punt returns for touchdowns
PuntReturnLong integer 32 No Yes Longest punt return
KickReturns integer 32 No Yes Total number of kick returns
KickReturnYards integer 32 No Yes Total number of kick return yards
KickReturnTouchdowns integer 32 No Yes Total number of kick returns for touchdowns
KickReturnLong integer 32 No Yes Longest kick return
BlockedKickReturnTouchdowns
from 2012
integer 32 Yes Yes Blocked kicks returned for a touchdown
FieldGoalReturnTouchdowns
from 2012
integer 32 Yes Yes Field goal returns for touchdowns
FantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing offensive players (QB, RB, WR and TE)
QuarterbackFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing quarterbacks
RunningbackFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing running backs
WideReceiverFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing wide receivers
TightEndFantasyPointsAllowed
from 2012
decimal 32 Yes Yes Fantasy points allowed to opposing tight ends
KickerFantasyPointsAllowed decimal 32 Yes Yes Fantasy points allowed to opposing kickers
Games integer 32 Yes No Games played
BlockedKickReturnYards integer 32 Yes Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Yes Field goal return yards (excluding blocked field goals)
QuarterbackHits integer 32 Yes Yes Quarterback hits
TacklesForLoss integer 32 Yes Yes Tackles for a loss
DefensiveTouchdowns integer 32 Yes Yes Total touchdowns scored by the defense
SpecialTeamsTouchdowns integer 32 Yes Yes Total touchdowns scored by the special teams
FantasyPoints decimal 32 Yes Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
Temperature integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Yes Wind speed at game start (MPH)
ThirdDownAttempts integer 32 Yes No Opponent's third down attempts
ThirdDownConversions integer 32 Yes No Opponent's third down conversions
FourthDownAttempts integer 32 Yes No Opponent's fourth down attempts
FourthDownConversions integer 32 Yes No Opponent's fourth down conversions
PointsAllowedByDefenseSpecialTeams integer 32 Yes No Number of points allowed to opposing offense and special teams.  This excludes points scored by the opponent's defense.
News  
Column Type Size Nullable Scrambled (?) Description
NewsID integer 32 No No Unique ID of news story
Title string 50 Yes No The brief title of the news (typically less than 100 characters)
Updated datetime No No The date/time the story broke
Url string 250 Yes No The url of the full story
Content string 50 Yes No The full body content of the story
Source string 50 Yes No The source of the story (ESPN.com, NBCSports.com, NFLData.com, etc.)
TermsOfUse string 50 Yes No The terms of use with using this news item, credit must be given to the originator of the story when specified in the terms of use
Team string 50 Yes No The team that relates to this story
PlayerID integer 32 Yes No The PlayerID of the player who relates to this story
PlayerGameSnapCount  
Column Type Size Nullable Scrambled (?) Description
GameKey string 10 No No A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam.
PlayerID integer 32 Yes No Unique ID assigned to each player that stays with them throughout their career
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL season of the game
GameDate datetime No No The date/time of the game
Week integer 32 No No The NFL week of the game (weeks 18-21 denote playoff games)
Team string 50 Yes No The abbreviation of the Team
Opponent string 50 Yes No The abbreviation of the Opponent
HomeOrAway string 50 Yes No Whether the player is Home or Away
Number integer 32 No No Player's jersey number
Name string 50 Yes No Player's name
Position string 50 Yes No Player's position in the starting lineup (if started), otherwise the position he substituted for
PositionCategory string 50 Yes No Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST)
Activated integer 32 No No Whether the player was Active at gametime
Played integer 32 No No Whether the player played in at least one play
Started integer 32 No No Whether the player started on offense or defense
FantasyPoints
from 2012
decimal 32 No Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
FantasyPointsPPR decimal 32 No Yes Fantasy points scored based on basic PPR fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
PlayerGameID
from 2012
integer 32 No No Unique ID of PlayerGame record (subject to change). For a static ID, use a combination of GameKey and PlayerID.
ShortName string 50 Yes No Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning)
PlayingSurface string 50 Yes No Playing surface of the stadium
Stadium string 50 Yes No Stadium of the event
Temperature integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Yes Wind speed at game start (MPH)
OffensiveSnapsPlayed integer 32 Yes Yes The number of snaps this player played on offense.
DefensiveSnapsPlayed integer 32 Yes Yes The number of snaps this player played on defense.
SpecialTeamsSnapsPlayed integer 32 Yes Yes The number of snaps this player played on special teams.
OffensiveTeamSnaps integer 32 Yes Yes The total number of offensive snaps this player's team played.
DefensiveTeamSnaps integer 32 Yes Yes The total number of defensive snaps this player's team played.
SpecialTeamsTeamSnaps integer 32 Yes Yes The total number of special teams snaps this player's team played.
PlayerSeasonSnapCount  
Column Type Size Nullable Scrambled (?) Description
PlayerID integer 32 Yes No Unique ID assigned to each player that stays with them throughout their career
SeasonType integer 32 No No The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason).
Season integer 32 No No The NFL regular season for which these totals apply
Team string 50 Yes No The abbreviation of the Team
Number integer 32 No No Player's jersey number
Name string 50 Yes No Player's name
Position string 50 Yes No Player's position in the starting lineup (if started), otherwise the position he substituted for
PositionCategory string 50 Yes No Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST)
Activated integer 32 No No Number of games player was Active on gameday
Played integer 32 No No Number of games played in
Started integer 32 No No Number of games started
FantasyPoints
from 2012
decimal 32 No Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
FantasyPointsPPR decimal 32 No Yes Fantasy points scored based on basic PPR fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
PlayerSeasonID
from 2012
integer 32 No No Unique ID of PlayerSeason record (subject to change). For a static ID, use a combination of SeasonType, Season and PlayerID.
ShortName string 50 Yes No Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning)
Temperature integer 32 Yes Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Yes Wind speed at game start (MPH)
OffensiveSnapsPlayed integer 32 Yes Yes The number of snaps this player played on offense.
DefensiveSnapsPlayed integer 32 Yes Yes The number of snaps this player played on defense.
SpecialTeamsSnapsPlayed integer 32 Yes Yes The number of snaps this player played on special teams.
OffensiveTeamSnaps integer 32 Yes Yes The total number of offensive snaps this player's team played.
DefensiveTeamSnaps integer 32 Yes Yes The total number of defensive snaps this player's team played.
SpecialTeamsTeamSnaps integer 32 Yes Yes The total number of special teams snaps this player's team played.
DailyFantasyPlayer  
Column Type Size Nullable Scrambled (?) Description
PlayerID integer 32 No No Unique ID assigned to each player that stays with them throughout their career
Date datetime No No The date/time of the event
ShortName string 50 No No Player's short name (typically first initial and last name)
Name string 50 No No Player's name
Team string 10 Yes No The abbreviation of the team this player is employed by, or if currently unemployed, the most recent team this player was employed by.
Opponent string 10 Yes No The abbreviation of the upcoming opponent
Position string 10 Yes No The player's daily fantasy position
Salary integer 32 No No The player's daily fantasy salary as determined by FantasyData, based on a $60,000 salary cap
LastGameFantasyPoints decimal 32 Yes No The fantasy points scored by this player in the last game played
ProjectedFantasyPoints decimal 32 Yes No The projected fantasy points this player will score in the upcoming event
OpponentRank integer 32 Yes No The upcoming opponent's rank in fantasy points allowed
OpponentPositionRank integer 32 Yes No The upcoming opponent's rank in fantasy points allowed to players at this player's position
Status string 50 Yes No The player's current status (including Healthy, Probable, Questionable, Doubtful, Out, Injured Reserve, Suspended, Practice Squad, and more)
StatusCode string 50 Yes No The shortened code representing the player's Status
StatusColor string 50 Yes No The color indicating how attractive this players status is (red, yellow, green)
DailyFantasyScoring  
Column Type Size Nullable Scrambled (?) Description
PlayerID integer 32 No No
Name string 50 No No
FantasyPoints decimal 32 Yes No
HasStarted boolean No No
IsInProgress boolean No No
IsOver boolean No No