- Fantasy Stats
- Fantasy Stats
- Projected Stats
- Snap Counts
- DFS Salaries
- Injury Report
- IDP Stats
- ADP Rankings
- Points Allowed
- Scoring System

- Team Stats
- Scores
- Odds
- Team Stats
- Team Rankings
- Depth Charts
- Standings

Below you will find a list of all data points that are contained within each feed that we offer. If any of the information provided below is unclear, or if you have a specific question, please contact support.

Expand All
Collapse All
Download CSV

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

SeasonType | integer | 32 | No | No | No | The season type of the timeframe (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason) |

Season | integer | 32 | No | No | No | The league year of the timeframe (this gets incremented on the first day of the league year during free agency) |

Week | integer | 32 | Yes | No | No | The week of the timeframe (Regular Season=1 to 17, Preseason=1 to 4, Postseason=1 to4, Offseason=NULL) |

Name | string | 50 | No | No | No | The friendly name of the Timeframe |

ShortName | string | 50 | No | No | No | The shorter name of the Timeframe |

StartDate | datetime | No | No | No | The start date/time of this Timeframe | |

EndDate | datetime | No | No | No | The end date/time of the Timeframe | |

FirstGameStart | datetime | Yes | No | No | The start date/time of the first game of the Timeframe (if no games then returns the StartDate) | |

FirstGameEnd | datetime | Yes | No | No | The end date/time of the first game of the Timeframe (if no games then returns the EndDate) | |

LastGameEnd | datetime | Yes | No | No | The end date/time of the last game of the Timeframe (if no games then returns the EndDate) | |

HasGames | boolean | No | No | No | Whether there are any games in this Timeframe | |

HasStarted | boolean | No | No | No | Whether this Timeframe has started | |

HasEnded | boolean | No | No | No | Whether this Timeframe has ended | |

HasFirstGameStarted | boolean | No | No | No | Whether the first game has started | |

HasFirstGameEnded | boolean | No | No | No | Whether the first game has ended | |

HasLastGameEnded | boolean | No | No | No | Whether the last game has ended | |

ApiSeason | string | 10 | Yes | No | No | The value of the Season parameter used to pass into the API. |

ApiWeek | string | 10 | Yes | No | No | The value of the Week parameter used to pass into the API. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

Key | string | 50 | No | No | Yes | Abbreviation of the team (e.g. SD, PHI, NE, IND, etc.) |

TeamID | integer | 32 | No | No | No | The auto-generated unique ID of the Team. |

PlayerID | integer | 32 | No | No | No | The auto-generated unique ID of the Team, that avoids collisions with PlayerIDs. This is useful when combining players and fantasy defenses to create fantasy teams. |

City | string | 50 | No | No | Yes | The city/location of the team (e.g. San Diego, Philadelphia, New England, Indianapolis, etc.) |

Name | string | 50 | No | No | Yes | The mascot of the team (e.g. Chargers, Eagles, Patriots, Colts, etc.) |

Conference | string | 50 | Yes | No | Yes | The conference of the team (e.g. AFC or NFC) |

Division | string | 50 | Yes | No | Yes | The division of the team (e.g. East, North, South, West) |

FullName | string | 50 | Yes | No | Yes | The full name of the team (e.g. New England Patriots) |

StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the team's current home stadium |

ByeWeek | integer | 32 | Yes | No | Yes | The bye week of the team in the upcoming regular season |

AverageDraftPosition | decimal | 32 | Yes | No | Yes | The average draft position of the team's fantasy defense (DST) |

AverageDraftPositionPPR | decimal | 32 | Yes | No | Yes | The average draft position in PPR leagues of the team's fantasy defense (DST) |

HeadCoach | string | 50 | Yes | No | Yes | The current head coach of the team |

OffensiveCoordinator | string | 50 | Yes | No | Yes | The current offensive coordinator of the team |

DefensiveCoordinator | string | 50 | Yes | No | Yes | The current defensive coordinator of the team |

SpecialTeamsCoach | string | 50 | Yes | No | Yes | The current special teams coach of the team |

OffensiveScheme | string | 10 | Yes | No | Yes | The offensive scheme this team runs (PRO, 2TE, 3WR). This is decided at our discretion. |

DefensiveScheme | string | 10 | Yes | No | Yes | The current defensive scheme this team runs (3-4, 4-3) |

UpcomingSalary | integer | 32 | Yes | Yes | Yes | The team's DEF/ST salary for the upcoming week in accordance with a $50,000 salary cap. This is used for daily fantasy sports salary cap contests. Salaries represent those published by DraftKings. When DraftKings doesn't publish a salary for a given game, the most recent DraftKings salary is used. |

UpcomingOpponent | string | 10 | Yes | Yes | Yes | The team's upcoming opponent's rank in DEF/ST fantasy points allowed. |

UpcomingOpponentRank | integer | 32 | Yes | Yes | Yes | The team's upcoming opponent's rank in DEF/ST fantasy points allowed. |

UpcomingOpponentPositionRank | integer | 32 | Yes | Yes | Yes | The team's upcoming opponent's rank in DEF/ST fantasy points allowed. |

UpcomingFanDuelSalary | integer | 32 | Yes | Yes | Yes | The team's DEF/ST FanDuel salary for the upcoming week. |

UpcomingDraftKingsSalary | integer | 32 | Yes | Yes | Yes | The team's DEF/ST DraftKings salary for the upcoming week. |

UpcomingYahooSalary | integer | 32 | Yes | Yes | Yes | The team's DEF/ST Yahoo salary for the upcoming week. |

PrimaryColor | string | 6 | Yes | No | Yes | The team's primary color. (This is not licensed for public or commercial use) |

SecondaryColor | string | 6 | Yes | No | Yes | The team's secondary color. (This is not licensed for public or commercial use) |

TertiaryColor | string | 6 | Yes | No | Yes | The team's tertiary color. (This is not licensed for public or commercial use) |

QuaternaryColor | string | 6 | Yes | No | Yes | The team's quaternary color. (This is not licensed for public or commercial use) |

WikipediaLogoUrl | string | 250 | Yes | No | Yes | The link to the team's logo hosted on Wikipedia. (This is not licensed for public or commercial use) |

WikipediaWordMarkUrl | string | 250 | Yes | No | Yes | The link to the team's wordmark logo hosted on Wikipedia. (This is not licensed for public or commercial use) |

GlobalTeamID | integer | 32 | Yes | No | No | |

DraftKingsName | string | 50 | Yes | No | Yes | |

DraftKingsPlayerID | integer | 32 | Yes | No | Yes | |

FanDuelName | string | 50 | Yes | No | Yes | |

FanDuelPlayerID | integer | 32 | Yes | No | Yes | |

FantasyDraftName | string | 50 | Yes | No | Yes | |

FantasyDraftPlayerID | integer | 32 | Yes | No | Yes | |

YahooName | string | 50 | Yes | No | Yes | |

YahooPlayerID | integer | 32 | Yes | No | Yes |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

StadiumID | integer | 32 | No | No | Yes | The unique ID of the stadium |

Name | string | 100 | No | No | Yes | The full name of the stadium |

City | string | 50 | No | No | Yes | The city where the stadium is located |

State | string | 10 | Yes | No | Yes | The US state where the stadium is located (if Stadium is outside US, this value is NULL) |

Country | string | 10 | No | No | Yes | The 2-digit country code where the stadium is located |

Capacity | integer | 32 | Yes | No | Yes | The estimated seating capacity of the stadium |

PlayingSurface | string | 50 | Yes | No | Yes | The playing surface of the stadium (Grass, Artificial or Dome) |

GeoLat | decimal | 32 | Yes | No | Yes | The geographic latitude coordinate of this venue. |

GeoLong | decimal | 32 | Yes | No | Yes | The geographic longitude coordinate of this venue. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | No | Yes | A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam. |

SeasonType | integer | 32 | No | No | Yes | The type of season that this game corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL season of the game |

Week | integer | 32 | No | No | Yes | The NFL week of the game (weeks 18-21 denote playoff games) |

Date | datetime | No | No | Yes | The date/time of the game | |

AwayTeam | string | 50 | Yes | No | Yes | The abbreviation of the Away Team |

HomeTeam | string | 50 | Yes | No | Yes | The abbreviation of the Home Team |

AwayScore | integer | 32 | Yes | Yes | Yes | The final score of the Away Team |

HomeScore | integer | 32 | Yes | Yes | Yes | The final score of the Home Team |

Channel | string | 50 | Yes | No | Yes | The television station broadcasting the game |

PointSpread | decimal | 32 | Yes | Yes | 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) |

OverUnder | decimal | 32 | Yes | Yes | Yes | The oddsmaker Over/Under at game start |

Quarter | string | 50 | Yes | No | 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 | No | 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 | No | Yes | The team that currently has possession of the ball (PHI, NE, NULL if game is not in progress or at halftime) |

Down | integer | 32 | Yes | Yes | Yes | The current down in the game (1, 2, 3, 4 or NULL) |

Distance | string | 10 | Yes | Yes | Yes | The yards to go for a first down (this can be any positive number or "Goal") |

YardLine | integer | 32 | Yes | No | Yes | The yard line that the ball is currently located, as of the most recently completed play |

YardLineTerritory | string | 10 | Yes | No | Yes | The team's territory that the ball is currently located ("SF", "BAL" or NULL) |

RedZone | string | 10 | Yes | No | Yes | The team that currently has the ball in the opponent's red zone ("SF", "BAL" or NULL) |

AwayScoreQuarter1 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 1 |

AwayScoreQuarter2 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 2 |

AwayScoreQuarter3 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 3 |

AwayScoreQuarter4 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 4 |

AwayScoreOvertime | integer | 32 | Yes | Yes | Yes | Points scored during Overtime |

HomeScoreQuarter1 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 1 |

HomeScoreQuarter2 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 2 |

HomeScoreQuarter3 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 3 |

HomeScoreQuarter4 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 4 |

HomeScoreOvertime | integer | 32 | Yes | Yes | Yes | Points scored during Overtime |

HasStarted | boolean | No | No | Yes | Whether the game has started (true/false) | |

IsInProgress | boolean | No | No | Yes | Whether the game is currently in progress (true/false) | |

IsOver | boolean | No | No | Yes | Whether the game is over (true/false) | |

Has1stQuarterStarted | boolean | No | No | Yes | Whether the 1st quarter has started | |

Has2ndQuarterStarted | boolean | No | No | Yes | Whether the 2nd quarter has started | |

Has3rdQuarterStarted | boolean | No | No | Yes | Whether the 3rd quarter has started | |

Has4thQuarterStarted | boolean | No | No | Yes | Whether the 4th quarter has started | |

IsOvertime | boolean | No | No | Yes | Whether this game went into overtime | |

DownAndDistance | string | 50 | Yes | No | Yes | Description of the down and distance for display purposes |

QuarterDescription | string | 50 | Yes | No | Yes | Description of the current quarter for display purposes |

StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the team's current home stadium |

LastUpdated | datetime | Yes | No | Yes | The date and time that this game was last updated (US Eastern Time) | |

GeoLat | decimal | 32 | Yes | No | Yes | The geographic latitude coordinate of this venue. |

GeoLong | decimal | 32 | Yes | No | Yes | The geographic longitude coordinate of this venue. |

ForecastTempLow | integer | 32 | Yes | No | Yes | The forecasted low temperature on game day at this venue (Fahrenheit). |

ForecastTempHigh | integer | 32 | Yes | No | Yes | The forecasted high temperature on game day at this venue (Fahrenheit). |

ForecastDescription | string | 50 | Yes | No | Yes | The forecast description on game day at this venue. |

ForecastWindChill | integer | 32 | Yes | No | Yes | The forecasted wind chill on game day at this venue. |

ForecastWindSpeed | integer | 32 | Yes | No | Yes | The forecasted wind speed on game day at this venue. |

AwayTeamMoneyLine | integer | 32 | Yes | Yes | Yes | Money line from the perspective of the away team. |

HomeTeamMoneyLine | integer | 32 | Yes | Yes | Yes | Money line from the perspective of the home team. |

Canceled | boolean | Yes | No | Yes | Indicates whether the game was canceled. | |

Closed | boolean | Yes | No | Yes | Indicates whether the game scores, stats, and other information, have been quality checked and closed out. | |

LastPlay | string | 250 | Yes | Yes | No | The description of the most recent play/event of the game. This is for display purposes and does not include corresponding data points. |

Day | date | Yes | No | No | ||

DateTime | datetime | Yes | No | No | ||

AwayTeamID | integer | 32 | Yes | No | No | |

HomeTeamID | integer | 32 | Yes | No | No | |

GlobalGameID | integer | 32 | Yes | No | No | |

GlobalAwayTeamID | integer | 32 | Yes | No | No | |

GlobalHomeTeamID | integer | 32 | Yes | No | No | |

PointSpreadAwayTeamMoneyLine
from 2017 |
integer | 32 | Yes | Yes | No | |

PointSpreadHomeTeamMoneyLine
from 2017 |
integer | 32 | Yes | Yes | No | |

ScoreID | integer | 32 | No | No | Yes | Unique ID of the Score/Game. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | Yes | 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. This value will be NULL for bye weeks. |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL season of the game |

Week | integer | 32 | No | No | Yes | The NFL week of the game (weeks 18-21 denote playoff games) |

Date | datetime | Yes | No | Yes | The date/time of the game | |

AwayTeam | string | 50 | Yes | No | Yes | The abbreviation of the Away Team |

HomeTeam | string | 50 | Yes | No | Yes | The abbreviation of the Home Team |

Channel | string | 50 | Yes | No | Yes | The television station broadcasting the game |

PointSpread | decimal | 32 | Yes | Yes | 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) |

OverUnder | decimal | 32 | Yes | Yes | Yes | The oddsmaker Over/Under at game start |

StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |

Canceled | boolean | Yes | No | Yes | Indicates whether the game was canceled. | |

GeoLat | decimal | 32 | Yes | No | Yes | The geographic latitude coordinate of this venue. |

GeoLong | decimal | 32 | Yes | No | Yes | The geographic longitude coordinate of this venue. |

ForecastTempLow | integer | 32 | Yes | No | Yes | The forecasted low temperature on game day at this venue (Fahrenheit). |

ForecastTempHigh | integer | 32 | Yes | No | Yes | The forecasted high temperature on game day at this venue (Fahrenheit). |

ForecastDescription | string | 50 | Yes | No | Yes | The forecast description on game day at this venue. |

ForecastWindChill | integer | 32 | Yes | No | Yes | The forecasted wind chill on game day at this venue. |

ForecastWindSpeed | integer | 32 | Yes | No | Yes | The forecasted wind speed on game day at this venue. |

AwayTeamMoneyLine | integer | 32 | Yes | Yes | Yes | Money line from the perspective of the away team. |

HomeTeamMoneyLine | integer | 32 | Yes | Yes | Yes | Money line from the perspective of the home team. |

Day | date | Yes | No | No | ||

DateTime | datetime | Yes | No | No | ||

GlobalGameID | integer | 32 | Yes | No | No | |

GlobalAwayTeamID | integer | 32 | Yes | No | No | |

GlobalHomeTeamID | integer | 32 | Yes | No | No | |

ScoreID | integer | 32 | No | No | Yes | Unique ID of the Score/Game. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

Season | integer | 32 | No | No | No | The NFL season during this bye week |

Week | integer | 32 | No | No | No | The NFL week during this bye week |

Team | string | 50 | Yes | No | No | The NFL team who is on bye during this week |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | No | No | A 9 digit unique code identifying the game that this record corresponds to. The GameID is composed of Season, SeasonType, Week and HomeTeam. |

Date | datetime | No | No | Yes | The date/time of the game | |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL season of the game |

Week | integer | 32 | No | No | Yes | The NFL week of the game (weeks 18-21 denote playoff games) |

Stadium
from 2001 |
string | 50 | Yes | No | Yes | Stadium of the event |

PlayingSurface | string | 50 | Yes | No | Yes | Playing surface of the stadium |

Temperature
from 2001 |
integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

Humidity
from 2001 |
integer | 32 | Yes | Yes | Yes | Humidity at game start (Percentage) |

WindSpeed
from 2001 |
integer | 32 | Yes | Yes | Yes | Wind speed at game start (MPH) |

AwayTeam | string | 50 | Yes | No | Yes | The abbreviation of the Away Team |

HomeTeam | string | 50 | Yes | No | Yes | The abbreviation of the Home Team |

AwayScore | integer | 32 | No | Yes | Yes | The final score of the Away Team |

HomeScore | integer | 32 | No | Yes | Yes | The final score of the Home Team |

TotalScore | integer | 32 | Yes | No | Yes | The total score of both teams |

OverUnder | decimal | 32 | Yes | Yes | Yes | The oddsmaker Over/Under at game start |

PointSpread | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Points scored during Quarter 1 |

AwayScoreQuarter2 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 2 |

AwayScoreQuarter3 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 3 |

AwayScoreQuarter4 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 4 |

AwayScoreOvertime | integer | 32 | Yes | Yes | Yes | Points scored during Overtime |

HomeScoreQuarter1 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 1 |

HomeScoreQuarter2 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 2 |

HomeScoreQuarter3 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 3 |

HomeScoreQuarter4 | integer | 32 | Yes | Yes | Yes | Points scored during Quarter 4 |

HomeScoreOvertime | integer | 32 | Yes | Yes | Yes | Points scored during Overtime |

AwayTimeOfPossession | string | 50 | Yes | No | Yes | Time of Possession |

HomeTimeOfPossession | string | 50 | Yes | No | Yes | Time of Possession |

AwayFirstDowns | integer | 32 | Yes | Yes | Yes | Total First Downs |

HomeFirstDowns | integer | 32 | Yes | Yes | Yes | Total First Downs |

AwayFirstDownsByRushing
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing First Downs |

HomeFirstDownsByRushing
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing First Downs |

AwayFirstDownsByPassing
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing First Downs |

HomeFirstDownsByPassing
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing First Downs |

AwayFirstDownsByPenalty
from 2001 |
integer | 32 | Yes | Yes | Yes | First Downs (via Penalty) |

HomeFirstDownsByPenalty
from 2001 |
integer | 32 | Yes | Yes | Yes | First Downs (via Penalty) |

AwayOffensivePlays | integer | 32 | Yes | Yes | Yes | Number of offensive plays run |

HomeOffensivePlays | integer | 32 | Yes | Yes | Yes | Number of offensive plays run |

AwayOffensiveYards | integer | 32 | Yes | Yes | Yes | Number of offensive yards gained |

HomeOffensiveYards | integer | 32 | Yes | Yes | Yes | Number of offensive yards gained |

AwayOffensiveYardsPerPlay | decimal | 32 | Yes | Yes | Yes | Average yards gained per offensive play |

HomeOffensiveYardsPerPlay | decimal | 32 | Yes | Yes | Yes | Average yards gained per offensive play |

AwayTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Touchdowns scored |

HomeTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Touchdowns scored |

AwayRushingAttempts | integer | 32 | Yes | Yes | Yes | Number of rushing attempts |

HomeRushingAttempts | integer | 32 | Yes | Yes | Yes | Number of rushing attempts |

AwayRushingYards | integer | 32 | Yes | Yes | Yes | Number of rushing yards |

HomeRushingYards | integer | 32 | Yes | Yes | Yes | Number of rushing yards |

AwayRushingYardsPerAttempt | decimal | 32 | Yes | Yes | Yes | Average rushing yards gained per attempt |

HomeRushingYardsPerAttempt | decimal | 32 | Yes | Yes | Yes | Average rushing yards gained per attempt |

AwayRushingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing touchdowns scored |

HomeRushingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing touchdowns scored |

AwayPassingAttempts | integer | 32 | Yes | Yes | Yes | Number of passes thrown |

HomePassingAttempts | integer | 32 | Yes | Yes | Yes | Number of passes thrown |

AwayPassingCompletions | integer | 32 | Yes | Yes | Yes | Number of pass completions |

HomePassingCompletions | integer | 32 | Yes | Yes | Yes | Number of pass completions |

AwayPassingYards | integer | 32 | Yes | Yes | Yes | Number of passing yards |

HomePassingYards | integer | 32 | Yes | Yes | Yes | Number of passing yards |

AwayPassingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing touchdowns scored |

HomePassingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing touchdowns scored |

AwayPassingInterceptions | integer | 32 | Yes | Yes | Yes | Interceptions thrown |

HomePassingInterceptions | integer | 32 | Yes | Yes | Yes | Interceptions thrown |

AwayPassingYardsPerAttempt | decimal | 32 | Yes | Yes | Yes | Average passing yards gained per attempt |

HomePassingYardsPerAttempt | decimal | 32 | Yes | Yes | Yes | Average passing yards gained per attempt |

AwayPassingYardsPerCompletion | decimal | 32 | Yes | Yes | Yes | Average passing yards gained per completion |

HomePassingYardsPerCompletion | decimal | 32 | Yes | Yes | Yes | Average passing yards gained per completion |

AwayCompletionPercentage | decimal | 32 | Yes | Yes | Yes | Percentage of passes that were completed |

HomeCompletionPercentage | decimal | 32 | Yes | Yes | Yes | Percentage of passes that were completed |

AwayPasserRating
from 2001 |
decimal | 32 | Yes | Yes | Yes | Passer rating |

HomePasserRating
from 2001 |
decimal | 32 | Yes | Yes | Yes | Passer rating |

AwayThirdDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down attempts |

HomeThirdDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down attempts |

AwayThirdDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down conversions |

HomeThirdDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down conversions |

AwayThirdDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of third downs converted |

HomeThirdDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of third downs converted |

AwayFourthDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down attempts |

HomeFourthDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down attempts |

AwayFourthDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down conversions |

HomeFourthDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down conversions |

AwayFourthDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of fourth downs converted |

HomeFourthDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of fourth downs converted |

AwayRedZoneAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities |

HomeRedZoneAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities |

AwayRedZoneConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities converted to touchdowns |

HomeRedZoneConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities converted to touchdowns |

AwayGoalToGoAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities |

HomeGoalToGoAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities |

AwayGoalToGoConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities converted to touchdowns |

HomeGoalToGoConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities converted to touchdowns |

AwayReturnYards | integer | 32 | Yes | Yes | Yes | Total punt and defensive return yards |

HomeReturnYards | integer | 32 | Yes | Yes | Yes | Total punt and defensive return yards |

AwayPenalties | integer | 32 | Yes | Yes | Yes | Penalties committed |

HomePenalties | integer | 32 | Yes | Yes | Yes | Penalties committed |

AwayPenaltyYards | integer | 32 | Yes | Yes | Yes | Penalty yards enforced against the away team |

HomePenaltyYards | integer | 32 | Yes | Yes | Yes | Penalty yards enforced against the away team |

AwayFumbles | integer | 32 | Yes | Yes | Yes | Fumbles |

HomeFumbles | integer | 32 | Yes | Yes | Yes | Fumbles |

AwayFumblesLost | integer | 32 | Yes | Yes | Yes | Fumbles lost |

HomeFumblesLost | integer | 32 | Yes | Yes | Yes | Fumbles lost |

AwayTimesSacked | integer | 32 | Yes | Yes | Yes | Number of times the away team was sacked |

HomeTimesSacked | integer | 32 | Yes | Yes | Yes | Number of times the away team was sacked |

AwayTimesSackedYards | integer | 32 | Yes | Yes | Yes | Number of yards lost as a result of being sacked |

HomeTimesSackedYards | integer | 32 | Yes | Yes | Yes | Number of yards lost as a result of being sacked |

AwaySafeties | integer | 32 | Yes | Yes | Yes | Safeties scored |

HomeSafeties | integer | 32 | Yes | Yes | Yes | Safeties scored |

AwayPunts | integer | 32 | Yes | Yes | Yes | Number of punts |

HomePunts | integer | 32 | Yes | Yes | Yes | Number of punts |

AwayPuntYards | integer | 32 | Yes | Yes | Yes | Total punt yards |

HomePuntYards | integer | 32 | Yes | Yes | Yes | Total punt yards |

AwayPuntAverage | decimal | 32 | Yes | Yes | Yes | Average number of yards per punt |

HomePuntAverage | decimal | 32 | Yes | Yes | Yes | Average number of yards per punt |

AwayGiveaways | integer | 32 | Yes | Yes | Yes | Number of giveaways |

HomeGiveaways | integer | 32 | Yes | Yes | Yes | Number of giveaways |

AwayTakeaways | integer | 32 | Yes | Yes | Yes | Number of takeaways |

HomeTakeaways | integer | 32 | Yes | Yes | Yes | Number of takeaways |

AwayTurnoverDifferential | integer | 32 | Yes | Yes | Yes | Number of takeaways minus giveaways |

HomeTurnoverDifferential | integer | 32 | Yes | Yes | Yes | Number of takeaways minus giveaways |

AwayKickoffs
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs |

HomeKickoffs
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs |

AwayKickoffsInEndZone
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that went into the end zone |

HomeKickoffsInEndZone
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that went into the end zone |

AwayKickoffTouchbacks
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that resulted in touchbacks |

HomeKickoffTouchbacks
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that resulted in touchbacks |

AwayPuntsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of punts that were blocked |

HomePuntsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of punts that were blocked |

AwayPuntNetAverage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

HomePuntNetAverage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

AwayExtraPointKickingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts |

HomeExtraPointKickingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts |

AwayExtraPointKickingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kicks made |

HomeExtraPointKickingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kicks made |

AwayExtraPointsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts that were blocked |

HomeExtraPointsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts that were blocked |

AwayExtraPointPassingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing attempts |

HomeExtraPointPassingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing attempts |

AwayExtraPointPassingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing conversions |

HomeExtraPointPassingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing conversions |

AwayExtraPointRushingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing attempts |

HomeExtraPointRushingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing attempts |

AwayExtraPointRushingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing conversions |

HomeExtraPointRushingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing conversions |

AwayFieldGoalAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts |

HomeFieldGoalAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts |

AwayFieldGoalsMade
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goals made |

HomeFieldGoalsMade
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goals made |

AwayFieldGoalsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

HomeFieldGoalsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

AwayPuntReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt returns |

HomePuntReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt returns |

AwayPuntReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt return yards |

HomePuntReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt return yards |

AwayKickReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff returns |

HomeKickReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff returns |

AwayKickReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff return yards |

HomeKickReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff return yards |

AwayInterceptionReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Defensive interceptions |

HomeInterceptionReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Defensive interceptions |

AwayInterceptionReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Interception return yards |

HomeInterceptionReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Interception return yards |

AwaySoloTackles | integer | 32 | Yes | Yes | Yes | Defensive solo tackles |

AwayAssistedTackles | integer | 32 | Yes | Yes | Yes | Defensive assisted tackles |

AwayQuarterbackHits | integer | 32 | Yes | Yes | Yes | Defensive QB hits |

AwayTacklesForLoss | integer | 32 | Yes | Yes | Yes | Defensive tackles for a loss |

AwaySacks | integer | 32 | Yes | Yes | Yes | Defensive sacks |

AwaySackYards | integer | 32 | Yes | Yes | Yes | Defensive sack yards |

AwayPassesDefended | integer | 32 | Yes | Yes | Yes | Defensive passes defended |

AwayFumblesForced | integer | 32 | Yes | Yes | Yes | Defensive fumbles forced |

AwayFumblesRecovered | integer | 32 | Yes | Yes | Yes | Fumbles recovered that resulted in change of possession |

AwayFumbleReturnYards | integer | 32 | Yes | Yes | Yes | Fumble return yards |

AwayFumbleReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Fumble return touchdowns |

AwayInterceptionReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Defensive interceptions |

AwayBlockedKicks | integer | 32 | Yes | Yes | Yes | Total number of opponent's kicks that were blocked |

AwayPuntReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Punt return touchdown |

AwayPuntReturnLong | integer | 32 | Yes | Yes | Yes | Longest punt return |

AwayKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Kick return touchdown |

AwayKickReturnLong | integer | 32 | Yes | Yes | Yes | Longest kick return |

AwayBlockedKickReturnYards | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

AwayBlockedKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return touchdowns |

AwayFieldGoalReturnYards | integer | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

AwayFieldGoalReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Field goal return touchdowns (excluding blocked field goals) |

AwayPuntNetYards | integer | 32 | Yes | Yes | Yes | Net punt yards |

HomeSoloTackles | integer | 32 | Yes | Yes | Yes | Defensive solo tackles |

HomeAssistedTackles | integer | 32 | Yes | Yes | Yes | Defensive assisted tackles |

HomeQuarterbackHits | integer | 32 | Yes | Yes | Yes | Defensive QB hits |

HomeTacklesForLoss | integer | 32 | Yes | Yes | Yes | Defensive tackles for a loss |

HomeSacks | integer | 32 | Yes | Yes | Yes | Defensive sacks |

HomeSackYards | integer | 32 | Yes | Yes | Yes | Defensive sack yards |

HomePassesDefended | integer | 32 | Yes | Yes | Yes | Defensive passes defended |

HomeFumblesForced | integer | 32 | Yes | Yes | Yes | Defensive fumbles forced |

HomeFumblesRecovered | integer | 32 | Yes | Yes | Yes | Fumbles recovered that resulted in change of possession |

HomeFumbleReturnYards | integer | 32 | Yes | Yes | Yes | Fumble return yards |

HomeFumbleReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Fumble return touchdowns |

HomeInterceptionReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Defensive interceptions |

HomeBlockedKicks | integer | 32 | Yes | Yes | Yes | Total number of opponent's kicks that were blocked |

HomePuntReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Punt return touchdown |

HomePuntReturnLong | integer | 32 | Yes | Yes | Yes | Longest punt return |

HomeKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Kick return touchdown |

HomeKickReturnLong | integer | 32 | Yes | Yes | Yes | Longest kick return |

HomeBlockedKickReturnYards | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

HomeBlockedKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return touchdowns |

HomeFieldGoalReturnYards | integer | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

HomeFieldGoalReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Field goal return touchdowns (excluding blocked field goals) |

HomePuntNetYards | integer | 32 | Yes | Yes | Yes | Net punt yards |

IsGameOver | boolean | Yes | No | No | Whether the game is over (true/false) | |

GameID | integer | 32 | No | No | Yes | Auto generated unique ID for this game (subject to change, although it very rarely does). For a static ID, use GameKey. |

StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |

AwayTwoPointConversionReturns
from 2015 |
integer | 32 | Yes | Yes | Yes | Two point conversion returns for two points. |

HomeTwoPointConversionReturns
from 2015 |
integer | 32 | Yes | Yes | Yes | Two point conversion returns for two points. |

ScoreID | integer | 32 | No | No | Yes | Unique ID of the Score/Game. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | 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 | Yes | The date/time of the game | |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL season of the game |

Week | integer | 32 | Yes | No | Yes | The NFL week of the game (weeks 18-21 denote playoff games) |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

Opponent | string | 50 | Yes | No | Yes | The abbreviation of the Opponent |

HomeOrAway | string | 4 | Yes | No | Yes | Whether the Team is Home or Away |

Score | integer | 32 | No | No | Yes | The final score of the Team |

OpponentScore | integer | 32 | No | No | Yes | The final score of the Opponent |

TotalScore | integer | 32 | No | No | Yes | The total score of both teams |

Stadium
from 2001 |
string | 50 | Yes | No | Yes | Stadium of the event |

PlayingSurface | string | 50 | Yes | No | Yes | Playing surface of the stadium |

Temperature
from 2001 |
integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

Humidity
from 2001 |
integer | 32 | Yes | Yes | Yes | Humidity at game start (Percentage) |

WindSpeed
from 2001 |
integer | 32 | Yes | Yes | Yes | Wind speed at game start (MPH) |

OverUnder | decimal | 32 | Yes | Yes | Yes | The oddsmaker Over/Under at game start |

PointSpread | decimal | 32 | Yes | Yes | Yes | 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 | Yes | Points scored during Quarter 1 for the Team |

ScoreQuarter2 | integer | 32 | Yes | No | Yes | Points scored during Quarter 2 for the Team |

ScoreQuarter3 | integer | 32 | Yes | No | Yes | Points scored during Quarter 3 for the Team |

ScoreQuarter4 | integer | 32 | Yes | No | Yes | Points scored during Quarter 4 for the Team |

ScoreOvertime | integer | 32 | No | No | Yes | Points scored during Overtime for the Team |

TimeOfPossessionMinutes | integer | 32 | Yes | Yes | Yes | Time of possession minutes |

TimeOfPossessionSeconds | integer | 32 | Yes | Yes | Yes | Time of possession seconds |

TimeOfPossession | string | 50 | Yes | No | Yes | Time of possession |

FirstDowns | integer | 32 | Yes | Yes | Yes | Total first downs |

FirstDownsByRushing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total rushing first downs |

FirstDownsByPassing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total passing first downs |

FirstDownsByPenalty
from 2001 |
integer | 32 | Yes | Yes | Yes | Total first downs by opponent's penalty |

OffensivePlays | integer | 32 | No | Yes | Yes | Number of offensive plays run |

OffensiveYards | integer | 32 | No | Yes | Yes | Number of offensive yards gained |

OffensiveYardsPerPlay | decimal | 32 | No | Yes | Yes | Average yards gained per offensive play |

Touchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Touchdowns scored |

RushingAttempts | integer | 32 | Yes | Yes | Yes | Number of rushing attempts |

RushingYards | integer | 32 | Yes | Yes | Yes | Number of rushing yards |

RushingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average rushing yards gained per attempt |

RushingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing touchdowns scored |

PassingAttempts | integer | 32 | Yes | Yes | Yes | Number of passes thrown |

PassingCompletions | integer | 32 | Yes | Yes | Yes | Number of pass completions |

PassingYards | integer | 32 | Yes | Yes | Yes | Number of passing yards |

PassingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing touchdowns scored |

PassingInterceptions | integer | 32 | Yes | Yes | Yes | Interceptions thrown |

PassingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average passing yards gained per attempt |

PassingYardsPerCompletion | decimal | 32 | No | Yes | Yes | Average passing yards gained per completion |

CompletionPercentage | decimal | 32 | No | Yes | Yes | Percentage of passes that were completed |

PasserRating
from 2001 |
decimal | 32 | Yes | Yes | Yes | Passer rating |

ThirdDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down attempts |

ThirdDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down conversions |

ThirdDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of third downs converted |

FourthDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down attempts |

FourthDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down conversions |

FourthDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of fourth downs converted |

RedZoneAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities |

RedZoneConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities converted to touchdowns |

GoalToGoAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities |

GoalToGoConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities converted to touchdowns |

ReturnYards | integer | 32 | Yes | Yes | Yes | Total punt and defensive return yards |

Penalties | integer | 32 | Yes | Yes | Yes | Penalties committed |

PenaltyYards | integer | 32 | Yes | Yes | Yes | Penalty yards enforced against team |

Fumbles | integer | 32 | Yes | Yes | Yes | Fumbles |

FumblesLost | integer | 32 | Yes | Yes | Yes | Fumbles lost |

TimesSacked | integer | 32 | Yes | Yes | Yes | Number of sacks allowed by Team |

TimesSackedYards | integer | 32 | Yes | Yes | Yes | Number of yards lost as a result of sacks allowed |

QuarterbackHits
from 2006 |
integer | 32 | Yes | Yes | Yes | Number of times the opposing QB was hit (includes sacks) |

TacklesForLoss
from 2008 |
integer | 32 | Yes | Yes | Yes | Number of times the opponent was tackled for a loss |

Safeties | integer | 32 | Yes | Yes | Yes | Safeties scored |

Punts | integer | 32 | Yes | Yes | Yes | Number of punts |

PuntYards | integer | 32 | Yes | Yes | Yes | Total punt yards |

PuntAverage | decimal | 32 | No | Yes | Yes | Average number of yards per punt |

Giveaways | integer | 32 | No | Yes | Yes | Number of giveaways |

Takeaways | integer | 32 | No | Yes | Yes | Number of takeaways |

TurnoverDifferential | integer | 32 | No | Yes | Yes | Number of takeaways minus giveaways |

OpponentScoreQuarter1 | integer | 32 | Yes | No | Yes | Points scored during Quarter 1 for the Team |

OpponentScoreQuarter2 | integer | 32 | Yes | No | Yes | Points scored during Quarter 2 for the Team |

OpponentScoreQuarter3 | integer | 32 | Yes | No | Yes | Points scored during Quarter 3 for the Team |

OpponentScoreQuarter4 | integer | 32 | Yes | No | Yes | Points scored during Quarter 4 for the Team |

OpponentScoreOvertime | integer | 32 | No | No | Yes | Points scored during Overtime for the Team |

OpponentTimeOfPossessionMinutes | integer | 32 | Yes | Yes | Yes | Time of possession minutes |

OpponentTimeOfPossessionSeconds | integer | 32 | Yes | Yes | Yes | Time of possession seconds |

OpponentTimeOfPossession | string | 50 | Yes | No | Yes | Time of possession |

OpponentFirstDowns | integer | 32 | Yes | Yes | Yes | Total first downs |

OpponentFirstDownsByRushing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total rushing first downs |

OpponentFirstDownsByPassing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total passing first downs |

OpponentFirstDownsByPenalty
from 2001 |
integer | 32 | Yes | Yes | Yes | Total first downs by opponent's penalty |

OpponentOffensivePlays | integer | 32 | No | Yes | Yes | Number of offensive plays run |

OpponentOffensiveYards | integer | 32 | No | Yes | Yes | Number of offensive yards gained |

