Need help?
Contact Us

NFL Data Dictionary

NFLdata.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.

Season

Column Type Size Nullable Description
LastCompletedSeason integer 32 No The most recently completed season. This value changes immediately after the Super Bowl.
CurrentSeason integer 32 No The current NFL season. This value changes when the NFL releases the schedule for the upcoming season.
UpcomingSeason integer 32 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

Column Type Size Nullable Description
LastCompletedWeek integer 32 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 The current week of the NFL season. This value canges on Tuesday night / Wednesday morning at midnight EST.
UpcomingWeek integer 32 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 Description
Key string 50 Yes Abbreviation of the team (e.g. SD, PHI, NE, IND, etc.)
City string 50 Yes The city/location of the team (e.g. San Diego, Philadelphia, New England, Indianapolis, etc.)
Name string 50 Yes The mascot of the team (e.g. Chargers, Eagles, Patriots, Colts, etc.)
Conference string 50 Yes The conference of the team (e.g. AFC or NFC)
Division string 50 Yes The division of the team (e.g. East, North, South, West)
FullName string 50 Yes The full name of the team (e.g. New England Patriots)

Score

Column Type Size Nullable Description
Season integer 32 No The NFL season of the game
Week integer 32 No The NFL week of the game (weeks 18-21 denote playoff games)
Date datetime No The date/time of the game
AwayTeam string 50 Yes The abbreviation of the Away Team
HomeTeam string 50 Yes The abbreviation of the Home Team
AwayScore integer 32 No The final score of the Away Team
HomeScore integer 32 No The final score of the Home Team
Channel string 50 Yes The television station broadcasting the game
PointSpread decimal 32 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 No The oddsmaker Point Spread at game start (from the perspective of the Home Team)
Quarter string 50 Yes 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 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 The team that currently has possession of the ball (PHI, NE, NULL if game is not in progress or at halftime)
AwayScoreQuarter1 integer 32 Yes Points scored during Quarter 1
AwayScoreQuarter2 integer 32 Yes Points scored during Quarter 2
AwayScoreQuarter3 integer 32 Yes Points scored during Quarter 3
AwayScoreQuarter4 integer 32 Yes Points scored during Quarter 4
AwayScoreOvertime integer 32 Yes Points scored during Overtime
HomeScoreQuarter1 integer 32 Yes Points scored during Quarter 1
HomeScoreQuarter2 integer 32 Yes Points scored during Quarter 2
HomeScoreQuarter3 integer 32 Yes Points scored during Quarter 3
HomeScoreQuarter4 integer 32 Yes Points scored during Quarter 4
HomeScoreOvertime integer 32 Yes Points scored during Overtime
HasStarted boolean No Whether the game has started (true/false)
IsInProgress boolean No Whether the game is currently in progress (true/false)
IsOver boolean No Whether the game is over (true/false)

Schedule

Column Type Size Nullable Description
Season integer 32 No The NFL season of the game
Week integer 32 No The NFL week of the game (weeks 18-21 denote playoff games)
Date datetime No The date/time of the game
AwayTeam string 50 Yes The abbreviation of the Away Team
HomeTeam string 50 Yes The abbreviation of the Home Team
Channel string 50 Yes The television station broadcasting the game
PointSpread decimal 32 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 No The oddsmaker Point Spread at game start (from the perspective of the Home Team)

Bye

Column Type Size Nullable Description
Season integer 32 No The NFL season during this bye week
Week integer 32 No The NFL week during this bye week
Team string 50 Yes The NFL team who is on bye during this week

Game

