STAT-API

NFL Data Dictionary

Main

nfl.seasons8 fieldsendpoints →

Each NFL league year, from the opening of training camp through the Super Bowl. The 2025 season refers to the 2025-26 league year, kicking off in early August and ending in February.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
end_datetimestamptznullable—2025-02-09T00:00:00.000ZLast day of the season (Super Bowl date or shortly after).
post_season_start_datetimestamptznullable—2025-01-11T00:00:00.000ZFirst day of the postseason (Wild Card weekend).
regular_season_start_datetimestamptznullable—2024-09-05T00:00:00.000ZFirst day of regular-season play (typically the Thursday after Labor Day).
regular_season_weeksinteger—18Number of regular-season weeks (18 since 2021; 17 in 2020 and earlier).
start_datetimestamptz—2024-09-05T00:00:00.000ZFirst day of the season (typically the start of preseason in early August).
start_yearinteger—2024Calendar year in which the season starts (e.g., 2025 = the 2025-26 season).
super_bowl_datetimestamptznullable—2025-02-09T00:00:00.000ZDate of the Super Bowl for this season.
nfl.teams13 fields· 2 refsendpoints →

The 32 NFL franchises plus historical predecessors — teams that have since relocated, renamed, or merged into the current league.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
league_team_idstring→ nfl.teams10403800-517c-7b8c-65a3-c61b95d86123Official NFL team UUID from api.nfl.com
stadium_idbigint→ nfl.stadiums16Primary home stadium (FK to `stadiums`); null if unknown or shared.
abbreviationstring—ARIThree-letter team code (e.g., KC, NE, GB).
activeboolean—trueTrue for currently-active franchises; false for relocated or defunct teams retained for historical references.
citystring—Los Angeles—
conferencestring—NFCConference assignment (AFC or NFC).
ValuesNFCAFC
divisionstring—WestDivision within the conference (e.g., AFC East, NFC West).
ValuesWestSouthNorthEast
full_namestring—Arizona Cardinals—
logo_urlstringnullable—https://a.espncdn.com/i/teamlogos/nfl/500/ari.pngURL to team logo image
namestring—Cardinals—
primary_colorstringnullable—#002244Hex color code for the team's primary uniform color (e.g., `#A71930`).
secondary_colorstringnullable—#000000Hex color code for the team's secondary uniform color.
Values#000000#FFB612#A5ACAF#C60C30#B0B7BC#A71930#9E7C0C#E64100#311D00#FB4F14#FFC20E#FFD100#F58220#FFC62F#B3995D#69BE28#322F2B#D50A0A
nfl.players27 fields· 2 refsendpoints →

Every individual who has played in the NFL — current rosters, free agents, retired veterans — plus team-defense entries used for fantasy and DST scoring.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
gsis_idstring—00-0022531Game Statistics and Information System ID (e.g. 00-0028830)
league_player_idstring→ nfl.players00-0022531Official NFL player ID (UUID) from nfl.com
team_idbigintnullable→ nfl.teams17Current NFL team (FK to `teams`); null for free agents and retired players.
birth_citystringnullable—Houston—
birth_countrystringnullable———
birth_datedatenullable—1997-02-14T05:00:00.000Z—
birth_statestringnullable—TX—
collegestringnullable—AlabamaCollege or last football affiliation before turning pro.
draft_numberstringnullable—1Pick number within the round; null or `UDFA` if undrafted.
draft_roundstringnullable—3Draft round (1-7); null or `UDFA` if undrafted.
draft_yearstringnullable—2023Calendar year the player was drafted; null or `UDFA` if undrafted.
experienceintegernullable—0Years of NFL experience (rookies = 0).
first_namestring—Michael—
full_namestring—Aaron Brewer—
full_position_liststringnullable——All positions the player is eligible at (semicolon-joined when multiple, e.g., `RB;WR`).
heightintegernullable—75Height in inches.
is_teamboolean—falseTrue for synthetic team-level entities (DST, team defense). Used to distinguish team defense 'players' from individual players.
Valuesfalsetrue
jerseystringnullable—35Jersey number with the player's current team (string to preserve leading zeros and special codes).
last_namestring—Jones—
nfl_slugstringnullable——URL slug used on nfl.com (e.g., `patrick-mahomes`).
overall_pickintegernullable—230Overall pick number across all rounds (1-262); null if undrafted.
position_groupstringnullable—OffenseBroad position group classification used by nflverse (e.g., `OFFENSE`, `DEFENSE`, `ST`).
ValuesOffenseDefenseSpecial Teams
primary_positionstring—DBPrimary roster position (e.g., QB, WR, RB, CB).
ValuesDBOLDLLBWRRBTEQBKPLSDST
profile_pic_urlstringnullable—https://static.www.nfl.com/image/upload/f_auto,q_auto/league/xcsyqvrlrpe6s3d0rodqURL to player profile picture image
roster_statusstringnullable—A01Canonical roster status, shared across leagues. NFL has the richest source vocabulary. The "on a team now" set is {active, injured_reserve, practice_squad, reserve, suspended}; free_agent/waived/retired/inactive are off-roster.
weightintegernullable—200Weight in pounds.
nfl.games31 fields· 5 refsendpoints →

Every scheduled and played NFL game — preseason exhibitions, the 18-week regular season, the playoffs from Wild Card weekend through the Super Bowl.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
away_team_idbigint→ nfl.teams19—
home_team_idbigint→ nfl.teams16—
league_game_idstring→ nfl.gamesc7ce9df0-2459-11ef-afd1-646009f18b2eOfficial NFL game ID from league source
season_idbigint→ nfl.seasons2024—
stadium_idinteger→ nfl.stadiums16Stadium hosting the game (FK to `stadiums`).
attendanceintegernullable——Reported attendance count; null when not published.
away_rotation_numberintegernullable——Sportsbook rotation number for the away team (3-4 digit cross-book reference).
away_teamstring—LARDenormalized team abbreviation for the away side at game time (snapshot copy of `teams.abbreviation`).
away_team_scoreinteger—0Final away-team score; 0 (not null) until the game completes.
channelstringnullable——Primary broadcast network/channel (e.g., `CBS`, `FOX`, `Prime Video`).
dayinteger—20210103Calendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern.
end_timetimestamptznullable——Actual game end timestamp; null until the game completes.
game_labelstringnullable—AFC Wild CardDisplay label for special games (e.g., `Thanksgiving Day`, `Monday Night Football`).
ValuesAFC Wild CardNFC Wild CardAFC DivisionalNFC DivisionalNFC ChampionshipAFC ChampionshipSuper Bowl
game_sub_labelstringnullable——Secondary label or sub-category for the game.
game_timetimestamptz—2024-09-15T17:00:00.000ZScheduled kickoff time (timezone-aware).
home_rotation_numberintegernullable——Sportsbook rotation number for the home team (3-4 digit cross-book reference).
home_teamstring—KCDenormalized team abbreviation for the home side at game time (snapshot copy of `teams.abbreviation`).
home_team_scoreinteger—0Final home-team score; 0 (not null) until the game completes.
neutral_venueboolean—falseTrue if the game is played at a neutral site (Super Bowl, international games, etc.).
Valuesfalsetrue
overtimeboolean—falseTrue if the game went to overtime.
Valuesfalsetrue
overtime_periodsintegernullable——Number of overtime periods played (1+ when `overtime` is true).
playoff_roundstringnullable—Wild CardPostseason round (`WildCard`, `Divisional`, `Conference Championship`, `Super Bowl`); null outside the postseason.
ValuesWild CardDivisionalConference ChampionshipSuper Bowl
playoff_seed_awayintegernullable——Away-team playoff seed (1-7); null outside the postseason.
playoff_seed_homeintegernullable——Home-team playoff seed (1-7); null outside the postseason.
postponed_statusstringnullable——Reason for postponement (e.g., `Weather`, `COVID`); null for games played as scheduled.
season_typestring—regular_seasonCanonical season phase. Postseason round detail (Wild Card / Divisional / Conference Championship / Super Bowl) lives in `playoff_round`.
Valuesregular_seasonpreseasonpostseason
start_timetimestamptz—2024-09-15T17:00:00.000ZActual kickoff timestamp; null before the game starts.
statusstring—FinalGame status. Currently always `Scheduled` (status reconciliation is pending) — detect completed games via populated scores, not this field.
ValuesFinalScheduledCanceled
typestring—RegularGame classification (`Regular`, `Playoff`, `Super Bowl`, `Preseason`).
ValuesRegularPreseasonPlayoff
weekinteger—1Week number within the season stage — 1-18 for regular season, restarting at 1 in the postseason (1 Wild Card, 2 Divisional, 3 Conference Championship, 4 Super Bowl). Note nfl.injuries.week uses the continuous 19-22 convention instead.

Plays

nfl.game_drives22 fields· 2 refsendpoints →

Each offensive possession in an NFL game — how the drive started, how it ended (touchdown, field goal, punt, turnover), starting and ending field position, time of possession, and play count.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
first_play_idbigint—40play_id of first play in drive
game_idbigint→ nfl.games222—
last_play_idbigint—131play_id of last play in drive
possession_team_idbigint→ nfl.teams13Team with possession (FK to teams)
drive_numberinteger—2Drive sequence number in game (1-indexed)
end_transitionstringnullable—PUNTHow possession ended (PUNT, TOUCHDOWN, TURNOVER, etc.)
ValuesPUNTTOUCHDOWNFIELD_GOALINTERCEPTIONDOWNSFUMBLEEND_GAMEEND_HALFMISSED_FGSAFETYBLOCKED_PUNTBLOCKED_FGBLOCKED_PUNT,_DOWNSFUMBLE,_SAFETYBLOCKED_FG,_DOWNS
end_yard_linestringnullable—50Ending field position (e.g., "OPP 10")
ended_with_scoreboolean—falseDrive resulted in points
Valuesfalsetrue
first_downsintegernullable—0First downs gained
fixed_driveinteger—2Corrected drive number from nflverse
game_clock_endstringnullable—00:00Game clock at drive end (mm:ss)
game_clock_startstringnullable—15:00Game clock at drive start (mm:ss)
inside_20boolean—falseDrive reached red zone
Valuesfalsetrue
play_countintegernullable—3Number of plays in drive
quarter_endintegernullable—2Quarter when drive ended
quarter_startintegernullable—2Quarter when drive started
resultstringnullable—PuntDrive outcome (Touchdown, Field goal, Punt, Turnover, etc.)
ValuesPuntTouchdownField goalTurnoverEnd of halfTurnover on downsMissed field goalOpp touchdownSafety
start_transitionstringnullable—KICKOFFHow possession was gained (KICKOFF, PUNT, TURNOVER, etc.)
ValuesKICKOFFPUNTINTERCEPTIONDOWNSFUMBLEMISSED_FGMUFFED_PUNTBLOCKED_PUNTONSIDE_KICKBLOCKED_PUNT,_DOWNSBLOCKED_FG,_DOWNSBLOCKED_FGMUFFED_KICKOFF
start_yard_linestringnullable—LV 30Starting field position (e.g., "KC 25")
time_of_possessionstringnullable—1:30Drive duration (mm:ss format)
yds_penalizedintegernullable—0Penalty yards on drive
nfl.play_by_plays372 fields· 49 refsendpoints →