OpponentOffensiveYardsPerPlay | decimal | 32 | No | Yes | Yes | Average yards gained per offensive play |

OpponentTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Touchdowns scored |

OpponentRushingAttempts | integer | 32 | Yes | Yes | Yes | Number of rushing attempts |

OpponentRushingYards | integer | 32 | Yes | Yes | Yes | Number of rushing yards |

OpponentRushingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average rushing yards gained per attempt |

OpponentRushingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing touchdowns scored |

OpponentPassingAttempts | integer | 32 | Yes | Yes | Yes | Number of passes thrown |

OpponentPassingCompletions | integer | 32 | Yes | Yes | Yes | Number of pass completions |

OpponentPassingYards | integer | 32 | Yes | Yes | Yes | Number of passing yards |

OpponentPassingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing touchdowns scored |

OpponentPassingInterceptions | integer | 32 | Yes | Yes | Yes | Interceptions thrown |

OpponentPassingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average passing yards gained per attempt |

OpponentPassingYardsPerCompletion | decimal | 32 | No | Yes | Yes | Average passing yards gained per completion |

OpponentCompletionPercentage | decimal | 32 | No | Yes | Yes | Percentage of passes that were completed |

OpponentPasserRating
from 2001 |
decimal | 32 | Yes | Yes | Yes | Passer rating |

OpponentThirdDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down attempts |

OpponentThirdDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down conversions |

OpponentThirdDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of third downs converted |

OpponentFourthDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down attempts |

OpponentFourthDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down conversions |

OpponentFourthDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of fourth downs converted |

OpponentRedZoneAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities |

OpponentRedZoneConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities converted to touchdowns |

OpponentGoalToGoAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities |

OpponentGoalToGoConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities converted to touchdowns |

OpponentReturnYards | integer | 32 | Yes | Yes | Yes | Total punt and defensive return yards |

OpponentPenalties | integer | 32 | Yes | Yes | Yes | Penalties committed |

OpponentPenaltyYards | integer | 32 | Yes | Yes | Yes | Penalty yards enforced against the opponent |

OpponentFumbles | integer | 32 | Yes | Yes | Yes | Fumbles |

OpponentFumblesLost | integer | 32 | Yes | Yes | Yes | Fumbles lost |

OpponentTimesSacked | integer | 32 | Yes | Yes | Yes | Number of sacks allowed by Opponent |

OpponentTimesSackedYards | integer | 32 | Yes | Yes | Yes | Number of yards opponent lost as a result of being sacked |

OpponentQuarterbackHits
from 2006 |
integer | 32 | Yes | Yes | Yes | Number of times our QB was hit but not sacked |

OpponentTacklesForLoss
from 2008 |
integer | 32 | Yes | Yes | Yes | Number of times our ball carrier was tackled for a loss |

OpponentSafeties
from 2001 |
integer | 32 | Yes | Yes | Yes | Safeties scored |

OpponentPunts | integer | 32 | Yes | Yes | Yes | Number of punts |

OpponentPuntYards | integer | 32 | Yes | Yes | Yes | Total punt yards |

OpponentPuntAverage | decimal | 32 | No | Yes | Yes | Average number of yards per punt |

OpponentGiveaways | integer | 32 | No | Yes | Yes | Number of giveaways |

OpponentTakeaways | integer | 32 | No | Yes | Yes | Number of takeaways |

OpponentTurnoverDifferential | integer | 32 | No | Yes | Yes | Number of takeaways minus giveaways |

RedZonePercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of red zone opportunities converted into touchdowns |

GoalToGoPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of goal-to-go opportunities converted into touchdowns |

QuarterbackHitsDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The differential of hits on the opposing quarterback minus hits on own team's quarterback |

TacklesForLossDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The differential of tackles for loss minus opponent's tackles for loss |

QuarterbackSacksDifferential
from 2001 |
integer | 32 | No | Yes | Yes | The Team's sack differential (similar to a turnover differential) |

TacklesForLossPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of running plays defended that resulted in tackle for loss |

QuarterbackHitsPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percantage of opposing quarterback drop backs that resulted hitting the quarterback |

TimesSackedPercentage
from 2001 |
decimal | 32 | No | No | Yes | Percentage of drop backs that resulted in a sack |

OpponentRedZonePercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of opponent's red zone opportunities converted into touchdowns |

OpponentGoalToGoPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of opponent's goal-to-go opportunities converted into touchdowns |

OpponentQuarterbackHitsDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The inverse of QuarterbackHitsDifferential |

OpponentTacklesForLossDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The inverse of TacklesForLossDifferential |

OpponentQuarterbackSacksDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The inverse of QuarterbackSacksDifferential |

OpponentTacklesForLossPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of running plays defended that resulted in tackle for loss |

OpponentQuarterbackHitsPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percantage of own team's quarterback drop backs that resulted in our quarterback getting hit |

OpponentTimesSackedPercentage
from 2001 |
decimal | 32 | No | Yes | Yes | Percentage of drop backs that resulted in a sack |

Kickoffs
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs |

KickoffsInEndZone
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that went into the end zone |

KickoffTouchbacks
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that resulted in touchbacks |

PuntsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of punts that were blocked |

PuntNetAverage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

ExtraPointKickingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts |

ExtraPointKickingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kicks made |

ExtraPointsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts that were blocked |

ExtraPointPassingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing attempts |

ExtraPointPassingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing conversions |

ExtraPointRushingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing attempts |

ExtraPointRushingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing conversions |

FieldGoalAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts |

FieldGoalsMade
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goals made |

FieldGoalsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

PuntReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt returns |

PuntReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt return yards |

KickReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff returns |

KickReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff return yards |

InterceptionReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Defensive interceptions |

InterceptionReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Interception return yards |

OpponentKickoffs
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs |

OpponentKickoffsInEndZone
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that went into the end zone |

OpponentKickoffTouchbacks
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that resulted in touchbacks |

OpponentPuntsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of punts that were blocked |

OpponentPuntNetAverage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

OpponentExtraPointKickingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts |

OpponentExtraPointKickingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kicks made |

OpponentExtraPointsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts that were blocked |

OpponentExtraPointPassingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing attempts |

OpponentExtraPointPassingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing conversions |

OpponentExtraPointRushingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing attempts |

OpponentExtraPointRushingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing conversions |

OpponentFieldGoalAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts |

OpponentFieldGoalsMade
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goals made |

OpponentFieldGoalsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

OpponentPuntReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt returns |

OpponentPuntReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt return yards |

OpponentKickReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff returns |

OpponentKickReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff return yards |

OpponentInterceptionReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Defensive interceptions |

OpponentInterceptionReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Interception return yards |

SoloTackles | integer | 32 | Yes | Yes | Yes | Defensive solo tackles |

AssistedTackles | integer | 32 | Yes | Yes | Yes | Defensive assisted tackles |

Sacks | integer | 32 | Yes | Yes | Yes | Defensive sacks |

SackYards | integer | 32 | Yes | Yes | Yes | Defensive sack yards |

PassesDefended | integer | 32 | Yes | Yes | Yes | Defensive passes defended |

FumblesForced | integer | 32 | Yes | Yes | Yes | Defensive fumbles forced |

FumblesRecovered | integer | 32 | Yes | Yes | Yes | Fumbles recovered that resulted in change of possession |

FumbleReturnYards | integer | 32 | Yes | Yes | Yes | Fumble return yards |

FumbleReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Fumble return touchdowns |

InterceptionReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Defensive interceptions |

BlockedKicks | integer | 32 | Yes | Yes | Yes | Total number of opponent's kicks that were blocked |

PuntReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Punt return touchdown |

PuntReturnLong | integer | 32 | Yes | Yes | Yes | Longest punt return |

KickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Kick return touchdown |

KickReturnLong | integer | 32 | Yes | Yes | Yes | Longest kick return |

BlockedKickReturnYards | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

BlockedKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return touchdowns |

FieldGoalReturnYards | integer | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

FieldGoalReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Field goal return touchdowns (excluding blocked field goals) |

PuntNetYards | integer | 32 | Yes | Yes | Yes | Net punt yards |

OpponentSoloTackles | integer | 32 | Yes | Yes | Yes | Defensive solo tackles |

OpponentAssistedTackles | integer | 32 | Yes | Yes | Yes | Defensive assisted tackles |

OpponentSacks | integer | 32 | Yes | Yes | Yes | Defensive sacks |

OpponentSackYards | integer | 32 | Yes | Yes | Yes | Defensive sack yards |

OpponentPassesDefended | integer | 32 | Yes | Yes | Yes | Defensive passes defended |

OpponentFumblesForced | integer | 32 | Yes | Yes | Yes | Defensive fumbles forced |

OpponentFumblesRecovered | integer | 32 | Yes | Yes | Yes | Fumbles recovered that resulted in change of possession |

OpponentFumbleReturnYards | integer | 32 | Yes | Yes | Yes | Fumble return yards |

OpponentFumbleReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Fumble return touchdowns |

OpponentInterceptionReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Defensive interceptions |

OpponentBlockedKicks | integer | 32 | Yes | Yes | Yes | Total number of opponent's kicks that were blocked |

OpponentPuntReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Punt return touchdown |

OpponentPuntReturnLong | integer | 32 | Yes | Yes | Yes | Longest punt return |

OpponentKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Kick return touchdown |

OpponentKickReturnLong | integer | 32 | Yes | Yes | Yes | Longest kick return |

OpponentBlockedKickReturnYards | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

OpponentBlockedKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return touchdowns |

OpponentFieldGoalReturnYards | integer | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

OpponentFieldGoalReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Field goal return touchdowns (excluding blocked field goals) |

OpponentPuntNetYards | integer | 32 | Yes | Yes | Yes | Net punt yards |

IsGameOver | boolean | Yes | No | No | Whether the game is over (true/false) | |

TeamName | string | 50 | Yes | No | Yes | The full name of the team (e.g. New England Patriots) |

DayOfWeek | string | 50 | Yes | No | Yes | The day of the week this game was played on (e.g. Sunday, Monday) |

PassingDropbacks | integer | 32 | Yes | Yes | Yes | The number of times the offense dropped back to pass |

OpponentPassingDropbacks | integer | 32 | Yes | Yes | Yes | The number of times the opponent dropped back to pass |

TeamGameID | integer | 32 | No | No | No | Unique ID of this TeamGame record (subject to change, although it very rarely does). For a guaranteed static ID, use a combination of GameKey and Team. |

PointDifferential | integer | 32 | Yes | No | No | |

PassingInterceptionPercentage | decimal | 32 | Yes | No | No | |

PuntReturnAverage | decimal | 32 | Yes | No | No | |

KickReturnAverage | decimal | 32 | Yes | No | No | |

ExtraPointPercentage | decimal | 32 | Yes | No | No | |

FieldGoalPercentage | decimal | 32 | Yes | No | No | |

OpponentPassingInterceptionPercentage | decimal | 32 | Yes | No | No | |

OpponentPuntReturnAverage | decimal | 32 | Yes | No | No | |

OpponentKickReturnAverage | decimal | 32 | Yes | No | No | |

OpponentExtraPointPercentage | decimal | 32 | Yes | No | No | |

OpponentFieldGoalPercentage | decimal | 32 | Yes | No | No | |

PenaltyYardDifferential | integer | 32 | Yes | No | No | |

PuntReturnYardDifferential | integer | 32 | Yes | No | No | |

KickReturnYardDifferential | integer | 32 | Yes | No | No | |

TwoPointConversionReturns | integer | 32 | Yes | No | Yes | Two point conversion returns for two points. |

OpponentTwoPointConversionReturns | integer | 32 | Yes | No | Yes | Opponent's two point conversion returns for two points. |

TeamID | integer | 32 | Yes | No | Yes | |

OpponentID | integer | 32 | Yes | No | Yes | |

Day | date | Yes | No | Yes | ||

DateTime | datetime | Yes | No | Yes | ||

GlobalGameID | integer | 32 | Yes | No | No | |

GlobalTeamID | integer | 32 | Yes | No | No | |

GlobalOpponentID | integer | 32 | Yes | No | Yes | |

ScoreID | integer | 32 | No | No | Yes | Unique ID of the Score/Game. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL regular season for which these totals apply |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

Score | integer | 32 | No | No | Yes | Total points scored |

OpponentScore | integer | 32 | No | No | Yes | Total points scored by opponents |

TotalScore | integer | 32 | No | No | Yes | Total points scored by both teams |

Temperature
from 2001 |
integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

Humidity
from 2001 |
integer | 32 | Yes | Yes | Yes | Humidity at game start (Percentage) |

WindSpeed
from 2001 |
integer | 32 | Yes | Yes | Yes | Wind speed at game start (MPH) |

OverUnder | decimal | 32 | Yes | Yes | Yes | The average Over/Under for the season |

PointSpread | decimal | 32 | Yes | Yes | Yes | The average Point Spread for the season (from the perspective of the Team) |

ScoreQuarter1 | integer | 32 | Yes | No | Yes | Points scored during Quarter 1 for the Team |

ScoreQuarter2 | integer | 32 | Yes | No | Yes | Points scored during Quarter 2 for the Team |

ScoreQuarter3 | integer | 32 | Yes | No | Yes | Points scored during Quarter 3 for the Team |

ScoreQuarter4 | integer | 32 | Yes | No | Yes | Points scored during Quarter 4 for the Team |

ScoreOvertime | integer | 32 | No | No | Yes | Points scored during Overtime for the Team |

TimeOfPossession | string | 50 | Yes | No | Yes | Time of possession |

FirstDowns | integer | 32 | Yes | Yes | Yes | Total first downs |

FirstDownsByRushing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total rushing first downs |

FirstDownsByPassing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total passing first downs |

FirstDownsByPenalty
from 2001 |
integer | 32 | Yes | Yes | Yes | Total first downs by opponent's penalty |

OffensivePlays | integer | 32 | No | Yes | Yes | Number of offensive plays run |

OffensiveYards | integer | 32 | No | Yes | Yes | Number of offensive yards gained |

OffensiveYardsPerPlay | decimal | 32 | No | Yes | Yes | Average yards gained per offensive play |

Touchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Touchdowns scored |

RushingAttempts | integer | 32 | Yes | Yes | Yes | Number of rushing attempts |

RushingYards | integer | 32 | Yes | Yes | Yes | Number of rushing yards |

RushingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average rushing yards gained per attempt |

RushingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing touchdowns scored |

PassingAttempts | integer | 32 | Yes | Yes | Yes | Number of passes thrown |

PassingCompletions | integer | 32 | Yes | Yes | Yes | Number of pass completions |

PassingYards | integer | 32 | Yes | Yes | Yes | Number of passing yards |

PassingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing touchdowns scored |

PassingInterceptions | integer | 32 | Yes | Yes | Yes | Interceptions thrown |

PassingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average passing yards gained per attempt |

PassingYardsPerCompletion | decimal | 32 | No | Yes | Yes | Average passing yards gained per completion |

CompletionPercentage | decimal | 32 | No | Yes | Yes | Percentage of passes that were completed |

PasserRating
from 2001 |
decimal | 32 | Yes | Yes | Yes | Passer rating |

ThirdDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down attempts |

ThirdDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down conversions |

ThirdDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of third downs converted |

FourthDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down attempts |

FourthDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down conversions |

FourthDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of fourth downs converted |

RedZoneAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities |

RedZoneConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities converted to touchdowns |

GoalToGoAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities |

GoalToGoConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities converted to touchdowns |

ReturnYards | integer | 32 | Yes | Yes | Yes | Total punt and defensive return yards |

Penalties | integer | 32 | Yes | Yes | Yes | Penalties committed |

PenaltyYards | integer | 32 | Yes | Yes | Yes | Penalty yards enforced against the Team |

Fumbles | integer | 32 | Yes | Yes | Yes | Fumbles |

FumblesLost | integer | 32 | Yes | Yes | Yes | Fumbles lost |

TimesSacked | integer | 32 | Yes | Yes | Yes | Number of sacks allowed by Team |

TimesSackedYards | integer | 32 | Yes | Yes | Yes | Number of yards lost as a result of sacks allowed |

QuarterbackHits
from 2006 |
integer | 32 | Yes | Yes | Yes | Number of times the opposing QB was hit but not sacked |

TacklesForLoss
from 2008 |
integer | 32 | Yes | Yes | Yes | Number of times the opponent was tackled for a loss |

Safeties
from 2001 |
integer | 32 | Yes | Yes | Yes | Safeties scored |

Punts | integer | 32 | Yes | Yes | Yes | Number of punts |

PuntYards | integer | 32 | Yes | Yes | Yes | Total punt yards |

PuntAverage | decimal | 32 | No | Yes | Yes | Average number of yards per punt |

Giveaways | integer | 32 | No | Yes | Yes | Number of giveaways |

Takeaways | integer | 32 | No | Yes | Yes | Number of takeaways |

TurnoverDifferential | integer | 32 | No | Yes | Yes | Number of takeaways minus giveaways |

OpponentScoreQuarter1 | integer | 32 | Yes | No | Yes | Points scored during Quarter 1 for the Team |

OpponentScoreQuarter2 | integer | 32 | Yes | No | Yes | Points scored during Quarter 2 for the Team |

OpponentScoreQuarter3 | integer | 32 | Yes | No | Yes | Points scored during Quarter 3 for the Team |

OpponentScoreQuarter4 | integer | 32 | Yes | No | Yes | Points scored during Quarter 4 for the Team |

OpponentScoreOvertime | integer | 32 | No | No | Yes | Points scored during Overtime for the Team |

OpponentTimeOfPossession | string | 50 | Yes | No | Yes | Time of possession |

OpponentFirstDowns | integer | 32 | Yes | Yes | Yes | Total first downs |

OpponentFirstDownsByRushing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total rushing first downs |

OpponentFirstDownsByPassing
from 2001 |
integer | 32 | Yes | Yes | Yes | Total passing first downs |

OpponentFirstDownsByPenalty
from 2001 |
integer | 32 | Yes | Yes | Yes | Total first downs by opponent's penalty |

OpponentOffensivePlays | integer | 32 | No | Yes | Yes | Number of offensive plays run |

OpponentOffensiveYards | integer | 32 | No | Yes | Yes | Number of offensive yards gained |

OpponentOffensiveYardsPerPlay | decimal | 32 | No | Yes | Yes | Average yards gained per offensive play |

OpponentTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Touchdowns scored |

OpponentRushingAttempts | integer | 32 | Yes | Yes | Yes | Number of rushing attempts |

OpponentRushingYards | integer | 32 | Yes | Yes | Yes | Number of rushing yards |

OpponentRushingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average rushing yards gained per attempt |

OpponentRushingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Rushing touchdowns scored |

OpponentPassingAttempts | integer | 32 | Yes | Yes | Yes | Number of passes thrown |

OpponentPassingCompletions | integer | 32 | Yes | Yes | Yes | Number of pass completions |