Column Type Size Nullable Description
Date datetime No The date/time of the game
Season integer 32 No The NFL season of the game
Week integer 32 No The NFL week of the game (weeks 18-21 denote playoff games)
Stadium string 50 Yes Stadium of the event
PlayingSurface string 50 Yes Playing surface of the stadium
Temperature integer 32 Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Wind speed at game start (MPH)
AwayTeam string 50 Yes The abbreviation of the Away Team
HomeTeam string 50 Yes The abbreviation of the Home Team
AwayScore integer 32 No The final score of the Away Team
HomeScore integer 32 No The final score of the Home Team
TotalScore integer 32 Yes The total score of both teams
OverUnder decimal 32 Yes The oddsmaker Over/Under at game start
PointSpread decimal 32 Yes 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 Points scored during Quarter 1
AwayScoreQuarter2 integer 32 Yes Points scored during Quarter 2
AwayScoreQuarter3 integer 32 Yes Points scored during Quarter 3
AwayScoreQuarter4 integer 32 Yes Points scored during Quarter 4
AwayScoreOvertime integer 32 Yes Points scored during Overtime
HomeScoreQuarter1 integer 32 Yes Points scored during Quarter 1
HomeScoreQuarter2 integer 32 Yes Points scored during Quarter 2
HomeScoreQuarter3 integer 32 Yes Points scored during Quarter 3
HomeScoreQuarter4 integer 32 Yes Points scored during Quarter 4
HomeScoreOvertime integer 32 Yes Points scored during Overtime
AwayTimeOfPossession string 50 Yes Time of Posession
HomeTimeOfPossession string 50 Yes Time of Posession
AwayFirstDowns integer 32 Yes Total First Downs
HomeFirstDowns integer 32 Yes Total First Downs
AwayFirstDownsByRushing integer 32 Yes Rushing First Downs
HomeFirstDownsByRushing integer 32 Yes Rushing First Downs
AwayFirstDownsByPassing integer 32 Yes Passing First Downs
HomeFirstDownsByPassing integer 32 Yes Passing First Downs
AwayFirstDownsByPenalty integer 32 Yes First Downs (via Penalty)
HomeFirstDownsByPenalty integer 32 Yes First Downs (via Penalty)
AwayOffensivePlays integer 32 Yes Number of offensive plays run
HomeOffensivePlays integer 32 Yes Number of offensive plays run
AwayOffensiveYards integer 32 Yes Number of offensive yards gained
HomeOffensiveYards integer 32 Yes Number of offensive yards gained
AwayOffensiveYardsPerPlay decimal 32 Yes Average yards gained per offensive play
HomeOffensiveYardsPerPlay decimal 32 Yes Average yards gained per offensive play
AwayTouchdowns integer 32 Yes Touchdowns scored
HomeTouchdowns integer 32 Yes Touchdowns scored
AwayRushingAttempts integer 32 Yes Number of rushing attempts
HomeRushingAttempts integer 32 Yes Number of rushing attempts
AwayRushingYards integer 32 Yes Number of rushing yards
HomeRushingYards integer 32 Yes Number of rushing yards
AwayRushingYardsPerAttempt decimal 32 Yes Average rushing yards gained per attempt
HomeRushingYardsPerAttempt decimal 32 Yes Average rushing yards gained per attempt
AwayRushingTouchdowns integer 32 Yes Rushing touchdowns scored
HomeRushingTouchdowns integer 32 Yes Rushing touchdowns scored
AwayPassingAttempts integer 32 Yes Number of passes thrown
HomePassingAttempts integer 32 Yes Number of passes thrown
AwayPassingCompletions integer 32 Yes Number of pass completions
HomePassingCompletions integer 32 Yes Number of pass completions
AwayPassingYards integer 32 Yes Number of passing yards
HomePassingYards integer 32 Yes Number of passing yards
AwayPassingTouchdowns integer 32 Yes Passing touchdowns scored
HomePassingTouchdowns integer 32 Yes Passing touchdowns scored
AwayPassingInterceptions integer 32 Yes Interceptions thrown
HomePassingInterceptions integer 32 Yes Interceptions thrown
AwayPassingYardsPerAttempt decimal 32 Yes Average passing yards gained per attempt
HomePassingYardsPerAttempt decimal 32 Yes Average passing yards gained per attempt
AwayPassingYardsPerCompletion decimal 32 Yes Average passing yards gained per completion
HomePassingYardsPerCompletion decimal 32 Yes Average passing yards gained per completion
AwayCompletionPercentage decimal 32 Yes Percentage of passes that were completed
HomeCompletionPercentage decimal 32 Yes Percentage of passes that were completed
AwayPasserRating decimal 32 Yes Passer rating
HomePasserRating decimal 32 Yes Passer rating
AwayThirdDownAttempts integer 32 Yes Third down attempts
HomeThirdDownAttempts integer 32 Yes Third down attempts
AwayThirdDownConversions integer 32 Yes Third down conversions
HomeThirdDownConversions integer 32 Yes Third down conversions
AwayThirdDownPercentage decimal 32 Yes Percentage of third downs converted
HomeThirdDownPercentage decimal 32 Yes Percentage of third downs converted
AwayFourthDownAttempts integer 32 Yes Fourth down attempts
HomeFourthDownAttempts integer 32 Yes Fourth down attempts
AwayFourthDownConversions integer 32 Yes Fourth down conversions
HomeFourthDownConversions integer 32 Yes Fourth down conversions
AwayFourthDownPercentage decimal 32 Yes Percentage of fourth downs converted
HomeFourthDownPercentage decimal 32 Yes Percentage of fourth downs converted
AwayRedZoneAttempts integer 32 Yes Red zone opportunities
HomeRedZoneAttempts integer 32 Yes Red zone opportunities
AwayRedZoneConversions integer 32 Yes Red zone opportunities converted to touchdowns
HomeRedZoneConversions integer 32 Yes Red zone opportunities converted to touchdowns
AwayGoalToGoAttempts integer 32 Yes 1st & Goal opportunities
HomeGoalToGoAttempts integer 32 Yes 1st & Goal opportunities
AwayGoalToGoConversions integer 32 Yes 1st & Goal opportunities converted to touchdowns
HomeGoalToGoConversions integer 32 Yes 1st & Goal opportunities converted to touchdowns
AwayReturnYards integer 32 Yes Total punt and defensive return yards
HomeReturnYards integer 32 Yes Total punt and defensive return yards
AwayPenalties integer 32 Yes Penalties committed
HomePenalties integer 32 Yes Penalties committed
AwayPenaltyYards integer 32 Yes Penalty yards enforced against the away team
HomePenaltyYards integer 32 Yes Penalty yards enforced against the away team
AwayFumbles integer 32 Yes Fumbles
HomeFumbles integer 32 Yes Fumbles
AwayFumblesLost integer 32 Yes Fumbles lost
HomeFumblesLost integer 32 Yes Fumbles lost
AwayTimesSacked integer 32 Yes Number of times the away team was sacked
HomeTimesSacked integer 32 Yes Number of times the away team was sacked
AwayTimesSackedYards integer 32 Yes Number of yards lost as a result of being sacked
HomeTimesSackedYards integer 32 Yes Number of yards lost as a result of being sacked
AwaySafeties integer 32 Yes Safeties scored
HomeSafeties integer 32 Yes Safeties scored
AwayPunts integer 32 Yes Number of punts
HomePunts integer 32 Yes Number of punts
AwayPuntYards integer 32 Yes Total punt yards
HomePuntYards integer 32 Yes Total punt yards
AwayPuntAverage decimal 32 Yes Average number of yards per punt
HomePuntAverage decimal 32 Yes Average number of yards per punt
AwayGiveaways integer 32 Yes Number of giveaways
HomeGiveaways integer 32 Yes Number of giveaways
AwayTakeaways integer 32 Yes Number of takeaways
HomeTakeaways integer 32 Yes Number of takeaways
AwayTurnoverDifferential integer 32 Yes Number of takeaways minus giveaways
HomeTurnoverDifferential integer 32 Yes Number of takeaways minus giveaways
AwayKickoffs integer 32 Yes Number of kickoffs
HomeKickoffs integer 32 Yes Number of kickoffs
AwayKickoffsInEndZone integer 32 Yes Number of kickoffs that went into the end zone
HomeKickoffsInEndZone integer 32 Yes Number of kickoffs that went into the end zone
AwayKickoffTouchbacks integer 32 Yes Number of kickoffs that resulted in touchbacks
HomeKickoffTouchbacks integer 32 Yes Number of kickoffs that resulted in touchbacks
AwayPuntsHadBlocked integer 32 Yes Number of punts that were blocked
HomePuntsHadBlocked integer 32 Yes Number of punts that were blocked
AwayPuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
HomePuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
AwayExtraPointKickingAttempts integer 32 Yes Extra point kick attempts
HomeExtraPointKickingAttempts integer 32 Yes Extra point kick attempts
AwayExtraPointKickingConversions integer 32 Yes Extra point kicks made
HomeExtraPointKickingConversions integer 32 Yes Extra point kicks made
AwayExtraPointsHadBlocked integer 32 Yes Extra point kick attempts that were blocked
HomeExtraPointsHadBlocked integer 32 Yes Extra point kick attempts that were blocked
AwayExtraPointPassingAttempts integer 32 Yes Two point conversion passing attempts
HomeExtraPointPassingAttempts integer 32 Yes Two point conversion passing attempts
AwayExtraPointPassingConversions integer 32 Yes Two point conversion passing conversions
HomeExtraPointPassingConversions integer 32 Yes Two point conversion passing conversions
AwayExtraPointRushingAttempts integer 32 Yes Two point conversion rushing attempts
HomeExtraPointRushingAttempts integer 32 Yes Two point conversion rushing attempts
AwayExtraPointRushingConversions integer 32 Yes Two point conversion rushing conversions
HomeExtraPointRushingConversions integer 32 Yes Two point conversion rushing conversions
AwayFieldGoalAttempts integer 32 Yes Field goal attempts
HomeFieldGoalAttempts integer 32 Yes Field goal attempts
AwayFieldGoalsMade integer 32 Yes Field goals made
HomeFieldGoalsMade integer 32 Yes Field goals made
AwayFieldGoalsHadBlocked integer 32 Yes Field goal attempts that were blocked
HomeFieldGoalsHadBlocked integer 32 Yes Field goal attempts that were blocked
AwayPuntReturns integer 32 Yes Punt returns
HomePuntReturns integer 32 Yes Punt returns
AwayPuntReturnYards integer 32 Yes Punt return yards
HomePuntReturnYards integer 32 Yes Punt return yards
AwayKickReturns integer 32 Yes Kickoff returns
HomeKickReturns integer 32 Yes Kickoff returns
AwayKickReturnYards integer 32 Yes Kickoff return yards
HomeKickReturnYards integer 32 Yes Kickoff return yards
AwayInterceptionReturns integer 32 Yes Defensive interceptions
HomeInterceptionReturns integer 32 Yes Defensive interceptions
AwayInterceptionReturnYards integer 32 Yes Interception return yards
HomeInterceptionReturnYards integer 32 Yes Interception return yards
AwaySoloTackles integer 32 Yes Defensive solo tackles
AwayAssistedTackles integer 32 Yes Defensive assisted tackles
AwayQuarterbackHits integer 32 Yes Defensive QB hits
AwayTacklesForLoss integer 32 Yes Defensive tackles for a loss
AwaySacks integer 32 Yes Defensive sacks
AwaySackYards integer 32 Yes Defensive sack yards
AwayPassesDefended integer 32 Yes Defensive passes defended
AwayFumblesForced integer 32 Yes Defensive fumbles forced
AwayFumblesRecovered integer 32 Yes Fumbles recovered that resulted in change of possession
AwayFumbleReturnYards integer 32 Yes Fumble return yards
AwayFumbleReturnTouchdowns integer 32 Yes Fumble return touchdowns
AwayInterceptionReturnTouchdowns integer 32 Yes Defensive interceptions
AwayBlockedKicks integer 32 Yes Total number of opponent's kicks that were blocked
AwayPuntReturnTouchdowns integer 32 Yes Punt return touchdown
AwayPuntReturnLong integer 32 Yes Longest punt return
AwayKickReturnTouchdowns integer 32 Yes Kick return touchdown
AwayKickReturnLong integer 32 Yes Longest kick return
AwayBlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
AwayBlockedKickReturnTouchdowns integer 32 Yes Blocked kick recovery return touchdowns
AwayFieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
AwayFieldGoalReturnTouchdowns integer 32 Yes Field goal return touchdowns (excluding blocked field goals)
AwayPuntNetYards integer 32 Yes Net punt yards
HomeSoloTackles integer 32 Yes Defensive solo tackles
HomeAssistedTackles integer 32 Yes Defensive assisted tackles
HomeQuarterbackHits integer 32 Yes Defensive QB hits
HomeTacklesForLoss integer 32 Yes Defensive tackles for a loss
HomeSacks integer 32 Yes Defensive sacks
HomeSackYards integer 32 Yes Defensive sack yards
HomePassesDefended integer 32 Yes Defensive passes defended
HomeFumblesForced integer 32 Yes Defensive fumbles forced
HomeFumblesRecovered integer 32 Yes Fumbles recovered that resulted in change of possession
HomeFumbleReturnYards integer 32 Yes Fumble return yards
HomeFumbleReturnTouchdowns integer 32 Yes Fumble return touchdowns
HomeInterceptionReturnTouchdowns integer 32 Yes Defensive interceptions
HomeBlockedKicks integer 32 Yes Total number of opponent's kicks that were blocked
HomePuntReturnTouchdowns integer 32 Yes Punt return touchdown
HomePuntReturnLong integer 32 Yes Longest punt return
HomeKickReturnTouchdowns integer 32 Yes Kick return touchdown
HomeKickReturnLong integer 32 Yes Longest kick return
HomeBlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
HomeBlockedKickReturnTouchdowns integer 32 Yes Blocked kick recovery return touchdowns
HomeFieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
HomeFieldGoalReturnTouchdowns integer 32 Yes Field goal return touchdowns (excluding blocked field goals)
HomePuntNetYards integer 32 Yes Net punt yards
IsGameOver boolean Yes Whether the game is over (true/false)

TeamGame

