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 1821 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 goaltogo 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 goaltogo 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. 