OpponentPassingYards | integer | 32 | Yes | Yes | Yes | Number of passing yards |

OpponentPassingTouchdowns
from 2001 |
integer | 32 | Yes | Yes | Yes | Passing touchdowns scored |

OpponentPassingInterceptions | integer | 32 | Yes | Yes | Yes | Interceptions thrown |

OpponentPassingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average passing yards gained per attempt |

OpponentPassingYardsPerCompletion | decimal | 32 | No | Yes | Yes | Average passing yards gained per completion |

OpponentCompletionPercentage | decimal | 32 | No | Yes | Yes | Percentage of passes that were completed |

OpponentPasserRating
from 2001 |
decimal | 32 | Yes | Yes | Yes | Passer rating |

OpponentThirdDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down attempts |

OpponentThirdDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Third down conversions |

OpponentThirdDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of third downs converted |

OpponentFourthDownAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down attempts |

OpponentFourthDownConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Fourth down conversions |

OpponentFourthDownPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of fourth downs converted |

OpponentRedZoneAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities |

OpponentRedZoneConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Red zone opportunities converted to touchdowns |

OpponentGoalToGoAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities |

OpponentGoalToGoConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | 1st & Goal opportunities converted to touchdowns |

OpponentReturnYards | integer | 32 | Yes | Yes | Yes | Total punt and defensive return yards |

OpponentPenalties | integer | 32 | Yes | Yes | Yes | Penalties committed |

OpponentPenaltyYards | integer | 32 | Yes | Yes | Yes | Penalty yards enforced against the away team |

OpponentFumbles | integer | 32 | Yes | Yes | Yes | Fumbles |

OpponentFumblesLost | integer | 32 | Yes | Yes | Yes | Fumbles lost |

OpponentTimesSacked | integer | 32 | Yes | Yes | Yes | Number of sacks allowed by Opponent |

OpponentTimesSackedYards | integer | 32 | Yes | Yes | Yes | Number of yards opponent lost as a result of being sacked |

OpponentQuarterbackHits
from 2006 |
integer | 32 | Yes | Yes | Yes | Number of times the opposing QB was hit but not sacked |

OpponentTacklesForLoss
from 2008 |
integer | 32 | Yes | Yes | Yes | Number of times our ball carrier was tackled for a loss |

OpponentSafeties
from 2001 |
integer | 32 | Yes | Yes | Yes | Safeties scored |

OpponentPunts | integer | 32 | Yes | Yes | Yes | Number of punts |

OpponentPuntYards | integer | 32 | Yes | Yes | Yes | Total punt yards |

OpponentPuntAverage | decimal | 32 | No | Yes | Yes | Average number of yards per punt |

OpponentGiveaways | integer | 32 | No | Yes | Yes | Number of giveaways |

OpponentTakeaways | integer | 32 | No | Yes | Yes | Number of takeaways |

OpponentTurnoverDifferential | integer | 32 | No | Yes | Yes | Number of takeaways minus giveaways |

RedZonePercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of red zone opportunities converted into touchdowns |

GoalToGoPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of goal-to-go opportunities converted into touchdowns |

QuarterbackHitsDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The differential of hits on the opposing quarterback minus hits on own team's quarterback |

TacklesForLossDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The differential of tackles for loss minus opponent's tackles for loss |

QuarterbackSacksDifferential
from 2001 |
integer | 32 | No | Yes | Yes | The Team's sack differential (similar to a turnover differential) |

TacklesForLossPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of running plays defended that resulted in tackle for loss |

QuarterbackHitsPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percantage of opposing quarterback drop backs that resulted hitting the quarterback |

TimesSackedPercentage
from 2001 |
decimal | 32 | No | No | Yes | Percentage of drop backs that resulted in a sack |

OpponentRedZonePercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of opponent's red zone opportunities converted into touchdowns |

OpponentGoalToGoPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of opponent's goal-to-go opportunities converted into touchdowns |

OpponentQuarterbackHitsDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The inverse of QuarterbackHitsDifferential |

OpponentTacklesForLossDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The inverse of TacklesForLossDifferential |

OpponentQuarterbackSacksDifferential
from 2001 |
integer | 32 | Yes | Yes | Yes | The inverse of QuarterbackSacksDifferential |

OpponentTacklesForLossPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percentage of running plays defended that resulted in tackle for loss |

OpponentQuarterbackHitsPercentage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Percantage of own team's quarterback drop backs that resulted in our quarterback getting hit |

OpponentTimesSackedPercentage
from 2001 |
decimal | 32 | No | Yes | Yes | Percentage of drop backs that resulted in a sack |

Kickoffs
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs |

KickoffsInEndZone
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that went into the end zone |

KickoffTouchbacks
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that resulted in touchbacks |

PuntsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of punts that were blocked |

PuntNetAverage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

ExtraPointKickingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts |

ExtraPointKickingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kicks made |

ExtraPointsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts that were blocked |

ExtraPointPassingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing attempts |

ExtraPointPassingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing conversions |

ExtraPointRushingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing attempts |

ExtraPointRushingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing conversions |

FieldGoalAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts |

FieldGoalsMade
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goals made |

FieldGoalsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

PuntReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt returns |

PuntReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt return yards |

KickReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff returns |

KickReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff return yards |

InterceptionReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Defensive interceptions |

InterceptionReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Interception return yards |

OpponentKickoffs
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs |

OpponentKickoffsInEndZone
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that went into the end zone |

OpponentKickoffTouchbacks
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of kickoffs that resulted in touchbacks |

OpponentPuntsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Number of punts that were blocked |

OpponentPuntNetAverage
from 2001 |
decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

OpponentExtraPointKickingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts |

OpponentExtraPointKickingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kicks made |

OpponentExtraPointsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Extra point kick attempts that were blocked |

OpponentExtraPointPassingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing attempts |

OpponentExtraPointPassingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion passing conversions |

OpponentExtraPointRushingAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing attempts |

OpponentExtraPointRushingConversions
from 2001 |
integer | 32 | Yes | Yes | Yes | Two point conversion rushing conversions |

OpponentFieldGoalAttempts
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts |

OpponentFieldGoalsMade
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goals made |

OpponentFieldGoalsHadBlocked
from 2001 |
integer | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

OpponentPuntReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt returns |

OpponentPuntReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Punt return yards |

OpponentKickReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff returns |

OpponentKickReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Kickoff return yards |

OpponentInterceptionReturns
from 2001 |
integer | 32 | Yes | Yes | Yes | Defensive interceptions |

OpponentInterceptionReturnYards
from 2001 |
integer | 32 | Yes | Yes | Yes | Interception return yards |

SoloTackles | integer | 32 | Yes | Yes | Yes | Defensive solo tackles |

AssistedTackles | integer | 32 | Yes | Yes | Yes | Defensive assisted tackles |

Sacks | integer | 32 | Yes | Yes | Yes | Defensive sacks |

SackYards | integer | 32 | Yes | Yes | Yes | Defensive sack yards |

PassesDefended | integer | 32 | Yes | Yes | Yes | Defensive passes defended |

FumblesForced | integer | 32 | Yes | Yes | Yes | Defensive fumbles forced |

FumblesRecovered | integer | 32 | Yes | Yes | Yes | Fumbles recovered that resulted in change of possession |

FumbleReturnYards | integer | 32 | Yes | Yes | Yes | Fumble return yards |

FumbleReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Fumble return touchdowns |

InterceptionReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Defensive interceptions |

BlockedKicks | integer | 32 | Yes | Yes | Yes | Total number of opponent's kicks that were blocked |

PuntReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Punt return touchdown |

PuntReturnLong | integer | 32 | Yes | Yes | Yes | Longest punt return |

KickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Kick return touchdown |

KickReturnLong | integer | 32 | Yes | Yes | Yes | Longest kick return |

BlockedKickReturnYards | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

BlockedKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return touchdowns |

FieldGoalReturnYards | integer | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

FieldGoalReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Field goal return touchdowns (excluding blocked field goals) |

PuntNetYards | integer | 32 | Yes | Yes | Yes | Net punt yards |

OpponentSoloTackles | integer | 32 | Yes | Yes | Yes | Defensive solo tackles |

OpponentAssistedTackles | integer | 32 | Yes | Yes | Yes | Defensive assisted tackles |

OpponentSacks | integer | 32 | Yes | Yes | Yes | Defensive sacks |

OpponentSackYards | integer | 32 | Yes | Yes | Yes | Defensive sack yards |

OpponentPassesDefended | integer | 32 | Yes | Yes | Yes | Defensive passes defended |

OpponentFumblesForced | integer | 32 | Yes | Yes | Yes | Defensive fumbles forced |

OpponentFumblesRecovered | integer | 32 | Yes | Yes | Yes | Fumbles recovered that resulted in change of possession |

OpponentFumbleReturnYards | integer | 32 | Yes | Yes | Yes | Fumble return yards |

OpponentFumbleReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Fumble return touchdowns |

OpponentInterceptionReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Defensive interceptions |

OpponentBlockedKicks | integer | 32 | Yes | Yes | Yes | Total number of opponent's kicks that were blocked |

OpponentPuntReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Punt return touchdown |

OpponentPuntReturnLong | integer | 32 | Yes | Yes | Yes | Longest punt return |

OpponentKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Kick return touchdown |

OpponentKickReturnLong | integer | 32 | Yes | Yes | Yes | Longest kick return |

OpponentBlockedKickReturnYards | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

OpponentBlockedKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Blocked kick recovery return touchdowns |

OpponentFieldGoalReturnYards | integer | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

OpponentFieldGoalReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Field goal return touchdowns (excluding blocked field goals) |

OpponentPuntNetYards | integer | 32 | Yes | Yes | Yes | Net punt yards |

TeamName | string | 50 | Yes | No | Yes | The full name of the team (e.g. New England Patriots) |

Games | integer | 32 | Yes | No | Yes | Total number of regular season games played |

PassingDropbacks | integer | 32 | Yes | Yes | Yes | The number of times the offense dropped back to pass |

OpponentPassingDropbacks | integer | 32 | Yes | Yes | Yes | The number of times the opponent dropped back to pass |

TeamSeasonID | integer | 32 | No | No | No | The unique identifier for this TeamSeason record (subject to change, although it very rarely does). For a static ID, use a combination of SeasonType, Season and Team. |

PointDifferential | integer | 32 | Yes | No | No | |

PassingInterceptionPercentage | decimal | 32 | Yes | No | No | |

PuntReturnAverage | decimal | 32 | Yes | No | No | |

KickReturnAverage | decimal | 32 | Yes | No | No | |

ExtraPointPercentage | decimal | 32 | Yes | No | No | |

FieldGoalPercentage | decimal | 32 | Yes | No | No | |

OpponentPassingInterceptionPercentage | decimal | 32 | Yes | No | No | |

OpponentPuntReturnAverage | decimal | 32 | Yes | No | No | |

OpponentKickReturnAverage | decimal | 32 | Yes | No | No | |

OpponentExtraPointPercentage | decimal | 32 | Yes | No | No | |

OpponentFieldGoalPercentage | decimal | 32 | Yes | No | No | |

PenaltyYardDifferential | integer | 32 | Yes | No | No | |

PuntReturnYardDifferential | integer | 32 | Yes | No | No | |

KickReturnYardDifferential | integer | 32 | Yes | No | No | |

TwoPointConversionReturns | integer | 32 | Yes | No | Yes | Two point conversion returns for two points. |

OpponentTwoPointConversionReturns | integer | 32 | Yes | No | Yes | Opponent's two point conversion returns for two points. |

TeamID | integer | 32 | Yes | No | Yes | |

GlobalTeamID | integer | 32 | Yes | No | No |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL regular season for which these totals apply |

Conference | string | 50 | Yes | No | Yes | The conference of the team (e.g. AFC or NFC) |

Division | string | 50 | Yes | No | Yes | The division of the team (e.g. East, North, South, West) |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

Name | string | 50 | Yes | No | Yes | The full name of the team |

Wins | integer | 32 | No | No | Yes | Regular season wins |

Losses | integer | 32 | No | No | Yes | Regular season losses |

Ties | integer | 32 | No | No | Yes | Regular season ties |

Percentage | decimal | 32 | No | Yes | Yes | Winning percentage |

PointsFor | integer | 32 | No | Yes | Yes | Points scored during regular season games |

PointsAgainst | integer | 32 | No | Yes | Yes | Points allowed during regular season games |

NetPoints | integer | 32 | No | No | Yes | Difference between PointsFor and PointsAgainst |

Touchdowns | integer | 32 | Yes | Yes | Yes | Total touchdowns scored |

DivisionWins | integer | 32 | No | No | Yes | Regular season wins within the division |

DivisionLosses | integer | 32 | No | No | Yes | Regular season losses within the division |

ConferenceWins | integer | 32 | No | No | Yes | Regular season wins within the conference |

ConferenceLosses | integer | 32 | No | No | Yes | Regular season losses within the conference |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

FantasyPlayerKey | string | 10 | No | No | No | Unique identifier of this fantasy player. If this is a team defense, then this is the abbreviation of the team. This field contains both integers and strings and should be treated as a string. This value is guaranteed to be unique among all players and teams and can be used as the primary key for the FantasyPlayer table. |

PlayerID | integer | 32 | No | No | No | PlayerID of this FantasyPlayer. For players, this is the same as the PlayerID. For teams, this is the uniquely generated PlayerID on the Team table. This number is guaranteed to be unique among all players and teams and can be used as the primary key for the FantasyPlayer table. |

Name | string | 50 | No | No | No | The name of the player or team. |

Team | string | 10 | Yes | No | No | The abbreviation of the team this player is on. If player is a free agent, this field is NULL. |

Position | string | 10 | No | No | No | The fantasy position of this player or team (QB, RB, WR, TE, K, DEF) |

AverageDraftPosition | decimal | 32 | Yes | Yes | No | The average draft position of this player in re-draft leagues. |

AverageDraftPositionPPR | decimal | 32 | Yes | Yes | No | The average draft position of this player in PPR re-draft leagues. |

ByeWeek | integer | 32 | Yes | No | No | The bye week of the team this player is currently on. |

LastSeasonFantasyPoints | decimal | 32 | Yes | Yes | No | The fantasy points scored by this player or team last season. |

ProjectedFantasyPoints | decimal | 32 | Yes | Yes | No | The projected fantasy points this player will score this upcoming season. |

AuctionValue | integer | 32 | Yes | Yes | No | Player's dollar value in a $200 salary cap auction draft. |

AuctionValuePPR | integer | 32 | Yes | Yes | No | Player's dollar value in a $200 salary cap PPR auction draft. |

AverageDraftPositionIDP | integer | 32 | Yes | Yes | No | The average draft position of this player in IDP re-draft leagues. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

PlayerID | integer | 32 | No | No | Yes | Unique ID assigned to each player that stays with them throughout their career |

Team | string | 10 | Yes | No | 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 | No | Yes | Player's jersey number |

FirstName | string | 50 | Yes | No | Yes | Player's first name |

LastName | string | 50 | Yes | No | Yes | Player's last name |

Position | string | 10 | Yes | No | Yes | Player's primary position. Possible values: C, CB, DB, DE, DE/LB, DL, DT, FB, FS, G, ILB, K, KR, LB, LS, NT, OL, OLB, OT, P, QB, RB, S, SS, T, TE, WR |

Status | string | 50 | Yes | No | Yes | The player's current status. Possible values include Active, Inactive, Injured Reserve, Physically Unable to Perform, Practice Squad, Suspended and Non Football Injury. Inactive indicates that this player is a free agent. Active indicates that this player is on his team's active roster. |

Height | string | 50 | Yes | No | Yes | Height in feet, inches |

Weight | integer | 32 | Yes | No | Yes | Weight in pounds |

BirthDate | datetime | Yes | No | Yes | Date of birth | |

College | string | 50 | Yes | No | Yes | College |

Experience | integer | 32 | Yes | Yes | Yes | Number of years experience. This number is incremented every year, in the Spring, when we load the rookies following the NFL Draft. Rookies will have Experience = Zero, while second year players will have Experience = 2. |

FantasyPosition | string | 10 | Yes | No | Yes | The player's fantasy football position. Possible values: QB, RB, WR, TE, K, DL, LB, DB |

Active | boolean | Yes | No | Yes | Whether the player is currently under contract with an NFL team | |

PositionCategory | string | 3 | Yes | No | Yes | The category (Offense, Defense or Special Teams) of the players position (OFF, DEF, ST) |

Name | string | 50 | Yes | No | Yes | Full name of the player (Cam Newton, Aaron Rodgers, etc.) |

Age | integer | 32 | Yes | No | Yes | The player's current age |

ExperienceString | string | 50 | Yes | No | Yes | The player's experience converted to a string |

BirthDateString | string | 50 | Yes | No | Yes | The player's date of birth converted to a string |

PhotoUrl | string | 250 | Yes | No | Yes | The url of the player's photo hosted on FantasyData.com (http://static.fantasydata.com/images/nfl/player/2593.jpg) |

ByeWeek | integer | 32 | Yes | No | Yes | The week the player is on Bye for the upcoming or current season |

UpcomingGameOpponent | string | 50 | Yes | No | Yes | The opponent the player is playing in the upcoming week |

UpcomingGameWeek | integer | 32 | No | No | Yes | The week of the player's upcoming game (this will be the upcoming week unless the player is on Bye that week, which would bump it to the next week) |

ShortName | string | 50 | Yes | No | Yes | A shortened version of the player's full name (C.Newton, A.Rodgers) |

AverageDraftPosition | decimal | 32 | Yes | Yes | Yes | The average draft position of the player for the upcoming season's fantasy football draft |

DepthPositionCategory | string | 3 | Yes | Yes | Yes | The category (Offense, Defense or Special Teams) of the players DepthPositionCategory (OFF, DEF, ST) |

DepthPosition | string | 10 | Yes | Yes | Yes | The position this player is listed at on his team's depth chart (e.g. QB, LWR, RDE, LILB) |

DepthOrder | integer | 32 | Yes | Yes | Yes | The order this player is at his position (1 = Starter, 2 = Backup, 3 = 3rd String) |

DepthDisplayOrder | integer | 32 | Yes | Yes | Yes | The display order of the positions (for display purposes) |

CurrentTeam
from 2013 |
string | 10 | Yes | No | Yes | The team who currently employs this player. This value is null when this player is unemployed. |

CollegeDraftTeam
from 2013 |
string | 10 | Yes | No | 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
from 2013 |
integer | 32 | Yes | No | Yes | The year this player entered the NFL as rookie. |

CollegeDraftRound
from 2013 |
integer | 32 | Yes | Yes | Yes | The round this player was drafted in. |

CollegeDraftPick
from 2013 |
integer | 32 | Yes | Yes | Yes | The overall pick in the draft this player was selected. |