Every individual play of every NFL game — what happened, where on the field, with what result. Includes pass and rush attempts, penalties, special teams, EPA, win probability, and the full game-clock and down-and-distance context.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
assist_tackle_1_player_idstringnullable→ nfl.players00-0037616Assist tackler 1 GSIS ID
assist_tackle_2_player_idstringnullable→ nfl.players00-0036294Assist tackler 2 GSIS ID
assist_tackle_3_player_idstringnullable→ nfl.players—Assist tackler 3 GSIS ID
assist_tackle_4_player_idstringnullable→ nfl.players—Assist tackler 4 GSIS ID
blocked_player_idstringnullable→ nfl.players00-0037527Blocked kick player GSIS ID
Values00-003752700-003784300-003698200-0037156
defensive_team_idbigintnullable→ nfl.teams14FK to teams table for defensive team
drive_idbigintnullable——FK to game_drives table
fantasy_idstringnullable—00-0035700Fantasy identifier
fantasy_player_idstringnullable→ nfl.players00-0034844Fantasy designation player ID
forced_fumble_player_1_player_idstringnullable→ nfl.players00-0033868Forced fumble player 1 GSIS ID
forced_fumble_player_2_player_idstringnullable→ nfl.players—Forced fumble player 2 GSIS ID
fumble_recovery_1_player_idstringnullable→ nfl.players00-0037666Recovery player 1 GSIS ID
fumble_recovery_2_player_idstringnullable→ nfl.players—Recovery player 2 GSIS ID
fumbled_1_player_idstringnullable→ nfl.players00-0036442First fumbler GSIS ID
fumbled_2_player_idstringnullable→ nfl.players—Second fumbler GSIS ID
game_idbigint→ nfl.games50FK to games table
half_sack_1_player_idstringnullable→ nfl.players00-0039148Half-sack player 1 GSIS ID
Values00-003914800-003850400-003237800-003695400-003267100-003241500-003910800-003589000-003760300-003694000-0035402
half_sack_2_player_idstringnullable→ nfl.players00-0036130Half-sack player 2 GSIS ID
Values00-003613000-003648000-003434400-003104000-003438500-003158300-003156500-003637800-003853500-003257400-003632100-0034251
interception_player_idstringnullable→ nfl.players00-0036388Interceptor GSIS ID
kicker_player_idstringnullable→ nfl.players00-0038905Kicker GSIS ID
kickoff_returner_player_idstringnullable→ nfl.players00-0037429Kickoff returner GSIS ID
lateral_interception_player_idstringnullable→ nfl.players—Lateral after INT GSIS ID
lateral_kickoff_returner_player_idstringnullable→ nfl.players—Lateral kickoff returner GSIS ID
lateral_punt_returner_player_idstringnullable→ nfl.players—Lateral punt returner GSIS ID
lateral_receiver_player_idstringnullable→ nfl.players00-0038976Lateral receiver GSIS ID (pass)
lateral_rusher_player_idstringnullable→ nfl.players00-0034975Lateral receiver GSIS ID (rush)
lateral_sack_player_idstringnullable→ nfl.players—Lateral after sack GSIS ID
nfl_api_idstringnullable—7d4019ca-1312-11ef-afd1-646009f18b2eUUID from NFL API
nflverse_game_idstringnullable→ nfl.games—Ten digit identifier for NFL game (nflverse format)
old_game_idstringnullable→ nfl.games2024090600Legacy NFL game ID format
own_kickoff_recovery_player_idstringnullable→ nfl.players—Own kickoff recovery player GSIS ID
pass_defense_1_player_idstringnullable→ nfl.players00-0034856Pass defense player 1 GSIS ID
pass_defense_2_player_idstringnullable→ nfl.players00-0031554Pass defense player 2 GSIS ID
Values00-003155400-003724600-003423400-003982900-003502000-003725000-0034720
passer_idbigintnullable—358FK to players table
passer_player_idstringnullable→ nfl.players00-0033537Passer GSIS ID
penalty_player_idstringnullable→ nfl.players00-0036874Penalized player GSIS ID
play_idstring—1Numeric play identifier unique to game
possession_team_idbigintnullable→ nfl.teams8FK to teams table for possession team
primary_player_gsis_idstringnullable——Primary player GSIS ID
punt_returner_player_idstringnullable→ nfl.players00-0039392Punt returner GSIS ID
punter_player_idstringnullable→ nfl.players00-0032943Punter GSIS ID
qb_hit_1_player_idstringnullable→ nfl.players00-0036932QB hitter GSIS ID
qb_hit_2_player_idstringnullable→ nfl.players00-0036130Second QB hitter GSIS ID
Values00-003613000-003648000-003434400-003104000-003438500-003158300-003156500-003257400-003632100-0034251
receiver_idbigintnullable—438FK to players table
receiver_player_idstringnullable→ nfl.players00-0033908Receiver GSIS ID
rusher_idbigintnullable—943FK to players table
rusher_player_idstringnullable→ nfl.players00-0035700Rusher GSIS ID
sack_player_idstringnullable→ nfl.players00-0036914Sacker GSIS ID
safety_player_idstringnullable→ nfl.players00-0035248Safety scorer GSIS ID
Values00-003524800-0037251
solo_tackle_1_player_idstringnullable→ nfl.players00-0034987Solo tackler 1 GSIS ID
solo_tackle_2_player_idstringnullable→ nfl.players00-0039753Solo tackler 2 GSIS ID
Values00-003975300-0039032
stadium_idintegernullable→ nfl.stadiums—Stadium ID
tackle_for_loss_1_player_idstringnullable→ nfl.players00-0034973TFL player 1 GSIS ID
tackle_for_loss_2_player_idstringnullable→ nfl.players—TFL player 2 GSIS ID
tackle_with_assist_1_player_idstringnullable→ nfl.players00-0031898Tackle-assist player 1 GSIS ID
tackle_with_assist_2_player_idstringnullable→ nfl.players—Tackle-assist player 2 GSIS ID
td_player_idstringnullable→ nfl.players00-0033906TD scorer GSIS ID
aborted_playboolean—falsePlay was aborted
Valuesfalsetrue
air_epadecimalnullable—-0.1479EPA from air yards
air_wpadecimalnullable—0.0000WPA from air yards
air_ydsintegernullable—5Yards in air (perpendicular to LOS)
assist_tackleboolean—falseAssist tackle on play
Valuesfalsetrue
assist_tackle_1_player_namestringnullable—J.JonesAssist tackler 1 name
assist_tackle_1_teamstringnullable—INDAssist tackler 1 team
assist_tackle_2_player_namestringnullable—L.WilsonAssist tackler 2 name
assist_tackle_2_teamstringnullable—LAAssist tackler 2 team
assist_tackle_3_player_namestringnullable——Assist tackler 3 name
assist_tackle_3_teamstringnullable——Assist tackler 3 team
assist_tackle_4_player_namestringnullable——Assist tackler 4 name
assist_tackle_4_teamstringnullable——Assist tackler 4 team
away_coachstringnullable—Antonio PierceAway team head coach
away_scoreintegernullable—20Total away points
away_teamstringnullable—LVAway team abbreviation
away_timeouts_remainingintegernullable—3Away timeouts remaining
away_wpdecimalnullable—0.0001Away team win probability
away_wp_postdecimalnullable—0.0001Away WP after play
blocked_player_namestringnullable—S.OlubiBlocked kick player name
ValuesS.OlubiD.HardyC.GolstonI.Charles
comp_air_epadecimalnullable—0.0000Completion air EPA
comp_air_wpadecimalnullable—0.0000Completion air WPA
comp_yac_epadecimalnullable—0.0000Completion YAC EPA
comp_yac_wpadecimalnullable—0.0000Completion YAC WPA
complete_passboolean—falsePass completed
Valuesfalsetrue
cpdecimalnullable—0.8676Completion probability
cpoedecimalnullable—13.2417Completion percentage over expected
def_wpdecimalnullable—0.4537Win probability for defense
defensive_extra_point_attemptboolean—falseDefense extra point attempt
defensive_extra_point_convboolean—falseDefense extra point success
defensive_two_point_attemptboolean—falseDefense two-point attempt
defensive_two_point_convboolean—falseDefense two-point conversion success
defteamstringnullable—INDDefensive team abbreviation
defteam_scoreintegernullable—0Defense team score at start
defteam_score_postintegernullable—0Defense team score at end
defteam_timeouts_remainingintegernullable—3Defensive team timeouts
descstringnullable—GAMEFull play description text
div_gameboolean—falseDivision game
Valuesfalsetrue
downintegernullable—1Down (1-4)
driveintegernullable—6Drive number in game
drive_end_transitionstringnullable—FIELD_GOALHow drive ended
ValuesFIELD_GOALPUNTTOUCHDOWNDOWNSINTERCEPTIONEND_GAMEFUMBLEMISSED_FGEND_HALFBLOCKED_PUNTSAFETY
drive_end_yard_linestringnullable—50Yard line at drive end
drive_ended_with_scoreboolean—trueDrive resulted in score
Valuestruefalse
drive_first_downsintegernullable—0First downs gained in drive
drive_game_clock_endstringnullable—00:00Game clock at drive end
drive_game_clock_startstringnullable—15:00Game clock at drive start
drive_inside20boolean—falseDrive reached red zone
Valuesfalsetrue
drive_play_countintegernullable—3Number of plays in drive
drive_play_id_endedstringnullable—4175Last play_id of drive
drive_play_id_startedstringnullable—40First play_id of drive
drive_quarter_endintegernullable—2Quarter when drive ended
drive_quarter_startintegernullable—3Quarter when drive started
drive_real_start_timestringnullable—2024-09-07T03:15:55.057ZDrive start time (real clock)
drive_start_transitionstringnullable—KICKOFFHow possession was obtained
ValuesKICKOFFPUNTINTERCEPTIONDOWNSFUMBLEMISSED_FGMUFFED_PUNTBLOCKED_PUNTMUFFED_KICKOFF
drive_start_yard_linestringnullable—PHI 30Yard line at drive start
drive_time_of_possessionstringnullable—2:28Drive time of possession (mm:ss)
drive_yds_penalizedintegernullable—0Penalty yards during drive
end_clock_timestringnullable—2024-09-15T17:30:53.207ZGame clock at play end
end_yard_linestringnullable——Yard line at play end
epdecimalnullable—0.9324Expected points before play
epadecimalnullable—0.0000Expected points added
extra_point_attemptboolean—falseExtra point attempt
Valuesfalsetrue
extra_point_probdecimalnullable—0.0000Extra point probability
extra_point_resultstringnullable—goodgood, failed, blocked, safety, aborted
Valuesgoodfailedblocked
fantasystringnullable—B.RobinsonFantasy designation
fantasy_player_namestringnullable—B.RobinsonFantasy designation player name
fg_probdecimalnullable—0.0000FG probability
field_goal_attemptboolean—falseField goal attempt
Valuesfalsetrue
field_goal_resultstringnullable—mademade, missed, or blocked
Valuesmademissed
first_downboolean—falseFirst down achieved
Valuesfalsetrue
first_down_passboolean—falsePassing first down
Valuesfalsetrue
first_down_penaltyboolean—falseFirst down via penalty
Valuesfalsetrue
first_down_rushboolean—falseRushing first down
Valuesfalsetrue
fixed_driveintegernullable—1Manual drive number correction
fixed_drive_resultstringnullable—Field goalManual drive result correction
ValuesField goalPuntTouchdownTurnoverTurnover on downsEnd of halfMissed field goalOpp touchdownSafety
forced_fumble_player_1_player_namestringnullable—M.GarrettForced fumble player 1 name
forced_fumble_player_1_teamstringnullable—KCForced fumble team 1
forced_fumble_player_2_player_namestringnullable——Forced fumble player 2 name
forced_fumble_player_2_teamstringnullable——Forced fumble team 2
fourth_down_convertedboolean—falseFourth down conversion
Valuesfalsetrue
fourth_down_failedboolean—falseFourth down failure
Valuesfalsetrue
fumbleboolean—falseFumble occurred
Valuesfalsetrue
fumble_forcedboolean—falseFumble was forced
Valuesfalsetrue
fumble_lostboolean—falseFumble was lost
Valuesfalsetrue
fumble_not_forcedboolean—falseFumble was not forced
Valuesfalsetrue
fumble_out_of_boundsboolean—falseFumble went OOB
Valuesfalsetrue
fumble_recovery_1_player_namestringnullable—J.TolbertRecovery player 1 name
fumble_recovery_1_teamstringnullable—CHIRecovery team 1
fumble_recovery_1_ydsintegernullable—0Recovery yards 1
fumble_recovery_2_player_namestringnullable——Recovery player 2 name
fumble_recovery_2_teamstringnullable——Recovery team 2
fumble_recovery_2_ydsintegernullable——Recovery yards 2
fumbled_1_player_namestringnullable—J.BurrowFirst fumbler name
fumbled_1_teamstringnullable—CINFirst fumbler team
fumbled_2_player_namestringnullable——Second fumbler name
fumbled_2_teamstringnullable——Second fumbler team
game_halfstringnullable—Half1Half1, Half2, or Overtime
ValuesHalf1Half2Overtime
game_seconds_remaininginteger—1800Seconds remaining in game
game_stadiumstringnullable—GEHA Field at Arrowhead StadiumGame stadium name
goal_to_goboolean—falseGoal-to-go situation
Valuesfalsetrue
half_sack_1_player_namestringnullable—K.WhiteHalf-sack player 1 name
ValuesK.WhiteT.SimpsonD.BucknerL.OnwuzurikeM.FoxM.JudonW.AndersonT.WhartonJ.PeevyO.OwehC.Granderson
half_sack_2_player_namestringnullable—J.MadubuikeHalf-sack player 2 name
ValuesJ.MadubuikeD.OdeyingboM.DavenportK.MackJ.BentleyG.JarrettD.HunterM.DannaDj.JohnsonM.PierceC.YoungD.Ekuale
half_seconds_remaininginteger—1800Seconds remaining in half
home_coachstringnullable—Nick SirianniHome team head coach
home_opening_kickoffboolean—trueHome team had opening kickoff
Valuestruefalse
home_scoreintegernullable—26Total home points
home_teamstringnullable—PHIHome team abbreviation
home_timeouts_remainingintegernullable—3Home timeouts remaining
home_wpdecimalnullable—0.9999Home team win probability
home_wp_postdecimalnullable—0.9999Home WP after play
incomplete_passboolean—falsePass incomplete
Valuesfalsetrue
interceptionboolean—falseInterception indicator
Valuesfalsetrue
interception_player_namestringnullable—X.McKinneyInterceptor name
jersey_numberintegernullable—8Primary player jersey
kick_distanceintegernullable—65Kick distance in yards
kicker_player_namestringnullable—B.GrupeKicker name
kickoff_attemptboolean—falseKickoff attempt
Valuesfalsetrue
kickoff_downedboolean—falseKickoff downed
kickoff_fair_catchboolean—falseKickoff fair catch
Valuesfalsetrue
kickoff_in_endzoneboolean—falseKickoff in endzone
Valuesfalsetrue
kickoff_inside_twentyboolean—falseKickoff inside 20
Valuesfalsetrue
kickoff_out_of_boundsboolean—falseKickoff OOB
Valuesfalsetrue
kickoff_returner_player_namestringnullable—R.BlackshearKickoff returner name
lateral_interception_player_namestringnullable——Lateral after INT name
lateral_kickoff_returner_player_namestringnullable——Lateral kickoff returner name
lateral_punt_returner_player_namestringnullable——Lateral punt returner name
lateral_receiver_player_namestringnullable—M.MimsLateral receiver name (pass)
lateral_receiving_ydsintegernullable—2Yards after lateral (pass)
lateral_receptionboolean—falseLateral on pass play
Valuesfalsetrue
lateral_returnboolean—falseLateral on return
lateral_rushboolean—falseLateral on rush play
Valuesfalsetrue
lateral_rusher_player_namestringnullable—J.HillLateral receiver name (rush)
lateral_rushing_ydsintegernullable—5Yards after lateral (rush)
lateral_sack_player_namestringnullable——Lateral after sack name
locationstringnullable—HomeHome or Neutral
ValuesHomeNeutral
namestringnullable—L.JacksonPrimary player name (passer or rusher)
no_huddleboolean—falseNo-huddle offense
Valuesfalsetrue
no_score_probdecimalnullable—0.0000Probability of no score
opp_fg_probdecimalnullable—0.0000Opponent FG probability
opp_safety_probdecimalnullable—0.0000Opponent safety probability
opp_td_probdecimalnullable—0.0000Opponent TD probability
order_sequencedecimalnullable—1.0000NFL play-ordering column
out_of_boundsboolean—falseRan/pushed/sacked out of bounds
Valuesfalsetrue
own_kickoff_recoveryboolean—falseOwn kickoff recovery
own_kickoff_recovery_player_namestringnullable——Own kickoff recovery player name
own_kickoff_recovery_tdboolean—falseOwn kickoff recovery TD
passboolean—falsePass play indicator
Valuesfalsetrue
pass_attemptboolean—falsePass attempt (includes sacks)
Valuesfalsetrue
pass_defense_1_player_namestringnullable—D.WardPass defense player 1 name
pass_defense_2_player_namestringnullable—E.KendricksPass defense player 2 name
ValuesE.KendricksJ.PitreP.FordD.MuasauD.Flannigan-FowlesM.EmersonR.Spillane
pass_lengthstringnullable—shortshort or deep
Valuesshortdeep
pass_locationstringnullable—rightleft, middle, or right
Valuesrightleftmiddle
pass_oedecimalnullable—37.7849Dropback percent over expected
pass_touchdownboolean—falsePassing touchdown
Valuesfalsetrue
passerstringnullable—D.WatsonDropback player name (includes scrambles)
passer_jersey_numberintegernullable—8Passer jersey number
passer_player_namestringnullable—D.WatsonPasser name
passing_ydsintegernullable—5Official passing yards
penaltyboolean—falsePenalty on play
Valuesfalsetrue
penalty_player_namestringnullable—P.SurtainPenalized player name
penalty_teamstringnullable—CLEPenalized team
penalty_typestringnullable—Offensive HoldingType of penalty
penalty_ydsintegernullable—5Penalty yards
playboolean—trueRegular play (1) vs special event (0)
Valuestruefalse
play_clockintegernullable—0Play clock at snap
play_deletedboolean—falsePlay was deleted
play_typestringnullable—passpass, run, punt, field_goal, kickoff, extra_point, qb_kneel, qb_spike, no_play
Valuespassrunno_playkickoffpuntfield_goalextra_pointqb_kneelqb_spike
play_type_nflstringnullable—PASSNFL source play type
ValuesPASSRUSHKICK_OFFPENALTYTIMEOUTPUNTSACKFIELD_GOALXP_KICKEND_QUARTERINTERCEPTIONGAME_STARTEND_GAMEPAT2UNSPECIFIED
posteamstringnullable—CLEPossession team abbreviation
posteam_scoreintegernullable—0Possession team score at start
posteam_score_postintegernullable—0Possession team score at end
posteam_timeouts_remainingintegernullable—3Possession team timeouts
posteam_typestringnullable—homehome or away
Valueshomeaway
punt_attemptboolean—falsePunt attempt
Valuesfalsetrue
punt_blockedboolean—falsePunt blocked
Valuesfalsetrue
punt_downedboolean—falsePunt downed
Valuesfalsetrue
punt_fair_catchboolean—falsePunt fair catch
Valuesfalsetrue
punt_in_endzoneboolean—falsePunt in endzone
punt_inside_twentyboolean—falsePunt inside 20
Valuesfalsetrue
punt_out_of_boundsboolean—falsePunt OOB
Valuesfalsetrue
punt_returner_player_namestringnullable—J.JacksonPunt returner name
punter_player_namestringnullable—R.DixonPunter name
qb_dropbackboolean—falseQB dropback (pass or scramble)
Valuesfalsetrue
qb_epadecimalnullable—0.0000QB EPA credit
qb_hitboolean—falseQB was hit
Valuesfalsetrue
qb_hit_1_player_namestringnullable—K.WhiteQB hitter name
qb_hit_2_player_namestringnullable—J.MadubuikeSecond QB hitter name
ValuesJ.MadubuikeD.OdeyingboM.DavenportK.MackJ.BentleyG.JarrettD.HunterM.PierceC.YoungD.Ekuale
qb_kneelboolean—falseQB kneel
Valuesfalsetrue
qb_scrambleboolean—falseQB scramble
Valuesfalsetrue
qb_spikeboolean—falseQB spike
Valuesfalsetrue
quarterinteger—2Quarter (1-4, 5=OT)
quarter_endboolean—falseBinary quarter-end marker
Valuesfalsetrue
quarter_seconds_remaininginteger—900Seconds remaining in quarter
receiverstringnullable—C.KuppTargeted receiver name
receiver_jersey_numberintegernullable—1Receiver jersey number
receiver_player_namestringnullable—C.KuppReceiver name
receiving_ydsintegernullable—5Official receiving yards
replay_or_challengeboolean—falseReplay/challenge occurred
Valuesfalsetrue
replay_or_challenge_resultstringnullable—reversedReplay result
Valuesreversedupheld
resultintegernullable—6Home score - Away score
return_teamstringnullable—DENReturning team
return_touchdownboolean—falseReturn touchdown
Valuesfalsetrue
return_ydsintegernullable—0Return yards
roofstringnullable—outdoorsdome, outdoors, closed, open
Valuesoutdoorscloseddome
run_gapstringnullable—endend, guard, or tackle
Valuesendguardtackle
run_locationstringnullable—leftleft, middle, or right
Valuesleftrightmiddle
rushboolean—falseRush play (no scrambles)
Valuesfalsetrue
rush_attemptboolean—falseRushing play indicator
Valuesfalsetrue
rush_touchdownboolean—falseRushing touchdown
Valuesfalsetrue
rusher_jersey_numberintegernullable—4Rusher jersey number
rusher_player_namestringnullable—B.RobinsonRusher name
rushing_ydsintegernullable—2Official rushing yards
sackboolean—falseSack indicator
Valuesfalsetrue
sack_player_namestringnullable—G.RousseauSacker name
safetyboolean—falseSafety scored
Valuesfalsetrue
safety_player_namestringnullable—Z.AllenSafety scorer name
ValuesZ.AllenA.Wright
safety_probdecimalnullable—0.0000Safety probability
score_differentialintegernullable—0Score gap at play start
score_differential_postintegernullable—0Score gap at play end
seriesintegernullable—1Series counter within game
series_resultstringnullable—First downFirst down, Touchdown, Punt, etc.
ValuesFirst downPuntField goalTouchdownTurnover on downsTurnoverQB kneelEnd of halfMissed field goalOpp touchdownSafety
series_successboolean—trueSeries resulted in first down or TD
Valuestruefalse
shotgunboolean—trueShotgun formation
Valuestruefalse
side_of_fieldstringnullable—CARTeam abbreviation whose side of field
solo_tackleboolean—falseSolo tackle on play
Valuesfalsetrue
solo_tackle_1_player_namestringnullable—J.JonesSolo tackler 1 name
solo_tackle_1_teamstringnullable—ATLSolo tackler 1 team
solo_tackle_2_player_namestringnullable—B.LimmerSolo tackler 2 name
ValuesB.LimmerT.Spears
solo_tackle_2_teamstringnullable—LASolo tackler 2 team
ValuesLATEN
spboolean—falseScoring play indicator
Valuesfalsetrue
specialboolean—falseSpecial teams indicator
Valuesfalsetrue
special_teams_playboolean—falseSpecial teams play indicator
Valuesfalsetrue
spread_linedecimalnullable—6.5000Vegas spread line
st_play_typestringnullable——Type of special teams play
stadiumstringnullable—GEHA Field at Arrowhead StadiumStadium name
start_timestringnullable—9/8/24, 13:03:08Kickoff time (eastern)
successbooleannullable—falsePlay success (based on down/distance)
Valuesfalsetrue
surfacestringnullable—grassPlaying surface type
Valuesgrassfieldturfmatrixturfastroturfsportturfa_turf
tackle_for_loss_1_player_namestringnullable—M.CrosbyTFL player 1 name
tackle_for_loss_2_player_namestringnullable——TFL player 2 name
tackle_with_assistboolean—falseTackle with assistance
Valuesfalsetrue
tackle_with_assist_1_player_namestringnullable—A.SingletonTackle-assist player 1 name
tackle_with_assist_1_teamstringnullable—INDTackle-assist player 1 team
tackle_with_assist_2_player_namestringnullable——Tackle-assist player 2 name
tackle_with_assist_2_teamstringnullable——Tackle-assist player 2 team
tackled_for_lossboolean—falseTackle for loss
Valuesfalsetrue
td_player_namestringnullable—A.KamaraTD scorer name
td_probdecimalnullable—0.0000TD probability
td_teamstringnullable—NOTeam scoring TD
tempintegernullable—67Temperature
third_down_convertedboolean—falseThird down conversion
Valuesfalsetrue
third_down_failedboolean—falseThird down failure
Valuesfalsetrue
timestringnullable—15:00Game clock at play start (mm:ss)
time_of_daystringnullable—2024-09-08T19:40:41ZPlay time in UTC
timeoutboolean—falseTimeout called
Valuesfalsetrue
timeout_teamstringnullable—BALTeam calling timeout
totalintegernullable—41Home score + Away score
total_away_comp_air_epadecimalnullable—0.0000Cumulative away completion air EPA
total_away_comp_air_wpadecimalnullable—0.0000Cumulative away completion air WPA
total_away_comp_yac_epadecimalnullable—0.0000Cumulative away completion YAC EPA
total_away_comp_yac_wpadecimalnullable—0.0000Cumulative away completion YAC WPA
total_away_epadecimalnullable—0.0000Cumulative away EPA
total_away_pass_epadecimalnullable—0.0000Cumulative away passing EPA
total_away_pass_wpadecimalnullable—0.0000Cumulative away passing WPA
total_away_raw_air_epadecimalnullable—0.0000Cumulative away raw air EPA
total_away_raw_air_wpadecimalnullable—0.0000Cumulative away raw air WPA
total_away_raw_yac_epadecimalnullable—0.0000Cumulative away raw YAC EPA
total_away_raw_yac_wpadecimalnullable—0.0000Cumulative away raw YAC WPA
total_away_rush_epadecimalnullable—0.0000Cumulative away rushing EPA
total_away_rush_wpadecimalnullable—0.0000Cumulative away rushing WPA
total_away_scoreintegernullable—0Away score at play start
total_home_comp_air_epadecimalnullable—0.0000Cumulative home completion air EPA
total_home_comp_air_wpadecimalnullable—0.0000Cumulative home completion air WPA
total_home_comp_yac_epadecimalnullable—0.0000Cumulative home completion YAC EPA
total_home_comp_yac_wpadecimalnullable—0.0000Cumulative home completion YAC WPA
total_home_epadecimalnullable—0.0000Cumulative home EPA
total_home_pass_epadecimalnullable—0.0000Cumulative home passing EPA
total_home_pass_wpadecimalnullable—0.0000Cumulative home passing WPA
total_home_raw_air_epadecimalnullable—0.0000Cumulative home raw air EPA
total_home_raw_air_wpadecimalnullable—0.0000Cumulative home raw air WPA
total_home_raw_yac_epadecimalnullable—0.0000Cumulative home raw YAC EPA
total_home_raw_yac_wpadecimalnullable—0.0000Cumulative home raw YAC WPA
total_home_rush_epadecimalnullable—0.0000Cumulative home rushing EPA
total_home_rush_wpadecimalnullable—0.0000Cumulative home rushing WPA
total_home_scoreintegernullable—0Home score at play start
total_linedecimalnullable—41.5000Vegas total line
touchbackboolean—falseTouchback
Valuesfalsetrue
touchdownboolean—falseTouchdown scored
Valuesfalsetrue
two_point_attemptboolean—falseTwo-point conversion attempt
Valuesfalsetrue
two_point_conv_resultstringnullable—failuresuccess, failure, safety, return
Valuesfailuresuccess
two_point_conversion_probdecimalnullable—0.0000Two-point conversion probability
vegas_home_wpdecimalnullable—1.0000Vegas home win probability
vegas_home_wpadecimalnullable—0.0000Vegas home WPA
vegas_wpdecimalnullable—0.9999Vegas win probability
vegas_wpadecimalnullable—0.0000Vegas-adjusted WPA
weatherstringnullable—Temp: 63° F, Humidity: 87%, Wind: SE 4 mphWeather conditions description
windintegernullable—10Wind speed (mph)
wpdecimalnullable—0.5463Win probability for possession team
wpadecimalnullable—0.0000Win probability added
xpassdecimalnullable—0.9759Dropback probability
xyac_epadecimalnullable—0.2981Expected EPA after catch
xyac_fddecimalnullable—1.0000First down probability (xYAC)
xyac_mean_yardagedecimalnullable—3.9685Average expected YAC
xyac_median_yardagedecimalnullable—2.0000Median expected YAC
xyac_successdecimalnullable—1.0000Positive EPA probability
yac_epadecimalnullable—0.0000EPA from yards after catch
yac_wpadecimalnullable—0.0000WPA from yards after catch
yard_lineintegernullable——Yard line number (0-50)
yardline_100integernullable—35Yards from opponent endzone (0-100)
yds_after_catchintegernullable—0YAC yards
yds_gainedintegernullable—0Yards gained on play
ydsnetintegernullable—70Total net yards on drive
ydstogointegernullable—10Yards to first down/goal
yrdlnstringnullable—MID 50Yard line string (e.g., "KC 25")
nfl.play_participations20 fields· 2 refsendpoints →