Column Type Size Nullable Description
Date datetime Yes The date/time of the game
Season integer 32 No The NFL season of the game
Week integer 32 Yes The NFL week of the game (weeks 18-21 denote playoff games)
Team string 50 Yes The abbreviation of the Team
Opponent string 50 Yes The abbreviation of the Opponent
HomeOrAway string 50 Yes Whether the Team is Home or Away
Score integer 32 No The final score of the Team
OpponentScore integer 32 No The final score of the Opponent
TotalScore integer 32 No The total score of both teams
Stadium string 50 Yes Stadium of the event
PlayingSurface string 50 Yes Playing surface of the stadium
Temperature integer 32 Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Wind speed at game start (MPH)
OverUnder decimal 32 Yes The oddsmaker Over/Under at game start
PointSpread decimal 32 Yes The oddsmaker Point Spread at game start (from the perspective of the Team)
ScoreQuarter1 integer 32 Yes Points scored during Quarter 1 for the Team
ScoreQuarter2 integer 32 Yes Points scored during Quarter 2 for the Team
ScoreQuarter3 integer 32 Yes Points scored during Quarter 3 for the Team
ScoreQuarter4 integer 32 Yes Points scored during Quarter 4 for the Team
ScoreOvertime integer 32 No Points scored during Overtime for the Team
TimeOfPossessionMinutes integer 32 Yes Time of posession minutes
TimeOfPossessionSeconds integer 32 Yes Time of posession seconds
TimeOfPossession string 50 Yes Time of posession
FirstDowns integer 32 Yes Total first downs
FirstDownsByRushing integer 32 Yes Total rushing first downs
FirstDownsByPassing integer 32 Yes Total passing first downs
FirstDownsByPenalty integer 32 Yes Total first downs by opponent's penalty
OffensivePlays integer 32 No Number of offensive plays run
OffensiveYards integer 32 No Number of offensive yards gained
OffensiveYardsPerPlay decimal 32 No Average yards gained per offensive play
Touchdowns integer 32 Yes Touchdowns scored
RushingAttempts integer 32 Yes Number of rushing attempts
RushingYards integer 32 Yes Number of rushing yards
RushingYardsPerAttempt decimal 32 No Average rushing yards gained per attempt
RushingTouchdowns integer 32 Yes Rushing touchdowns scored
PassingAttempts integer 32 Yes Number of passes thrown
PassingCompletions integer 32 Yes Number of pass completions
PassingYards integer 32 Yes Number of passing yards
PassingTouchdowns integer 32 Yes Passing touchdowns scored
PassingInterceptions integer 32 Yes Interceptions thrown
PassingYardsPerAttempt decimal 32 No Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Average passing yards gained per completion
CompletionPercentage decimal 32 No Percentage of passes that were completed
PasserRating decimal 32 Yes Passer rating
ThirdDownAttempts integer 32 Yes Third down attempts
ThirdDownConversions integer 32 Yes Third down conversions
ThirdDownPercentage decimal 32 Yes Percentage of third downs converted
FourthDownAttempts integer 32 Yes Fourth down attempts
FourthDownConversions integer 32 Yes Fourth down conversions
FourthDownPercentage decimal 32 Yes Percentage of fourth downs converted
RedZoneAttempts integer 32 Yes Red zone opportunities
RedZoneConversions integer 32 Yes Red zone opportunities converted to touchdowns
GoalToGoAttempts integer 32 Yes 1st & Goal opportunities
GoalToGoConversions integer 32 Yes 1st & Goal opportunities converted to touchdowns
ReturnYards integer 32 Yes Total punt and defensive return yards
Penalties integer 32 Yes Penalties committed
PenaltyYards integer 32 Yes Penalty yards enforced against team
Fumbles integer 32 Yes Fumbles
FumblesLost integer 32 Yes Fumbles lost
TimesSacked integer 32 Yes Number of sacks allowed by Team
TimesSackedYards integer 32 Yes Number of yards lost as a result of sacks allowed
QuarterbackHits integer 32 Yes Number of times the opposing QB was hit (includes sacks)
TacklesForLoss integer 32 Yes Number of times the opponent was tackled for a loss
Safeties integer 32 Yes Safeties scored
Punts integer 32 Yes Number of punts
PuntYards integer 32 Yes Total punt yards
PuntAverage decimal 32 No Average number of yards per punt
Giveaways integer 32 No Number of giveaways
Takeaways integer 32 No Number of takeaways
TurnoverDifferential integer 32 No Number of takeaways minus giveaways
OpponentScoreQuarter1 integer 32 Yes Points scored during Quarter 1 for the Team
OpponentScoreQuarter2 integer 32 Yes Points scored during Quarter 2 for the Team
OpponentScoreQuarter3 integer 32 Yes Points scored during Quarter 3 for the Team
OpponentScoreQuarter4 integer 32 Yes Points scored during Quarter 4 for the Team
OpponentScoreOvertime integer 32 No Points scored during Overtime for the Team
OpponentTimeOfPossessionMinutes integer 32 Yes Time of posession minutes
OpponentTimeOfPossessionSeconds integer 32 Yes Time of posession seconds
OpponentTimeOfPossession string 50 Yes Time of posession
OpponentFirstDowns integer 32 Yes Total first downs
OpponentFirstDownsByRushing integer 32 Yes Total rushing first downs
OpponentFirstDownsByPassing integer 32 Yes Total passing first downs
OpponentFirstDownsByPenalty integer 32 Yes Total first downs by opponent's penalty
OpponentOffensivePlays integer 32 No Number of offensive plays run
OpponentOffensiveYards integer 32 No Number of offensive yards gained
OpponentOffensiveYardsPerPlay decimal 32 No Average yards gained per offensive play
OpponentTouchdowns integer 32 Yes Touchdowns scored
OpponentRushingAttempts integer 32 Yes Number of rushing attempts
OpponentRushingYards integer 32 Yes Number of rushing yards
OpponentRushingYardsPerAttempt decimal 32 No Average rushing yards gained per attempt
OpponentRushingTouchdowns integer 32 Yes Rushing touchdowns scored
OpponentPassingAttempts integer 32 Yes Number of passes thrown
OpponentPassingCompletions integer 32 Yes Number of pass completions
OpponentPassingYards integer 32 Yes Number of passing yards
OpponentPassingTouchdowns integer 32 Yes Passing touchdowns scored
OpponentPassingInterceptions integer 32 Yes Interceptions thrown
OpponentPassingYardsPerAttempt decimal 32 No Average passing yards gained per attempt
OpponentPassingYardsPerCompletion decimal 32 No Average passing yards gained per completion
OpponentCompletionPercentage decimal 32 No Percentage of passes that were completed
OpponentPasserRating decimal 32 Yes Passer rating
OpponentThirdDownAttempts integer 32 Yes Third down attempts
OpponentThirdDownConversions integer 32 Yes Third down conversions
OpponentThirdDownPercentage decimal 32 Yes Percentage of third downs converted
OpponentFourthDownAttempts integer 32 Yes Fourth down attempts
OpponentFourthDownConversions integer 32 Yes Fourth down conversions
OpponentFourthDownPercentage decimal 32 Yes Percentage of fourth downs converted
OpponentRedZoneAttempts integer 32 Yes Red zone opportunities
OpponentRedZoneConversions integer 32 Yes Red zone opportunities converted to touchdowns
OpponentGoalToGoAttempts integer 32 Yes 1st & Goal opportunities
OpponentGoalToGoConversions integer 32 Yes 1st & Goal opportunities converted to touchdowns
OpponentReturnYards integer 32 Yes Total punt and defensive return yards
OpponentPenalties integer 32 Yes Penalties committed
OpponentPenaltyYards integer 32 Yes Penalty yards enforced against the opponent
OpponentFumbles integer 32 Yes Fumbles
OpponentFumblesLost integer 32 Yes Fumbles lost
OpponentTimesSacked integer 32 Yes Number of sacks allowed by Opponent
OpponentTimesSackedYards integer 32 Yes Number of yards opponent lost as a result of being sacked
OpponentQuarterbackHits integer 32 Yes Number of times our QB was hit but not sacked
OpponentTacklesForLoss integer 32 Yes Number of times our ball carrier was tackled for a loss
OpponentSafeties integer 32 Yes Safeties scored
OpponentPunts integer 32 Yes Number of punts
OpponentPuntYards integer 32 Yes Total punt yards
OpponentPuntAverage decimal 32 No Average number of yards per punt
OpponentGiveaways integer 32 No Number of giveaways
OpponentTakeaways integer 32 No Number of takeaways
OpponentTurnoverDifferential integer 32 No Number of takeaways minus giveaways
RedZonePercentage decimal 32 Yes Percentage of red zone opportunities converted into touchdowns
GoalToGoPercentage decimal 32 Yes Percentage of goal-to-go opportunities converted into touchdowns
QuarterbackHitsDifferential integer 32 Yes The differential of hits on the opposing quarterback minus hits on own team's quarterback
TacklesForLossDifferential integer 32 Yes The differential of tackles for loss minus opponent's tackles for loss
QuarterbackSacksDifferential integer 32 No The Team's sack differential (similar to a turnover differential)
TacklesForLossPercentage decimal 32 Yes Percentage of running plays defended that resulted in tackle for loss
QuarterbackHitsPercentage decimal 32 Yes Percantage of opposing quarterback drop backs that resulted hitting the quarterback
TimesSackedPercentage decimal 32 No Percentage of drop backs that resulted in a sack
OpponentRedZonePercentage decimal 32 Yes Percentage of opponent's red zone opportunities converted into touchdowns
OpponentGoalToGoPercentage decimal 32 Yes Percentage of opponent's goal-to-go opportunities converted into touchdowns
OpponentQuarterbackHitsDifferential integer 32 Yes The inverse of QuarterbackHitsDifferential
OpponentTacklesForLossDifferential integer 32 Yes The inverse of TacklesForLossDifferential
OpponentQuarterbackSacksDifferential integer 32 Yes The inverse of QuarterbackSacksDifferential
OpponentTacklesForLossPercentage decimal 32 Yes Percentage of running plays defended that resulted in tackle for loss
OpponentQuarterbackHitsPercentage decimal 32 Yes Percantage of own team's quarterback drop backs that resulted in our quarterback getting hit
OpponentTimesSackedPercentage decimal 32 No Percentage of drop backs that resulted in a sack
Kickoffs integer 32 Yes Number of kickoffs
KickoffsInEndZone integer 32 Yes Number of kickoffs that went into the end zone
KickoffTouchbacks integer 32 Yes Number of kickoffs that resulted in touchbacks
PuntsHadBlocked integer 32 Yes Number of punts that were blocked
PuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
ExtraPointKickingAttempts integer 32 Yes Extra point kick attempts
ExtraPointKickingConversions integer 32 Yes Extra point kicks made
ExtraPointsHadBlocked integer 32 Yes Extra point kick attempts that were blocked
ExtraPointPassingAttempts integer 32 Yes Two point conversion passing attempts
ExtraPointPassingConversions integer 32 Yes Two point conversion passing conversions
ExtraPointRushingAttempts integer 32 Yes Two point conversion rushing attempts
ExtraPointRushingConversions integer 32 Yes Two point conversion rushing conversions
FieldGoalAttempts integer 32 Yes Field goal attempts
FieldGoalsMade integer 32 Yes Field goals made
FieldGoalsHadBlocked integer 32 Yes Field goal attempts that were blocked
PuntReturns integer 32 Yes Punt returns
PuntReturnYards integer 32 Yes Punt return yards
KickReturns integer 32 Yes Kickoff returns
KickReturnYards integer 32 Yes Kickoff return yards
InterceptionReturns integer 32 Yes Defensive interceptions
InterceptionReturnYards integer 32 Yes Interception return yards
OpponentKickoffs integer 32 Yes Number of kickoffs
OpponentKickoffsInEndZone integer 32 Yes Number of kickoffs that went into the end zone
OpponentKickoffTouchbacks integer 32 Yes Number of kickoffs that resulted in touchbacks
OpponentPuntsHadBlocked integer 32 Yes Number of punts that were blocked
OpponentPuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
OpponentExtraPointKickingAttempts integer 32 Yes Extra point kick attempts
OpponentExtraPointKickingConversions integer 32 Yes Extra point kicks made
OpponentExtraPointsHadBlocked integer 32 Yes Extra point kick attempts that were blocked
OpponentExtraPointPassingAttempts integer 32 Yes Two point conversion passing attempts
OpponentExtraPointPassingConversions integer 32 Yes Two point conversion passing conversions
OpponentExtraPointRushingAttempts integer 32 Yes Two point conversion rushing attempts
OpponentExtraPointRushingConversions integer 32 Yes Two point conversion rushing conversions
OpponentFieldGoalAttempts integer 32 Yes Field goal attempts
OpponentFieldGoalsMade integer 32 Yes Field goals made
OpponentFieldGoalsHadBlocked integer 32 Yes Field goal attempts that were blocked
OpponentPuntReturns integer 32 Yes Punt returns
OpponentPuntReturnYards integer 32 Yes Punt return yards
OpponentKickReturns integer 32 Yes Kickoff returns
OpponentKickReturnYards integer 32 Yes Kickoff return yards
OpponentInterceptionReturns integer 32 Yes Defensive interceptions
OpponentInterceptionReturnYards integer 32 Yes Interception return yards
SoloTackles integer 32 Yes Defensive solo tackles
AssistedTackles integer 32 Yes Defensive assisted tackles
Sacks integer 32 Yes Defensive sacks
SackYards integer 32 Yes Defensive sack yards
PassesDefended integer 32 Yes Defensive passes defended
FumblesForced integer 32 Yes Defensive fumbles forced
FumblesRecovered integer 32 Yes Fumbles recovered that resulted in change of possession
FumbleReturnYards integer 32 Yes Fumble return yards
FumbleReturnTouchdowns integer 32 Yes Fumble return touchdowns
InterceptionReturnTouchdowns integer 32 Yes Defensive interceptions
BlockedKicks integer 32 Yes Total number of opponent's kicks that were blocked
PuntReturnTouchdowns integer 32 Yes Punt return touchdown
PuntReturnLong integer 32 Yes Longest punt return
KickReturnTouchdowns integer 32 Yes Kick return touchdown
KickReturnLong integer 32 Yes Longest kick return
BlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
BlockedKickReturnTouchdowns integer 32 Yes Blocked kick recovery return touchdowns
FieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
FieldGoalReturnTouchdowns integer 32 Yes Field goal return touchdowns (excluding blocked field goals)
PuntNetYards integer 32 Yes Net punt yards
OpponentSoloTackles integer 32 Yes Defensive solo tackles
OpponentAssistedTackles integer 32 Yes Defensive assisted tackles
OpponentSacks integer 32 Yes Defensive sacks
OpponentSackYards integer 32 Yes Defensive sack yards
OpponentPassesDefended integer 32 Yes Defensive passes defended
OpponentFumblesForced integer 32 Yes Defensive fumbles forced
OpponentFumblesRecovered integer 32 Yes Fumbles recovered that resulted in change of possession
OpponentFumbleReturnYards integer 32 Yes Fumble return yards
OpponentFumbleReturnTouchdowns integer 32 Yes Fumble return touchdowns
OpponentInterceptionReturnTouchdowns integer 32 Yes Defensive interceptions
OpponentBlockedKicks integer 32 Yes Total number of opponent's kicks that were blocked
OpponentPuntReturnTouchdowns integer 32 Yes Punt return touchdown
OpponentPuntReturnLong integer 32 Yes Longest punt return
OpponentKickReturnTouchdowns integer 32 Yes Kick return touchdown
OpponentKickReturnLong integer 32 Yes Longest kick return
OpponentBlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
OpponentBlockedKickReturnTouchdowns integer 32 Yes Blocked kick recovery return touchdowns
OpponentFieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
OpponentFieldGoalReturnTouchdowns integer 32 Yes Field goal return touchdowns (excluding blocked field goals)
OpponentPuntNetYards integer 32 Yes Net punt yards
IsGameOver boolean Yes Whether the game is over (true/false)
TeamName string 50 Yes The full name of the team (e.g. New England Patriots)
DayOfWeek string 50 Yes The day of the week this game was played on (e.g. Sunday, Monday)
PassingDropbacks integer 32 Yes The number of times the offense dropped back to pass
OpponentPassingDropbacks integer 32 Yes The number of times the opponent dropped back to pass