IsUndraftedFreeAgent
from 2013 |
boolean | No | No | Yes | Whether this player was an undrafted free agent. This value is True if the player was drafted. | |

HeightFeet | integer | 32 | Yes | No | Yes | The feet component of a player's height (if player is 6'3", then this value would be 6) |

HeightInches | integer | 32 | Yes | No | Yes | The inches component of a player's height (if player is 6'3", then this value would be 3) |

UpcomingOpponentRank | integer | 32 | Yes | Yes | Yes | The player's upcoming opponent's rank in fantasy points allowed. |

UpcomingOpponentPositionRank | integer | 32 | Yes | Yes | Yes | The player's upcoming opponent's rank in fantasy points allowed to his fantasy position. |

CurrentStatus | string | 50 | Yes | Yes | Yes | The player's current status, aggregated from Status and Injury Status (possible values are: Suspended, Injured Reserve, Non Football Injury, Physically Unable To Perform, Free Agent, Practice Squad, Healthy, Probable, Questionable, Doubtful, Out) |

UpcomingSalary | integer | 32 | Yes | Yes | Yes | The player's salary for the upcoming week in accordance with a $50,000 salary cap. This is used for daily fantasy sports salary cap contests. Salaries represent those published by DraftKings. When DraftKings doesn't publish a salary for a given game, the most recent DraftKings salary is used. |

FantasyAlarmPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the FantasyAlarm news feed. |

SportRadarPlayerID | string | 50 | Yes | No | Yes | The player's cross reference PlayerID to the SportRadar API. |

RotoworldPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the Rotoworld news feed. |

RotoWirePlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the RotoWire news feed. |

StatsPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the STATS data feeds. |

SportsDirectPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the SportsDirect data feeds. |

XmlTeamPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the XML Team data feeds. |

FanDuelPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to FanDuel. |

DraftKingsPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to DraftKings. |

YahooPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to Yahoo Daily Fantasy Sports Contests. |

InjuryStatus | string | 50 | Yes | Yes | Yes | The player's current injury status, in the form of likelihood that player plays (Probable, Questionable, Doubtful, Out) |

InjuryBodyPart | string | 50 | Yes | Yes | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |

InjuryStartDate | datetime | Yes | Yes | Yes | The day that the injury started or first discovered. | |

InjuryNotes | string | 250 | Yes | Yes | Yes | Brief description of the player's injury and expected availability. |

FanDuelName | string | 50 | Yes | No | Yes | The player's full name in FanDuel's daily fantasy sports platform. |

DraftKingsName | string | 50 | Yes | No | Yes | The player's full name in DraftKings' daily fantasy sports platform. |

YahooName | string | 50 | Yes | No | Yes | The player's full name in Yahoo's daily fantasy sports platform. |

FantasyPositionDepthOrder | integer | 32 | Yes | Yes | Yes | The order this player is at his team's FantasyPosition |

InjuryPractice | string | 10 | Yes | Yes | Yes | Whether the player participated in practice (None, Limited, Full) |

InjuryPracticeDescription | string | 50 | Yes | Yes | Yes | Full description of whether the player participated in practice) |

DeclaredInactive | boolean | No | Yes | Yes | Whether the player has been declared inactive. This value is updated in the hours leading up to game start time, as teams announce their inactive players. This is only updated for offensive skill position players (QB, RB, WR, TE) | |

UpcomingFanDuelSalary | integer | 32 | Yes | Yes | Yes | The player's FanDuel salary for the upcoming week. |

UpcomingDraftKingsSalary | integer | 32 | Yes | Yes | Yes | The player's DraftKings salary for the upcoming week. |

UpcomingYahooSalary | integer | 32 | Yes | Yes | Yes | The player's Yahoo salary for the upcoming week. |

TeamID | integer | 32 | Yes | No | Yes | |

GlobalTeamID | integer | 32 | Yes | No | No | |

FantasyDraftPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to FantasyDraft. |

FantasyDraftName | string | 50 | Yes | No | Yes | The player's full name in FantasyDraft's daily fantasy sports platform. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

PlayerID | integer | 32 | No | No | Yes | Unique ID of the Player (assigned by FantasyData). |

Name | string | 50 | Yes | No | Yes | Name of Player. |

TeamID | integer | 32 | Yes | No | Yes | Unique ID of the Team the player belongs to (assigned by FantasyData). |

Team | string | 50 | Yes | No | Yes | Name of the team the player belongs to. |

Position | string | 50 | Yes | No | Yes | Position player plays. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

InjuryID | integer | 32 | No | No | Yes | Unique ID of the injury status |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The season of the game that this injury leads up to |

Week | integer | 32 | No | No | Yes | The week of the game that this injury leads up to |

PlayerID | integer | 32 | No | No | Yes | The PlayerID of the injured player |

Name | string | 50 | Yes | No | Yes | The full name of the injured player |

Position | string | 50 | Yes | No | Yes | The position of the injured player |

Number | integer | 32 | No | No | Yes | The jersey number of the injured player |

Team | string | 50 | Yes | No | Yes | The team the injured player is on |

Opponent | string | 50 | Yes | No | Yes | The upcoming opponent of the injured player |

BodyPart | string | 50 | Yes | Yes | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |

Status | string | 50 | Yes | Yes | Yes | Likelihood that player plays (Probable, Questionable, Doubtful, Out) |

Practice | string | 50 | Yes | Yes | Yes | Whether the player participated in practice (None, Limited, Full) |

PracticeDescription | string | 50 | Yes | Yes | Yes | Full description of whether the player participated in practice) |

Updated | datetime | No | No | Yes | The date/time the injury status was updated | |

DeclaredInactive | boolean | Yes | Yes | No | Whether the player has been declared inactive. This value is updated in the hours leading up to game start time, as teams announce their inactive players. This is only updated for offensive skill position players (QB, RB, WR, TE) | |

TeamID | integer | 32 | Yes | No | No | |

OpponentID | integer | 32 | Yes | No | No |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | No | No | |

PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL season of the game |

GameDate | datetime | No | No | Yes | The date/time of the game | |

Week | integer | 32 | No | No | Yes | The NFL week of the game (weeks 18-21 denote playoff games) |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

Opponent | string | 50 | Yes | No | Yes | The abbreviation of the Opponent |

HomeOrAway | string | 4 | Yes | No | Yes | Whether the player is Home or Away |

Number | integer | 32 | No | No | Yes | Player's jersey number |

Name | string | 50 | Yes | No | Yes | Player's name |

Position | string | 50 | Yes | No | Yes | Player's position for this particular game or season. Possible values: C, CB, DB, DE, DE/LB, DL, DT, FB, FS, G, ILB, K, KR, LB, LS, NT, OL, OLB, OT, P, QB, RB, S, SS, T, TE, WR |

PositionCategory | string | 50 | Yes | No | Yes | Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST) |

Activated | integer | 32 | No | No | Yes | Whether the player was Active at gametime |

Played | integer | 32 | No | No | Yes | Whether the player played in at least one play |

Started | integer | 32 | No | No | Yes | Whether the player started on offense or defense |

PassingAttempts | decimal | 32 | No | Yes | Yes | Number of passes thrown |

PassingCompletions | decimal | 32 | No | Yes | Yes | Number of pass completions |

PassingYards | decimal | 32 | No | Yes | Yes | Number of passing yards |

PassingCompletionPercentage | decimal | 32 | No | Yes | Yes | Percentage of passes that were completed |

PassingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average passing yards gained per attempt |

PassingYardsPerCompletion | decimal | 32 | No | Yes | Yes | Average passing yards gained per completion |

PassingTouchdowns | decimal | 32 | No | Yes | Yes | Passing touchdowns scored |

PassingInterceptions | decimal | 32 | No | Yes | Yes | Interceptions thrown |

PassingRating | decimal | 32 | No | Yes | Yes | Passer rating |

PassingLong | decimal | 32 | No | Yes | Yes | Longest completion |

PassingSacks | decimal | 32 | No | Yes | Yes | Number of times sacked |

PassingSackYards | decimal | 32 | No | Yes | Yes | Yards lost as a result of being sacked |

RushingAttempts | decimal | 32 | No | Yes | Yes | Number of rushing attempts |

RushingYards | decimal | 32 | No | Yes | Yes | Number of rushing yards |

RushingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average rushing yards gained per attempt |

RushingTouchdowns | decimal | 32 | No | Yes | Yes | Rushing touchdowns scored |

RushingLong | decimal | 32 | No | Yes | Yes | Longest rush |

ReceivingTargets
from 2009 |
decimal | 32 | Yes | Yes | Yes | Number of times targeted by passer |

Receptions | decimal | 32 | No | Yes | Yes | Number of receptions |

ReceivingYards | decimal | 32 | No | Yes | Yes | Total receiving yards |

ReceivingYardsPerReception | decimal | 32 | No | Yes | Yes | Average yards gained per reception |

ReceivingTouchdowns | decimal | 32 | No | Yes | Yes | Receiving touchdowns |

ReceivingLong | decimal | 32 | No | Yes | Yes | Longest reception |

Fumbles | decimal | 32 | No | Yes | Yes | Times fumbled |

FumblesLost
from 2003 |
decimal | 32 | Yes | Yes | Yes | Number of fumbles recovered by opponent |

PuntReturns | decimal | 32 | No | Yes | Yes | Number of punt return attempts |

PuntReturnYards | decimal | 32 | No | Yes | Yes | Total return yards on punts |

PuntReturnYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average yards gained per punt return |

PuntReturnTouchdowns | decimal | 32 | No | Yes | Yes | Number of touchdowns on punt returns |

PuntReturnLong | decimal | 32 | No | Yes | Yes | Longest punt return |

KickReturns | decimal | 32 | No | Yes | Yes | Number of kick return attempts |

KickReturnYards | decimal | 32 | No | Yes | Yes | Total return yards on kicks |

KickReturnYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average yards gained per kick return |

KickReturnTouchdowns | decimal | 32 | No | Yes | Yes | Number of touchdowns on kick returns |

KickReturnLong | decimal | 32 | No | Yes | Yes | Longest kick return |

SoloTackles | decimal | 32 | No | Yes | Yes | Solo, unassisted tackles |

AssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles (also called a half tackle) |

TacklesForLoss
from 2008 |
decimal | 32 | Yes | Yes | Yes | Tackles behind the opponent's line of scrimmage |

Sacks | decimal | 32 | No | Yes | Yes | Sacks of the opposing quarterback |

SackYards | decimal | 32 | No | Yes | Yes | Yards lost as a result of sacking the opposing quarterback |

QuarterbackHits
from 2006 |
decimal | 32 | Yes | Yes | Yes | Number of times hitting an opposing quarterback without sacking him |

PassesDefended | decimal | 32 | No | Yes | Yes | Passes defended or batted down |

FumblesForced | decimal | 32 | No | Yes | Yes | Number of fumbles forced |

FumblesRecovered | decimal | 32 | No | Yes | Yes | Number of fumbles recovered |

FumbleReturnYards | decimal | 32 | No | Yes | Yes | Return yards from fumble recoveries |

FumbleReturnTouchdowns | decimal | 32 | No | Yes | Yes | Return touchdowns from fumble recoveries |

Interceptions | decimal | 32 | No | Yes | Yes | Number of interceptions |

InterceptionReturnYards | decimal | 32 | No | Yes | Yes | Return yards from interceptions |

InterceptionReturnTouchdowns | decimal | 32 | No | Yes | Yes | Return touchdowns from interceptions |

BlockedKicks | decimal | 32 | No | Yes | Yes | Total number of field goals and punts blocked |

SpecialTeamsSoloTackles | decimal | 32 | No | Yes | Yes | Solo tackles on kick and punt plays |

SpecialTeamsAssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles on kick and punt plays |

MiscSoloTackles | decimal | 32 | No | Yes | Yes | Solo tackles when playing offense (after a turnover) |

MiscAssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles when playing offense (after a turnover) |

Punts | decimal | 32 | No | Yes | Yes | Number of punts |

PuntYards | decimal | 32 | No | Yes | Yes | Total number of punt yards |

PuntAverage | decimal | 32 | No | Yes | Yes | Average yards per punt |

FieldGoalsAttempted | decimal | 32 | No | Yes | Yes | Number of field goal attempts |

FieldGoalsMade | decimal | 32 | No | Yes | Yes | Number of successful field goal attempts |

FieldGoalsLongestMade | decimal | 32 | No | Yes | Yes | Longest successful field goal attempt |

ExtraPointsMade | decimal | 32 | No | Yes | Yes | Number of successful extra points |

TwoPointConversionPasses | decimal | 32 | No | Yes | Yes | Successful two point conversion passes |

TwoPointConversionRuns | decimal | 32 | No | Yes | Yes | Successful two point conversion runs |

TwoPointConversionReceptions | decimal | 32 | No | Yes | Yes | Successful two point conversion receptions |

FantasyPoints | decimal | 32 | No | Yes | Yes | Fantasy points scored based on basic fantasy scoring system (https://fantasydata.com/resources/fantasy-scoring-system.aspx) |

FantasyPointsPPR | decimal | 32 | No | Yes | No | Fantasy points scored based on basic PPR fantasy scoring system (https://fantasydata.com/resources/fantasy-scoring-system.aspx) |

ReceptionPercentage | decimal | 32 | No | Yes | Yes | Percentage of ReceivingTargets convert into Receptions |

ReceivingYardsPerTarget | decimal | 32 | No | Yes | Yes | Average yards gained per ReceivingTargets |

Tackles | decimal | 32 | No | Yes | Yes | Sum of SoloTackles and AssistedTackles |

OffensiveTouchdowns | decimal | 32 | No | Yes | Yes | Offensive touchdowns scored |

DefensiveTouchdowns | decimal | 32 | No | Yes | Yes | Defensive touchdowns scored |

SpecialTeamsTouchdowns | decimal | 32 | No | Yes | Yes | Special teams touchdowns scored |

Touchdowns | decimal | 32 | No | Yes | Yes | Total touchdowns scored |

FantasyPosition | string | 50 | Yes | No | Yes | The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB) |

FieldGoalPercentage | decimal | 32 | No | Yes | Yes | Percentage of Field Goal attempts that we successful |

PlayerGameID | integer | 32 | No | No | Yes | Unique ID of PlayerGame record (subject to change, although it very rarely does). For a static ID, use a combination of GameKey and PlayerID. |

FumblesOwnRecoveries | decimal | 32 | Yes | Yes | Yes | Own team's fumbles recovered (did not result in a turnover) |

FumblesOutOfBounds | decimal | 32 | Yes | Yes | Yes | Fumbles by this player that went out of bounds (no one was awarded the recovery) |

KickReturnFairCatches | decimal | 32 | Yes | Yes | Yes | Fair catches made on kickoffs |

PuntReturnFairCatches | decimal | 32 | Yes | Yes | Yes | Fair catches made on punts |

PuntTouchbacks | decimal | 32 | Yes | Yes | Yes | Punts by this player that were touchbacks |

PuntInside20 | decimal | 32 | Yes | Yes | Yes | Punts by this player that were downed inside the 20 yard line |

PuntNetAverage | decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

ExtraPointsAttempted | decimal | 32 | Yes | Yes | Yes | Extra point kicks attempted |

BlockedKickReturnTouchdowns | decimal | 32 | Yes | Yes | Yes | Blocked kicks that this player returned for touchdowns |

FieldGoalReturnTouchdowns | decimal | 32 | Yes | Yes | Yes | Field goals that this player returned for touchdowns |

Safeties | decimal | 32 | Yes | Yes | Yes | Defensive safeties (sacks in end zone, solo tackles in end zone, blocked kicks that went out of bounds in the end zone) |

FieldGoalsHadBlocked | decimal | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

PuntsHadBlocked | decimal | 32 | Yes | Yes | Yes | Punts that were blocked |

ExtraPointsHadBlocked | decimal | 32 | Yes | Yes | Yes | Extra points that were blocked |

PuntLong | decimal | 32 | Yes | Yes | Yes | Longest punt |

BlockedKickReturnYards | decimal | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

FieldGoalReturnYards | decimal | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

PuntNetYards | decimal | 32 | Yes | Yes | Yes | Net punt yards |

SpecialTeamsFumblesForced | decimal | 32 | Yes | Yes | Yes | Fumbles forced on special teams plays |

SpecialTeamsFumblesRecovered | decimal | 32 | Yes | Yes | Yes | Fumbles recovered on special teams plays |

MiscFumblesForced | decimal | 32 | Yes | Yes | Yes | Fumbles forced after a turnover on offensive plays |

MiscFumblesRecovered | decimal | 32 | Yes | Yes | Yes | Fumbles recovered after a turnover on offensive plays |

ShortName | string | 50 | Yes | No | Yes | Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning) |

PlayingSurface | string | 50 | Yes | No | Yes | Playing surface of the stadium |

IsGameOver | boolean | Yes | No | Yes | Whether the game is over (true/false) | |

SafetiesAllowed | decimal | 32 | Yes | Yes | Yes | Safeties allowed (tackled in end zone, sacked in end zone, ran out of bounds in end zone, or committed a penalty in end zone, e.g. Intentional Grounding or Offensive Holding) |

Stadium | string | 50 | Yes | No | Yes | Stadium of the event |

Temperature | integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

Humidity | integer | 32 | Yes | Yes | Yes | Humidity at game start (Percentage) |

WindSpeed | integer | 32 | Yes | Yes | Yes | Wind speed at game start (MPH) |

FanDuelSalary
from 2014 |
integer | 32 | Yes | Yes | Yes | The player's salary for FanDuel daily fantasy contests. |

DraftKingsSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The player's salary for DraftKings daily fantasy contests. |

FantasyDataSalary
from 2014 |
integer | 32 | Yes | Yes | Yes | The player's salary as calculated by FantasyData. Based on the same salary cap as DraftKings contests ($50,000). |

OffensiveSnapsPlayed
from 2012 |
integer | 32 | Yes | Yes | Yes | The number of snaps this player played on offense. |

DefensiveSnapsPlayed
from 2012 |
integer | 32 | Yes | Yes | Yes | The number of snaps this player played on defense. |

SpecialTeamsSnapsPlayed
from 2012 |
integer | 32 | Yes | Yes | Yes | The number of snaps this player played on special teams. |

OffensiveTeamSnaps
from 2012 |
integer | 32 | Yes | Yes | Yes | The total number of offensive snaps this player's team played. |

DefensiveTeamSnaps
from 2012 |
integer | 32 | Yes | Yes | Yes | The total number of defensive snaps this player's team played. |

SpecialTeamsTeamSnaps
from 2012 |
integer | 32 | Yes | Yes | Yes | The total number of special teams snaps this player's team played. |

VictivSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The player's salary for Victiv daily fantasy contests. |

TwoPointConversionReturns
from 2015 |
decimal | 32 | Yes | Yes | Yes | Two point conversions returned for two points. |

FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Fantasy points based on FanDuel's scoring system. |

FieldGoalsMade0to19 | decimal | 32 | Yes | Yes | Yes | Field goals made of 0 to 19 yards. |