The personnel and pre-snap setup on every NFL play (one row per play, not per player) — offensive formation, personnel grouping, defensive look, coverage scheme, and the on-field player ids as comma-joined text columns. 2024 season coverage.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games61—
play_idstring—40Play identifier matching `play_by_plays.play_id` for the same game.
possession_team_idbigint→ nfl.teams26Team in possession on this play (FK to `teams`).
defenders_in_boxintegernullable—6Number of defenders within ~8 yards of the line of scrimmage at the snap.
defense_coverage_typestringnullable—COVER_1Specific coverage scheme (e.g., `COVER_1`, `COVER_2_MAN`, `COVER_3`, `COVER_4`).
ValuesCOVER_1COVER_2COVER_32_MANCOVER_4COVER_0COVER_6COMBOCOVER_9BLOWN
defense_man_zone_typestringnullable—MAN_COVERAGEMan- vs. zone-coverage classification (`MAN`, `ZONE`).
ValuesMAN_COVERAGEZONE_COVERAGE
defense_personnelstringnullable—3 CB, 2 DE, 2 DT, 1 FS, 2 ILB, 1 SSDefensive personnel grouping (e.g., `4 DL, 2 LB, 5 DB`).
defense_players_gsis_idsstringnullable—00-0033393,00-0039156,00-0038407,00-0034359,00-0036479,00-0032378,00-0033952,00-0036253,00-0034431,…GSIS IDs of defensive players on the field for this play.
n_defenseintegernullable—11Count of defensive players on the field (typically 11).
n_offenseintegernullable—11Count of offensive players on the field (typically 11).
ngs_air_ydsdecimalnullable——Air yards traveled by the pass from the line of scrimmage to where the receiver caught/dropped it (Next Gen Stats).
number_of_pass_rushersintegernullable—0Number of defenders who rushed the passer on this play (Next Gen Stats).
offense_formationstringnullable—SHOTGUNOffensive formation alignment (e.g., `SHOTGUN`, `SINGLEBACK`, `I_FORM`, `PISTOL`).
ValuesSHOTGUNUNDER CENTERPISTOL
offense_personnelstringnullable—1 C, 2 G, 1 QB, 1 RB, 2 T, 1 TE, 3 WROffensive personnel grouping in `RB-TE-WR` shorthand (e.g., `1 RB, 2 TE, 2 WR` → `12 personnel`).
offense_players_gsis_idsstringnullable—00-0036325,00-0036417,00-0036968,00-0037297,00-0039150,00-0036555,00-0033284,00-0039356,00-0033589,…GSIS IDs of offensive players on the field for this play.
players_on_play_gsis_idsstringnullable—00-0037758,00-0039000,00-0039821,00-0036552,00-0036325,00-0036417,00-0036968,00-0037297,00-0035687,…GSIS IDs of every player on the field for this play (comma-separated or JSON-encoded depending on source vintage).
routestringnullable—QUICK OUTRoute the targeted receiver ran (e.g., `GO`, `SLANT`, `OUT`, `POST`).
ValuesQUICK OUTHITCH/CURLSCREENIN/DIGGODEEP OUTSHALLOW CROSS/DRAGSLANTCORNERSWINGPOSTTEXAS/ANGLEWHEEL
time_to_throwdecimalnullable—2.3000Time from snap to pass release in seconds (Next Gen Stats).
was_pressurebooleannullable—falseTrue if the quarterback faced pass-rush pressure on this play.
Valuesfalsetrue