TeamSeason

Column Type Size Nullable Description
Season integer 32 No The NFL regular season for which these totals apply
Team string 50 Yes The abbreviation of the Team
Score integer 32 No Total points scored
OpponentScore integer 32 No Total points scored by opponents
TotalScore integer 32 No Total points scored by both teams
Temperature integer 32 Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Wind speed at game start (MPH)
OverUnder decimal 32 Yes The oddsmaker Over/Under at game start
PointSpread decimal 32 Yes The oddsmaker Point Spread at game start (from the perspective of the Team)
ScoreQuarter1 integer 32 Yes Points scored during Quarter 1 for the Team
ScoreQuarter2 integer 32 Yes Points scored during Quarter 2 for the Team
ScoreQuarter3 integer 32 Yes Points scored during Quarter 3 for the Team
ScoreQuarter4 integer 32 Yes Points scored during Quarter 4 for the Team
ScoreOvertime integer 32 No Points scored during Overtime for the Team
TimeOfPossession string 50 Yes Time of posession
FirstDowns integer 32 Yes Total first downs
FirstDownsByRushing integer 32 Yes Total rushing first downs
FirstDownsByPassing integer 32 Yes Total passing first downs
FirstDownsByPenalty integer 32 Yes Total first downs by opponent's penalty
OffensivePlays integer 32 No Number of offensive plays run
OffensiveYards integer 32 No Number of offensive yards gained
OffensiveYardsPerPlay decimal 32 No Average yards gained per offensive play
Touchdowns integer 32 Yes Touchdowns scored
RushingAttempts integer 32 Yes Number of rushing attempts
RushingYards integer 32 Yes Number of rushing yards
RushingYardsPerAttempt decimal 32 No Average rushing yards gained per attempt
RushingTouchdowns integer 32 Yes Rushing touchdowns scored
PassingAttempts integer 32 Yes Number of passes thrown
PassingCompletions integer 32 Yes Number of pass completions
PassingYards integer 32 Yes Number of passing yards
PassingTouchdowns integer 32 Yes Passing touchdowns scored
PassingInterceptions integer 32 Yes Interceptions thrown
PassingYardsPerAttempt decimal 32 No Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Average passing yards gained per completion
CompletionPercentage decimal 32 No Percentage of passes that were completed
PasserRating decimal 32 Yes Passer rating
ThirdDownAttempts integer 32 Yes Third down attempts
ThirdDownConversions integer 32 Yes Third down conversions
ThirdDownPercentage decimal 32 Yes Percentage of third downs converted
FourthDownAttempts integer 32 Yes Fourth down attempts
FourthDownConversions integer 32 Yes Fourth down conversions
FourthDownPercentage decimal 32 Yes Percentage of fourth downs converted
RedZoneAttempts integer 32 Yes Red zone opportunities
RedZoneConversions integer 32 Yes Red zone opportunities converted to touchdowns
GoalToGoAttempts integer 32 Yes 1st & Goal opportunities
GoalToGoConversions integer 32 Yes 1st & Goal opportunities converted to touchdowns
ReturnYards integer 32 Yes Total punt and defensive return yards
Penalties integer 32 Yes Penalties committed
PenaltyYards integer 32 Yes Penalty yards enforced against the Team
Fumbles integer 32 Yes Fumbles
FumblesLost integer 32 Yes Fumbles lost
TimesSacked integer 32 Yes Number of sacks allowed by Team
TimesSackedYards integer 32 Yes Number of yards lost as a result of sacks allowed
QuarterbackHits integer 32 Yes Number of times the opposing QB was hit but not sacked
TacklesForLoss integer 32 Yes Number of times the opponent was tackled for a loss
Safeties integer 32 Yes Safeties scored
Punts integer 32 Yes Number of punts
PuntYards integer 32 Yes Total punt yards
PuntAverage decimal 32 No Average number of yards per punt
Giveaways integer 32 No Number of giveaways
Takeaways integer 32 No Number of takeaways
TurnoverDifferential integer 32 No Number of takeaways minus giveaways
OpponentScoreQuarter1 integer 32 Yes Points scored during Quarter 1 for the Team
OpponentScoreQuarter2 integer 32 Yes Points scored during Quarter 2 for the Team
OpponentScoreQuarter3 integer 32 Yes Points scored during Quarter 3 for the Team
OpponentScoreQuarter4 integer 32 Yes Points scored during Quarter 4 for the Team
OpponentScoreOvertime integer 32 No Points scored during Overtime for the Team
OpponentTimeOfPossession string 50 Yes Time of posession
OpponentFirstDowns integer 32 Yes Total first downs
OpponentFirstDownsByRushing integer 32 Yes Total rushing first downs
OpponentFirstDownsByPassing integer 32 Yes Total passing first downs
OpponentFirstDownsByPenalty integer 32 Yes Total first downs by opponent's penalty
OpponentOffensivePlays integer 32 No Number of offensive plays run
OpponentOffensiveYards integer 32 No Number of offensive yards gained
OpponentOffensiveYardsPerPlay decimal 32 No Average yards gained per offensive play
OpponentTouchdowns integer 32 Yes Touchdowns scored
OpponentRushingAttempts integer 32 Yes Number of rushing attempts
OpponentRushingYards integer 32 Yes Number of rushing yards
OpponentRushingYardsPerAttempt decimal 32 No Average rushing yards gained per attempt
OpponentRushingTouchdowns integer 32 Yes Rushing touchdowns scored
OpponentPassingAttempts integer 32 Yes Number of passes thrown
OpponentPassingCompletions integer 32 Yes Number of pass completions
OpponentPassingYards integer 32 Yes Number of passing yards
OpponentPassingTouchdowns integer 32 Yes Passing touchdowns scored
OpponentPassingInterceptions integer 32 Yes Interceptions thrown
OpponentPassingYardsPerAttempt decimal 32 No Average passing yards gained per attempt
OpponentPassingYardsPerCompletion decimal 32 No Average passing yards gained per completion
OpponentCompletionPercentage decimal 32 No Percentage of passes that were completed
OpponentPasserRating decimal 32 Yes Passer rating
OpponentThirdDownAttempts integer 32 Yes Third down attempts
OpponentThirdDownConversions integer 32 Yes Third down conversions
OpponentThirdDownPercentage decimal 32 Yes Percentage of third downs converted
OpponentFourthDownAttempts integer 32 Yes Fourth down attempts
OpponentFourthDownConversions integer 32 Yes Fourth down conversions
OpponentFourthDownPercentage decimal 32 Yes Percentage of fourth downs converted
OpponentRedZoneAttempts integer 32 Yes Red zone opportunities
OpponentRedZoneConversions integer 32 Yes Red zone opportunities converted to touchdowns
OpponentGoalToGoAttempts integer 32 Yes 1st & Goal opportunities
OpponentGoalToGoConversions integer 32 Yes 1st & Goal opportunities converted to touchdowns
OpponentReturnYards integer 32 Yes Total punt and defensive return yards
OpponentPenalties integer 32 Yes Penalties committed
OpponentPenaltyYards integer 32 Yes Penalty yards enforced against the away team
OpponentFumbles integer 32 Yes Fumbles
OpponentFumblesLost integer 32 Yes Fumbles lost
OpponentTimesSacked integer 32 Yes Number of sacks allowed by Opponent
OpponentTimesSackedYards integer 32 Yes Number of yards opponent lost as a result of being sacked
OpponentQuarterbackHits integer 32 Yes Number of times the opposing QB was hit but not sacked
OpponentTacklesForLoss integer 32 Yes Number of times our ball carrier was tackled for a loss
OpponentSafeties integer 32 Yes Safeties scored
OpponentPunts integer 32 Yes Number of punts
OpponentPuntYards integer 32 Yes Total punt yards
OpponentPuntAverage decimal 32 No Average number of yards per punt
OpponentGiveaways integer 32 No Number of giveaways
OpponentTakeaways integer 32 No Number of takeaways
OpponentTurnoverDifferential integer 32 No Number of takeaways minus giveaways
RedZonePercentage decimal 32 Yes Percentage of red zone opportunities converted into touchdowns
GoalToGoPercentage decimal 32 Yes Percentage of goal-to-go opportunities converted into touchdowns
QuarterbackHitsDifferential integer 32 Yes The differential of hits on the opposing quarterback minus hits on own team's quarterback
TacklesForLossDifferential integer 32 Yes The differential of tackles for loss minus opponent's tackles for loss
QuarterbackSacksDifferential integer 32 No The Team's sack differential (similar to a turnover differential)
TacklesForLossPercentage decimal 32 Yes Percentage of running plays defended that resulted in tackle for loss
QuarterbackHitsPercentage decimal 32 Yes Percantage of opposing quarterback drop backs that resulted hitting the quarterback
TimesSackedPercentage decimal 32 No Percentage of drop backs that resulted in a sack
OpponentRedZonePercentage decimal 32 Yes Percentage of opponent's red zone opportunities converted into touchdowns
OpponentGoalToGoPercentage decimal 32 Yes Percentage of opponent's goal-to-go opportunities converted into touchdowns
OpponentQuarterbackHitsDifferential integer 32 Yes The inverse of QuarterbackHitsDifferential
OpponentTacklesForLossDifferential integer 32 Yes The inverse of TacklesForLossDifferential
OpponentQuarterbackSacksDifferential integer 32 Yes The inverse of QuarterbackSacksDifferential
OpponentTacklesForLossPercentage decimal 32 Yes Percentage of running plays defended that resulted in tackle for loss
OpponentQuarterbackHitsPercentage decimal 32 Yes Percantage of own team's quarterback drop backs that resulted in our quarterback getting hit
OpponentTimesSackedPercentage decimal 32 No Percentage of drop backs that resulted in a sack
Kickoffs integer 32 Yes Number of kickoffs
KickoffsInEndZone integer 32 Yes Number of kickoffs that went into the end zone
KickoffTouchbacks integer 32 Yes Number of kickoffs that resulted in touchbacks
PuntsHadBlocked integer 32 Yes Number of punts that were blocked
PuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
ExtraPointKickingAttempts integer 32 Yes Extra point kick attempts
ExtraPointKickingConversions integer 32 Yes Extra point kicks made
ExtraPointsHadBlocked integer 32 Yes Extra point kick attempts that were blocked
ExtraPointPassingAttempts integer 32 Yes Two point conversion passing attempts
ExtraPointPassingConversions integer 32 Yes Two point conversion passing conversions
ExtraPointRushingAttempts integer 32 Yes Two point conversion rushing attempts
ExtraPointRushingConversions integer 32 Yes Two point conversion rushing conversions
FieldGoalAttempts integer 32 Yes Field goal attempts
FieldGoalsMade integer 32 Yes Field goals made
FieldGoalsHadBlocked integer 32 Yes Field goal attempts that were blocked
PuntReturns integer 32 Yes Punt returns
PuntReturnYards integer 32 Yes Punt return yards
KickReturns integer 32 Yes Kickoff returns
KickReturnYards integer 32 Yes Kickoff return yards
InterceptionReturns integer 32 Yes Defensive interceptions
InterceptionReturnYards integer 32 Yes Interception return yards
OpponentKickoffs integer 32 Yes Number of kickoffs
OpponentKickoffsInEndZone integer 32 Yes Number of kickoffs that went into the end zone
OpponentKickoffTouchbacks integer 32 Yes Number of kickoffs that resulted in touchbacks
OpponentPuntsHadBlocked integer 32 Yes Number of punts that were blocked
OpponentPuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
OpponentExtraPointKickingAttempts integer 32 Yes Extra point kick attempts
OpponentExtraPointKickingConversions integer 32 Yes Extra point kicks made
OpponentExtraPointsHadBlocked integer 32 Yes Extra point kick attempts that were blocked
OpponentExtraPointPassingAttempts integer 32 Yes Two point conversion passing attempts
OpponentExtraPointPassingConversions integer 32 Yes Two point conversion passing conversions
OpponentExtraPointRushingAttempts integer 32 Yes Two point conversion rushing attempts
OpponentExtraPointRushingConversions integer 32 Yes Two point conversion rushing conversions
OpponentFieldGoalAttempts integer 32 Yes Field goal attempts
OpponentFieldGoalsMade integer 32 Yes Field goals made
OpponentFieldGoalsHadBlocked integer 32 Yes Field goal attempts that were blocked
OpponentPuntReturns integer 32 Yes Punt returns
OpponentPuntReturnYards integer 32 Yes Punt return yards
OpponentKickReturns integer 32 Yes Kickoff returns
OpponentKickReturnYards integer 32 Yes Kickoff return yards
OpponentInterceptionReturns integer 32 Yes Defensive interceptions
OpponentInterceptionReturnYards integer 32 Yes Interception return yards
SoloTackles integer 32 Yes Defensive solo tackles
AssistedTackles integer 32 Yes Defensive assisted tackles
Sacks integer 32 Yes Defensive sacks
SackYards integer 32 Yes Defensive sack yards
PassesDefended integer 32 Yes Defensive passes defended
FumblesForced integer 32 Yes Defensive fumbles forced
FumblesRecovered integer 32 Yes Fumbles recovered that resulted in change of possession
FumbleReturnYards integer 32 Yes Fumble return yards
FumbleReturnTouchdowns integer 32 Yes Fumble return touchdowns
InterceptionReturnTouchdowns integer 32 Yes Defensive interceptions
BlockedKicks integer 32 Yes Total number of opponent's kicks that were blocked
PuntReturnTouchdowns integer 32 Yes Punt return touchdown
PuntReturnLong integer 32 Yes Longest punt return
KickReturnTouchdowns integer 32 Yes Kick return touchdown
KickReturnLong integer 32 Yes Longest kick return
BlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
BlockedKickReturnTouchdowns integer 32 Yes Blocked kick recovery return touchdowns
FieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
FieldGoalReturnTouchdowns integer 32 Yes Field goal return touchdowns (excluding blocked field goals)
PuntNetYards integer 32 Yes Net punt yards
OpponentSoloTackles integer 32 Yes Defensive solo tackles
OpponentAssistedTackles integer 32 Yes Defensive assisted tackles
OpponentSacks integer 32 Yes Defensive sacks
OpponentSackYards integer 32 Yes Defensive sack yards
OpponentPassesDefended integer 32 Yes Defensive passes defended
OpponentFumblesForced integer 32 Yes Defensive fumbles forced
OpponentFumblesRecovered integer 32 Yes Fumbles recovered that resulted in change of possession
OpponentFumbleReturnYards integer 32 Yes Fumble return yards
OpponentFumbleReturnTouchdowns integer 32 Yes Fumble return touchdowns
OpponentInterceptionReturnTouchdowns integer 32 Yes Defensive interceptions
OpponentBlockedKicks integer 32 Yes Total number of opponent's kicks that were blocked
OpponentPuntReturnTouchdowns integer 32 Yes Punt return touchdown
OpponentPuntReturnLong integer 32 Yes Longest punt return
OpponentKickReturnTouchdowns integer 32 Yes Kick return touchdown
OpponentKickReturnLong integer 32 Yes Longest kick return
OpponentBlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
OpponentBlockedKickReturnTouchdowns integer 32 Yes Blocked kick recovery return touchdowns
OpponentFieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
OpponentFieldGoalReturnTouchdowns integer 32 Yes Field goal return touchdowns (excluding blocked field goals)
OpponentPuntNetYards integer 32 Yes Net punt yards
TeamName string 50 Yes The full name of the team (e.g. New England Patriots)
Games integer 32 Yes Total number of regular season games played
PassingDropbacks integer 32 Yes The number of times the offense dropped back to pass
OpponentPassingDropbacks integer 32 Yes The number of times the opponent dropped back to pass