FieldGoalsMade20to29 | decimal | 32 | Yes | Yes | Yes | Field goals made of 20 to 29 yards. |

FieldGoalsMade30to39 | decimal | 32 | Yes | Yes | Yes | Field goals made of 30 to 39 yards. |

FieldGoalsMade40to49 | decimal | 32 | Yes | Yes | Yes | Field goals made of 40 to 49 yards. |

FieldGoalsMade50Plus | decimal | 32 | Yes | Yes | Yes | Field goals made of 50+ yards. |

FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Fantasy points based on DraftKings' scoring system. |

YahooSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The player's salary for Yahoo daily fantasy contests. |

FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Fantasy points based on Yahoo's daily fantasy scoring system. |

InjuryStatus | string | 50 | Yes | Yes | Yes | The player's injury status for the upcoming game, in the form of likelihood that player plays (Probable, Questionable, Doubtful, Out) |

InjuryBodyPart | string | 50 | Yes | Yes | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |

InjuryStartDate | datetime | Yes | Yes | Yes | The day that the injury started or first discovered. | |

InjuryNotes | string | 250 | Yes | Yes | Yes | Brief description of the player's injury and expected availability. |

FanDuelPosition | string | 10 | Yes | Yes | Yes | The player's eligible position in FanDuel's daily fantasy sports platform. |

DraftKingsPosition | string | 10 | Yes | Yes | Yes | The player's eligible position in DraftKings' daily fantasy sports platform. |

YahooPosition | string | 10 | Yes | Yes | Yes | The player's eligible position in Yahoo's daily fantasy sports platform. |

OpponentRank | integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent with regards to fantasy points allowed. |

OpponentPositionRank | integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed. |

InjuryPractice | string | 10 | Yes | Yes | Yes | Whether the player participated in practice (None, Limited, Full) |

InjuryPracticeDescription | string | 50 | Yes | Yes | Yes | Full description of whether the player participated in practice) |

DeclaredInactive | boolean | No | Yes | Yes | Whether the player has been declared inactive. This value is updated in the hours leading up to game start time, as teams announce their inactive players. This is only updated for offensive skill position players (QB, RB, WR, TE) | |

FantasyDraftSalary
from 2016 |
integer | 32 | Yes | Yes | Yes | The player's salary for FantasyDraft daily fantasy contests. |

FantasyDraftPosition
from 2016 |
string | 10 | Yes | No | Yes | The player's eligible position in FantasyDraft's daily fantasy sports platform. |

TeamID | integer | 32 | Yes | No | Yes | |

OpponentID | integer | 32 | Yes | No | Yes | |

Day | date | Yes | No | Yes | ||

DateTime | datetime | Yes | No | Yes | ||

GlobalGameID | integer | 32 | Yes | No | No | |

GlobalTeamID | integer | 32 | Yes | No | No | |

GlobalOpponentID | integer | 32 | Yes | No | Yes | |

ScoreID | integer | 32 | No | No | Yes | Unique ID of the Score/Game. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

Score | Score | Yes | No | Yes | ||

Quarters | Quarter[] | Yes | No | Yes | ||

TeamGames | TeamGame[] | Yes | No | Yes | ||

PlayerGames | PlayerGame[] | Yes | No | Yes | ||

FantasyDefenseGames | FantasyDefenseGame[] | Yes | No | Yes | ||

ScoringPlays | ScoringPlay[] | Yes | No | Yes | ||

ScoringDetails | ScoringDetail[] | Yes | No | Yes |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL regular season for which these totals apply |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

Number | integer | 32 | No | No | Yes | Player's jersey number |

Name | string | 50 | Yes | No | Yes | Player's name |

Position | string | 50 | Yes | No | Yes | Player's position in the starting lineup (if started), otherwise the position he substituted for |

PositionCategory | string | 50 | Yes | No | Yes | Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST) |

Activated | integer | 32 | No | No | Yes | Number of games player was Active on gameday |

Played | integer | 32 | No | No | Yes | Number of games played in |

Started | integer | 32 | No | No | Yes | Number of games started |

PassingAttempts | decimal | 32 | No | Yes | Yes | Number of passes thrown |

PassingCompletions | decimal | 32 | No | Yes | Yes | Number of pass completions |

PassingYards | decimal | 32 | No | Yes | Yes | Number of passing yards |

PassingCompletionPercentage | decimal | 32 | No | Yes | Yes | Percentage of passes that were completed |

PassingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average passing yards gained per attempt |

PassingYardsPerCompletion | decimal | 32 | No | Yes | Yes | Average passing yards gained per completion |

PassingTouchdowns | decimal | 32 | No | Yes | Yes | Passing touchdowns scored |

PassingInterceptions | decimal | 32 | No | Yes | Yes | Interceptions thrown |

PassingRating | decimal | 32 | No | Yes | Yes | Passer rating |

PassingLong | decimal | 32 | No | Yes | Yes | Longest completion |

PassingSacks | decimal | 32 | No | Yes | Yes | Number of times sacked |

PassingSackYards | decimal | 32 | No | Yes | Yes | Yards lost as a result of being sacked |

RushingAttempts | decimal | 32 | No | Yes | Yes | Number of rushing attempts |

RushingYards | decimal | 32 | No | Yes | Yes | Number of rushing yards |

RushingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average rushing yards gained per attempt |

RushingTouchdowns | decimal | 32 | No | Yes | Yes | Rushing touchdowns scored |

RushingLong | decimal | 32 | No | Yes | Yes | Longest rush |

ReceivingTargets
from 2009 |
decimal | 32 | Yes | Yes | Yes | Number of times targeted by passer |

Receptions | decimal | 32 | No | Yes | Yes | Number of receptions |

ReceivingYards | decimal | 32 | No | Yes | Yes | Total receiving yards |

ReceivingYardsPerReception | decimal | 32 | No | Yes | Yes | Average yards gained per reception |

ReceivingTouchdowns | decimal | 32 | No | Yes | Yes | Receiving touchdowns |

ReceivingLong | decimal | 32 | No | Yes | Yes | Longest reception |

Fumbles | decimal | 32 | No | Yes | Yes | Times fumbled |

FumblesLost
from 2003 |
decimal | 32 | Yes | Yes | Yes | Number of fumbles recovered by opponent |

PuntReturns | decimal | 32 | No | Yes | Yes | Number of punt return attempts |

PuntReturnYards | decimal | 32 | No | Yes | Yes | Total return yards on punts |

PuntReturnYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average yards gained per punt return |

PuntReturnTouchdowns | decimal | 32 | No | Yes | Yes | Number of touchdowns on punt returns |

PuntReturnLong | decimal | 32 | No | Yes | Yes | Longest punt return |

KickReturns | decimal | 32 | No | Yes | Yes | Number of kick return attempts |

KickReturnYards | decimal | 32 | No | Yes | Yes | Total return yards on kicks |

KickReturnYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average yards gained per kick return |

KickReturnTouchdowns | decimal | 32 | No | Yes | Yes | Number of touchdowns on kick returns |

KickReturnLong | decimal | 32 | No | Yes | Yes | Longest kick return |

SoloTackles | decimal | 32 | No | Yes | Yes | Solo, unassisted tackles |

AssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles (also called a half tackle) |

TacklesForLoss
from 2008 |
decimal | 32 | Yes | Yes | Yes | Tackles behind the opponent's line of scrimmage |

Sacks | decimal | 32 | No | Yes | Yes | Sacks of the opposing quarterback |

SackYards | decimal | 32 | No | Yes | Yes | Yards lost as a result of sacking the opposing quarterback |

QuarterbackHits
from 2006 |
decimal | 32 | Yes | Yes | Yes | Number of times hitting an opposing quarterback without sacking him |

PassesDefended | decimal | 32 | No | Yes | Yes | Passes defended or batted down |

FumblesForced | decimal | 32 | No | Yes | Yes | Number of fumbles forced |

FumblesRecovered | decimal | 32 | No | Yes | Yes | Number of fumbles recovered |

FumbleReturnYards | decimal | 32 | No | Yes | Yes | Return yards from fumble recoveries |

FumbleReturnTouchdowns | decimal | 32 | No | Yes | Yes | Return touchdowns from fumble recoveries |

Interceptions | decimal | 32 | No | Yes | Yes | Number of interceptions |

InterceptionReturnYards | decimal | 32 | No | Yes | Yes | Return yards from interceptions |

InterceptionReturnTouchdowns | decimal | 32 | No | Yes | Yes | Return touchdowns from interceptions |

BlockedKicks | decimal | 32 | No | Yes | Yes | Total number of field goals and punts blocked |

SpecialTeamsSoloTackles | decimal | 32 | No | Yes | Yes | Solo tackles on kick and punt plays |

SpecialTeamsAssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles on kick and punt plays |

MiscSoloTackles | decimal | 32 | No | Yes | Yes | Solo tackles when playing offense (after a turnover) |

MiscAssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles when playing offense (after a turnover) |

Punts | decimal | 32 | No | Yes | Yes | Number of punts |

PuntYards | decimal | 32 | No | Yes | Yes | Total number of punt yards |

PuntAverage | decimal | 32 | No | Yes | Yes | Average yards per punt |

FieldGoalsAttempted | decimal | 32 | No | Yes | Yes | Number of field goal attempts |

FieldGoalsMade | decimal | 32 | No | Yes | Yes | Number of successful field goal attempts |

FieldGoalsLongestMade | decimal | 32 | No | Yes | Yes | Longest successful field goal attempt |

ExtraPointsMade | decimal | 32 | No | Yes | Yes | Number of successful extra points |

TwoPointConversionPasses | decimal | 32 | No | Yes | Yes | Successful two point conversion passes |

TwoPointConversionRuns | decimal | 32 | No | Yes | Yes | Successful two point conversion runs |

TwoPointConversionReceptions | decimal | 32 | No | Yes | Yes | Successful two point conversion receptions |