Stats

nfl.operator_team_lookups6 fields· 3 refsendpoints →

How each sportsbook and fantasy operator names every NFL team — the mapping from each operator's team code or abbreviation to the unified franchise record.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
operator_idbigint→ main.operators4Reference to main.operator entity
operator_team_idstring→ nfl.teams28External team ID from operator
team_idbigint→ nfl.teams32Internal nfl.teams.id reference
abbreviationstringnullable——Team abbreviation for reconciliation
team_namestringnullable—Washington CommandersTeam name for reconciliation
nfl.season_team_stats32 fields· 2 refsendpoints →

Season totals for each NFL team — wins and losses, points scored and allowed, yards on offense and defense, turnovers, red-zone and down-conversion efficiency, kicking accuracy. Regular-season games only.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
season_idbigint→ nfl.seasons2025—
team_idbigint→ nfl.teams1—
completionsinteger—0—
defensive_interceptionsinteger—10—
defensive_sacksdecimal—42.0000Sacks recorded by this team's defense (half-sacks supported as decimals).
defensive_tdsinteger—1Touchdowns scored by the defense (interception return + fumble recovery TD); excludes special-teams returns.
extra_pts_attemptedinteger—40—
extra_pts_madeinteger—33—
field_goals_attemptedinteger—31—
field_goals_madeinteger—34—
first_downsinteger—410—
fourth_down_attemptsinteger—35Total fourth-down plays attempted (excludes punts and field-goal attempts).
fourth_down_conversionsinteger—15Fourth-down attempts converted to a first down or touchdown.
fumbles_recoveredinteger—7—
games_playedinteger—20—
lossesinteger—9—
pass_attemptsinteger—0—
passing_tdsinteger—0—
passing_ydsinteger—4616—
pts_allowedinteger—311—
pts_scoredinteger—481—
red_zone_attemptsinteger—0Possessions reaching the red zone (inside the opponent's 20-yard line).
red_zone_conversionsinteger—0Red-zone trips that ended in a touchdown.
rushing_tdsinteger—0—
rushing_ydsinteger—2136—
third_down_attemptsinteger—264Total third-down plays attempted.
third_down_conversionsinteger—99Third-down attempts converted to a first down or touchdown.
tiesinteger—3—
total_ydsinteger—5759—
turnoversinteger—22Possessions lost via interception or fumble.
winsinteger—8—
nfl.game_player_firstdown_stats54 fields· 4 refsendpoints →

Per-game player stats restricted to first-down plays — the same first-down production breakouts as the season aggregate, for each individual game.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games61—
opponent_team_idbigint→ nfl.teams10—
player_idbigint→ nfl.players657—
team_idbigint→ nfl.teams9—
assisted_tacklesinteger—0Assisted tackles on first down
defensive_tdsinteger—0Total defensive touchdowns on first down
forced_fumblesinteger—0Forced fumbles on first down
fumble_recovery_tdsinteger—0Fumble recovery touchdowns on first down
fumble_recovery_ydsinteger—0Fumble recovery yards on first down
fumblesinteger—0Fumbles on first down
fumbles_lostinteger—0Fumbles lost on first down
fumbles_recoveredinteger—0Fumbles recovered on first down
interception_tdsinteger—0Interception return touchdowns on first down
interception_ydsinteger—0Interception return yards on first down
interceptionsinteger—0Interceptions on first down
is_homeboolean—trueTrue if player's team is the home team
Valuestruefalse
offensive_snapsinteger—0Offensive snaps played on first down
offensive_tdsinteger—0Total offensive touchdowns on first down
passes_defendedinteger—0Passes defended on first down
passing_attemptsinteger—0Passing attempts on first down
passing_completion_percentagedecimal—0.0000Completion percentage on first down
passing_completionsinteger—0Completed passes on first down
passing_interceptionsinteger—0Interceptions thrown on first down
passing_longinteger—0Longest pass completion on first down
passing_ratingdecimal—0.0000Passer rating on first down
passing_sack_ydsinteger—0Yards lost to sacks on first down
passing_sacksinteger—0Times sacked on first down
passing_tdsinteger—0Passing touchdowns on first down
passing_ydsinteger—0Passing yards on first down
passing_yds_per_attemptdecimal—0.0000Passing yards per attempt on first down
passing_yds_per_completiondecimal—0.0000Passing yards per completion on first down
positionstring—WRPlayer position at time of game
ValuesWRRBDEFTEQBOLLB
quarterback_hitsinteger—0QB hits on first down
receiving_longinteger—0Longest reception on first down
receiving_tdsinteger—0Receiving touchdowns on first down
receiving_ydsinteger—0Receiving yards on first down
receiving_yds_per_receptiondecimal—0.0000Yards per reception on first down
receiving_yds_per_targetdecimal—0.0000Receiving yards per target on first down
reception_percentagedecimal—0.0000Reception percentage (receptions/targets) on first down
receptionsinteger—0Receptions on first down
rushing_attemptsinteger—0Rushing attempts on first down
rushing_longinteger—0Longest rush on first down
rushing_tdsinteger—0Rushing touchdowns on first down
rushing_ydsinteger—0Rushing yards on first down
rushing_yds_per_attemptdecimal—0.0000Rushing yards per attempt on first down
sacksdecimal—0.0000Sacks on first down (0.5 for half sacks)
solo_tacklesinteger—0Solo tackles on first down
tackles_for_lossinteger—0Tackles for loss on first down
targetsinteger—0Times targeted on first down
total_tdsinteger—0Total touchdowns scored on first down
two_pt_pass_conversionsinteger—0—
two_pt_reception_conversionsinteger—0—
two_pt_rush_conversionsinteger—0—
nfl.game_player_ngs_passings26 fields· 3 refsendpoints →

NFL Next Gen Stats for quarterbacks per game — RFID-tracked passing metrics like time to throw, average depth of target, completed air yards, on-target throw rate, and aggressiveness against tight coverage.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games121—
player_gsis_idstring—00-0039732GSIS ID for cross-reference
player_idbigint→ nfl.players2999—
team_idbigint→ nfl.teams17—
aggressivenessdecimalnullable—20.0000Percentage of throws into tight windows (defender within 1 yard)
attemptsintegernullable—30—
avg_air_distancedecimalnullable—22.4754Average ball travel distance on all attempts
avg_air_yds_differentialdecimalnullable—-0.8631Difference between intended and completed air yards
avg_air_yds_to_sticksdecimalnullable—-5.2445Average air yards relative to first down marker
avg_completed_air_ydsdecimalnullable—3.7511Average air yards on completed passes
avg_intended_air_ydsdecimalnullable—6.0133Average air yards on all pass attempts
avg_time_to_throwdecimalnullable—2.6513Average time from snap to throw (seconds)
completion_percentagedecimalnullable—66.6667—
completion_percentage_above_expectationdecimalnullable—-2.0683CPOE - Actual completion % minus expected (positive = better than expected)
completionsintegernullable—19—
expected_completion_percentagedecimalnullable—65.3373Model-predicted completion percentage based on throw difficulty
interceptionsintegernullable—0—
max_air_distancedecimalnullable—45.0275Maximum ball travel distance
max_completed_air_distancedecimalnullable—35.6106Longest completed pass distance (ball travel)
pass_tdsintegernullable—1—
pass_ydsintegernullable—212—
passer_ratingdecimalnullable—81.2500—
seasoninteger—2024—
season_typestring—regular_seasonCanonical season phase.
weekinteger—3—
nfl.game_player_ngs_receivings20 fields· 3 refsendpoints →

NFL Next Gen Stats for receivers per game — RFID-tracked receiving metrics like separation at the throw, cushion at the snap, target separation, and yards over expected.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games157—
player_gsis_idstring—00-0036900GSIS ID for cross-reference
player_idbigint→ nfl.players1446—
team_idbigint→ nfl.teams9—
avg_cushiondecimalnullable—5.5500Average distance from nearest defender at snap (yards)
avg_expected_yacdecimalnullable—3.9326Model-predicted YAC based on catch location/defenders
avg_intended_air_ydsdecimalnullable—7.1300Average depth of targets
avg_separationdecimalnullable—3.3793Average distance from nearest defender at catch point (yards)
avg_yacdecimalnullable—0.8400Average yards after catch
avg_yac_above_expectationdecimalnullable—1.0087Actual YAC minus expected (positive = creates extra yards)
catch_percentagedecimalnullable—66.6667—
percent_share_of_intended_air_ydsdecimalnullable—23.4320Percentage of team total intended air yards (deep target share)
rec_tdsintegernullable—0—
receptionsintegernullable—4—
seasoninteger—2024—
season_typestring—regular_seasonCanonical season phase.
targetsintegernullable—5—
weekinteger—3—
yardsintegernullable—30—
nfl.game_player_ngs_rushings19 fields· 3 refsendpoints →

NFL Next Gen Stats for ball carriers per game — RFID-tracked rushing metrics like efficiency, expected rushing yards, rushing yards over expected, and time behind the line of scrimmage.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games4904—
player_gsis_idstring—00-0037840GSIS ID for cross-reference
player_idbigint→ nfl.players1927—
team_idbigint→ nfl.teams11—
avg_rush_ydsdecimalnullable—4.0000—
avg_time_to_losdecimalnullable—2.8227Average time to reach line of scrimmage (seconds)
efficiencydecimalnullable—3.4002Distance traveled per rushing yard gained (lower = more efficient)
expected_rush_ydsdecimalnullable—47.4790Model-predicted rushing yards based on blocking/defense
percent_attempts_gte_eight_defendersdecimalnullable—0.0000Percentage of rushes facing 8+ defenders in box
rush_attemptsintegernullable—12—
rush_pct_over_expecteddecimalnullable—0.5000RYOE as percentage over expected
rush_tdsintegernullable—0—
rush_ydsintegernullable—44—
rush_yds_over_expecteddecimalnullable—35.5210RYOE - Actual yards minus expected (positive = better)
rush_yds_over_expected_per_attdecimalnullable—0.0416RYOE per attempt
seasoninteger—2025—
season_typestring—regular_seasonCanonical season phase.
weekinteger—4—
nfl.game_player_pfr_advstats46 fields· 4 refsendpoints →

Per-game advanced player stats in the Pro Football Reference tradition — drop rates, time under pressure, yards before and after contact, broken tackles, passer rating allowed in coverage.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games57—
opponent_team_idbigint→ nfl.teams10Opposing team in this matchup (FK to `teams`).
player_idbigint→ nfl.players657—
team_idbigint→ nfl.teams10—
carriesintegernullable—0Rushing attempts.
def_adotdecimalnullable—0.0000Average depth of target (yards) when this defender was in coverage.
def_air_yds_completedintegernullable—0Air yards completed on receptions allowed.
def_completion_pctdecimalnullable—0.0000Completion percentage allowed (0.0-100.0).
def_completions_allowedintegernullable—0Receptions allowed in coverage.
def_intsintegernullable—0Interceptions made by this defender in coverage.
def_missed_tackle_pctdecimalnullable—0.0000Missed-tackle rate on tackle opportunities (0.0-100.0).
def_missed_tacklesintegernullable—0Tackle attempts missed by this defender.
def_passer_rating_alloweddecimalnullable—0.0000Passer rating allowed when targeted (0-158.3).
def_pressuresintegernullable—0Total pressures generated (hurries + hits + sacks).
def_receiving_td_allowedintegernullable—0Receiving touchdowns allowed in coverage.
def_sacksdecimalnullable—0.0000Sacks recorded (half-sacks supported as decimals).
def_tackles_combinedintegernullable—0Combined tackles (solo + assisted).
def_targetsintegernullable—0Pass targets thrown at this defender's coverage assignment.
def_times_blitzedintegernullable—0Pass-rushing snaps as a blitzer.
def_times_hitqbintegernullable—0QB hits generated as a pass rusher.
def_times_hurriedintegernullable—0Hurries generated as a pass rusher.
def_yds_after_catchintegernullable—0Yards-after-catch allowed in coverage.
def_yds_allowedintegernullable—0Receiving yards allowed in coverage.
def_yds_allowed_per_cmpdecimalnullable—0.0000Yards allowed per reception.
def_yds_allowed_per_tgtdecimalnullable—0.0000Yards allowed per target.
passing_bad_throw_pctdecimalnullable—0.0000Bad-throw rate on pass attempts (0.0-100.0).
passing_bad_throwsintegernullable—0Pass attempts charged as bad throws by PFR scoring.
passing_drop_pctdecimalnullable—0.0000Drop rate on catchable passes (0.0-100.0).
passing_dropsintegernullable—0Pass attempts dropped by the receiver (charged to the QB's catchable-target count).
receiving_broken_tacklesintegernullable—0Tackles the receiver broke on receiving plays.
receiving_dropintegernullable—0Drops charged to this receiver.
receiving_drop_pctdecimalnullable—0.0000Receiver drop rate on catchable targets (0.0-100.0).
receiving_intintegernullable—0Interceptions thrown when this player was the target.
receiving_ratdecimalnullable—0.0000Passer rating generated when targeted (0-158.3).
rushing_broken_tacklesintegernullable—0Tackles the runner broke on rushing plays.
rushing_yds_after_contactintegernullable—0Total rushing yards gained after first contact.
rushing_yds_after_contact_avgdecimalnullable—0.0000Yards after contact averaged per rush.
rushing_yds_before_contactintegernullable—0Total rushing yards gained before first contact.
rushing_yds_before_contact_avgdecimalnullable—0.0000Yards before contact averaged per rush.
times_blitzedintegernullable—0Dropbacks the QB faced a blitz.
times_hitintegernullable—0QB hits (defender contacted the QB on the throw).
times_hurriedintegernullable—0Dropbacks the QB was hurried but not pressured.
times_pressuredintegernullable—0Total pressures faced (sum of hurries/hits/sacks-allowed indicators).
times_pressured_pctdecimalnullable—0.0000Pressure rate per dropback (0.0-100.0).
times_sackedintegernullable—0Sacks taken by this QB.
nfl.game_player_redzone_stats54 fields· 4 refsendpoints →

Per-game player stats restricted to red-zone plays — the same red-zone breakouts as the season aggregate, for each individual game.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games95—
opponent_team_idbigint→ nfl.teams16—
player_idbigint→ nfl.players657—
team_idbigint→ nfl.teams16—
assisted_tacklesinteger—0Assisted tackles in red zone
defensive_tdsinteger—0Total defensive touchdowns in red zone
forced_fumblesinteger—0Forced fumbles in red zone
fumble_recovery_tdsinteger—0Fumble recovery touchdowns in red zone
fumble_recovery_ydsinteger—0Fumble recovery yards in red zone
fumblesinteger—0Fumbles in the red zone
fumbles_lostinteger—0Fumbles lost in the red zone
fumbles_recoveredinteger—0Fumbles recovered in red zone
interception_tdsinteger—0Interception return touchdowns in red zone
interception_ydsinteger—0Interception return yards in red zone
interceptionsinteger—0Interceptions in red zone
is_homeboolean—falseTrue if player's team is the home team
Valuesfalsetrue
offensive_snapsinteger—0Offensive snaps played in red zone situations
offensive_tdsinteger—0Total offensive touchdowns in the red zone
passes_defendedinteger—0Passes defended in red zone
passing_attemptsinteger—0Passing attempts in the red zone
passing_completion_percentagedecimal—0.0000Completion percentage in the red zone
passing_completionsinteger—0Completed passes in the red zone
passing_interceptionsinteger—0Interceptions thrown in the red zone
passing_longinteger—0Longest pass completion in the red zone
passing_ratingdecimal—0.0000Passer rating in the red zone
passing_sack_ydsinteger—0Yards lost to sacks in the red zone
passing_sacksinteger—0Times sacked in the red zone
passing_tdsinteger—0Passing touchdowns in the red zone
passing_ydsinteger—0Passing yards in the red zone
passing_yds_per_attemptdecimal—0.0000Passing yards per attempt in the red zone
passing_yds_per_completiondecimal—0.0000Passing yards per completion in the red zone
positionstring—DEFPlayer position at time of game
ValuesDEFWRRBQBTEOLPLBDL
quarterback_hitsinteger—0QB hits in red zone
receiving_longinteger—0Longest reception in the red zone
receiving_tdsinteger—0Receiving touchdowns in the red zone
receiving_ydsinteger—0Receiving yards in the red zone
receiving_yds_per_receptiondecimal—0.0000Yards per reception in the red zone
receiving_yds_per_targetdecimal—0.0000Receiving yards per target in the red zone
reception_percentagedecimal—0.0000Reception percentage (receptions/targets) in the red zone
receptionsinteger—0Receptions in the red zone
rushing_attemptsinteger—0Rushing attempts in the red zone
rushing_longinteger—0Longest rush in the red zone
rushing_tdsinteger—0Rushing touchdowns in the red zone
rushing_ydsinteger—0Rushing yards in the red zone
rushing_yds_per_attemptdecimal—0.0000Rushing yards per attempt in the red zone
sacksdecimal—0.0000Sacks in red zone (0.5 for half sacks)
solo_tacklesinteger—0Solo tackles in red zone
tackles_for_lossinteger—0Tackles for loss in red zone
targetsinteger—0Times targeted in the red zone
total_tdsinteger—0Total touchdowns scored in the red zone
two_pt_pass_conversionsinteger—0Successful two-point conversion passes in the red zone
two_pt_reception_conversionsinteger—0Successful two-point conversion receptions in the red zone
two_pt_rush_conversionsinteger—0Successful two-point conversion runs in the red zone
nfl.game_player_stats142 fields· 4 refsendpoints →

Each NFL player's stat line for each game — every passing, rushing, receiving, defensive, special-teams, and scoring statistic recorded that day.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games90—
opponent_team_idbigint→ nfl.teams15—
player_idbigint→ nfl.players298—
team_idbigint→ nfl.teams10—
air_yds_sharedecimal—0.0000Percentage of team air yards
assisted_tacklesintegernullable—1Assisted tackles
blocked_kick_return_tdsintegernullable—0Blocked kick return touchdowns
blocked_kick_return_ydsintegernullable—0Blocked kick return yards
blocked_kicksintegernullable—0Blocked kicks (FG, XP, punts)
completionsinteger—0—
dakotadecimalnullable—0.1798DAKOTA: adjusted completion % + EPA metric
data_sourcestringnullable—pbp_onlyData source (nflverse, nfl_api, sportsdata)
Valuespbp_onlynflversenfl_api
defensive_interceptionsintegernullable—0Defensive interceptions
defensive_sack_ydsintegernullable—0Yards lost on defensive sacks
defensive_sacksdecimalnullable—0.0000Defensive sacks (can be half sacks)
defensive_snapsintegernullable—0Defensive snaps played
defensive_tdsintegernullable—0Total defensive touchdowns (INT + fumble return TDs)
defensive_team_snapsintegernullable—1Total team defensive snaps (for calculating snap %)
depth_orderintegernullable—1Depth order within position (1=starter, 2=backup, etc.) - joined from depth charts
depth_positionstringnullable—WRDepth chart position (QB1, RB2, etc.) - joined from depth charts
extra_pts_attemptedintegernullable—0Extra points attempted
extra_pts_had_blockedintegernullable—0Extra points blocked by opponent
extra_pts_madeintegernullable—0Extra points made
fantasy_ptsdecimal—0.0000Standard fantasy points (nflverse calculation)
fantasy_pts_pprdecimal—0.0000PPR fantasy points (nflverse calculation)
field_goal_percentagedecimalnullable——Field goal percentage
field_goal_return_tdsintegernullable——Field goal return touchdowns
field_goal_return_ydsintegernullable——Field goal return yards (missed FG returns)
field_goals_attemptedintegernullable—0Field goals attempted
field_goals_had_blockedintegernullable—0Field goals blocked by opponent
field_goals_longestintegernullable——Longest field goal made (yards)
field_goals_madeintegernullable—0Field goals made
field_goals_made_0_19integernullable—0Field goals made 0-19 yards
field_goals_made_20_29integernullable—0Field goals made 20-29 yards
field_goals_made_30_39integernullable—0Field goals made 30-39 yards
field_goals_made_40_49integernullable—0Field goals made 40-49 yards
field_goals_made_50_plusintegernullable—0Field goals made 50+ yards
forced_fumblesintegernullable—1Forced fumbles
fumble_return_tdsintegernullable—0Fumble return touchdowns
fumble_return_ydsintegernullable—0Fumble return yards
fumbles_out_of_boundsintegernullable—1Fumbles out of bounds
fumbles_own_recoveriesintegernullable—1Own fumbles recovered
fumbles_recoveredintegernullable—1Fumbles recovered
humidityintegernullable——Humidity percentage
interception_return_tdsintegernullable—0Interception return touchdowns
interception_return_ydsintegernullable—0Interception return yards
interceptions_throwninteger—0—
is_homeboolean—falseTrue if player's team is the home team
Valuesfalsetrue
kick_return_avgfloatnullable—260Kick return average (yards per return)
kick_return_fair_catchesintegernullable—0Fair catches on kick returns
kick_return_fumblesintegernullable—0Fumbles on kick returns
kick_return_fumbles_lostintegernullable—0Fumbles lost on kick returns
kick_return_longintegernullable—31Longest kick return (yards)
kick_return_tdsintegernullable—0Kick return touchdowns
kick_return_ydsintegernullable—0Total kick return yards
kick_returnsintegernullable—1Number of kick returns
misc_assisted_tacklesintegernullable——Miscellaneous assisted tackles
misc_fumbles_forcedintegernullable——Miscellaneous fumbles forced
misc_fumbles_recoveredintegernullable——Miscellaneous fumbles recovered
misc_solo_tacklesintegernullable——Miscellaneous solo tackles
offensive_snapsintegernullable—14Offensive snaps played
offensive_team_snapsintegernullable—64Total team offensive snaps (for calculating snap %)
pacrdecimalnullable—2.0000Passer air conversion ratio
pass_attemptsinteger—0—
passes_defendedintegernullable—1Passes defended
passing_2pt_conversionsinteger—0—
passing_air_ydsinteger—0—
passing_completion_percentagedecimalnullable—10.0000Completion percentage
passing_epadecimal—0.0000Expected points added from passing
passing_first_downsinteger—0—
passing_longintegernullable—25Longest pass completion (yards)
passing_ratingdecimalnullable—39.5833Passer rating
passing_tdsinteger—0—
passing_ydsinteger—0—
passing_yds_after_catchinteger—0—
playing_surfacestringnullable——Playing surface type (grass, turf, etc.)
positionstring—DEFPlayer position at time of game
ValuesDEFWRTEDBRBOL
position_groupstring—DEFPosition group (QB, RB, WR, TE, etc.)
ValuesDEFWRTERBOLSPEC
punt_averagedecimalnullable—510.0000Punt average (yards)
punt_inside_20integernullable—1Punts inside 20 yard line
punt_longintegernullable—60Longest punt (yards)
punt_net_averagefloatnullable——Net punt average (gross - return yards)
punt_net_ydsintegernullable——Net punt yards (gross - return yards)
punt_return_avgfloatnullable—100Punt return average (yards per return)
punt_return_fair_catchesintegernullable—0Fair catches on punt returns
punt_return_fumblesintegernullable—0Fumbles on punt returns (includes muffs)
punt_return_fumbles_lostintegernullable—0Fumbles lost on punt returns
punt_return_longintegernullable—8Longest punt return (yards)
punt_return_tdsintegernullable—0Punt return touchdowns
punt_return_ydsintegernullable—0Total punt return yards
punt_returnsintegernullable—1Number of punt returns
punt_touchbacksintegernullable—0Punt touchbacks
punt_ydsintegernullable—0Total punt yards
puntsintegernullable—2Number of punts
punts_had_blockedintegernullable—0Punts blocked by opponent
quarterback_hitsintegernullable—0Quarterback hits
racrdecimalnullable—0.0000Receiver air conversion ratio
receiving_2pt_conversionsinteger—0—
receiving_air_ydsinteger—0—
receiving_epadecimal—0.0000Expected points added from receiving
receiving_first_downsinteger—0—
receiving_fumblesinteger—0—
receiving_fumbles_lostinteger—0—
receiving_longintegernullable—9Longest reception (yards)
receiving_tdsinteger—0—
receiving_ydsinteger—0—
receiving_yds_after_catchinteger—0—
receiving_yds_per_receptiondecimalnullable—50.0000Yards per reception
reception_percentagedecimalnullable—10.0000Reception percentage (receptions/targets)
receptionsinteger—0—
rushing_2pt_conversionsinteger—0—
rushing_attemptsinteger—0—
rushing_epadecimal—0.0000Expected points added from rushing
rushing_first_downsinteger—0—
rushing_fumblesinteger—0—
rushing_fumbles_lostinteger—0—
rushing_longintegernullable—9Longest rush (yards)
rushing_tdsinteger—0—
rushing_ydsinteger—0—
rushing_yds_per_attemptdecimalnullable—20.0000Rushing yards per attempt
sack_fumblesinteger—0—
sack_fumbles_lostinteger—0—
sack_ydsinteger—0—
sacks_allowedinteger—0—
safetiesintegernullable—0Safeties
solo_tacklesintegernullable—1Solo tackles
special_teams_assisted_tacklesintegernullable—1Assisted tackles on special teams
special_teams_fumbles_forcedintegernullable—0Fumbles forced on special teams
special_teams_fumbles_recoveredintegernullable—0Fumbles recovered on special teams
special_teams_snapsintegernullable—0Special teams snaps played
special_teams_solo_tacklesintegernullable—1Solo tackles on special teams
special_teams_tdsinteger—0—
special_teams_team_snapsintegernullable—13Total team special teams snaps (for calculating snap %)
stadiumstringnullable——Stadium name
tackles_for_lossintegernullable—0Tackles for loss
target_sharedecimal—0.0000Percentage of team targets
targetsinteger—0—
temperatureintegernullable——Game temperature (Fahrenheit)
two_pt_returnsintegernullable——Two-point conversion returns (defensive)
wind_speedintegernullable——Wind speed (mph)
woprdecimalnullable—0.0000Weighted opportunity rating
nfl.game_player_thirddown_stats54 fields· 4 refsendpoints →

Per-game player stats restricted to third-down plays — the same third-down breakouts as the season aggregate, for each individual game.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games60—
opponent_team_idbigint→ nfl.teams8—
player_idbigint→ nfl.players657—
team_idbigint→ nfl.teams10—
assisted_tacklesinteger—0Assisted tackles on third down
defensive_tdsinteger—0Total defensive touchdowns on third down
forced_fumblesinteger—0Forced fumbles on third down
fumble_recovery_tdsinteger—0Fumble recovery touchdowns on third down
fumble_recovery_ydsinteger—0Fumble recovery yards on third down
fumblesinteger—0Fumbles on third down
fumbles_lostinteger—0Fumbles lost on third down
fumbles_recoveredinteger—0Fumbles recovered on third down
interception_tdsinteger—0Interception return touchdowns on third down
interception_ydsinteger—0Interception return yards on third down
interceptionsinteger—0Interceptions on third down
is_homeboolean—falseTrue if player's team is the home team
Valuesfalsetrue
offensive_snapsinteger—0Offensive snaps played on third down
offensive_tdsinteger—0Total offensive touchdowns on third down
passes_defendedinteger—0Passes defended on third down
passing_attemptsinteger—0Passing attempts on third down
passing_completion_percentagedecimal—0.0000Completion percentage on third down
passing_completionsinteger—0Completed passes on third down
passing_interceptionsinteger—0Interceptions thrown on third down
passing_longinteger—0Longest pass completion on third down
passing_ratingdecimal—0.0000Passer rating on third down
passing_sack_ydsinteger—0Yards lost to sacks on third down
passing_sacksinteger—0Times sacked on third down
passing_tdsinteger—0Passing touchdowns on third down
passing_ydsinteger—0Passing yards on third down
passing_yds_per_attemptdecimal—0.0000Passing yards per attempt on third down
passing_yds_per_completiondecimal—0.0000Passing yards per completion on third down
positionstring—DEFPlayer position at time of game
ValuesDEFWRRBQBTEOLDL
quarterback_hitsinteger—0QB hits on third down
receiving_longinteger—0Longest reception on third down
receiving_tdsinteger—0Receiving touchdowns on third down
receiving_ydsinteger—0Receiving yards on third down
receiving_yds_per_receptiondecimal—0.0000Yards per reception on third down
receiving_yds_per_targetdecimal—0.0000Receiving yards per target on third down
reception_percentagedecimal—0.0000Reception percentage (receptions/targets) on third down
receptionsinteger—0Receptions on third down
rushing_attemptsinteger—0Rushing attempts on third down
rushing_longinteger—0Longest rush on third down
rushing_tdsinteger—0Rushing touchdowns on third down
rushing_ydsinteger—0Rushing yards on third down
rushing_yds_per_attemptdecimal—0.0000Rushing yards per attempt on third down
sacksdecimal—0.0000Sacks on third down (0.5 for half sacks)
solo_tacklesinteger—0Solo tackles on third down
tackles_for_lossinteger—0Tackles for loss on third down
targetsinteger—0Times targeted on third down
total_tdsinteger—0Total touchdowns scored on third down
two_pt_pass_conversionsinteger—0—
two_pt_reception_conversionsinteger—0—
two_pt_rush_conversionsinteger—0—
nfl.game_team_stats131 fields· 2 refsendpoints →

Each NFL team's stat line for each game — the same offensive, defensive, scoring, and situational counters as the season aggregate, broken out per game with home/away context.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games4718—
team_idbigint→ nfl.teams22—
blocked_extra_ptsinteger—0—
blocked_field_goalsinteger—0—
blocked_kick_return_tdsinteger—0Blocked kick return touchdowns
blocked_kick_return_ydsinteger—0Blocked kick return yards
blocked_kicksinteger—0Total blocked kicks (FGs + XPs + punts) for DST fantasy scoring
blocked_puntsinteger—0—
completion_percentagedecimal—66.6667—
completionsinteger—19—
defensive_interceptionsinteger—0—
defensive_sacksinteger—1—
defensive_tdsinteger—0—
defensive_team_snapsinteger—726Total defensive snaps by team in game
extra_pt_percentagedecimal—100.0000Extra point conversion percentage
extra_pts_attemptedinteger—2—
extra_pts_blockedinteger—0Extra points that were blocked
extra_pts_madeinteger—2—
field_goal_percentagedecimal—100.0000—
field_goal_return_tdsinteger—0Field goal return touchdowns
field_goal_return_ydsinteger—0Field goal return yards (missed FGs)
field_goals_attemptedinteger—2—
field_goals_blockedinteger—0Field goals that were blocked
field_goals_madeinteger—2—
first_downsinteger—19—
first_downs_passinginteger—11—
first_downs_penaltyinteger—1—
first_downs_rushinginteger—5—
forced_fumblesinteger—0—
fourth_down_attemptsinteger—1—
fourth_down_conversionsinteger—0—
fourth_down_percentagedecimal—0.0000—
fumble_return_tdsinteger—0Fumble return touchdowns
fumble_return_ydsinteger—0Fumble return yards
fumbles_lostinteger—0—
fumbles_recoveredinteger—0—
interception_percentagedecimal—0.0000Percentage of passes intercepted
interception_return_tdsinteger—0Interception return touchdowns
interception_return_ydsinteger—0Interception return yards
interception_returnsinteger—0Number of interception returns
interceptions_throwninteger—0—
is_homeboolean—falseTrue if team is the home team
Valuesfalsetrue
kick_return_avgdecimal—0.0000Average yards per kick return
kick_return_longinteger—0Longest kick return
kick_return_tdsinteger—0—
kick_return_ydsinteger—0—
kick_return_yds_differentialinteger—0Kick return yards minus opponent kick return yards
kick_returnsinteger—0Number of kick returns
kickoff_touchbacksinteger—0Kickoffs resulting in touchbacks
kickoffsinteger—0Number of kickoffs
kickoffs_in_endzoneinteger—0Kickoffs that reached the end zone
lossinteger—0—
offensive_playsinteger—64Total offensive plays run
offensive_team_snapsinteger—726Total offensive snaps by team in game
offensive_ydsinteger—356Total offensive yards gained
pass_attemptsinteger—34—
passer_ratingdecimal—97.9167—
passes_defendedinteger—4—
passing_dropbacksinteger—34Number of passing dropbacks
passing_tdsinteger—1—
passing_ydsinteger—188—
penaltiesinteger—6—
penalty_ydsinteger—45—
penalty_yds_differentialinteger—0Opponent penalty yards minus own penalty yards
point_differentialinteger—0Points scored minus points allowed
ptsinteger—0—
pts_allowed_definteger—0Points allowed for DEF scoring (FanDuel). Excludes return TDs against - only offensive points allowed.
pts_allowed_dstinteger—0Points allowed for DST scoring (DraftKings/Yahoo). Includes return TDs against - real scoreboard points.
punt_averagedecimal—44.0000—
punt_net_averagedecimal—44.0000Net punt average yards
punt_net_ydsinteger—0Total net punt yards
punt_return_avgdecimal—0.0000Average yards per punt return
punt_return_longinteger—0Longest punt return
punt_return_tdsinteger—0—
punt_return_ydsinteger—0—
punt_return_yds_differentialinteger—0Punt return yards minus opponent punt return yards
punt_returnsinteger—0Number of punt returns
punt_ydsinteger—0—
puntsinteger—3—
punts_blockedinteger—0Number of punts blocked
qb_hits_differentialinteger—0QB hits made minus QB hits allowed
qb_hits_percentagedecimal—0.0000Percentage of dropbacks resulting in QB hit
quarterback_hitsinteger—4—
receiving_tdsinteger—1—
receiving_ydsinteger—188—
receptionsinteger—19—
red_zone_attemptsinteger—3—
red_zone_conversionsinteger—3—
red_zone_percentagedecimal—100.0000—
rushing_attemptsinteger—23—
rushing_tdsinteger—0—
rushing_ydsinteger—119—
rushing_yds_per_attemptdecimal—3.0000Rushing yards per attempt
sack_ydsinteger—0—
sacked_percentagedecimal—0.0000Percentage of dropbacks resulting in sack
sacks_allowedinteger—1—
sacks_differentialinteger—0Sacks made minus sacks allowed
safetiesinteger—0—
score_otinteger—0Points scored in overtime
score_q1integer—0Points scored in Q1
score_q2integer—0Points scored in Q2
score_q3integer—0Points scored in Q3
score_q4integer—0Points scored in Q4
special_teams_team_snapsinteger—264Total special teams snaps by team in game
tacklesinteger—51—
tackles_for_lossinteger—1—
tfl_differentialinteger—0Tackles for loss made minus allowed
tfl_percentagedecimal—0.0000Percentage of plays resulting in TFL
third_down_attemptsinteger—13—
third_down_conversionsinteger—5—
third_down_percentagedecimal—33.3333—
tieinteger—0—
time_of_possessioninteger—1805—
total_return_ydsinteger—0Total punt and kick return yards
total_ydsinteger—356—
touchdownsinteger—2Total touchdowns scored
turnover_differentialinteger—0—
turnoversinteger—0—
two_point_conversion_attemptsinteger—0—
two_point_conversionsinteger—0—
two_pt_conversion_returnsinteger—0Defensive two-point conversion returns
two_pt_pass_attemptsinteger—0Two-point conversion pass attempts
two_pt_pass_conversionsinteger—0Two-point conversion pass conversions
two_pt_rush_attemptsinteger—0Two-point conversion rush attempts
two_pt_rush_conversionsinteger—0Two-point conversion rush conversions
wininteger—0—
yds_per_carrydecimal—3.0000—
yds_per_completiondecimal—10.0000Passing yards per completion
yds_per_pass_attemptdecimal—6.0000—
yds_per_playdecimal—6.0000Average yards per offensive play
nfl.operator_player_lookups6 fields· 3 refsendpoints →

How each sportsbook and fantasy operator names every NFL player — the mapping from each operator's own player identifier to a unified player record.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
operator_idbigint→ main.operators5Reference to main.operator entity
operator_player_idstring→ nfl.players6012External player ID from operator
player_idbigint→ nfl.players2Internal nfl.players.id reference
player_namestringnullable—Lamar JacksonPlayer name as provided by operator
positionstringnullable—DBPosition as provided by operator
ValuesDBDLLBWRRBTEQBOLPKLS
nfl.season_player_firstdown_stats52 fields· 2 refsendpoints →

Season player stats restricted to first-down plays — passing, rushing, and receiving production filtered to first-down attempts, useful for early-down efficiency analysis.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nfl.players2—
season_idbigint→ nfl.seasons2025—
assisted_tacklesinteger—0Assisted tackles on first down
defensive_tdsinteger—0Total defensive touchdowns on first down
forced_fumblesinteger—0Forced fumbles on first down
fumble_recovery_tdsinteger—0Fumble recovery touchdowns on first down
fumble_recovery_ydsinteger—0Fumble recovery yards on first down
fumblesinteger—0Fumbles on first down
fumbles_lostinteger—0Fumbles lost on first down
fumbles_recoveredinteger—0Fumbles recovered on first down
games_playedinteger—1Number of games with first down involvement
games_startedinteger—0Number of games started
interception_tdsinteger—0Interception return touchdowns on first down
interception_ydsinteger—0Interception return yards on first down
interceptionsinteger—0Interceptions on first down
offensive_snapsinteger—0Offensive snaps played on first down
offensive_tdsinteger—0Total offensive touchdowns on first down
passes_defendedinteger—0Passes defended on first down
passing_attemptsinteger—0Passing attempts on first down
passing_completion_percentagedecimal—0.0000Completion percentage on first down
passing_completionsinteger—0Completed passes on first down
passing_interceptionsinteger—0Interceptions thrown on first down
passing_longinteger—0Longest pass completion on first down
passing_ratingdecimal—0.0000Passer rating on first down
passing_sack_ydsinteger—0Yards lost to sacks on first down
passing_sacksinteger—0Times sacked on first down
passing_tdsinteger—0Passing touchdowns on first down
passing_ydsinteger—0Passing yards on first down
passing_yds_per_attemptdecimal—0.0000Passing yards per attempt on first down
passing_yds_per_completiondecimal—0.0000Passing yards per completion on first down
quarterback_hitsinteger—0QB hits on first down
receiving_longinteger—0Longest reception on first down
receiving_tdsinteger—0Receiving touchdowns on first down
receiving_ydsinteger—0Receiving yards on first down
receiving_yds_per_receptiondecimal—0.0000Yards per reception on first down
receiving_yds_per_targetdecimal—0.0000Receiving yards per target on first down
reception_percentagedecimal—0.0000Reception percentage (receptions/targets) on first down
receptionsinteger—0Receptions on first down
rushing_attemptsinteger—0Rushing attempts on first down
rushing_longinteger—0Longest rush on first down
rushing_tdsinteger—0Rushing touchdowns on first down
rushing_ydsinteger—0Rushing yards on first down
rushing_yds_per_attemptdecimal—0.0000Rushing yards per attempt on first down
sacksdecimal—0.0000Sacks on first down (0.5 for half sacks)
solo_tacklesinteger—0Solo tackles on first down
tackles_for_lossinteger—0Tackles for loss on first down
targetsinteger—0Times targeted on first down
total_tdsinteger—0Total touchdowns scored on first down
two_pt_pass_conversionsinteger—0—
two_pt_reception_conversionsinteger—0—
two_pt_rush_conversionsinteger—0—
nfl.season_player_redzone_stats52 fields· 2 refsendpoints →

Season player stats restricted to red-zone plays (inside the opponent's 20) — scoring efficiency, touchdown rate, and yardage production in the most-valuable area of the field.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nfl.players2—
season_idbigint→ nfl.seasons2025—
assisted_tacklesinteger—0Assisted tackles in red zone
defensive_tdsinteger—0Total defensive touchdowns in red zone
forced_fumblesinteger—0Forced fumbles in red zone
fumble_recovery_tdsinteger—0Fumble recovery touchdowns in red zone
fumble_recovery_ydsinteger—0Fumble recovery yards in red zone
fumblesinteger—0Fumbles in the red zone
fumbles_lostinteger—0Fumbles lost in the red zone
fumbles_recoveredinteger—0Fumbles recovered in red zone
games_playedinteger—1Number of games with red zone involvement
games_startedinteger—0Number of games started
interception_tdsinteger—0Interception return touchdowns in red zone
interception_ydsinteger—0Interception return yards in red zone
interceptionsinteger—0Interceptions in red zone
offensive_snapsinteger—0Offensive snaps played in red zone situations
offensive_tdsinteger—0Total offensive touchdowns in the red zone
passes_defendedinteger—0Passes defended in red zone
passing_attemptsinteger—0Passing attempts in the red zone
passing_completion_percentagedecimal—0.0000Completion percentage in the red zone
passing_completionsinteger—0Completed passes in the red zone
passing_interceptionsinteger—0Interceptions thrown in the red zone
passing_longinteger—0Longest pass completion in the red zone
passing_ratingdecimal—0.0000Passer rating in the red zone
passing_sack_ydsinteger—0Yards lost to sacks in the red zone
passing_sacksinteger—0Times sacked in the red zone
passing_tdsinteger—0Passing touchdowns in the red zone
passing_ydsinteger—0Passing yards in the red zone
passing_yds_per_attemptdecimal—0.0000Passing yards per attempt in the red zone
passing_yds_per_completiondecimal—0.0000Passing yards per completion in the red zone
quarterback_hitsinteger—0QB hits in red zone
receiving_longinteger—0Longest reception in the red zone
receiving_tdsinteger—0Receiving touchdowns in the red zone
receiving_ydsinteger—0Receiving yards in the red zone
receiving_yds_per_receptiondecimal—0.0000Yards per reception in the red zone
receiving_yds_per_targetdecimal—0.0000Receiving yards per target in the red zone
reception_percentagedecimal—0.0000Reception percentage (receptions/targets) in the red zone
receptionsinteger—0Receptions in the red zone
rushing_attemptsinteger—0Rushing attempts in the red zone
rushing_longinteger—0Longest rush in the red zone
rushing_tdsinteger—0Rushing touchdowns in the red zone
rushing_ydsinteger—0Rushing yards in the red zone
rushing_yds_per_attemptdecimal—0.0000Rushing yards per attempt in the red zone
sacksdecimal—0.0000Sacks in red zone (0.5 for half sacks)
solo_tacklesinteger—0Solo tackles in red zone
tackles_for_lossinteger—0Tackles for loss in red zone
targetsinteger—0Times targeted in the red zone
total_tdsinteger—0Total touchdowns scored in the red zone
two_pt_pass_conversionsinteger—0Successful two-point conversion passes in the red zone
two_pt_reception_conversionsinteger—0Successful two-point conversion receptions in the red zone
two_pt_rush_conversionsinteger—0Successful two-point conversion runs in the red zone
nfl.season_player_stats89 fields· 2 refsendpoints →

Season totals for each NFL player — passing, rushing, receiving, defensive, special-teams, and scoring stats accumulated across the year. Regular-season games only; playoff totals are not included.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nfl.players2—
season_idbigint→ nfl.seasons2025—
completion_percentagedecimal—0.0000—
completionsinteger—0—
defensive_tdsinteger—0—
extra_pts_attemptedinteger—0—
extra_pts_madeinteger—0—
fair_catchesinteger—0—
field_goal_percentagedecimal—0.0000—
field_goals_attemptedinteger—0—
field_goals_madeinteger—0—
field_goals_made_0_19integer—0—
field_goals_made_20_29integer—0—
field_goals_made_30_39integer—0—
field_goals_made_40_49integer—0—
field_goals_made_50_plusinteger—0—
forced_fumblesinteger—0—
fumble_return_ydsinteger—0—
fumble_tdsinteger—0—
fumblesinteger—0—
fumbles_lostinteger—0—
fumbles_receivinginteger—0—
fumbles_recoveredinteger—0—
fumbles_rushinginteger—0—
games_playedinteger—17—
games_startedinteger—0—
interception_return_ydsinteger—0—
interception_tdsinteger—0—
interceptions_defenseinteger—0—
interceptions_throwninteger—0—
kick_return_averagedecimal—0.0000—
kick_return_tdsinteger—0—
kick_return_ydsinteger—0—
kick_returnsinteger—0—
longest_field_goalinteger—0—
longest_kick_returninteger—0—
longest_puntinteger—0—
longest_punt_returninteger—0—
longest_receptioninteger—0—
longest_rushinteger—0—
pass_attemptsinteger—0—
passer_ratingdecimal—0.0000—
passes_defendedinteger—0—
passing_air_ydsinteger—0Total passing air yards
passing_first_downsinteger—0Total passing first downs
passing_longinteger—0Longest pass (season max)
passing_tdsinteger—0—
passing_ydsinteger—0—
passing_yds_after_catchinteger—0Total YAC from passes
punt_averagedecimal—0.0000—
punt_net_averagedecimal—0.0000—
punt_return_averagedecimal—0.0000—
punt_return_tdsinteger—0—
punt_return_ydsinteger—0—
punt_returnsinteger—0—
punt_touchbacksinteger—0—
punt_ydsinteger—0—
puntsinteger—0—
punts_blockedinteger—0—
punts_inside_20integer—0—
quarterback_hitsinteger—0—
receiving_air_ydsinteger—0Total receiving air yards
receiving_first_downsinteger—0Total receiving first downs
receiving_fumbles_lostinteger—0Total receiving fumbles lost
receiving_tdsinteger—0—
receiving_ydsinteger—0—
receiving_yds_after_catchinteger—0Total receiving YAC
receptionsinteger—0—
rushing_attemptsinteger—0—
rushing_first_downsinteger—0Total rushing first downs
rushing_fumbles_lostinteger—0Total rushing fumbles lost
rushing_tdsinteger—0—
rushing_ydsinteger—0—
sack_fumblesinteger—0Total fumbles on sacks
sack_fumbles_lostinteger—0Total sack fumbles lost
sack_yds_lostinteger—0—
sacksdecimal—0.0000—
sacks_takeninteger—0—
safetiesinteger—0—
special_teams_tdsinteger—0Total special teams touchdowns
tackles_assistedinteger—0—
tackles_for_lossinteger—0—
tackles_solointeger—0—
targetsinteger—0—
total_tacklesinteger—0—
yds_per_attemptdecimal—0.0000—
yds_per_carrydecimal—0.0000—
yds_per_receptiondecimal—0.0000—
nfl.season_player_thirddown_stats52 fields· 2 refsendpoints →

Season player stats restricted to third-down plays — conversion rates and production on the down that most often decides whether a drive lives or dies.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nfl.players2—
season_idbigint→ nfl.seasons2024—
assisted_tacklesinteger—0Assisted tackles on third down
defensive_tdsinteger—0Total defensive touchdowns on third down
forced_fumblesinteger—0Forced fumbles on third down
fumble_recovery_tdsinteger—0Fumble recovery touchdowns on third down
fumble_recovery_ydsinteger—0Fumble recovery yards on third down
fumblesinteger—0Fumbles on third down
fumbles_lostinteger—0Fumbles lost on third down
fumbles_recoveredinteger—0Fumbles recovered on third down
games_playedinteger—1Number of games with third down involvement
games_startedinteger—0Number of games started
interception_tdsinteger—0Interception return touchdowns on third down
interception_ydsinteger—0Interception return yards on third down
interceptionsinteger—0Interceptions on third down
offensive_snapsinteger—0Offensive snaps played on third down
offensive_tdsinteger—0Total offensive touchdowns on third down
passes_defendedinteger—0Passes defended on third down
passing_attemptsinteger—0Passing attempts on third down
passing_completion_percentagedecimal—0.0000Completion percentage on third down
passing_completionsinteger—0Completed passes on third down
passing_interceptionsinteger—0Interceptions thrown on third down
passing_longinteger—0Longest pass completion on third down
passing_ratingdecimal—0.0000Passer rating on third down
passing_sack_ydsinteger—0Yards lost to sacks on third down
passing_sacksinteger—0Times sacked on third down
passing_tdsinteger—0Passing touchdowns on third down
passing_ydsinteger—0Passing yards on third down
passing_yds_per_attemptdecimal—0.0000Passing yards per attempt on third down
passing_yds_per_completiondecimal—0.0000Passing yards per completion on third down
quarterback_hitsinteger—0QB hits on third down
receiving_longinteger—0Longest reception on third down
receiving_tdsinteger—0Receiving touchdowns on third down
receiving_ydsinteger—0Receiving yards on third down
receiving_yds_per_receptiondecimal—0.0000Yards per reception on third down
receiving_yds_per_targetdecimal—0.0000Receiving yards per target on third down
reception_percentagedecimal—0.0000Reception percentage (receptions/targets) on third down
receptionsinteger—0Receptions on third down
rushing_attemptsinteger—0Rushing attempts on third down
rushing_longinteger—0Longest rush on third down
rushing_tdsinteger—0Rushing touchdowns on third down
rushing_ydsinteger—0Rushing yards on third down
rushing_yds_per_attemptdecimal—0.0000Rushing yards per attempt on third down
sacksdecimal—0.0000Sacks on third down (0.5 for half sacks)
solo_tacklesinteger—0Solo tackles on third down
tackles_for_lossinteger—0Tackles for loss on third down
targetsinteger—0Times targeted on third down
total_tdsinteger—0Total touchdowns scored on third down
two_pt_pass_conversionsinteger—0—
two_pt_reception_conversionsinteger—0—
two_pt_rush_conversionsinteger—0—

Odds

nfl.game_lines18 fields· 3 refsendpoints →

NFL game betting lines — point spreads, moneylines, and over/under totals. Currently one consensus closing line per game (nflverse-sourced; captured_at equals kickoff time); multi-snapshot open-to-close history is not yet captured. Regular-season games only.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games49—
operator_idbigint→ main.operators6Data source (ESPN, DraftKings, FanDuel, nflverse, etc.)
season_idbigint→ nfl.seasons2024Denormalized for efficient season-level queries
captured_attimestamptz—2024-09-15T17:00:00.000ZWhen this snapshot was captured
implied_away_scoredecimalnullable—24.5000Calculated from spread + total
implied_away_win_pctdecimalnullable—0.4348From moneyline, 0-1
implied_home_scoredecimalnullable—23.0000Calculated from spread + total
implied_home_win_pctdecimalnullable—0.6078From moneyline, 0-1
is_openingboolean—falseTrue if this is the opening line
moneyline_awayintegernullable—130American odds for away team win
moneyline_homeintegernullable—-155American odds for home team win
over_oddsintegernullable—-110American odds for over
spreaddecimalnullable—2.5000Home team spread (e.g., -3.5 means home favored by 3.5)
spread_away_oddsintegernullable—-110American odds for away spread
spread_home_oddsintegernullable—-110American odds for home spread (e.g., -110)
totaldecimalnullable—44.5000Combined score total line (e.g., 47.5)
under_oddsintegernullable—-110American odds for under

Lineups & Roster

nfl.coaching_staff_tenures13 fields· 2 refsendpoints →

Every coaching change across NFL history with dates — when each head coach, offensive coordinator, and defensive coordinator started, when they left, and why (fired, resigned, promoted, retired).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
season_idbigint→ nfl.seasons2024Reference to the season
team_idbigint→ nfl.teams6Reference to the team
effective_datedate—2024-02-01T00:00:00.000ZDate this coach started in this role
end_datedatenullable—2024-11-29T00:00:00.000ZDate this coach ended (null if current)
first_namestringnullable—Mike—
full_namestring—Thomas BrownCoach full name
is_interimboolean—false—
Valuesfalsetrue
last_namestringnullable—Harbaugh—
positionstring—HCCoaching position (HC, OC, DC)
ValuesHCOCDC
reasonstringnullable—firedReason for change (fired, resigned, hired, promoted)
sourcestringnullable—seedData source (pfr, cbs_sports, espn, manual)
source_urlstringnullable—seed:coaching-tenure-2024.yml—
nfl.coaching_staffs8 fields· 2 refsendpoints →

The coaching staff for each NFL team at a given season — head coach, offensive coordinator, defensive coordinator, special teams coordinator, and position coaches.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
season_idbigint→ nfl.seasons2024—
team_idbigint→ nfl.teams1—
experienceintegernullable———
first_namestring—Mike—
full_namestring—Thomas Brown—
last_namestring—Harbaugh—
positionstring—DC—
ValuesDCHCOC
nfl.depth_chart_snapshots8 fields· 2 refsendpoints →

A team's full depth chart captured at a specific moment in the season — the season-opening baseline, plus any week the team published a fresh full chart. For the canonical per-game weekly chart use depth_charts instead; this snapshot/entry pair is the point-in-time scrape representation.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
season_idbigint→ nfl.seasons15—
team_idbigint→ nfl.teams29—
entry_countinteger—172Number of entries in this snapshot
is_baselineboolean—trueTrue if this is the season baseline snapshot
snapshot_attimestamptz—2026-03-14T07:32:09.000ZWhen this snapshot was taken
sourcestring—nflverseData source (nflverse, espn, etc.)
weekinteger—28NFL week number (0=preseason)
nfl.depth_chart_entries8 fields· 1 refsendpoints →

Where each player sits on the depth chart — position, depth order (starter, second-string, backup), and the formation grouping (offense, defense, special teams). Child rows of depth_chart_snapshots; for the canonical per-game weekly chart use depth_charts instead.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nfl.players1237—
snapshot_idbigint—44—
depth_orderinteger—2Order within position (1=starter, 2=backup, etc.)
depth_positionstring—WRSpecific depth position (QB1, RB2, etc.)
formationstringnullable—DefenseFormation group (offense, defense, special_teams)
ValuesDefenseOffense3WR 1TEBase 4-3 DSpecial TeamsBase 3-4 D
jersey_numberintegernullable———
positionstring—WRPosition abbreviation (QB, RB, WR, etc.)
nfl.depth_charts15 fields· 4 refsendpoints →

One player's depth-chart slot for a given team in a given NFL week — position, depth order (starter, backup, …), roster status, and game-type context. One row per (game × team × player × depth-position) combination.

FieldTypeReferencesExampleDescription
idkeybigint——Primary key — sequential row identifier.
elias_idstringnullable——Elias Sports Bureau player identifier (nullable — populated only when the source feed includes Elias IDs).
game_idbigint→ nfl.games120FK to nfl.games — the game this depth chart is associated with.
player_idbigint→ nfl.players19FK to nfl.players — the player occupying this depth-chart slot.
season_idbigint→ nfl.seasons1FK to nfl.seasons — the season containing this game.
team_idbigint→ nfl.teams32FK to nfl.teams — the team whose depth chart this row belongs to.
depth_orderintegernullable—1Depth-chart rank at this position — 1 for the starter, 2 for the primary backup, etc. NFL depth charts typically run 1–5 deep at each position.
depth_positionstring—DTPosition slot on the depth chart, which can differ from the player's primary position when they're listed at a secondary position (e.g., a player whose primary position is T may also appear on the depth chart at G).
ValuesDTWRDETQBLSGTECBILBKOLBCFSPSSNTRBFBMLB
depth_teamstringnullable——Sub-team designation within the depth chart when present (e.g., a formation-specific team grouping). Sparse — typically NULL.
formationstringnullable——Formation unit this slot belongs to (e.g., OFF, DEF, ST). Sparse — typically NULL.
game_typestring—REGPhase of the season: REG (regular season), WC (Wild Card), DIV (Divisional), CON (Conference Championship), SB (Super Bowl).
ValuesREGDIVWCCONSB
jersey_numberintegernullable——Player's jersey number on the team for this game (nullable — populated when the depth chart includes uniform numbers).
positionstring—DTPlayer's listed position abbreviation (e.g., QB, RB, WR, T, DT, CB, MLB, K, P).
ValuesDTWRDETQBLSGTECBILBKOLBCFSPSSNTRBFBMLB
statusstringnullable—ActiveNFL roster status code at the time of the chart: ACT (active), DEV (practice squad / developmental), INA (inactive), RES (reserve / IR), EXE (exempt), CUT (released), TRC (traded — pending), TRD (traded), RET (retired), E01 (other transactional status).
ValuesActiveReservePracticeSquadInactiveRetiredCutExempt
weekinteger—15NFL week number within the season (1-18 regular season; postseason weeks use higher numbers per league convention).
nfl.game_team_rosters9 fields· 3 refsendpoints →

The gameday roster for each NFL game — every player who suited up that day, who started, who was inactive, and at what position.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games120—
player_idbigint→ nfl.players19—
team_idbigint→ nfl.teams32—
commentstringnullable——Optional note from the gameday roster report (e.g., reason for inactive).
dayinteger—20241212Day-of-year integer (matches `game.day` for partitioning).
positionstringnullable—DLPosition the player suited up at for this game.
ValuesDLOLDBWRLBQBLSTEKPRB
starterboolean—trueTrue if the player started this game.
Valuestruefalse
statusstringnullable—ActiveRoster status for the game, readable single-word vocabulary (`Active`, `Inactive`, `PracticeSquad`, `Reserve`, `Cut`, `Retired`, `Exempt`, `PracticeSquadReleased`).
ValuesActiveReservePracticeSquadInactiveRetiredCutExempt
nfl.game_team_staffs6 fields· 2 refsendpoints →

The coaching staff on the sideline for each NFL game — head coach, offensive coordinator, defensive coordinator, for both teams.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games49Reference to the game
team_idbigint→ nfl.teams16Reference to the team
defensive_coordinatorstringnullable——Defensive coordinator name
head_coachstringnullable—Andy ReidHead coach name (from nflverse)
offensive_coordinatorstringnullable——Offensive coordinator name
nfl.team_player_rosters8 fields· 3 refsendpoints →

Day-by-day player-to-team affiliations across the season — who was on which roster, at what position, on every day from training camp through the Super Bowl.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nfl.players765—
season_idbigint→ nfl.seasons2024—
team_idbigint→ nfl.teams32—
dayinteger—20240905Day-of-year integer; the row is valid for that single day.
depth_orderintegernullable——Depth-chart order at this position on this date (1 = starter).
positionstringnullable—DBPosition assigned to the player for this season-day.
ValuesDBOLDLLBWRRBTEQBKPLS
position_groupstringnullable—OffensePosition group (`OFFENSE`, `DEFENSE`, `ST`).
ValuesOffenseDefenseSpecial Teams

Misc

nfl.stadiums20 fields· 1 refsendpoints →

Venues that have hosted NFL games — current home stadiums, neutral-site locations like international and Super Bowl venues, and historical fields no longer in use.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
league_stadium_idstringnullable→ nfl.stadiums00081065-961a-76b2-de6a-b6da2602a129Official NFL stadium ID from API
addressstringnullable—1 Patriot Pl, Foxborough, MA 02035Street address of the stadium.
capacityintegernullable—65000Approximate seating capacity for football configuration.
citystring—Santa Clara—
closed_datetimestamptznullable——Date the stadium closed (null if currently in use).
countrystringnullable—USA—
ValuesUSADEUGBRMEXESPBRAIRL
descriptionstringnullable———
elevationfloatnullable—256Elevation in feet above sea level
image_urlstringnullable—https://upload.wikimedia.org/wikipedia/commons/thumb/7/70/Gillette_Stadium_%28aerial%29.jpg/1280px-…URL to aerial/overview image of stadium
latitudefloatnullable—42.0909Latitude of the stadium centroid (decimal degrees, WGS84).
longitudefloatnullable—-71.2643Longitude of the stadium centroid (decimal degrees, WGS84).
namestring—Gillette Stadium—
opened_datetimestamptznullable—2002-01-01T00:00:00.000ZDate the stadium opened for play.
orientationfloatnullable—0Field orientation in degrees (0-360). Direction end zones face, measured from south end zone. 0/360=North, 90=East, 180=South, 270=West
roof_typestringnullable—OpenRoof type (e.g., `open`, `dome`, `retractable`).
ValuesOpenRetractableDome
statestringnullable—FL—
surfacestringnullable—GrassPlaying surface type (e.g., `grass`, `FieldTurf`, `Astroturf`).
ValuesGrassFieldTurfHybrid GrassA-Turf TitanBermuda GrassUBU Sports Speed Series S5-M
team_namestringnullable——Team commonly associated with this stadium at the time (display string, not a foreign key).
timezonestringnullable—America/New_YorkIANA timezone (e.g., America/New_York)
ValuesAmerica/New_YorkAmerica/ChicagoAmerica/Los_AngelesEurope/BerlinEurope/LondonAmerica/Mexico_CityEurope/MadridAmerica/Indiana/IndianapolisAmerica/DenverAmerica/DetroitAmerica/PhoenixAmerica/Sao_PauloEurope/Dublin
nfl.playoffs11 fields· 4 refsendpoints →

The NFL postseason bracket — Wild Card weekend, the Divisional Round, the Conference Championships, and the Super Bowl, with seeds, scores, and outcomes.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
away_team_idbigint→ nfl.teams19—
home_team_idbigint→ nfl.teams26—
season_idbigint→ nfl.seasons2024—
winner_team_idbigintnullable→ nfl.teams26Winning team (FK to `teams`); null until the game completes.
away_team_seedinteger—0Playoff seed (1-7) of the away team for this matchup.
conferencestringnullable—AFCConference the matchup is contested within (`AFC`, `NFC`); null for the Super Bowl (inter-conference).
ValuesAFCNFC
game_numberinteger—1Sequence number within the round (used to order multiple games in the same round).
home_team_seedinteger—0Playoff seed (1-7) of the home team for this matchup.
playoff_roundstring—Wild CardPostseason round (`WildCard`, `Divisional`, `Conference Championship`, `Super Bowl`).
ValuesWild CardDivisionalConference ChampionshipSuper Bowl
statusstring—FinalMatchup status (`Scheduled`, `InProgress`, `Final`).
nfl.combine_results16 fields· 2 refsendpoints →

NFL Scouting Combine results — every prospect's measurables and drill times from the annual Indianapolis combine (height, weight, 40-yard dash, vertical jump, bench press, broad jump, three-cone, shuttle).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
cfb_idstringnullable—kris-abrams-draine-1College Football Reference player ID (external lookup).
pfr_idstringnullable—AbraKr00Pro Football Reference player ID (external lookup).
player_idbigint→ nfl.players2707—
team_idbigintnullable→ nfl.teams——
benchintegernullable—21Bench press repetitions at 225 lbs.
broad_jumpintegernullable—124Broad jump distance in inches.
conedecimalnullable—6.82003-cone drill time in seconds.
fortydecimalnullable—4.460040-yard dash time in seconds.
htstringnullable—6-4Height as reported by the Combine (e.g., `6-2` for 6 feet 2 inches).
Values6-46-36-16-56-26-05-116-65-105-95-86-76-86-95-7
positionstring—WRPosition the player was measured as (e.g., QB, WR, RB, CB).
ValuesWRCBDTRBEDGEOTLBGTEQBCSAFKDEPCB/WR
schoolstringnullable—MichiganCollege or last-affiliation school name.
seasoninteger—2025Calendar year of the Combine (e.g., 2024 for the February 2024 combine).
shuttledecimalnullable—4.400020-yard shuttle time in seconds.
verticaldecimalnullable—34.5000Vertical jump in inches.
wtintegernullable—205Weight in pounds.
nfl.draft_picks38 fields· 4 refsendpoints →

Every NFL Draft selection from the modern draft era — round, pick number, drafting team, college, and the career stats that followed (Pro Bowls, All-Pros, Hall of Fame, total games played, career statistics by position).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
cfb_player_idstringnullable→ nfl.playerscaleb-williams-3College Football Reference player ID.
gsis_idstring——Game Statistics and Information System ID (NFL official cross-system join key).
pfr_player_idstring→ nfl.playersWillCa03Pro Football Reference player ID.
player_idbigint→ nfl.players3180—
team_idbigint→ nfl.teams22—
ageintegernullable—23Player age at the time of the draft.
allpro_countinteger—0Career All-Pro selections.
car_avintegernullable——Career Approximate Value (Pro Football Reference, unweighted sum across seasons).
career_to_yearintegernullable—2025Most recent NFL season the player appeared in (calendar year).
categorystring—DLPosition category (e.g., `OFF`, `DEF`, `ST`).
ValuesDLOLDBWRRBLBTEQBKPFSLS
collegestring—TexasCollege the player was drafted out of.
def_intsinteger—0Career defensive interceptions.
def_sacksdecimal—0.0000Career sacks (defensive; half-sacks supported as decimals).
def_solo_tacklesinteger—0Career solo defensive tackles.
dr_avintegernullable—1Approximate Value accumulated while with the drafting team.
games_playedinteger—17Total career regular-season games played.
is_hofboolean—falseTrue if the player is enshrined in the Pro Football Hall of Fame.
pass_attemptsinteger—0Career pass attempts.
pass_completionsinteger—0Career pass completions.
pass_intsinteger—0Career interceptions thrown.
pass_tdsinteger—0Career passing touchdowns.
pass_ydsinteger—0Career passing yards.
pfr_player_namestringnullable—Marcus HarrisPlayer name as recorded on Pro Football Reference.
pickinteger—1Pick number within the round.
positionstring—OLPosition the player was drafted at (e.g., QB, WR, DE).
ValuesOLWRRBLBDECBDBDTTEDLQBSAFOTKGCPFSOLBLS
probowl_countinteger—0Career Pro Bowl selections.
rec_tdsinteger—0Career receiving touchdowns.
rec_ydsinteger—0Career receiving yards.
receptionsinteger—0Career receptions.
roundinteger—6Draft round (1-7).
rush_attsinteger—0Career rushing attempts.
rush_tdsinteger—0Career rushing touchdowns.
rush_ydsinteger—0Career rushing yards.
seasoninteger—2025Calendar year of the draft.
seasons_startedinteger—0Number of NFL seasons in which the player was a primary starter.
sidestring—OSide of the ball (`OFF` or `DEF`).
ValuesODS
w_avintegernullable—1Weighted Approximate Value (Pro Football Reference career composite metric).
nfl.game_weathers18 fields· 2 refsendpoints →

On-field weather throughout each NFL game — temperature, wind, humidity, and precipitation captured at fixed intervals from kickoff. Useful for outdoor-game performance analysis.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games4992—
stadium_idbigint→ nfl.stadiums16—
feels_like_temperatureintegernullable—72—
field_conditionstringnullable———
humidityfloatnullable—50—
is_domeboolean—false—
Valuesfalsetrue
minutes_from_startinteger—0Minutes from game start (0, 30, 60, 90, 120, 150)
precipitationfloatnullable—0—
precipitation_probabilityfloatnullable—0—
recorded_attimestamptz—2025-09-07T19:00:00.000Z—
roof_statusstringnullable—Open—
ValuesOpenDomeRetractable
temperatureintegernullable—72—
weather_conditionstringnullable—INDOOR—
ValuesINDOOROVERCASTCLEARDRIZZLEMAINLY_CLEARPARTLY_CLOUDYSNOWRAIN
weather_descriptionstringnullable—Indoor stadium - controlled environment—
ValuesIndoor stadium - controlled environmentOvercastClear skyMainly clearLight drizzlePartly cloudyModerate drizzleSlight snowSlight rainModerate rainModerate snowDense drizzleHeavy rainHeavy snow
wind_directionfloatnullable—0—
wind_gustfloatnullable—0—
wind_speedfloatnullable—0—
nfl.injuries15 fields· 4 refsendpoints →

The weekly NFL injury report — every player listed each game week with their practice participation, game-status designation (Out, Doubtful, Questionable, Probable), and the body part affected.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nfl.games151—
player_idbigint→ nfl.players936—
season_idbigint→ nfl.seasons2024—
team_idbigint→ nfl.teams4—
date_modifiedtimestamptznullable—2024-11-08T19:11:50.000ZTimestamp of the most recent NFL feed update for this report.
game_typestring—REGGame classification for the upcoming game (`REG`, `WC`, `DIV`, `CON`, `SB`).
ValuesREGDIVCONWCSB
positionstring—LBPosition the player was listed at on the report.
ValuesLBWRCBTDTSDETERBGQBCKFBPLSUNKDBDL
practice_primary_injurystringnullable—KneePrimary injury reported on the practice participation report.
practice_secondary_injurystringnullable—KneeSecondary injury reported on the practice participation report.
practice_statusstringnullable—Full Participation in PracticePractice participation as long-form strings — `Did Not Participate In Practice`, `Limited Participation in Practice`, `Full Participation in Practice` (occasionally `Note` or blank).
ValuesFull Participation in PracticeDid Not Participate In PracticeLimited Participation in Practice Note
report_primary_injurystringnullable—KneePrimary injury body part listed on the official Wednesday/Thursday report (e.g., `Hamstring`, `Knee`).
report_secondary_injurystringnullable—KneeSecondary injury listed on the official injury report.
report_statusstringnullable—QuestionableGame-status designation (`Out`, `Doubtful`, `Questionable`; occasionally `Note` or blank when no designation was issued).
ValuesQuestionableOutDoubtfulNote
weekinteger—9NFL week the report covers — 1-18 regular season, continuing 19 Wild Card, 20 Divisional, 21 Conference Championship, 22 Super Bowl. Note nfl.games.week restarts at 1 in the postseason instead.
nfl.player_contracts21 fields· 2 refsendpoints →

NFL player contracts — total value, average annual pay, guaranteed money, and salary cap impact for every signed deal, with cap-inflated comparisons across eras.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
otc_idstring—9466OverTheCap unique contract identifier (external).
player_idbigint→ nfl.players1546—
team_idbigint→ nfl.teams25—
apybigint—895000Average annual value (APY) in U.S. dollars — total `value` divided by `years`.
apy_cap_pctdecimal—0.0040APY as a percentage of the league salary cap in the signing year (0.0-100.0).
collegestringnullable—Florida State—
date_of_birthdatenullable———
guaranteedbigint—0Total guaranteed money over the life of the contract, in U.S. dollars.
heightstringnullable—6'3"Height as reported by OverTheCap (e.g., `6-2`).
Values6'3"6'2"6'4"6'5"6'0"5'11"6'1"5'9"6'6"6'7"5'10"5'8"6'8"
inflated_apybigint—895000`apy` adjusted to the most recent salary cap.
inflated_guaranteedbigint—0`guaranteed` adjusted to the most recent salary cap.
inflated_valuebigint—895000`value` adjusted to the most recent salary cap, in U.S. dollars.
is_activeboolean—trueTrue for the player's currently-active contract; false for historical contracts.
player_page_urlstringnullable—https://overthecap.com/player/zach-wilson/9466/Direct URL to the player's page on overthecap.com.
positionstring—WRPlayer position at the time the contract was signed.
ValuesWRCBEDIDLSLBRBTERTQBLGLTKCRGPFBLS
season_history_jsonstringnullable——JSON-encoded year-by-year cap-hit breakdown for the life of the contract (stored as a string).
valuebigint—895000Total contract value in U.S. dollars as reported by OverTheCap.
weightintegernullable—199Weight in pounds.
year_signedinteger—2022Calendar year the contract was signed.
yearsinteger—4Total contract length in years.
nfl.player_news16 fields· 2 refsendpoints →

News about NFL players — transactions, injuries, lineup announcements, suspensions, and general beat-reporter updates.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
external_idstringnullable—sportsdata-214469—
player_idbigintnullable→ nfl.players925—
team_idbigintnullable→ nfl.teams27—
ai_processedboolean—false—
analysisstringnullable———
authorstringnullable—Staff—
categorystringnullable—injuryinjury, transaction, lineup, general
Valuesinjurytransactiongenerallineup
contentstringnullable—Los Angeles Rams star wide receiver Puka Nacua has been accused of biting a woman in Los Angeles an…—
descriptionstringnullable—Fantasy football draft rankings from Matt Bowen, Mike Clay, Tristan H. Cockcroft, Daniel Dopp, Eric…—
linkstringnullable—https://www.espn.com/video/clip?id=47726158—
news_timetimestamptz—2026-05-04T04:00:00.000Z—
priorityinteger—5—
situational_impactjsonbnullable—[object Object]—
sourcestringnullable—cbs_sports—
Valuescbs_sportssportsdataespn
titlestring—Marcus Harris Questionable for Week 1 vs. Jets (Knee)—