Standing

Column Type Size Nullable Description
Season integer 32 No The NFL regular season for which these totals apply
Conference string 50 Yes The conference of the team (e.g. AFC or NFC)
Division string 50 Yes The division of the team (e.g. East, North, South, West)
Team string 50 Yes The abbreviation of the Team
Name string 50 Yes The full name of the team
Wins integer 32 No Regular season wins
Losses integer 32 No Regular season losses
Ties integer 32 No Regular season ties
Percentage decimal 32 No Winning percentage
PointsFor integer 32 No Points scored during regular season games
PointsAgainst integer 32 No Points allowed during regular season games
NetPoints integer 32 No Difference between PointsFor and PointsAgainst
Touchdowns integer 32 Yes Total touchdowns scored
DivisionWins integer 32 No Regular season wins within the division
DivisionLosses integer 32 No Regular season losses within the division
ConferenceWins integer 32 No Regular season wins within the conference
ConferenceLosses integer 32 No Regular season losses within the conference

Player

Column Type Size Nullable Description
PlayerID integer 32 No Unique ID assigned to each player that stays with them throughout their career
Team string 50 Yes 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 Player's jersey number
FirstName string 50 Yes Player's first name
LastName string 50 Yes Player's last name
Position string 50 Yes Player's most commonly played position
Status string 50 Yes Active, Inactive, PUP, IR
Height string 50 Yes Height in feet, inches
Weight string 50 Yes Weight in pounds
BirthDate datetime Yes Date of birth
College string 50 Yes College
Experience integer 32 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 50 Yes The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB)
Active boolean Yes Whether the player is currently employed by an NFL team
PositionCategory string 50 Yes The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST)
Name string 50 Yes Full name of the player (Cam Newton, Aaron Rodgers, etc.)
Age integer 32 Yes The player's current age
ExperienceString string 50 Yes The player's experience converted to a string
BirthDateString string 50 Yes The player's date of birth converted to a string
PhotoUrl string 50 Yes The url of the player's photo hosted on NFLData.com (http://static.nfldata.com/images/player/7242.jpg)
ByeWeek integer 32 Yes The week the player is on Bye for the upcoming or current season
UpcomingGameOpponent string 50 Yes The opponent the player is playing in the upcoming week
UpcomingGameWeek integer 32 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 A shortened version of the player's full name (C.Newton, A.Rodgers)
AverageDraftPosition decimal 32 Yes The average draft position of the player for the upcoming season's fantasy football draft
DepthPositionCategory string 50 Yes The category (Offense, Defense or Special Teams) of the players DepthPositionCategory (OFF, DEF, ST)
DepthPosition string 50 Yes The position this player is listed at on his team's depth chart (e.g. QB, LWR, RDE, LILB)
DepthOrder integer 32 Yes The order this player is at his position (1 = Starter, 2 = Backup, 3 = 3rd String)
DepthDisplayOrder integer 32 Yes The display order of the positions (for display purposes)
CurrentTeam string 10 Yes The team who currently employs this player. This value is null when this player is unemployed.
CollegeDraftTeam integer 32 Yes 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 integer 32 Yes The year this player entered the NFL as rookie.
CollegeDraftRound integer 32 Yes The round this player was drafted in.
CollegeDraftPick integer 32 Yes The overall pick in the draft this player was selected.
IsUndraftedFreeAgent boolean No Whether this player was an undrafted free agent. This value is True if the player was drafted.