FantasyPoints | decimal | 32 | No | Yes | Yes | Fantasy points scored based on basic fantasy scoring system (https://fantasydata.com/resources/fantasy-scoring-system.aspx) |

FantasyPointsPPR | decimal | 32 | No | Yes | No | Fantasy points scored based on basic PPR fantasy scoring system (https://fantasydata.com/resources/fantasy-scoring-system.aspx) |

ReceptionPercentage | decimal | 32 | No | Yes | Yes | Percentage of ReceivingTargets convert into Receptions |

ReceivingYardsPerTarget | decimal | 32 | No | Yes | Yes | Average yards gained per ReceivingTargets |

Tackles | decimal | 32 | No | Yes | Yes | Sum of SoloTackles and AssistedTackles |

OffensiveTouchdowns | decimal | 32 | No | Yes | Yes | Offensive touchdowns scored |

DefensiveTouchdowns | decimal | 32 | No | Yes | Yes | Defensive touchdowns scored |

SpecialTeamsTouchdowns | decimal | 32 | No | Yes | Yes | Special teams touchdowns scored |

Touchdowns | decimal | 32 | No | Yes | Yes | Total touchdowns scored |

FantasyPosition | string | 50 | Yes | No | Yes | The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB) |

FieldGoalPercentage | decimal | 32 | No | Yes | Yes | Percentage of Field Goal attempts that we successful |

PlayerSeasonID | integer | 32 | No | No | Yes | Unique ID of PlayerSeason record (subject to change, although it very rarely does). For a static ID, use a combination of SeasonType, Season and PlayerID. |

FumblesOwnRecoveries | decimal | 32 | Yes | Yes | Yes | Own team's fumbles recovered (did not result in a turnover) |

FumblesOutOfBounds | decimal | 32 | Yes | Yes | Yes | Fumbles by this player that went out of bounds (no one was awarded the recovery) |

KickReturnFairCatches | decimal | 32 | Yes | Yes | Yes | Fair catches made on kickoffs |

PuntReturnFairCatches | decimal | 32 | Yes | Yes | Yes | Fair catches made on punts |

PuntTouchbacks | decimal | 32 | Yes | Yes | Yes | Punts by this player that were touchbacks |

PuntInside20 | decimal | 32 | Yes | Yes | Yes | Punts by this player that were downed inside the 20 yard line |

PuntNetAverage | decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

ExtraPointsAttempted | decimal | 32 | Yes | Yes | Yes | Extra point kicks attempted |

BlockedKickReturnTouchdowns | decimal | 32 | Yes | Yes | Yes | Blocked kicks that this player returned for touchdowns |

FieldGoalReturnTouchdowns | decimal | 32 | Yes | Yes | Yes | Field goals that this player returned for touchdowns |

Safeties | decimal | 32 | Yes | Yes | Yes | Defensive safeties (sacks in end zone, solo tackles in end zone, blocked kicks that went out of bounds in the end zone) |

FieldGoalsHadBlocked | decimal | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

PuntsHadBlocked | decimal | 32 | Yes | Yes | Yes | Punts that were blocked |

ExtraPointsHadBlocked | decimal | 32 | Yes | Yes | Yes | Extra points that were blocked |

PuntLong | decimal | 32 | Yes | Yes | Yes | Longest punt |

BlockedKickReturnYards | decimal | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

FieldGoalReturnYards | decimal | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

PuntNetYards | decimal | 32 | Yes | Yes | Yes | Net punt yards |

SpecialTeamsFumblesForced | decimal | 32 | Yes | Yes | Yes | Fumbles forced on special teams plays |

SpecialTeamsFumblesRecovered | decimal | 32 | Yes | Yes | Yes | Fumbles recovered on special teams plays |

MiscFumblesForced | decimal | 32 | Yes | Yes | Yes | Fumbles forced after a turnover on offensive plays |

MiscFumblesRecovered | decimal | 32 | Yes | Yes | Yes | Fumbles recovered after a turnover on offensive plays |

ShortName | string | 50 | Yes | No | Yes | Shorter version of player's name, includes first initial and last name (e.g. A. Rodgers, P.Manning) |

SafetiesAllowed | decimal | 32 | Yes | Yes | Yes | Safeties allowed (tackled in end zone, sacked in end zone, ran out of bounds in end zone, or committed a penalty in end zone, e.g. Intentional Grounding or Offensive Holding) |

Temperature | integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

Humidity | integer | 32 | Yes | Yes | Yes | Humidity at game start (Percentage) |

WindSpeed | integer | 32 | Yes | Yes | Yes | Wind speed at game start (MPH) |

OffensiveSnapsPlayed
from 2012 |
integer | 32 | Yes | Yes | Yes | The number of snaps this player played on offense. |

DefensiveSnapsPlayed
from 2012 |
integer | 32 | Yes | Yes | Yes | The number of snaps this player played on defense. |

SpecialTeamsSnapsPlayed
from 2012 |
integer | 32 | Yes | Yes | Yes | The number of snaps this player played on special teams. |

OffensiveTeamSnaps
from 2012 |
integer | 32 | Yes | Yes | Yes | The total number of offensive snaps this player's team played. |

DefensiveTeamSnaps
from 2012 |
integer | 32 | Yes | Yes | Yes | The total number of defensive snaps this player's team played. |

SpecialTeamsTeamSnaps
from 2012 |
integer | 32 | Yes | Yes | Yes | The total number of special teams snaps this player's team played. |

AuctionValue | decimal | 32 | Yes | Yes | Yes | Player's dollar value in a $200 salary cap auction draft. |

AuctionValuePPR | decimal | 32 | Yes | Yes | Yes | Player's dollar value in a $200 salary cap PPR auction draft. |

TwoPointConversionReturns
from 2015 |
decimal | 32 | Yes | Yes | Yes | Two point conversions returned for two points. |

FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Fantasy points based on FanDuel's scoring system. |

FieldGoalsMade0to19 | decimal | 32 | Yes | Yes | Yes | Field goals made of 0 to 19 yards. |

FieldGoalsMade20to29 | decimal | 32 | Yes | Yes | Yes | Field goals made of 20 to 29 yards. |

FieldGoalsMade30to39 | decimal | 32 | Yes | Yes | Yes | Field goals made of 30 to 39 yards. |

FieldGoalsMade40to49 | decimal | 32 | Yes | Yes | Yes | Field goals made of 40 to 49 yards. |

FieldGoalsMade50Plus | decimal | 32 | Yes | Yes | Yes | Field goals made of 50+ yards. |

FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Fantasy points based on DraftKings' scoring system. |

FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Fantasy points based on Yahoo's daily fantasy scoring system. |

AverageDraftPosition | decimal | 32 | Yes | Yes | Yes | The average draft position of the team's fantasy defense (DST) |

AverageDraftPositionPPR | decimal | 32 | Yes | Yes | Yes | The average draft position in PPR leagues of the team's fantasy defense (DST) |

TeamID | integer | 32 | Yes | No | Yes | |

GlobalTeamID | integer | 32 | Yes | No | No |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | No | No | |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

ScoringPlayID | integer | 32 | No | No | No | Unique id of the scoring play |

Season | integer | 32 | No | No | No | The NFL season of the game |

Week | integer | 32 | No | No | No | The NFL week of the game (weeks 18-21 denote playoff games) |

AwayTeam | string | 10 | No | No | No | The abbreviation of the away team |

HomeTeam | string | 10 | No | No | No | The abbreviation of the home team |

Date | datetime | Yes | No | No | The date/time of the game | |

Sequence | integer | 32 | Yes | No | No | The order in which the scoring play happened |

Team | string | 10 | Yes | No | No | The abbreviation of the team that scored |

Quarter | string | 10 | Yes | No | No | The quarter that the score occurred in |

TimeRemaining | string | 10 | Yes | No | No | The time remaining in the quarter when the score occurred |

PlayDescription | string | 500 | Yes | No | No | The detailed description of the play for display purposes |

AwayScore | integer | 32 | Yes | Yes | No | The away team's score as a result of the scoring play (includes point after) |

HomeScore | integer | 32 | Yes | Yes | No | The home team's score as a result of the scoring play (includes point after) |

ScoreID | integer | 32 | No | No | Yes | Unique ID of the Score/Game. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | No | No | |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

PlayerID | integer | 32 | Yes | No | Yes | PlayerID of the player who scored |

Team | string | 50 | Yes | No | Yes | The team who the player played for |

Season | integer | 32 | No | No | Yes | The season during which the score happened |

Week | integer | 32 | No | No | Yes | The week during which the score happened |

ScoringType | string | 50 | Yes | No | Yes | The type of scoring play (e.g. BlockedFieldGoalReturnTouchdown, BlockedPuntReturnTouchdown, FieldGoalMade, FieldGoalReturnTouchdown, FumbleReturnTouchdown, InterceptionReturnTouchdown, KickoffReturnTouchdown, PassingTouchdown, PuntReturnTouchdown, ReceivingTouchdown, RushingTouchdown, Safety) |

Length | integer | 32 | No | Yes | Yes | The length in yards of the score |

ScoringDetailID | integer | 32 | No | No | Yes | Unique identifier of this scoring detail |

PlayerGameID | integer | 32 | No | No | Yes | PlayerGameID of the game that this scoring detail occurred |

ScoreID | integer | 32 | Yes | No | Yes | Unique ID of the Score/Game. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | No | No | |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL season of the game |

Week | integer | 32 | Yes | No | Yes | The NFL week of the game (weeks 18-21 denote playoff games) |

Date | datetime | Yes | No | Yes | The date/time of the game | |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

Opponent | string | 50 | Yes | No | Yes | The abbreviation of the Opponent |

PointsAllowed | decimal | 32 | No | Yes | Yes | Number of points allowed |

TouchdownsScored | decimal | 32 | No | Yes | Yes | Defensive and special teams touchdowns scores |

SoloTackles | decimal | 32 | No | Yes | Yes | Total number solo tackles |

AssistedTackles | decimal | 32 | No | Yes | Yes | Total number assisted tackles |

Sacks | decimal | 32 | No | Yes | Yes | Total number of sacks of the opposing quarterback |

SackYards | decimal | 32 | No | Yes | Yes | Total number of yards lost when sacking the opposing quarterback |

PassesDefended | decimal | 32 | No | Yes | Yes | Total number of passes defended |

FumblesForced | decimal | 32 | No | Yes | Yes | Total number of fumbles forced |

FumblesRecovered | decimal | 32 | No | Yes | Yes | Total number of fumbles recovered |

FumbleReturnYards | decimal | 32 | No | Yes | Yes | Total return yards from fumbles recovered |

FumbleReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total touchdowns from fumbles recovered |

Interceptions | decimal | 32 | No | Yes | Yes | Total number of interceptions |

InterceptionReturnYards | decimal | 32 | No | Yes | Yes | Total number of interception return yards |

InterceptionReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total number of interception returns for touchdowns |

BlockedKicks | decimal | 32 | No | Yes | Yes | Total number of blocked field goals and blocked punts |

Safeties | decimal | 32 | No | Yes | Yes | Total safeties scored |

PuntReturns | decimal | 32 | No | Yes | Yes | Total number of punt returns |

PuntReturnYards | decimal | 32 | No | Yes | Yes | Total number of punt return yards |

PuntReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total number of punt returns for touchdowns |

PuntReturnLong | decimal | 32 | No | Yes | Yes | Longest punt return |

KickReturns | decimal | 32 | No | Yes | Yes | Total number of kick returns |

KickReturnYards | decimal | 32 | No | Yes | Yes | Total number of kick return yards |

KickReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total number of kick returns for touchdowns |

KickReturnLong | decimal | 32 | No | Yes | Yes | Longest kick return |

BlockedKickReturnTouchdowns
from 2001 |
decimal | 32 | Yes | Yes | Yes | Blocked kicks returned for a touchdown |

FieldGoalReturnTouchdowns
from 2001 |
decimal | 32 | Yes | Yes | Yes | Field goal returns for touchdowns |

FantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

QuarterbackFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing quarterbacks |

RunningbackFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing running backs |

WideReceiverFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing wide receivers |

TightEndFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing tight ends |

KickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing kickers |

BlockedKickReturnYards | decimal | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

FieldGoalReturnYards | decimal | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

QuarterbackHits | decimal | 32 | Yes | Yes | Yes | Quarterback hits |

TacklesForLoss | decimal | 32 | Yes | Yes | Yes | Tackles for a loss |

DefensiveTouchdowns | decimal | 32 | Yes | Yes | Yes | Total touchdowns scored by the defense |

SpecialTeamsTouchdowns | decimal | 32 | Yes | Yes | Yes | Total touchdowns scored by the special teams |

IsGameOver | boolean | Yes | No | Yes | Whether the game is over (true/false) | |

FantasyPoints | decimal | 32 | Yes | Yes | Yes | Fantasy points scored based on basic fantasy scoring system (https://fantasydata.com/resources/fantasy-scoring-system.aspx) |

Stadium | string | 50 | Yes | No | Yes | Stadium of the event |

Temperature | integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

Humidity | integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

WindSpeed | integer | 32 | Yes | Yes | Yes | Humidity at game start (Percentage) |

ThirdDownAttempts | decimal | 32 | Yes | Yes | Yes | Opponent's third down attempts |

ThirdDownConversions | decimal | 32 | Yes | Yes | Yes | Opponent's third down conversions |

FourthDownAttempts | decimal | 32 | Yes | Yes | Yes | Opponent's fourth down attempts |

FourthDownConversions | decimal | 32 | Yes | Yes | Yes | Opponent's fourth down conversions |

PointsAllowedByDefenseSpecialTeams | decimal | 32 | Yes | Yes | Yes | Number of points allowed to opposing offense and special teams. This excludes points scored by the opponent's defense. |

FanDuelSalary
from 2014 |
integer | 32 | Yes | Yes | Yes | The team's DEF/ST salary for FanDuel daily fantasy contests. |

DraftKingsSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The team's DEF/ST salary for DraftKings daily fantasy contests. |

FantasyDataSalary
from 2014 |
integer | 32 | Yes | Yes | Yes | The team's DST salary as calculated by FantasyData. Based on the same salary cap as DraftKings contests ($50,000). |

VictivSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The player's salary for Victiv daily fantasy contests. |

TwoPointConversionReturns
from 2015 |
decimal | 32 | Yes | Yes | Yes | Two point conversions returned for two points. |

FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Fantasy points based on FanDuel's scoring system. |

FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Fantasy points based on DraftKings' scoring system. |

OffensiveYardsAllowed | decimal | 32 | Yes | Yes | Yes | Offensive yards allowed by this team's defense. |

YahooSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The player's salary for Yahoo daily fantasy contests. |

PlayerID | integer | 32 | Yes | No | Yes | The team's unique PlayerID for use when combining with player feeds. |

FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Fantasy points based on Yahoo's daily fantasy scoring system. |

HomeOrAway | string | 4 | Yes | No | Yes | Whether the Team is Home or Away (possible values: HOME, AWAY) |

OpponentRank | integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent with regards to fantasy points allowed. |

OpponentPositionRank | integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed. |

FantasyDraftSalary
from 2016 |
integer | 32 | Yes | Yes | Yes | The team's DEF/ST salary for FantasyDraft daily fantasy contests. |

TeamID | integer | 32 | Yes | No | Yes | The ID of the team. |

OpponentID | integer | 32 | Yes | No | Yes | The ID of the team's opponent. |

Day | date | Yes | No | Yes | The day of the game. | |

DateTime | datetime | Yes | No | Yes | The date/time of the game. | |

GlobalGameID | integer | 32 | Yes | No | No | |

GlobalTeamID | integer | 32 | Yes | No | No | |

GlobalOpponentID | integer | 32 | Yes | No | Yes | |

DraftKingsPosition | string | 10 | Yes | No | Yes | The position of this team's DEF/ST, as listed by DraftKings. |

FanDuelPosition | string | 10 | Yes | No | Yes | The position of this team's DEF/ST, as listed by FanDuel. |

FantasyDraftPosition | string | 10 | Yes | No | Yes | The position of this team's DEF/ST, as listed by FantasyDraft. |

YahooPosition | string | 10 | Yes | No | Yes | The position of this team's DEF/ST, as listed by Yahoo DFS. |

FantasyDefenseID | integer | 32 | Yes | No | Yes | Unique ID of FantasyDefense record (subject to change, although it very rarely does). For a guaranteed static ID, use a combination of GameKey and Team. |

ScoreID | integer | 32 | No | No | Yes | Unique ID of the Score/Game. |

FanDuelFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

FanDuelQuarterbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing quarterbacks |

FanDuelRunningbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing running backs |

FanDuelWideReceiverFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing wide receivers |

FanDuelTightEndFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing tight ends |

FanDuelKickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing kickers |

DraftKingsFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

DraftKingsQuarterbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing quarterbacks |

DraftKingsRunningbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing running backs |

DraftKingsWideReceiverFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing wide receivers |

DraftKingsTightEndFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing tight ends |

DraftKingsKickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing kickers |

YahooFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

YahooQuarterbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing quarterbacks |

YahooRunningbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing running backs |

YahooWideReceiverFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing wide receivers |

YahooTightEndFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing tight ends |

YahooKickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing kickers |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL regular season for which these totals apply |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

PointsAllowed | decimal | 32 | No | Yes | Yes | Number of points allowed |

TouchdownsScored | decimal | 32 | No | Yes | Yes | Defensive and special teams touchdowns scores |

SoloTackles | decimal | 32 | No | Yes | Yes | Total number solo tackles |

AssistedTackles | decimal | 32 | No | Yes | Yes | Total number assisted tackles |

Sacks | decimal | 32 | No | Yes | Yes | Total number of sacks of the opposing quarterback |

SackYards | decimal | 32 | No | Yes | Yes | Total number of yards lost when sacking the opposing quarterback |

PassesDefended | decimal | 32 | No | Yes | Yes | Total number of passes defended |

FumblesForced | decimal | 32 | No | Yes | Yes | Total number of fumbles forced |

FumblesRecovered | decimal | 32 | No | Yes | Yes | Total number of fumbles recovered |

FumbleReturnYards | decimal | 32 | No | Yes | Yes | Total return yards from fumbles recovered |

FumbleReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total touchdowns from fumbles recovered |

Interceptions | decimal | 32 | No | Yes | Yes | Total number of interceptions |

InterceptionReturnYards | decimal | 32 | No | Yes | Yes | Total number of interception return yards |

InterceptionReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total number of interception returns for touchdowns |

BlockedKicks | decimal | 32 | No | Yes | Yes | Total number of blocked field goals and blocked punts |

Safeties | decimal | 32 | No | Yes | Yes | Total safeties scored |

PuntReturns | decimal | 32 | No | Yes | Yes | Total number of punt returns |

PuntReturnYards | decimal | 32 | No | Yes | Yes | Total number of punt return yards |

PuntReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total number of punt returns for touchdowns |

PuntReturnLong | decimal | 32 | No | Yes | Yes | Longest punt return |

KickReturns | decimal | 32 | No | Yes | Yes | Total number of kick returns |

KickReturnYards | decimal | 32 | No | Yes | Yes | Total number of kick return yards |

KickReturnTouchdowns | decimal | 32 | No | Yes | Yes | Total number of kick returns for touchdowns |

KickReturnLong | decimal | 32 | No | Yes | Yes | Longest kick return |

BlockedKickReturnTouchdowns
from 2001 |
decimal | 32 | Yes | Yes | Yes | Blocked kicks returned for a touchdown |

FieldGoalReturnTouchdowns
from 2001 |
decimal | 32 | Yes | Yes | Yes | Field goal returns for touchdowns |

FantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

QuarterbackFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing quarterbacks |

RunningbackFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing running backs |

WideReceiverFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing wide receivers |

TightEndFantasyPointsAllowed
from 2001 |
decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing tight ends |

KickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Fantasy points allowed to opposing kickers |

Games | integer | 32 | Yes | No | Yes | Games played |

BlockedKickReturnYards | decimal | 32 | Yes | Yes | Yes | Blocked kick recovery return yards |

FieldGoalReturnYards | decimal | 32 | Yes | Yes | Yes | Field goal return yards (excluding blocked field goals) |

QuarterbackHits | decimal | 32 | Yes | Yes | Yes | Quarterback hits |

TacklesForLoss | decimal | 32 | Yes | Yes | Yes | Tackles for a loss |

DefensiveTouchdowns | decimal | 32 | Yes | Yes | Yes | Total touchdowns scored by the defense |

SpecialTeamsTouchdowns | decimal | 32 | Yes | Yes | Yes | Total touchdowns scored by the special teams |

FantasyPoints | decimal | 32 | Yes | Yes | Yes | |

Temperature | integer | 32 | Yes | Yes | Yes | Temperature at game start (Farenheit) |

Humidity | integer | 32 | Yes | Yes | Yes | Humidity at game start (Percentage) |

WindSpeed | integer | 32 | Yes | Yes | Yes | Wind speed at game start (MPH) |

ThirdDownAttempts | decimal | 32 | Yes | Yes | Yes | Opponent's third down attempts |

ThirdDownConversions | decimal | 32 | Yes | Yes | Yes | Opponent's third down conversions |

FourthDownAttempts | decimal | 32 | Yes | Yes | Yes | Opponent's fourth down attempts |

FourthDownConversions | decimal | 32 | Yes | Yes | Yes | Opponent's fourth down conversions |

PointsAllowedByDefenseSpecialTeams | decimal | 32 | Yes | Yes | Yes | Number of points allowed to opposing offense and special teams. Â This excludes points scored by the opponent's defense. |

AuctionValue | decimal | 32 | Yes | Yes | Yes | Player's dollar value in a $200 salary cap auction draft. |

AuctionValuePPR | decimal | 32 | Yes | Yes | Yes | Player's dollar value in a $200 salary cap PPR auction draft. |

TwoPointConversionReturns
from 2015 |
decimal | 32 | Yes | Yes | Yes | Two point conversions returned for two points. |

FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Fantasy points based on FanDuel's scoring system. |

FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Fantasy points based on DraftKings' scoring system. |

OffensiveYardsAllowed | decimal | 32 | Yes | Yes | Yes | Offensive yards allowed by this team's defense. |

PlayerID | integer | 32 | Yes | No | Yes | The team's unique PlayerID for use when mixing with player feeds. |

FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Fantasy points based on Yahoo's daily fantasy scoring system. |

AverageDraftPosition | decimal | 32 | Yes | Yes | Yes | The average draft position of the team's fantasy defense (DST) |

AverageDraftPositionPPR | decimal | 32 | Yes | Yes | Yes | The average draft position in PPR leagues of the team's fantasy defense (DST) |

TeamID | integer | 32 | Yes | No | Yes | |

GlobalTeamID | integer | 32 | Yes | No | No | |

FanDuelFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

FanDuelQuarterbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing quarterbacks |

FanDuelRunningbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing running backs |

FanDuelWideReceiverFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing wide receivers |

FanDuelTightEndFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing tight ends |

FanDuelKickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | FanDuel fantasy points allowed to opposing kickers |

DraftKingsFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

DraftKingsQuarterbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing quarterbacks |

DraftKingsRunningbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing running backs |

DraftKingsWideReceiverFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing wide receivers |

DraftKingsTightEndFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing tight ends |

DraftKingsKickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | DraftKings fantasy points allowed to opposing kickers |

YahooFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing offensive players (QB, RB, WR and TE) |

YahooQuarterbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing quarterbacks |

YahooRunningbackFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing running backs |

YahooWideReceiverFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing wide receivers |

YahooTightEndFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing tight ends |

YahooKickerFantasyPointsAllowed | decimal | 32 | Yes | Yes | Yes | Yahoo fantasy points allowed to opposing kickers |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

NewsID | integer | 32 | No | No | No | Unique ID of news story |

Source | string | 50 | Yes | No | No | The source of the story (FantasyData, RotoBaller, NBCSports.com, etc.) |

Updated | datetime | No | No | No | The date/time that the content was published | |

TimeAgo | string | 50 | Yes | No | No | A description of how long ago this content was published |

Title | string | 100 | Yes | No | No | The brief title of the news (typically less than 100 characters) |

Content | string | 5000 | Yes | No | No | The full body content of the story |

Url | string | 250 | Yes | No | No | The url of the full story |

TermsOfUse | string | 500 | Yes | No | No | The terms of use with using this news item, credit must be given to the originator of the story when specified in the terms of use |

Author | string | 50 | Yes | No | No | The author of the content |

Categories | string | 100 | Yes | No | No | Comma delimited meta tags describing the categories of this content |

PlayerID | integer | 32 | Yes | No | No | The PlayerID of the player who relates to this story |

TeamID | integer | 32 | Yes | No | No | The TeamID of the team that relates to this story |

Team | string | 10 | Yes | No | No | The team that relates to this story |

PlayerID2 | integer | 32 | Yes | No | No | The PlayerID of the player who relates to this story |

TeamID2 | integer | 32 | Yes | No | No | The TeamID of the team that relates to this story |

Team2 | string | 10 | Yes | No | No | The team that relates to this story |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

ArticleID | integer | 32 | No | No | Yes | Unique ID of the Article (assigned by FantasyData) |

Title | string | 50 | Yes | No | Yes | Article title |

Source | string | 50 | Yes | No | Yes | Article source company |

Updated | datetime | No | No | Yes | Article publish/last updated date | |

Content | string | 5000 | Yes | Yes | Yes | Main Content of the article |

Url | string | 250 | Yes | No | Yes | Source company article url |

TermsOfUse | string | 500 | Yes | No | Yes | |

Author | string | 50 | Yes | Yes | Yes | Article Author |

Players | PlayerInfo[] | Yes | No | Yes | Basic info on players included in the article |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

QuarterID | integer | 32 | No | No | Yes | Unique identifier for each Quarter. |

ScoreID | integer | 32 | No | No | Yes | The unique identifier of the Score record this Quarter belongs to. |

Number | integer | 32 | No | No | Yes | The Number (Order) of the Quarter in the scope of the Game. |

Name | string | 10 | No | No | Yes | The Name of the Quarter (possible values: 1, 2, 3, 4, OT, OT2, OT3, etc) |

Description | string | 20 | Yes | No | Yes | The long description of the Quarter. |

AwayTeamScore | integer | 32 | Yes | No | Yes | The total points scored by the away team in this Quarter. |

HomeTeamScore | integer | 32 | Yes | No | Yes | The total points scored by the home team in this Quarter. |

Updated | datetime | Yes | No | Yes | The database generated timestamp of when this Quarter was last updated. | |

Created | datetime | Yes | No | Yes | The database generated timestamp of when this Quarter was first created. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

PlayID | integer | 32 | No | No | Yes | Unique identifier for each Play. |

QuarterID | integer | 32 | No | No | Yes | The QuarterID of the Quarter record, in which this Play occurred. |

QuarterName | string | 10 | Yes | No | Yes | The Name of the Quarter, in which this Play occurred. |

Sequence | integer | 32 | Yes | No | Yes | The order in which this Play / Event happened over the course of the Game. |

TimeRemainingMinutes | integer | 32 | Yes | No | Yes | The minutes of the time remaining in the Quarter, when this play occurred. |

TimeRemainingSeconds | integer | 32 | Yes | No | Yes | The seconds of the time remaining in the Quarter, when this play occurred. |

PlayTime | datetime | Yes | No | Yes | The estimated timestamp of when this Play occurred on the field. Please note that we do not have scouts at the venue, so this is an estimate based on our TV feed and estimated TV feed delay. | |

Updated | datetime | Yes | No | Yes | The database generated timestamp of when this Play was last updated. | |

Created | datetime | Yes | No | Yes | The database generated timestamp of when this Play was first created. | |

Team | string | 10 | Yes | No | Yes | The abbreviation of the Team that this Play was executed by. |

Opponent | string | 10 | Yes | No | Yes | The abbreviation of the Opponent of the Team that this Play was executed by. |

Down | integer | 32 | Yes | Yes | Yes | The Down when this Play occurred. |

Distance | integer | 32 | Yes | Yes | Yes | The Distance when this Play occurred. |

YardLine | integer | 32 | Yes | Yes | Yes | The Yard Line of where this Play occurred. |

YardLineTerritory | string | 10 | Yes | Yes | Yes | The Territory of the Yard Line of where this Play occurred. |

YardsToEndZone | integer | 32 | Yes | Yes | Yes | The number of yards to go to reach the end zone at the start of the Play. |

Type | string | 20 | Yes | No | Yes | The Type of Play that occurred (possible values: Rush, PassCompleted, PassIncomplete, PassIntercepted, TwoPointConversion, Punt, Kickoff, FieldGoal, ExtraPoint, Fumble, Penalty, Sack, Timeout, Period) |

YardsGained | integer | 32 | Yes | Yes | Yes | The yards gained or lost on the play |

Description | string | 250 | Yes | Yes | Yes | The description of the Play. |

IsScoringPlay | boolean | Yes | No | Yes | Indicates whether this Play was a scoring play. |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

PlayStatID | integer | 32 | No | No | Yes | Unique identifier for each PlayStat. |

PlayID | integer | 32 | No | No | Yes | The PlayID of the Play record, in which this PlayStat occurred. |

Sequence | integer | 32 | No | No | Yes | The order in which the PlayStat was registered to the Play. |

PlayerID | integer | 32 | No | No | Yes | The PlayerID of the Player whose stats this represents. |

Name | string | 50 | No | No | Yes | The Name of the Player whose stats this represents. |

Team | string | 10 | No | No | Yes | The Team of the Player. |

Opponent | string | 10 | No | No | Yes | The Opponent of the Player. |

HomeOrAway | string | 4 | No | No | Yes | Whether the Player was Home or Away (possible values: HOME, AWAY) |

Direction | string | 20 | Yes | Yes | Yes | The Direction this Play occurred (possible values: Left, Middle, Right) |

Updated | datetime | Yes | No | Yes | The database generated timestamp of when this PlayStat was last updated. | |

Created | datetime | Yes | No | Yes | The database generated timestamp of when this PlayStat was first created. | |

PassingAttempts | integer | 32 | Yes | Yes | Yes | Passing attempts on the play |

PassingCompletions | integer | 32 | Yes | Yes | Yes | Passing completions on the play |

PassingYards | integer | 32 | Yes | Yes | Yes | Passing yards on the play |

PassingTouchdowns | integer | 32 | Yes | Yes | Yes | Passing touchdowns thrown on the play |

PassingInterceptions | integer | 32 | Yes | Yes | Yes | Passing interceptions thrown on the play |

PassingSacks | integer | 32 | Yes | Yes | Yes | Times sacked on the play |

PassingSackYards | integer | 32 | Yes | Yes | Yes | Yards lost from being sacked on the play |

RushingAttempts | integer | 32 | Yes | Yes | Yes | Rushing attempts on the play |

RushingYards | integer | 32 | Yes | Yes | Yes | Rushing yards on the play |

RushingTouchdowns | integer | 32 | Yes | Yes | Yes | Rushing touchdowns on the play |

ReceivingTargets | integer | 32 | Yes | Yes | Yes | Receiving targets on the play |

Receptions | integer | 32 | Yes | Yes | Yes | Receptions on the play |

ReceivingYards | integer | 32 | Yes | Yes | Yes | Receiving yards on the play |

ReceivingTouchdowns | integer | 32 | Yes | Yes | Yes | Receiving touchdowns on the play |

Fumbles | integer | 32 | Yes | Yes | Yes | Times fumbled on the play |

FumblesLost | integer | 32 | Yes | Yes | Yes | Fumbles lost on the play |

TwoPointConversionAttempts | integer | 32 | Yes | Yes | Yes | Two point conversion attempts on the play |

TwoPointConversionPasses | integer | 32 | Yes | Yes | Yes | Two point conversion passes on the play |

TwoPointConversionRuns | integer | 32 | Yes | Yes | Yes | Two point conversion runs on the play |

TwoPointConversionReceptions | integer | 32 | Yes | Yes | Yes | Two point conversion receptions on the play |

TwoPointConversionReturns | integer | 32 | Yes | Yes | Yes | Two point conversion returns on the play |

SoloTackles | integer | 32 | Yes | Yes | Yes | Solo tackles on the play |

AssistedTackles | integer | 32 | Yes | Yes | Yes | Assisted tackles on the play |

TacklesForLoss | integer | 32 | Yes | Yes | Yes | Tackles for loss of yards on the play |

Sacks | decimal | 32 | Yes | Yes | Yes | Sacks by this player on the play |

SackYards | decimal | 32 | Yes | Yes | Yes | Sack yards by this player on the play |

PassesDefended | integer | 32 | Yes | Yes | Yes | Passes defended on the play |

Safeties | integer | 32 | Yes | Yes | Yes | Safeties scored by this player on the play |

FumblesForced | integer | 32 | Yes | Yes | Yes | Fumbles forced on the play |

FumblesRecovered | integer | 32 | Yes | Yes | Yes | Fumbles recovered on the play |

FumbleReturnYards | integer | 32 | Yes | Yes | Yes | Fumble recovery return yards on the play |

FumbleReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Fumble recoveries returned for touchdowns on the play |

Interceptions | integer | 32 | Yes | Yes | Yes | Interceptions made on the play |

InterceptionReturnYards | integer | 32 | Yes | Yes | Yes | Interception return yards on the play |

InterceptionReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Interception return touchdowns on the play |

PuntReturns | integer | 32 | Yes | Yes | Yes | Punts returned on the play |

PuntReturnYards | integer | 32 | Yes | Yes | Yes | Punt return yards on the play |

PuntReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Punt returns for touchdowns on the play |

KickReturns | integer | 32 | Yes | Yes | Yes | Kicks returned on the play |

KickReturnYards | integer | 32 | Yes | Yes | Yes | Kick return yards on the play |

KickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Kick return touchdowns on the play |

BlockedKicks | integer | 32 | Yes | Yes | Yes | Blocked kicks on the play |

BlockedKickReturns | integer | 32 | Yes | Yes | Yes | Blocked kick returns on the play |

BlockedKickReturnYards | integer | 32 | Yes | Yes | Yes | Blocked kick return yards on the play |

BlockedKickReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Blocked kick return touchdowns on the play |

FieldGoalReturns | integer | 32 | Yes | Yes | Yes | Field goal returns on the play |

FieldGoalReturnYards | integer | 32 | Yes | Yes | Yes | Field goal return yards on the play |

FieldGoalReturnTouchdowns | integer | 32 | Yes | Yes | Yes | Field goal return touchdowns on the play |

Kickoffs | integer | 32 | Yes | Yes | Yes | Kickoffs by this player on the play |

KickoffYards | integer | 32 | Yes | Yes | Yes | Gross kickoff yards by this player on the play |

KickoffTouchbacks | integer | 32 | Yes | Yes | Yes | Kickoff touchbacks on the play |

Punts | integer | 32 | Yes | Yes | Yes | Punts by this player on the play |

PuntYards | integer | 32 | Yes | Yes | Yes | Gross punt yards by this player on the play |

PuntTouchbacks | integer | 32 | Yes | Yes | Yes | Punt touchbacks by this player on the play |

PuntsHadBlocked | integer | 32 | Yes | Yes | Yes | Punts by this player that were blocked on the play |

FieldGoalsAttempted | integer | 32 | Yes | Yes | Yes | Field goals attempted on the play |

FieldGoalsMade | integer | 32 | Yes | Yes | Yes | Field goals made on the play |

FieldGoalsYards | integer | 32 | Yes | Yes | Yes | Field goal yards attempted on the play |

FieldGoalsHadBlocked | integer | 32 | Yes | Yes | Yes | Field goals attempted by this player that were blocked on the play |

ExtraPointsAttempted | integer | 32 | Yes | Yes | Yes | Extra points attempted by this player on the play |

ExtraPointsMade | integer | 32 | Yes | Yes | Yes | Extra points made by this player on the play |

ExtraPointsHadBlocked | integer | 32 | Yes | Yes | Yes | Extra point attempts by this player that were blocked on the play |

Penalties | integer | 32 | Yes | Yes | Yes | Penalties enforced against this player on the play |

PenaltyYards | integer | 32 | Yes | Yes | Yes | Penalty yards enforced against this player on the play |

Column | Type | Size | Nullable |
Scrambled |
CSV | Description |
---|---|---|---|---|---|---|

GameKey | string | 10 | No | No | No | |

PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |

SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason). |

Season | integer | 32 | No | No | Yes | The NFL season of the game |

GameDate | datetime | No | No | Yes | The date/time of the game | |

Week | integer | 32 | No | No | Yes | The NFL week of the game (weeks 18-21 denote playoff games) |

Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |

Opponent | string | 50 | Yes | No | Yes | The abbreviation of the Opponent |

HomeOrAway | string | 4 | Yes | No | Yes | Whether the player is Home or Away |

Number | integer | 32 | No | No | Yes | Player's jersey number |

Name | string | 50 | Yes | No | Yes | Player's name |

Position | string | 50 | Yes | No | Yes | Player's position for this particular game or season. Possible values: C, CB, DB, DE, DE/LB, DL, DT, FB, FS, G, ILB, K, KR, LB, LS, NT, OL, OLB, OT, P, QB, RB, S, SS, T, TE, WR |

PositionCategory | string | 50 | Yes | No | Yes | Abbreviation of either Offense, Defense or Special Teams (OFF, DEF, ST) |

Activated | integer | 32 | No | No | Yes | Whether the player was Active at gametime |

Played | integer | 32 | No | No | Yes | Whether the player played in at least one play |

Started | integer | 32 | No | No | Yes | Whether the player started on offense or defense |

PassingAttempts | decimal | 32 | No | Yes | Yes | Number of passes thrown |

PassingCompletions | decimal | 32 | No | Yes | Yes | Number of pass completions |

PassingYards | decimal | 32 | No | Yes | Yes | Number of passing yards |

PassingCompletionPercentage | decimal | 32 | No | Yes | Yes | Percentage of passes that were completed |

PassingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average passing yards gained per attempt |

PassingYardsPerCompletion | decimal | 32 | No | Yes | Yes | Average passing yards gained per completion |

PassingTouchdowns | decimal | 32 | No | Yes | Yes | Passing touchdowns scored |

PassingInterceptions | decimal | 32 | No | Yes | Yes | Interceptions thrown |

PassingRating | decimal | 32 | No | Yes | Yes | Passer rating |

PassingLong | decimal | 32 | No | Yes | Yes | Longest completion |

PassingSacks | decimal | 32 | No | Yes | Yes | Number of times sacked |

PassingSackYards | decimal | 32 | No | Yes | Yes | Yards lost as a result of being sacked |

RushingAttempts | decimal | 32 | No | Yes | Yes | Number of rushing attempts |

RushingYards | decimal | 32 | No | Yes | Yes | Number of rushing yards |

RushingYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average rushing yards gained per attempt |

RushingTouchdowns | decimal | 32 | No | Yes | Yes | Rushing touchdowns scored |

RushingLong | decimal | 32 | No | Yes | Yes | Longest rush |

ReceivingTargets
from 2009 |
decimal | 32 | Yes | Yes | Yes | Number of times targeted by passer |

Receptions | decimal | 32 | No | Yes | Yes | Number of receptions |

ReceivingYards | decimal | 32 | No | Yes | Yes | Total receiving yards |

ReceivingYardsPerReception | decimal | 32 | No | Yes | Yes | Average yards gained per reception |

ReceivingTouchdowns | decimal | 32 | No | Yes | Yes | Receiving touchdowns |

ReceivingLong | decimal | 32 | No | Yes | Yes | Longest reception |

Fumbles | decimal | 32 | No | Yes | Yes | Times fumbled |

FumblesLost
from 2003 |
decimal | 32 | Yes | Yes | Yes | Number of fumbles recovered by opponent |

PuntReturns | decimal | 32 | No | Yes | Yes | Number of punt return attempts |

PuntReturnYards | decimal | 32 | No | Yes | Yes | Total return yards on punts |

PuntReturnYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average yards gained per punt return |

PuntReturnTouchdowns | decimal | 32 | No | Yes | Yes | Number of touchdowns on punt returns |

PuntReturnLong | decimal | 32 | No | Yes | Yes | Longest punt return |

KickReturns | decimal | 32 | No | Yes | Yes | Number of kick return attempts |

KickReturnYards | decimal | 32 | No | Yes | Yes | Total return yards on kicks |

KickReturnYardsPerAttempt | decimal | 32 | No | Yes | Yes | Average yards gained per kick return |

KickReturnTouchdowns | decimal | 32 | No | Yes | Yes | Number of touchdowns on kick returns |

KickReturnLong | decimal | 32 | No | Yes | Yes | Longest kick return |

SoloTackles | decimal | 32 | No | Yes | Yes | Solo, unassisted tackles |

AssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles (also called a half tackle) |

TacklesForLoss
from 2008 |
decimal | 32 | Yes | Yes | Yes | Tackles behind the opponent's line of scrimmage |

Sacks | decimal | 32 | No | Yes | Yes | Sacks of the opposing quarterback |

SackYards | decimal | 32 | No | Yes | Yes | Yards lost as a result of sacking the opposing quarterback |

QuarterbackHits
from 2006 |
decimal | 32 | Yes | Yes | Yes | Number of times hitting an opposing quarterback without sacking him |

PassesDefended | decimal | 32 | No | Yes | Yes | Passes defended or batted down |

FumblesForced | decimal | 32 | No | Yes | Yes | Number of fumbles forced |

FumblesRecovered | decimal | 32 | No | Yes | Yes | Number of fumbles recovered |

FumbleReturnYards | decimal | 32 | No | Yes | Yes | Return yards from fumble recoveries |

FumbleReturnTouchdowns | decimal | 32 | No | Yes | Yes | Return touchdowns from fumble recoveries |

Interceptions | decimal | 32 | No | Yes | Yes | Number of interceptions |

InterceptionReturnYards | decimal | 32 | No | Yes | Yes | Return yards from interceptions |

InterceptionReturnTouchdowns | decimal | 32 | No | Yes | Yes | Return touchdowns from interceptions |

BlockedKicks | decimal | 32 | No | Yes | Yes | Total number of field goals and punts blocked |

SpecialTeamsSoloTackles | decimal | 32 | No | Yes | Yes | Solo tackles on kick and punt plays |

SpecialTeamsAssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles on kick and punt plays |

MiscSoloTackles | decimal | 32 | No | Yes | Yes | Solo tackles when playing offense (after a turnover) |

MiscAssistedTackles | decimal | 32 | No | Yes | Yes | Assisted tackles when playing offense (after a turnover) |

Punts | decimal | 32 | No | Yes | Yes | Number of punts |

PuntYards | decimal | 32 | No | Yes | Yes | Total number of punt yards |

PuntAverage | decimal | 32 | No | Yes | Yes | Average yards per punt |

FieldGoalsAttempted | decimal | 32 | No | Yes | Yes | Number of field goal attempts |

FieldGoalsMade | decimal | 32 | No | Yes | Yes | Number of successful field goal attempts |

FieldGoalsLongestMade | decimal | 32 | No | Yes | Yes | Longest successful field goal attempt |

ExtraPointsMade | decimal | 32 | No | Yes | Yes | Number of successful extra points |

TwoPointConversionPasses | decimal | 32 | No | Yes | Yes | Successful two point conversion passes |

TwoPointConversionRuns | decimal | 32 | No | Yes | Yes | Successful two point conversion runs |

TwoPointConversionReceptions | decimal | 32 | No | Yes | Yes | Successful two point conversion receptions |

FantasyPoints | decimal | 32 | No | Yes | Yes | |

FantasyPointsPPR | decimal | 32 | No | Yes | No | Fantasy points scored based on basic PPR fantasy scoring system (https://fantasydata.com/resources/fantasy-scoring-system.aspx) |

ReceptionPercentage | decimal | 32 | No | Yes | Yes | Percentage of ReceivingTargets convert into Receptions |

ReceivingYardsPerTarget | decimal | 32 | No | Yes | Yes | Average yards gained per ReceivingTargets |

Tackles | decimal | 32 | No | Yes | Yes | Sum of SoloTackles and AssistedTackles |

OffensiveTouchdowns | decimal | 32 | No | Yes | Yes | Offensive touchdowns scored |

DefensiveTouchdowns | decimal | 32 | No | Yes | Yes | Defensive touchdowns scored |

SpecialTeamsTouchdowns | decimal | 32 | No | Yes | Yes | Special teams touchdowns scored |

Touchdowns | decimal | 32 | No | Yes | Yes | Total touchdowns scored |

FantasyPosition | string | 50 | Yes | No | Yes | The player's fantasy football position (e.g. QB, RB, WR, TE, K, DL, LB, DB) |

FieldGoalPercentage | decimal | 32 | No | Yes | Yes | Percentage of Field Goal attempts that we successful |

PlayerGameID | integer | 32 | No | No | Yes | Unique ID of PlayerGame record (subject to change, although it very rarely does). For a static ID, use a combination of GameKey and PlayerID. |

FumblesOwnRecoveries | decimal | 32 | Yes | Yes | Yes | Own team's fumbles recovered (did not result in a turnover) |

FumblesOutOfBounds | decimal | 32 | Yes | Yes | Yes | Fumbles by this player that went out of bounds (no one was awarded the recovery) |

KickReturnFairCatches | decimal | 32 | Yes | Yes | Yes | Fair catches made on kickoffs |

PuntReturnFairCatches | decimal | 32 | Yes | Yes | Yes | Fair catches made on punts |

PuntTouchbacks | decimal | 32 | Yes | Yes | Yes | Punts by this player that were touchbacks |

PuntInside20 | decimal | 32 | Yes | Yes | Yes | Punts by this player that were downed inside the 20 yard line |

PuntNetAverage | decimal | 32 | Yes | Yes | Yes | Net punt average (includes punt return yards as negative) |

ExtraPointsAttempted | decimal | 32 | Yes | Yes | Yes | Extra point kicks attempted |

BlockedKickReturnTouchdowns | decimal | 32 | Yes | Yes | Yes | Blocked kicks that this player returned for touchdowns |

FieldGoalReturnTouchdowns | decimal | 32 | Yes | Yes | Yes | Field goals that this player returned for touchdowns |

Safeties | decimal | 32 | Yes | Yes | Yes | Defensive safeties (sacks in end zone, solo tackles in end zone, blocked kicks that went out of bounds in the end zone) |

FieldGoalsHadBlocked | decimal | 32 | Yes | Yes | Yes | Field goal attempts that were blocked |

PuntsHadBlocked | decimal | 32 | Yes | Yes | Yes | Punts that were blocked |