Injury

Column Type Size Nullable Description
InjuryID integer 32 No Unique ID of the injury status
Season integer 32 No The season of the game that this injury leads up to
Week integer 32 No The week of the game that this injury leads up to
PlayerID integer 32 No The PlayerID of the injured player
Name string 50 Yes The full name of the injured player
Position string 50 Yes The position of the injured player
Number integer 32 No The jersey number of the injured player
Team string 50 Yes The team the injured player is on
Opponent string 50 Yes The upcoming opponent of the injured player
BodyPart string 50 Yes The body part that is injured (Knee, Groin, Calf, Hamstring, etc.)
Status string 50 Yes Likelihood that player plays (Probably, Questionable, Doubtful, Out)
Practice string 50 Yes Whether the player participated in practice (None, Limited, Full)
PracticeDescription string 50 Yes Full description of whether the player participated in practice)
Updated datetime No The date/time the injury status was updated

PlayerGame

Column Type Size Nullable Description
PlayerID integer 32 Yes Unique ID assigned to each player that stays with them throughout their career
Season integer 32 No The NFL season of the game
GameDate datetime No The date/time of the game
Week integer 32 No The NFL week of the game (weeks 18-21 denote playoff games)
Team string 50 Yes The abbreviation of the Team
Opponent string 50 Yes The abbreviation of the Opponent
HomeOrAway string 50 Yes Whether the player is Home or Away
Number integer 32 No Player's jersey number
Name string 50 Yes Player's name
Position string 50 Yes Player's position in the starting lineup (if started), otherwise the position he substituted for
PositionCategory string 50 Yes Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST)
Activated integer 32 No Whether the player was Active at gametime
Played integer 32 No Whether the player played in at least one play
Started integer 32 No Whether the player started on offense or defense
PassingAttempts integer 32 No Number of passes thrown
PassingCompletions integer 32 No Number of pass completions
PassingYards integer 32 No Number of passing yards
PassingCompletionPercentage decimal 32 No Percentage of passes that were completed
PassingYardsPerAttempt decimal 32 No Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Average passing yards gained per completion
PassingTouchdowns integer 32 No Passing touchdowns scored
PassingInterceptions integer 32 No Interceptions thrown
PassingRating decimal 32 No Passer rating
PassingLong integer 32 No Longest completion
PassingSacks integer 32 No Number of times sacked
PassingSackYards integer 32 No Yards lost as a result of being sacked
RushingAttempts integer 32 No Number of rushing attempts
RushingYards integer 32 No Number of rushing yards
RushingYardsPerAttempt decimal 32 No Average rushing yards gained per attempt
RushingTouchdowns integer 32 No Rushing touchdowns scored
RushingLong integer 32 No Longest rush
ReceivingTargets integer 32 Yes Number of times targeted by passer
Receptions integer 32 No Number of receptions
ReceivingYards integer 32 No Total receiving yards
ReceivingYardsPerReception decimal 32 No Average yards gained per reception
ReceivingTouchdowns integer 32 No Receiving touchdowns
ReceivingLong integer 32 No Longest reception
Fumbles integer 32 No Times fumbled
FumblesLost integer 32 Yes Number of fumbles recovered by opponent
PuntReturns integer 32 No Number of punt return attempts
PuntReturnYards integer 32 No Total return yards on punts
PuntReturnYardsPerAttempt decimal 32 No Average yards gained per punt return
PuntReturnTouchdowns integer 32 No Number of touchdowns on punt returns
PuntReturnLong integer 32 No Longest punt return
KickReturns integer 32 No Number of kick return attempts
KickReturnYards integer 32 No Total return yards on kicks
KickReturnYardsPerAttempt decimal 32 No Average yards gained per kick return
KickReturnTouchdowns integer 32 No Number of touchdowns on kick returns
KickReturnLong integer 32 No Longest kick return
SoloTackles integer 32 No Solo, unassisted tackles
AssistedTackles integer 32 No Assisted tackles (also called a half tackle)
TacklesForLoss integer 32 Yes Tackles behind the opponent's line of scrimmage
Sacks decimal 32 No Sacks of the opposing quarterback
SackYards integer 32 No Yards lost as a result of sacking the opposing quarterback
QuarterbackHits integer 32 Yes Number of times hitting an opposing quarterback without sacking him
PassesDefended integer 32 No Passes defended or batted down
FumblesForced integer 32 No Number of fumbles forced
FumblesRecovered integer 32 No Number of fumbles recovered
FumbleReturnYards integer 32 No Return yards from fumble recoveries
FumbleReturnTouchdowns integer 32 No Return touchdowns from fumble recoveries
Interceptions integer 32 No Number of interceptions
InterceptionReturnYards integer 32 No Return yards from interceptions
InterceptionReturnTouchdowns integer 32 No Return touchdowns from interceptions
BlockedKicks integer 32 No Total nmber of field goals and punts blocked
SpecialTeamsSoloTackles integer 32 No Solo tackles on kick and punt plays
SpecialTeamsAssistedTackles integer 32 No Assisted tackles on kick and punt plays
MiscSoloTackles integer 32 No Solo tackles when playing offense (after a turnover)
MiscAssistedTackles integer 32 No Assisted tackles when playing offense (after a turnover)
Punts integer 32 No Number of punts
PuntYards integer 32 No Total number of punt yards
PuntAverage decimal 32 No Average yards per punt
FieldGoalsAttempted integer 32 No Number of field goal attempts
FieldGoalsMade integer 32 No Number of successful field goal attempts
FieldGoalsLongestMade integer 32 No Longest successful field goal attempt
ExtraPointsMade integer 32 No Number of successful extra points
TwoPointConversionPasses integer 32 No Successful two point conversion passes
TwoPointConversionRuns integer 32 No Successful two point conversion runs
TwoPointConversionReceptions integer 32 No Successful two point conversion receptions
FantasyPoints decimal 32 No Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
ReceptionPercentage decimal 32 No Percentage of ReceivingTargets convert into Receptions
ReceivingYardsPerTarget decimal 32 No Average yards gained per ReceivingTargets
Tackles integer 32 No Sum of SoloTackles and AssistedTackles
OffensiveTouchdowns integer 32 No Offensive touchdowns scored
DefensiveTouchdowns integer 32 No Defensive touchdowns scored
SpecialTeamsTouchdowns integer 32 No Special teams touchdowns scored
Touchdowns integer 32 No Total touchdowns scored
FantasyPosition string 50 Yes The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB)
FieldGoalPercentage decimal 32 No Percentage of Field Goal attempts that we successful
PlayerGameID integer 32 No Unique ID of PlayerGame record
FumblesOwnRecoveries integer 32 Yes Own team's fumbles recovered (did not result in a turnover)
FumblesOutOfBounds integer 32 Yes Fumbles by this player that went out of bounds (no one was awarded the recovery)
KickReturnFairCatches integer 32 Yes Fair catches made on kickoffs
PuntReturnFairCatches integer 32 Yes Fair catches made on punts
PuntTouchbacks integer 32 Yes Punts by this player that were touchbacks
PuntInside20 integer 32 Yes Punts by this player that were downed inside the 20 yard line
PuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
ExtraPointsAttempted integer 32 Yes Extra point kicks attempted
BlockedKickReturnTouchdowns integer 32 Yes Blocked kicks that this player returned for touchdowns
FieldGoalReturnTouchdowns integer 32 Yes Field goals that this player returned for touchdowns
Safeties integer 32 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 Field goal attempts that were blocked
PuntsHadBlocked integer 32 Yes Punts that were blocked
ExtraPointsHadBlocked integer 32 Yes Extra points that were blocked
PuntLong integer 32 Yes Longest punt
BlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
PuntNetYards integer 32 Yes Net punt yards
SpecialTeamsFumblesForced integer 32 Yes Fumbles forced on special teams plays
SpecialTeamsFumblesRecovered integer 32 Yes Fumbles recovered on special teams plays
MiscFumblesForced integer 32 Yes Fumbles forced after a turnover on offensive plays
MiscFumblesRecovered integer 32 Yes Fumbles recovered after a turnover on offensive plays
ShortName string 50 Yes Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning)
PlayingSurface string 50 Yes Playing surface of the stadium
IsGameOver boolean Yes Whether the game is over (true/false)
SafetiesAllowed integer 32 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 Stadium of the event
Temperature integer 32 Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Wind speed at game start (MPH)

PlayerSeason

Column Type Size Nullable Description
PlayerID integer 32 Yes Unique ID assigned to each player that stays with them throughout their career
Season integer 32 No The NFL regular season for which these totals apply
Team string 50 Yes The abbreviation of the Team
Number integer 32 No Player's jersey number
Name string 50 Yes Player's name
Position string 50 Yes Player's position in the starting lineup (if started), otherwise the position he substituted for
PositionCategory string 50 Yes Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST)
Activated integer 32 No Number of games player was Active on gameday
Played integer 32 No Number of games played in
Started integer 32 No Number of games started
PassingAttempts integer 32 No Number of passes thrown
PassingCompletions integer 32 No Number of pass completions
PassingYards integer 32 No Number of passing yards
PassingCompletionPercentage decimal 32 No Percentage of passes that were completed
PassingYardsPerAttempt decimal 32 No Average passing yards gained per attempt
PassingYardsPerCompletion decimal 32 No Average passing yards gained per completion
PassingTouchdowns integer 32 No Passing touchdowns scored
PassingInterceptions integer 32 No Interceptions thrown
PassingRating decimal 32 No Passer rating
PassingLong integer 32 No Longest completion
PassingSacks integer 32 No Number of times sacked
PassingSackYards integer 32 No Yards lost as a result of being sacked
RushingAttempts integer 32 No Number of rushing attempts
RushingYards integer 32 No Number of rushing yards
RushingYardsPerAttempt decimal 32 No Average rushing yards gained per attempt
RushingTouchdowns integer 32 No Rushing touchdowns scored
RushingLong integer 32 No Longest rush
ReceivingTargets integer 32 Yes Number of times targeted by passer
Receptions integer 32 No Number of receptions
ReceivingYards integer 32 No Total receiving yards
ReceivingYardsPerReception decimal 32 No Average yards gained per reception
ReceivingTouchdowns integer 32 No Receiving touchdowns
ReceivingLong integer 32 No Longest reception
Fumbles integer 32 No Times fumbled
FumblesLost integer 32 Yes Number of fumbles recovered by opponent
PuntReturns integer 32 No Number of punt return attempts
PuntReturnYards integer 32 No Total return yards on punts
PuntReturnYardsPerAttempt decimal 32 No Average yards gained per punt return
PuntReturnTouchdowns integer 32 No Number of touchdowns on punt returns
PuntReturnLong integer 32 No Longest punt return
KickReturns integer 32 No Number of kick return attempts
KickReturnYards integer 32 No Total return yards on kicks
KickReturnYardsPerAttempt decimal 32 No Average yards gained per kick return
KickReturnTouchdowns integer 32 No Number of touchdowns on kick returns
KickReturnLong integer 32 No Longest kick return
SoloTackles integer 32 No Solo, unassisted tackles
AssistedTackles integer 32 No Assisted tackles (also called a half tackle)
TacklesForLoss integer 32 Yes Tackles behind the opponent's line of scrimmage
Sacks decimal 32 No Sacks of the opposing quarterback
SackYards integer 32 No Yards lost as a result of sacking the opposing quarterback
QuarterbackHits integer 32 Yes Number of times hitting an opposing quarterback without sacking him
PassesDefended integer 32 No Passes defended or batted down
FumblesForced integer 32 No Number of fumbles forced
FumblesRecovered integer 32 No Number of fumbles recovered
FumbleReturnYards integer 32 No Return yards from fumble recoveries
FumbleReturnTouchdowns integer 32 No Return touchdowns from fumble recoveries
Interceptions integer 32 No Number of interceptions
InterceptionReturnYards integer 32 No Return yards from interceptions
InterceptionReturnTouchdowns integer 32 No Return touchdowns from interceptions
BlockedKicks integer 32 No Total nmber of field goals and punts blocked
SpecialTeamsSoloTackles integer 32 No Solo tackles on kick and punt plays
SpecialTeamsAssistedTackles integer 32 No Assisted tackles on kick and punt plays
MiscSoloTackles integer 32 No Solo tackles when playing offense (after a turnover)
MiscAssistedTackles integer 32 No Assisted tackles when playing offense (after a turnover)
Punts integer 32 No Number of punts
PuntYards integer 32 No Total number of punt yards
PuntAverage decimal 32 No Average yards per punt
FieldGoalsAttempted integer 32 No Number of field goal attempts
FieldGoalsMade integer 32 No Number of successful field goal attempts
FieldGoalsLongestMade integer 32 No Longest successful field goal attempt
ExtraPointsMade integer 32 No Number of successful extra points
TwoPointConversionPasses integer 32 No Successful two point conversion passes
TwoPointConversionRuns integer 32 No Successful two point conversion runs
TwoPointConversionReceptions integer 32 No Successful two point conversion receptions
FantasyPoints decimal 32 No Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
ReceptionPercentage decimal 32 No Percentage of ReceivingTargets convert into Receptions
ReceivingYardsPerTarget decimal 32 No Average yards gained per ReceivingTargets
Tackles integer 32 No Sum of SoloTackles and AssistedTackles
OffensiveTouchdowns integer 32 No Offensive touchdowns scored
DefensiveTouchdowns integer 32 No Defensive touchdowns scored
SpecialTeamsTouchdowns integer 32 No Special teams touchdowns scored
Touchdowns integer 32 No Total touchdowns scored
FantasyPosition string 50 Yes The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB)
FieldGoalPercentage decimal 32 No Percentage of Field Goal attempts that we successful
PlayerSeasonID integer 32 No Unique ID of PlayerSeason record
FumblesOwnRecoveries integer 32 Yes Own team's fumbles recovered (did not result in a turnover)
FumblesOutOfBounds integer 32 Yes Fumbles by this player that went out of bounds (no one was awarded the recovery)
KickReturnFairCatches integer 32 Yes Fair catches made on kickoffs
PuntReturnFairCatches integer 32 Yes Fair catches made on punts
PuntTouchbacks integer 32 Yes Punts by this player that were touchbacks
PuntInside20 integer 32 Yes Punts by this player that were downed inside the 20 yard line
PuntNetAverage decimal 32 Yes Net punt average (includes punt return yards as negative)
ExtraPointsAttempted integer 32 Yes Extra point kicks attempted
BlockedKickReturnTouchdowns integer 32 Yes Blocked kicks that this player returned for touchdowns
FieldGoalReturnTouchdowns integer 32 Yes Field goals that this player returned for touchdowns
Safeties integer 32 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 Field goal attempts that were blocked
PuntsHadBlocked integer 32 Yes Punts that were blocked
ExtraPointsHadBlocked integer 32 Yes Extra points that were blocked
PuntLong integer 32 Yes Longest punt
BlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
PuntNetYards integer 32 Yes Net punt yards
SpecialTeamsFumblesForced integer 32 Yes Fumbles forced on special teams plays
SpecialTeamsFumblesRecovered integer 32 Yes Fumbles recovered on special teams plays
MiscFumblesForced integer 32 Yes Fumbles forced after a turnover on offensive plays
MiscFumblesRecovered integer 32 Yes Fumbles recovered after a turnover on offensive plays
ShortName string 50 Yes Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning)
SafetiesAllowed integer 32 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 Temperature at game start (Farenheit)
Humidity integer 32 Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Wind speed at game start (MPH)

ScoringPlay

Column Type Size Nullable Description
ScoringPlayID integer 32 No Unique id of the scoring play
Season integer 32 No The NFL season of the game
Week integer 32 No The NFL week of the game (weeks 18-21 denote playoff games)
AwayTeam string 10 No The abbreviation of the away team
HomeTeam string 10 No The abbreviation of the home team
Date datetime Yes The date/time of the game
Sequence integer 32 Yes The order in which the scoring play happened
Team string 10 Yes The abbreviation of the team that scored
Quarter string 10 Yes The quarter that the score occurred in
TimeRemaining string 10 Yes The time remaining in the quarter when the score occurred
PlayDescription string 500 Yes The detailed description of the play for display purposes
AwayScore integer 32 Yes The away team's score as a result of the scoring play (includes point after)
HomeScore integer 32 Yes The home team's score as a result of the scoring play (includes point after)

ScoringDetail

Column Type Size Nullable Description
PlayerID integer 32 Yes PlayerID of the player who scored
Team string 50 Yes The team who the player played for
Season integer 32 No The season during which the score happened
Week integer 32 No The week during which the score happened
ScoringType string 50 Yes The type of scoring play (e.g. BlockedFieldGoalReturnTouchdown, BlockedPuntReturnTouchdown, FieldGoalMade, FieldGoalMissed, FieldGoalReturnTouchdown, FumbleReturnTouchdown, InterceptionReturnTouchdown, KickoffReturnTouchdown, PassingTouchdown, PuntReturnTouchdown, ReceivingTouchdown, RushingTouchdown, Safety)
Length integer 32 No The length in yards of the score
ScoringDetailID integer 32 No Unique identifier of this scoring detail
PlayerGameID integer 32 No PlayerGameID of the game that this scoring detail occurred

FantasyDefenseGame

Column Type Size Nullable Description
Season integer 32 No The NFL season of the game
Week integer 32 Yes The NFL week of the game (weeks 18-21 denote playoff games)
Date datetime Yes The date/time of the game
Team string 50 Yes The abbreviation of the Team
Opponent string 50 Yes The abbreviation of the Opponent
PointsAllowed integer 32 No Number of points allowed
TouchdownsScored integer 32 No Defensive and special teams touchdowns scores
SoloTackles integer 32 No Total number solo tackles
AssistedTackles integer 32 No Total number assisted tackles
Sacks integer 32 No Total number of sacks of the opposing quaterback
SackYards integer 32 No Total number of yards lost when sacking the opposing quaterback
PassesDefended integer 32 No Total number of passes defended
FumblesForced integer 32 No Total number of fumbles forced
FumblesRecovered integer 32 No Total number of fumbles recovered
FumbleReturnYards integer 32 No Total return yards from fumbles recovered
FumbleReturnTouchdowns integer 32 No Total touchdowns from fumbles recovered
Interceptions integer 32 No Total number of interceptions
InterceptionReturnYards integer 32 No Total number of interception return yards
InterceptionReturnTouchdowns integer 32 No Total number of interception returns for touchdowns
BlockedKicks integer 32 No Total number of blocked field goals and blocked punts
Safeties integer 32 No Total safeties scored
PuntReturns integer 32 No Total number of punt returns
PuntReturnYards integer 32 No Total number of punt return yards
PuntReturnTouchdowns integer 32 No Total number of punt returns for touchdowns
PuntReturnLong integer 32 No Longest punt return
KickReturns integer 32 No Total number of kick returns
KickReturnYards integer 32 No Total number of kick return yards
KickReturnTouchdowns integer 32 No Total number of kick returns for touchdowns
KickReturnLong integer 32 No Longest kick return
BlockedKickReturnTouchdowns integer 32 Yes Blocked kicks returned for a touchdown
FieldGoalReturnTouchdowns integer 32 Yes Field goal returns for touchdowns
FantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing offensive players (QB, RB, WR and TE)
QuarterbackFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing quarterbacks
RunningbackFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing running backs
WideReceiverFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing wide receivers
TightEndFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing tight ends
KickerFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing kickers
BlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
QuarterbackHits integer 32 Yes Quarterback hits
TacklesForLoss integer 32 Yes Tackles for a loss
DefensiveTouchdowns integer 32 Yes Total touchdowns scored by the defense
SpecialTeamsTouchdowns integer 32 Yes Total touchdowns scored by the special teams
IsGameOver boolean Yes Whether the game is over (true/false)
FantasyPoints decimal 32 Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
Stadium string 50 Yes Stadium of the event
Temperature integer 32 Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Temperature at game start (Farenheit)
WindSpeed integer 32 Yes Humidity at game start (Percentage)

FantasyDefenseSeason

Column Type Size Nullable Description
Season integer 32 No The NFL regular season for which these totals apply
Team string 50 Yes The abbreviation of the Team
PointsAllowed integer 32 No Number of points allowed
TouchdownsScored integer 32 No Defensive and special teams touchdowns scores
SoloTackles integer 32 No Total number solo tackles
AssistedTackles integer 32 No Total number assisted tackles
Sacks integer 32 No Total number of sacks of the opposing quaterback
SackYards integer 32 No Total number of yards lost when sacking the opposing quaterback
PassesDefended integer 32 No Total number of passes defended
FumblesForced integer 32 No Total number of fumbles forced
FumblesRecovered integer 32 No Total number of fumbles recovered
FumbleReturnYards integer 32 No Total return yards from fumbles recovered
FumbleReturnTouchdowns integer 32 No Total touchdowns from fumbles recovered
Interceptions integer 32 No Total number of interceptions
InterceptionReturnYards integer 32 No Total number of interception return yards
InterceptionReturnTouchdowns integer 32 No Total number of interception returns for touchdowns
BlockedKicks integer 32 No Total number of blocked field goals and blocked punts
Safeties integer 32 No Total safeties scored
PuntReturns integer 32 No Total number of punt returns
PuntReturnYards integer 32 No Total number of punt return yards
PuntReturnTouchdowns integer 32 No Total number of punt returns for touchdowns
PuntReturnLong integer 32 No Longest punt return
KickReturns integer 32 No Total number of kick returns
KickReturnYards integer 32 No Total number of kick return yards
KickReturnTouchdowns integer 32 No Total number of kick returns for touchdowns
KickReturnLong integer 32 No Longest kick return
BlockedKickReturnTouchdowns integer 32 Yes Blocked kicks returned for a touchdown
FieldGoalReturnTouchdowns integer 32 Yes Field goal returns for touchdowns
FantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing offensive players (QB, RB, WR and TE)
QuarterbackFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing quarterbacks
RunningbackFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing running backs
WideReceiverFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing wide receivers
TightEndFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing tight ends
KickerFantasyPointsAllowed decimal 32 Yes Fantasy points allowed to opposing kickers
Games integer 32 Yes Games played
BlockedKickReturnYards integer 32 Yes Blocked kick recovery return yards
FieldGoalReturnYards integer 32 Yes Field goal return yards (excluding blocked field goals)
QuarterbackHits integer 32 Yes Quarterback hits
TacklesForLoss integer 32 Yes Tackles for a loss
DefensiveTouchdowns integer 32 Yes Total touchdowns scored by the defense
SpecialTeamsTouchdowns integer 32 Yes Total touchdowns scored by the special teams
FantasyPoints decimal 32 Yes Fantasy points scored based on basic fantasy scoring system (https://nfldata.com/nfl-stats/fantasy-scoring-system.aspx)
Temperature integer 32 Yes Temperature at game start (Farenheit)
Humidity integer 32 Yes Humidity at game start (Percentage)
WindSpeed integer 32 Yes Wind speed at game start (MPH)

News

Column Type Size Nullable Description
NewsID integer 32 No Unique ID of news story
Title string 50 Yes The brief title of the news (typically less than 100 characters)
Updated datetime No The date/time the story broke
Url string 50 Yes The url of the full story
Content string 50 Yes The full body content of the story
Source string 50 Yes The source of the story (ESPN.com, NBCSports.com, NFLData.com, etc.)
TermsOfUse string 50 Yes 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 The team that relates to this story
PlayerID integer 32 Yes The PlayerID of the player who relates to this story