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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
end_date	timestamptznullable	—	2020-02-02T05:00:00.000Z	Last day of the season (Super Bowl date or shortly after).
post_season_start_date	timestamptznullable	—	2020-01-04T05:00:00.000Z	First day of the postseason (Wild Card weekend).
regular_season_start_date	timestamptznullable	—	2019-09-05T04:00:00.000Z	First day of regular-season play (typically the Thursday after Labor Day).
regular_season_weeks	integer	—	18	Number of regular-season weeks (18 since 2021; 17 in 2020 and earlier).
start_date	timestamptz	—	2019-09-05T04:00:00.000Z	First day of the season (typically the start of preseason in early August).
start_year	integer	—	2019	Calendar year in which the season starts (e.g., 2025 = the 2025-26 season).
super_bowl_date	timestamptznullable	—	2020-02-02T05:00:00.000Z	Date of the Super Bowl for this season.

nfl.teams13 fields· 1 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
league_team_id	string	—	10403800-517c-7b8c-65a3-c61b95d86123	Official NFL team UUID from api.nfl.com
stadium_id	bigint	→ nfl.stadiums	16	Primary home stadium (FK to `stadiums`); null if unknown or shared.
abbreviation	string	—	ARI	Three-letter team code (e.g., KC, NE, GB).
active	boolean	—	true	True for currently-active franchises; false for relocated or defunct teams retained for historical references.
city	string	—	Los Angeles	—
conference	string	—	NFC	Conference assignment (AFC or NFC). Values`NFCAFC`
division	string	—	West	Division within the conference (e.g., AFC East, NFC West). Values`WestSouthNorthEast`
full_name	string	—	Arizona Cardinals	—
logo_url	stringnullable	—	https://a.espncdn.com/i/teamlogos/nfl/500/ari.png	URL to team logo image
name	string	—	Cardinals	—
primary_color	stringnullable	—	#002244	Hex color code for the team's primary uniform color (e.g., `#A71930`).
secondary_color	stringnullable	—	#000000	Hex 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.games30 fields· 4 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
away_team_id	bigint	→ nfl.teams	19	—
home_team_id	bigint	→ nfl.teams	16	—
league_game_id	string	—	c7ce9df0-2459-11ef-afd1-646009f18b2e	Official NFL game ID from league source
season_id	bigint	→ nfl.seasons	2024	—
stadium_id	integer	→ nfl.stadiums	16	Stadium hosting the game (FK to `stadiums`).
attendance	integernullable	—	64628	Reported attendance count; null when not published.
away_rotation_number	integernullable	—	—	Sportsbook rotation number for the away team (3-4 digit cross-book reference).
away_team	string	—	LAR	Denormalized team abbreviation for the away side at game time (snapshot copy of `teams.abbreviation`).
away_team_score	integer	—	0	Final away-team score; 0 (not null) until the game completes.
channel	stringnullable	—	—	Primary broadcast network/channel (e.g., `CBS`, `FOX`, `Prime Video`).
day	integer	—	20210103	Calendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern.
end_time	timestamptznullable	—	—	Actual game end timestamp; null until the game completes.
game_label	stringnullable	—	AFC Wild Card	Display label for special games (e.g., `Thanksgiving Day`, `Monday Night Football`). Values`AFC Wild CardNFC Wild CardAFC DivisionalNFC DivisionalNFC ChampionshipAFC ChampionshipSuper Bowl`
game_sub_label	stringnullable	—	—	Secondary label or sub-category for the game.
game_time	timestamptznullable	—	2027-01-10T18:00:00.000Z	Scheduled kickoff time (timezone-aware); null when the league published no time.
home_rotation_number	integernullable	—	—	Sportsbook rotation number for the home team (3-4 digit cross-book reference).
home_team	string	—	KC	Denormalized team abbreviation for the home side at game time (snapshot copy of `teams.abbreviation`).
home_team_score	integer	—	0	Final home-team score; 0 (not null) until the game completes.
neutral_venue	boolean	—	false	True if the game is played at a neutral site (Super Bowl, international games, etc.). Values`falsetrue`
overtime	boolean	—	false	True if the game went to overtime. Values`falsetrue`
overtime_periods	integernullable	—	—	Number of overtime periods played (1+ when `overtime` is true).
playoff_round	stringnullable	—	Wild Card	Postseason round (`WildCard`, `Divisional`, `Conference Championship`, `Super Bowl`); null outside the postseason. Values`Wild CardDivisionalConference ChampionshipSuper Bowl`
playoff_seed_away	integernullable	—	5	Away-team playoff seed (1-7); null outside the postseason.
playoff_seed_home	integernullable	—	2	Home-team playoff seed (1-7); null outside the postseason.
postponed_status	stringnullable	—	—	Reason for postponement (e.g., `Weather`, `COVID`); null for games played as scheduled.
season_type	string	—	regular_season	Canonical season phase. Postseason round detail (Wild Card / Divisional / Conference Championship / Super Bowl) lives in `playoff_round`. Values`regular_seasonpreseasonpostseason`
status	string	—	Final	Game status. Currently always `Scheduled` (status reconciliation is pending) — detect completed games via populated scores, not this field. Values`FinalScheduledCanceled`
type	string	—	Regular	Game classification (`Regular`, `Playoff`, `Super Bowl`, `Preseason`). Values`RegularPreseasonPlayoff`
week	integer	—	1	Week 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.

nfl.players27 fields· 1 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
gsis_id	string	—	00-0022531	Game Statistics and Information System ID (e.g. 00-0028830)
league_player_id	stringnullable	—	3200524f-4433-9293-a3cf-ad7758d03003	Official NFL player ID (UUID) from nfl.com
team_id	bigintnullable	→ nfl.teams	1	Current NFL team (FK to `teams`); null for free agents and retired players.
birth_city	stringnullable	—	Houston	—
birth_country	stringnullable	—	—	—
birth_date	datenullable	—	1997-02-14	—
birth_state	stringnullable	—	TX	—
college	stringnullable	—	Alabama	College or last football affiliation before turning pro.
draft_number	stringnullable	—	1	Pick number within the round; null or `UDFA` if undrafted.
draft_round	stringnullable	—	1	Draft round (1-7); null or `UDFA` if undrafted.
draft_year	stringnullable	—	2023	Calendar year the player was drafted; null or `UDFA` if undrafted.
experience	integernullable	—	1	Years of NFL experience (rookies = 0).
first_name	string	—	Michael	—
full_name	string	—	Aaron Brewer	—
full_position_list	stringnullable	—	—	All positions the player is eligible at (semicolon-joined when multiple, e.g., `RB;WR`).
height	integernullable	—	75	Height in inches.
is_team	boolean	—	false	True for synthetic team-level entities (DST, team defense). Used to distinguish team defense 'players' from individual players. Values`falsetrue`
jersey	stringnullable	—	null	Jersey number with the player's current team (string to preserve leading zeros and special codes).
last_name	string	—	Jones	—
nfl_slug	stringnullable	—	—	URL slug used on nfl.com (e.g., `patrick-mahomes`).
overall_pick	integernullable	—	217	Overall pick number across all rounds (1-262); null if undrafted.
position_group	stringnullable	—	Offense	Broad position group classification used by nflverse (e.g., `OFFENSE`, `DEFENSE`, `ST`). Values`OffenseDefenseSpecial Teams`
primary_position	string	—	WR	Primary roster position (e.g., QB, WR, RB, CB).
profile_pic_url	stringnullable	—	https://static.www.nfl.com/image/upload/f_auto,q_auto/league/xcsyqvrlrpe6s3d0rodq	URL to player profile picture image
roster_status	stringnullable	—	active	Canonical 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. Values`activepractice_squadwaivedreservefree_agentinjured_reserveinactiveretiredsuspended`
weight	integernullable	—	200	Weight in pounds.

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
first_play_id	bigint	—	40	play_id of first play in drive
game_id	bigint	→ nfl.games	222	—
last_play_id	bigint	—	131	play_id of last play in drive
possession_team_id	bigint	→ nfl.teams	13	Team with possession (FK to teams)
drive_number	integer	—	2	Drive sequence number in game (1-indexed)
end_transition	stringnullable	—	PUNT	How possession ended (PUNT, TOUCHDOWN, TURNOVER, etc.) Values`PUNTTOUCHDOWNFIELD_GOALINTERCEPTIONDOWNSFUMBLEEND_GAMEEND_HALFMISSED_FGSAFETYBLOCKED_PUNTBLOCKED_FGBLOCKED_PUNT,_DOWNSFUMBLE,_SAFETYBLOCKED_FG,_DOWNS`
end_yard_line	stringnullable	—	50	Ending field position (e.g., "OPP 10")
ended_with_score	boolean	—	false	Drive resulted in points Values`falsetrue`
first_downs	integernullable	—	0	First downs gained
fixed_drive	integer	—	2	Corrected drive number from nflverse
game_clock_end	stringnullable	—	00:00	Game clock at drive end (mm:ss)
game_clock_start	stringnullable	—	15:00	Game clock at drive start (mm:ss)
inside_20	boolean	—	false	Drive reached red zone Values`falsetrue`
play_count	integernullable	—	3	Number of plays in drive
quarter_end	integernullable	—	2	Quarter when drive ended
quarter_start	integernullable	—	2	Quarter when drive started
result	stringnullable	—	Punt	Drive outcome (Touchdown, Field goal, Punt, Turnover, etc.) Values`PuntTouchdownField goalTurnoverEnd of halfTurnover on downsMissed field goalOpp touchdownSafety`
start_transition	stringnullable	—	KICKOFF	How possession was gained (KICKOFF, PUNT, TURNOVER, etc.) Values`KICKOFFPUNTINTERCEPTIONDOWNSFUMBLEMISSED_FGMUFFED_PUNTBLOCKED_PUNTONSIDE_KICKBLOCKED_PUNT,_DOWNSBLOCKED_FG,_DOWNSBLOCKED_FGMUFFED_KICKOFF`
start_yard_line	stringnullable	—	LV 30	Starting field position (e.g., "KC 25")
time_of_possession	stringnullable	—	1:30	Drive duration (mm:ss format)
yds_penalized	integernullable	—	0	Penalty yards on drive

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	61	—
play_id	string	—	40	Play identifier matching `play_by_plays.play_id` for the same game.
possession_team_id	bigint	→ nfl.teams	26	Team in possession on this play (FK to `teams`).
defenders_in_box	integernullable	—	6	Number of defenders within ~8 yards of the line of scrimmage at the snap.
defense_coverage_type	stringnullable	—	COVER_1	Specific coverage scheme (e.g., `COVER_1`, `COVER_2_MAN`, `COVER_3`, `COVER_4`). Values`COVER_1COVER_2COVER_32_MANCOVER_4COVER_0COVER_6COMBOCOVER_9BLOWN`
defense_man_zone_type	stringnullable	—	MAN_COVERAGE	Man- vs. zone-coverage classification (`MAN`, `ZONE`). Values`MAN_COVERAGEZONE_COVERAGE`
defense_personnel	stringnullable	—	3 CB, 2 DE, 2 DT, 1 FS, 2 ILB, 1 SS	Defensive personnel grouping (e.g., `4 DL, 2 LB, 5 DB`).
defense_players_gsis_ids	stringnullable	—	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_defense	integernullable	—	11	Count of defensive players on the field (typically 11).
n_offense	integernullable	—	11	Count of offensive players on the field (typically 11).
ngs_air_yds	decimalnullable	—	—	Air yards traveled by the pass from the line of scrimmage to where the receiver caught/dropped it (Next Gen Stats).
number_of_pass_rushers	integernullable	—	0	Number of defenders who rushed the passer on this play (Next Gen Stats).
offense_formation	stringnullable	—	SHOTGUN	Offensive formation alignment (e.g., `SHOTGUN`, `SINGLEBACK`, `I_FORM`, `PISTOL`). Values`SHOTGUNUNDER CENTERPISTOL`
offense_personnel	stringnullable	—	1 C, 2 G, 1 QB, 1 RB, 2 T, 1 TE, 3 WR	Offensive personnel grouping in `RB-TE-WR` shorthand (e.g., `1 RB, 2 TE, 2 WR` → `12 personnel`).
offense_players_gsis_ids	stringnullable	—	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_ids	stringnullable	—	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).
route	stringnullable	—	QUICK OUT	Route the targeted receiver ran (e.g., `GO`, `SLANT`, `OUT`, `POST`). Values`QUICK OUTHITCH/CURLSCREENIN/DIGGODEEP OUTSHALLOW CROSS/DRAGSLANTCORNERSWINGPOSTTEXAS/ANGLEWHEEL`
time_to_throw	decimalnullable	—	2.3000	Time from snap to pass release in seconds (Next Gen Stats).
was_pressure	booleannullable	—	false	True if the quarterback faced pass-rush pressure on this play. Values`falsetrue`

nfl.play_by_plays372 fields· 8 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
assist_tackle_1_player_id	stringnullable	—	00-0037616	Assist tackler 1 GSIS ID
assist_tackle_2_player_id	stringnullable	—	00-0036294	Assist tackler 2 GSIS ID
assist_tackle_3_player_id	stringnullable	—	—	Assist tackler 3 GSIS ID
assist_tackle_4_player_id	stringnullable	—	—	Assist tackler 4 GSIS ID
blocked_player_id	stringnullable	—	00-0037527	Blocked kick player GSIS ID Values`00-003752700-003784300-003698200-0037156`
defensive_team_id	bigintnullable	→ nfl.teams	14	FK to teams table for defensive team
drive_id	bigintnullable	→ nfl.game_drives	41	FK to game_drives table
fantasy_id	stringnullable	—	00-0035700	Fantasy identifier
fantasy_player_id	stringnullable	—	00-0034844	Fantasy designation player ID
forced_fumble_player_1_player_id	stringnullable	—	00-0033868	Forced fumble player 1 GSIS ID
forced_fumble_player_2_player_id	stringnullable	—	—	Forced fumble player 2 GSIS ID
fumble_recovery_1_player_id	stringnullable	—	00-0037666	Recovery player 1 GSIS ID
fumble_recovery_2_player_id	stringnullable	—	—	Recovery player 2 GSIS ID
fumbled_1_player_id	stringnullable	—	00-0036442	First fumbler GSIS ID
fumbled_2_player_id	stringnullable	—	—	Second fumbler GSIS ID
game_id	bigint	→ nfl.games	50	FK to games table
half_sack_1_player_id	stringnullable	—	00-0039148	Half-sack player 1 GSIS ID Values`00-003914800-003850400-003237800-003695400-003267100-003241500-003910800-003589000-003760300-003694000-0035402`
half_sack_2_player_id	stringnullable	—	00-0036130	Half-sack player 2 GSIS ID Values`00-003613000-003648000-003434400-003104000-003438500-003158300-003156500-003637800-003853500-003257400-003632100-0034251`
interception_player_id	stringnullable	—	00-0036388	Interceptor GSIS ID
kicker_player_id	stringnullable	—	00-0038905	Kicker GSIS ID
kickoff_returner_player_id	stringnullable	—	00-0037429	Kickoff returner GSIS ID
lateral_interception_player_id	stringnullable	—	—	Lateral after INT GSIS ID
lateral_kickoff_returner_player_id	stringnullable	—	—	Lateral kickoff returner GSIS ID
lateral_punt_returner_player_id	stringnullable	—	—	Lateral punt returner GSIS ID
lateral_receiver_player_id	stringnullable	—	00-0038976	Lateral receiver GSIS ID (pass)
lateral_rusher_player_id	stringnullable	—	00-0034975	Lateral receiver GSIS ID (rush)
lateral_sack_player_id	stringnullable	—	—	Lateral after sack GSIS ID
nfl_api_id	stringnullable	—	7d4019ca-1312-11ef-afd1-646009f18b2e	UUID from NFL API
nflverse_game_id	stringnullable	—	—	Ten digit identifier for NFL game (nflverse format)
old_game_id	stringnullable	—	2024090600	Legacy NFL game ID format
own_kickoff_recovery_player_id	stringnullable	—	—	Own kickoff recovery player GSIS ID
pass_defense_1_player_id	stringnullable	—	00-0034856	Pass defense player 1 GSIS ID
pass_defense_2_player_id	stringnullable	—	00-0031554	Pass defense player 2 GSIS ID Values`00-003155400-003724600-003423400-003982900-003502000-003725000-0034720`
passer_id	bigintnullable	→ nfl.players	358	FK to players table
passer_player_id	stringnullable	—	00-0033537	Passer GSIS ID
penalty_player_id	stringnullable	—	00-0036874	Penalized player GSIS ID
play_id	string	—	1	Numeric play identifier unique to game
possession_team_id	bigintnullable	→ nfl.teams	8	FK to teams table for possession team
primary_player_gsis_id	stringnullable	—	—	Primary player GSIS ID
punt_returner_player_id	stringnullable	—	00-0039392	Punt returner GSIS ID
punter_player_id	stringnullable	—	00-0032943	Punter GSIS ID
qb_hit_1_player_id	stringnullable	—	00-0036932	QB hitter GSIS ID
qb_hit_2_player_id	stringnullable	—	00-0036130	Second QB hitter GSIS ID Values`00-003613000-003648000-003434400-003104000-003438500-003158300-003156500-003257400-003632100-0034251`
receiver_id	bigintnullable	→ nfl.players	438	FK to players table
receiver_player_id	stringnullable	—	00-0033908	Receiver GSIS ID
rusher_id	bigintnullable	→ nfl.players	943	FK to players table
rusher_player_id	stringnullable	—	00-0035700	Rusher GSIS ID
sack_player_id	stringnullable	—	00-0036914	Sacker GSIS ID
safety_player_id	stringnullable	—	00-0035248	Safety scorer GSIS ID Values`00-003524800-0037251`
solo_tackle_1_player_id	stringnullable	—	00-0034987	Solo tackler 1 GSIS ID
solo_tackle_2_player_id	stringnullable	—	00-0039753	Solo tackler 2 GSIS ID Values`00-003975300-0039032`
stadium_id	integernullable	→ nfl.stadiums	—	Stadium ID
tackle_for_loss_1_player_id	stringnullable	—	00-0034973	TFL player 1 GSIS ID
tackle_for_loss_2_player_id	stringnullable	—	—	TFL player 2 GSIS ID
tackle_with_assist_1_player_id	stringnullable	—	00-0031898	Tackle-assist player 1 GSIS ID
tackle_with_assist_2_player_id	stringnullable	—	—	Tackle-assist player 2 GSIS ID
td_player_id	stringnullable	—	00-0033906	TD scorer GSIS ID
aborted_play	boolean	—	false	Play was aborted Values`falsetrue`
air_epa	decimalnullable	—	-0.1479	EPA from air yards
air_wpa	decimalnullable	—	0.0000	WPA from air yards
air_yds	integernullable	—	5	Yards in air (perpendicular to LOS)
assist_tackle	boolean	—	false	Assist tackle on play Values`falsetrue`
assist_tackle_1_player_name	stringnullable	—	J.Jones	Assist tackler 1 name
assist_tackle_1_team	stringnullable	—	IND	Assist tackler 1 team
assist_tackle_2_player_name	stringnullable	—	L.Wilson	Assist tackler 2 name
assist_tackle_2_team	stringnullable	—	LA	Assist tackler 2 team
assist_tackle_3_player_name	stringnullable	—	—	Assist tackler 3 name
assist_tackle_3_team	stringnullable	—	—	Assist tackler 3 team
assist_tackle_4_player_name	stringnullable	—	—	Assist tackler 4 name
assist_tackle_4_team	stringnullable	—	—	Assist tackler 4 team
away_coach	stringnullable	—	Antonio Pierce	Away team head coach
away_score	integernullable	—	20	Total away points
away_team	stringnullable	—	LV	Away team abbreviation
away_timeouts_remaining	integernullable	—	3	Away timeouts remaining
away_wp	decimalnullable	—	0.0001	Away team win probability
away_wp_post	decimalnullable	—	0.0001	Away WP after play
blocked_player_name	stringnullable	—	S.Olubi	Blocked kick player name Values`S.OlubiD.HardyC.GolstonI.Charles`
comp_air_epa	decimalnullable	—	0.0000	Completion air EPA
comp_air_wpa	decimalnullable	—	0.0000	Completion air WPA
comp_yac_epa	decimalnullable	—	0.0000	Completion YAC EPA
comp_yac_wpa	decimalnullable	—	0.0000	Completion YAC WPA
complete_pass	boolean	—	false	Pass completed Values`falsetrue`
cp	decimalnullable	—	0.8676	Completion probability
cpoe	decimalnullable	—	13.2417	Completion percentage over expected
def_wp	decimalnullable	—	0.4537	Win probability for defense
defensive_extra_point_attempt	boolean	—	false	Defense extra point attempt
defensive_extra_point_conv	boolean	—	false	Defense extra point success
defensive_two_point_attempt	boolean	—	false	Defense two-point attempt
defensive_two_point_conv	boolean	—	false	Defense two-point conversion success
defteam	stringnullable	—	IND	Defensive team abbreviation
defteam_score	integernullable	—	0	Defense team score at start
defteam_score_post	integernullable	—	0	Defense team score at end
defteam_timeouts_remaining	integernullable	—	3	Defensive team timeouts
desc	stringnullable	—	GAME	Full play description text
div_game	boolean	—	false	Division game Values`falsetrue`
down	integernullable	—	1	Down (1-4)
drive	integernullable	—	6	Drive number in game
drive_end_transition	stringnullable	—	FIELD_GOAL	How drive ended Values`FIELD_GOALPUNTTOUCHDOWNDOWNSINTERCEPTIONEND_GAMEFUMBLEMISSED_FGEND_HALFBLOCKED_PUNTSAFETY`
drive_end_yard_line	stringnullable	—	50	Yard line at drive end
drive_ended_with_score	boolean	—	true	Drive resulted in score Values`truefalse`
drive_first_downs	integernullable	—	0	First downs gained in drive
drive_game_clock_end	stringnullable	—	00:00	Game clock at drive end
drive_game_clock_start	stringnullable	—	15:00	Game clock at drive start
drive_inside20	boolean	—	false	Drive reached red zone Values`falsetrue`
drive_play_count	integernullable	—	3	Number of plays in drive
drive_play_id_ended	stringnullable	—	4175	Last play_id of drive
drive_play_id_started	stringnullable	—	40	First play_id of drive
drive_quarter_end	integernullable	—	2	Quarter when drive ended
drive_quarter_start	integernullable	—	3	Quarter when drive started
drive_real_start_time	stringnullable	—	2024-09-07T03:15:55.057Z	Drive start time (real clock)
drive_start_transition	stringnullable	—	KICKOFF	How possession was obtained Values`KICKOFFPUNTINTERCEPTIONDOWNSFUMBLEMISSED_FGMUFFED_PUNTBLOCKED_PUNTMUFFED_KICKOFF`
drive_start_yard_line	stringnullable	—	PHI 30	Yard line at drive start
drive_time_of_possession	stringnullable	—	2:28	Drive time of possession (mm:ss)
drive_yds_penalized	integernullable	—	0	Penalty yards during drive
end_clock_time	stringnullable	—	2024-09-15T17:30:53.207Z	Game clock at play end
end_yard_line	stringnullable	—	—	Yard line at play end
ep	decimalnullable	—	0.9324	Expected points before play
epa	decimalnullable	—	0.0000	Expected points added
extra_point_attempt	boolean	—	false	Extra point attempt Values`falsetrue`
extra_point_prob	decimalnullable	—	0.0000	Extra point probability
extra_point_result	stringnullable	—	good	good, failed, blocked, safety, aborted Values`goodfailedblocked`
fantasy	stringnullable	—	B.Robinson	Fantasy designation
fantasy_player_name	stringnullable	—	B.Robinson	Fantasy designation player name
fg_prob	decimalnullable	—	0.0000	FG probability
field_goal_attempt	boolean	—	false	Field goal attempt Values`falsetrue`
field_goal_result	stringnullable	—	made	made, missed, or blocked Values`mademissed`
first_down	boolean	—	false	First down achieved Values`falsetrue`
first_down_pass	boolean	—	false	Passing first down Values`falsetrue`
first_down_penalty	boolean	—	false	First down via penalty Values`falsetrue`
first_down_rush	boolean	—	false	Rushing first down Values`falsetrue`
fixed_drive	integernullable	—	1	Manual drive number correction
fixed_drive_result	stringnullable	—	Field goal	Manual drive result correction Values`Field goalPuntTouchdownTurnoverTurnover on downsEnd of halfMissed field goalOpp touchdownSafety`
forced_fumble_player_1_player_name	stringnullable	—	M.Garrett	Forced fumble player 1 name
forced_fumble_player_1_team	stringnullable	—	KC	Forced fumble team 1
forced_fumble_player_2_player_name	stringnullable	—	—	Forced fumble player 2 name
forced_fumble_player_2_team	stringnullable	—	—	Forced fumble team 2
fourth_down_converted	boolean	—	false	Fourth down conversion Values`falsetrue`
fourth_down_failed	boolean	—	false	Fourth down failure Values`falsetrue`
fumble	boolean	—	false	Fumble occurred Values`falsetrue`
fumble_forced	boolean	—	false	Fumble was forced Values`falsetrue`
fumble_lost	boolean	—	false	Fumble was lost Values`falsetrue`
fumble_not_forced	boolean	—	false	Fumble was not forced Values`falsetrue`
fumble_out_of_bounds	boolean	—	false	Fumble went OOB Values`falsetrue`
fumble_recovery_1_player_name	stringnullable	—	J.Tolbert	Recovery player 1 name
fumble_recovery_1_team	stringnullable	—	CHI	Recovery team 1
fumble_recovery_1_yds	integernullable	—	0	Recovery yards 1
fumble_recovery_2_player_name	stringnullable	—	—	Recovery player 2 name
fumble_recovery_2_team	stringnullable	—	—	Recovery team 2
fumble_recovery_2_yds	integernullable	—	—	Recovery yards 2
fumbled_1_player_name	stringnullable	—	J.Burrow	First fumbler name
fumbled_1_team	stringnullable	—	CIN	First fumbler team
fumbled_2_player_name	stringnullable	—	—	Second fumbler name
fumbled_2_team	stringnullable	—	—	Second fumbler team
game_half	stringnullable	—	Half1	Half1, Half2, or Overtime Values`Half1Half2Overtime`
game_seconds_remaining	integer	—	1800	Seconds remaining in game
game_stadium	stringnullable	—	GEHA Field at Arrowhead Stadium	Game stadium name
goal_to_go	boolean	—	false	Goal-to-go situation Values`falsetrue`
half_sack_1_player_name	stringnullable	—	K.White	Half-sack player 1 name Values`K.WhiteT.SimpsonD.BucknerL.OnwuzurikeM.FoxM.JudonW.AndersonT.WhartonJ.PeevyO.OwehC.Granderson`
half_sack_2_player_name	stringnullable	—	J.Madubuike	Half-sack player 2 name Values`J.MadubuikeD.OdeyingboM.DavenportK.MackJ.BentleyG.JarrettD.HunterM.DannaDj.JohnsonM.PierceC.YoungD.Ekuale`
half_seconds_remaining	integer	—	1800	Seconds remaining in half
home_coach	stringnullable	—	Nick Sirianni	Home team head coach
home_opening_kickoff	boolean	—	true	Home team had opening kickoff Values`truefalse`
home_score	integernullable	—	26	Total home points
home_team	stringnullable	—	PHI	Home team abbreviation
home_timeouts_remaining	integernullable	—	3	Home timeouts remaining
home_wp	decimalnullable	—	0.9999	Home team win probability
home_wp_post	decimalnullable	—	0.9999	Home WP after play
incomplete_pass	boolean	—	false	Pass incomplete Values`falsetrue`
interception	boolean	—	false	Interception indicator Values`falsetrue`
interception_player_name	stringnullable	—	X.McKinney	Interceptor name
jersey_number	integernullable	—	8	Primary player jersey
kick_distance	integernullable	—	65	Kick distance in yards
kicker_player_name	stringnullable	—	B.Grupe	Kicker name
kickoff_attempt	boolean	—	false	Kickoff attempt Values`falsetrue`
kickoff_downed	boolean	—	false	Kickoff downed
kickoff_fair_catch	boolean	—	false	Kickoff fair catch Values`falsetrue`
kickoff_in_endzone	boolean	—	false	Kickoff in endzone Values`falsetrue`
kickoff_inside_twenty	boolean	—	false	Kickoff inside 20 Values`falsetrue`
kickoff_out_of_bounds	boolean	—	false	Kickoff OOB Values`falsetrue`
kickoff_returner_player_name	stringnullable	—	R.Blackshear	Kickoff returner name
lateral_interception_player_name	stringnullable	—	—	Lateral after INT name
lateral_kickoff_returner_player_name	stringnullable	—	—	Lateral kickoff returner name
lateral_punt_returner_player_name	stringnullable	—	—	Lateral punt returner name
lateral_receiver_player_name	stringnullable	—	M.Mims	Lateral receiver name (pass)
lateral_receiving_yds	integernullable	—	2	Yards after lateral (pass)
lateral_reception	boolean	—	false	Lateral on pass play Values`falsetrue`
lateral_return	boolean	—	false	Lateral on return
lateral_rush	boolean	—	false	Lateral on rush play Values`falsetrue`
lateral_rusher_player_name	stringnullable	—	J.Hill	Lateral receiver name (rush)
lateral_rushing_yds	integernullable	—	5	Yards after lateral (rush)
lateral_sack_player_name	stringnullable	—	—	Lateral after sack name
location	stringnullable	—	Home	Home or Neutral Values`HomeNeutral`
name	stringnullable	—	L.Jackson	Primary player name (passer or rusher)
no_huddle	boolean	—	false	No-huddle offense Values`falsetrue`
no_score_prob	decimalnullable	—	0.0000	Probability of no score
opp_fg_prob	decimalnullable	—	0.0000	Opponent FG probability
opp_safety_prob	decimalnullable	—	0.0000	Opponent safety probability
opp_td_prob	decimalnullable	—	0.0000	Opponent TD probability
order_sequence	decimalnullable	—	1.0000	NFL play-ordering column
out_of_bounds	boolean	—	false	Ran/pushed/sacked out of bounds Values`falsetrue`
own_kickoff_recovery	boolean	—	false	Own kickoff recovery
own_kickoff_recovery_player_name	stringnullable	—	—	Own kickoff recovery player name
own_kickoff_recovery_td	boolean	—	false	Own kickoff recovery TD
pass	boolean	—	false	Pass play indicator Values`falsetrue`
pass_attempt	boolean	—	false	Pass attempt (includes sacks) Values`falsetrue`
pass_defense_1_player_name	stringnullable	—	D.Ward	Pass defense player 1 name
pass_defense_2_player_name	stringnullable	—	E.Kendricks	Pass defense player 2 name Values`E.KendricksJ.PitreP.FordD.MuasauD.Flannigan-FowlesM.EmersonR.Spillane`
pass_length	stringnullable	—	short	short or deep Values`shortdeep`
pass_location	stringnullable	—	right	left, middle, or right Values`rightleftmiddle`
pass_oe	decimalnullable	—	37.7849	Dropback percent over expected
pass_touchdown	boolean	—	false	Passing touchdown Values`falsetrue`
passer	stringnullable	—	D.Watson	Dropback player name (includes scrambles)
passer_jersey_number	integernullable	—	8	Passer jersey number
passer_player_name	stringnullable	—	D.Watson	Passer name
passing_yds	integernullable	—	5	Official passing yards
penalty	boolean	—	false	Penalty on play Values`falsetrue`
penalty_player_name	stringnullable	—	P.Surtain	Penalized player name
penalty_team	stringnullable	—	CLE	Penalized team
penalty_type	stringnullable	—	Offensive Holding	Type of penalty
penalty_yds	integernullable	—	5	Penalty yards
play	boolean	—	true	Regular play (1) vs special event (0) Values`truefalse`
play_clock	integernullable	—	0	Play clock at snap
play_deleted	boolean	—	false	Play was deleted
play_type	stringnullable	—	pass	pass, run, punt, field_goal, kickoff, extra_point, qb_kneel, qb_spike, no_play Values`passrunno_playkickoffpuntfield_goalextra_pointqb_kneelqb_spike`
play_type_nfl	stringnullable	—	PASS	NFL source play type Values`PASSRUSHKICK_OFFPENALTYTIMEOUTPUNTSACKFIELD_GOALXP_KICKEND_QUARTERINTERCEPTIONGAME_STARTEND_GAMEPAT2UNSPECIFIED`
posteam	stringnullable	—	CLE	Possession team abbreviation
posteam_score	integernullable	—	0	Possession team score at start
posteam_score_post	integernullable	—	0	Possession team score at end
posteam_timeouts_remaining	integernullable	—	3	Possession team timeouts
posteam_type	stringnullable	—	home	home or away Values`homeaway`
punt_attempt	boolean	—	false	Punt attempt Values`falsetrue`
punt_blocked	boolean	—	false	Punt blocked Values`falsetrue`
punt_downed	boolean	—	false	Punt downed Values`falsetrue`
punt_fair_catch	boolean	—	false	Punt fair catch Values`falsetrue`
punt_in_endzone	boolean	—	false	Punt in endzone
punt_inside_twenty	boolean	—	false	Punt inside 20 Values`falsetrue`
punt_out_of_bounds	boolean	—	false	Punt OOB Values`falsetrue`
punt_returner_player_name	stringnullable	—	J.Jackson	Punt returner name
punter_player_name	stringnullable	—	R.Dixon	Punter name
qb_dropback	boolean	—	false	QB dropback (pass or scramble) Values`falsetrue`
qb_epa	decimalnullable	—	0.0000	QB EPA credit
qb_hit	boolean	—	false	QB was hit Values`falsetrue`
qb_hit_1_player_name	stringnullable	—	K.White	QB hitter name
qb_hit_2_player_name	stringnullable	—	J.Madubuike	Second QB hitter name Values`J.MadubuikeD.OdeyingboM.DavenportK.MackJ.BentleyG.JarrettD.HunterM.PierceC.YoungD.Ekuale`
qb_kneel	boolean	—	false	QB kneel Values`falsetrue`
qb_scramble	boolean	—	false	QB scramble Values`falsetrue`
qb_spike	boolean	—	false	QB spike Values`falsetrue`
quarter	integer	—	2	Quarter (1-4, 5=OT)
quarter_end	boolean	—	false	Binary quarter-end marker Values`falsetrue`
quarter_seconds_remaining	integer	—	900	Seconds remaining in quarter
receiver	stringnullable	—	C.Kupp	Targeted receiver name
receiver_jersey_number	integernullable	—	1	Receiver jersey number
receiver_player_name	stringnullable	—	C.Kupp	Receiver name
receiving_yds	integernullable	—	5	Official receiving yards
replay_or_challenge	boolean	—	false	Replay/challenge occurred Values`falsetrue`
replay_or_challenge_result	stringnullable	—	reversed	Replay result Values`reversedupheld`
result	integernullable	—	6	Home score - Away score
return_team	stringnullable	—	DEN	Returning team
return_touchdown	boolean	—	false	Return touchdown Values`falsetrue`
return_yds	integernullable	—	0	Return yards
roof	stringnullable	—	outdoors	dome, outdoors, closed, open Values`outdoorscloseddome`
run_gap	stringnullable	—	end	end, guard, or tackle Values`endguardtackle`
run_location	stringnullable	—	left	left, middle, or right Values`leftrightmiddle`
rush	boolean	—	false	Rush play (no scrambles) Values`falsetrue`
rush_attempt	boolean	—	false	Rushing play indicator Values`falsetrue`
rush_touchdown	boolean	—	false	Rushing touchdown Values`falsetrue`
rusher_jersey_number	integernullable	—	4	Rusher jersey number
rusher_player_name	stringnullable	—	B.Robinson	Rusher name
rushing_yds	integernullable	—	2	Official rushing yards
sack	boolean	—	false	Sack indicator Values`falsetrue`
sack_player_name	stringnullable	—	G.Rousseau	Sacker name
safety	boolean	—	false	Safety scored Values`falsetrue`
safety_player_name	stringnullable	—	Z.Allen	Safety scorer name Values`Z.AllenA.Wright`
safety_prob	decimalnullable	—	0.0000	Safety probability
score_differential	integernullable	—	0	Score gap at play start
score_differential_post	integernullable	—	0	Score gap at play end
series	integernullable	—	1	Series counter within game
series_result	stringnullable	—	First down	First down, Touchdown, Punt, etc. Values`First downPuntField goalTouchdownTurnover on downsTurnoverQB kneelEnd of halfMissed field goalOpp touchdownSafety`
series_success	boolean	—	true	Series resulted in first down or TD Values`truefalse`
shotgun	boolean	—	true	Shotgun formation Values`truefalse`
side_of_field	stringnullable	—	CAR	Team abbreviation whose side of field
solo_tackle	boolean	—	false	Solo tackle on play Values`falsetrue`
solo_tackle_1_player_name	stringnullable	—	J.Jones	Solo tackler 1 name
solo_tackle_1_team	stringnullable	—	ATL	Solo tackler 1 team
solo_tackle_2_player_name	stringnullable	—	B.Limmer	Solo tackler 2 name Values`B.LimmerT.Spears`
solo_tackle_2_team	stringnullable	—	LA	Solo tackler 2 team Values`LATEN`
sp	boolean	—	false	Scoring play indicator Values`falsetrue`
special	boolean	—	false	Special teams indicator Values`falsetrue`
special_teams_play	boolean	—	false	Special teams play indicator Values`falsetrue`
spread_line	decimalnullable	—	6.5000	Vegas spread line
st_play_type	stringnullable	—	—	Type of special teams play
stadium	stringnullable	—	GEHA Field at Arrowhead Stadium	Stadium name
start_time	stringnullable	—	9/8/24, 13:03:08	Kickoff time (eastern)
success	booleannullable	—	false	Play success (based on down/distance) Values`falsetrue`
surface	stringnullable	—	grass	Playing surface type Values`grassfieldturfmatrixturfastroturfsportturfa_turf`
tackle_for_loss_1_player_name	stringnullable	—	M.Crosby	TFL player 1 name
tackle_for_loss_2_player_name	stringnullable	—	—	TFL player 2 name
tackle_with_assist	boolean	—	false	Tackle with assistance Values`falsetrue`
tackle_with_assist_1_player_name	stringnullable	—	A.Singleton	Tackle-assist player 1 name
tackle_with_assist_1_team	stringnullable	—	IND	Tackle-assist player 1 team
tackle_with_assist_2_player_name	stringnullable	—	—	Tackle-assist player 2 name
tackle_with_assist_2_team	stringnullable	—	—	Tackle-assist player 2 team
tackled_for_loss	boolean	—	false	Tackle for loss Values`falsetrue`
td_player_name	stringnullable	—	A.Kamara	TD scorer name
td_prob	decimalnullable	—	0.0000	TD probability
td_team	stringnullable	—	NO	Team scoring TD
temp	integernullable	—	67	Temperature
third_down_converted	boolean	—	false	Third down conversion Values`falsetrue`
third_down_failed	boolean	—	false	Third down failure Values`falsetrue`
time	stringnullable	—	15:00	Game clock at play start (mm:ss)
time_of_day	stringnullable	—	2024-09-08T19:40:41Z	Play time in UTC
timeout	boolean	—	false	Timeout called Values`falsetrue`
timeout_team	stringnullable	—	BAL	Team calling timeout
total	integernullable	—	41	Home score + Away score
total_away_comp_air_epa	decimalnullable	—	0.0000	Cumulative away completion air EPA
total_away_comp_air_wpa	decimalnullable	—	0.0000	Cumulative away completion air WPA
total_away_comp_yac_epa	decimalnullable	—	0.0000	Cumulative away completion YAC EPA
total_away_comp_yac_wpa	decimalnullable	—	0.0000	Cumulative away completion YAC WPA
total_away_epa	decimalnullable	—	0.0000	Cumulative away EPA
total_away_pass_epa	decimalnullable	—	0.0000	Cumulative away passing EPA
total_away_pass_wpa	decimalnullable	—	0.0000	Cumulative away passing WPA
total_away_raw_air_epa	decimalnullable	—	0.0000	Cumulative away raw air EPA
total_away_raw_air_wpa	decimalnullable	—	0.0000	Cumulative away raw air WPA
total_away_raw_yac_epa	decimalnullable	—	0.0000	Cumulative away raw YAC EPA
total_away_raw_yac_wpa	decimalnullable	—	0.0000	Cumulative away raw YAC WPA
total_away_rush_epa	decimalnullable	—	0.0000	Cumulative away rushing EPA
total_away_rush_wpa	decimalnullable	—	0.0000	Cumulative away rushing WPA
total_away_score	integernullable	—	0	Away score at play start
total_home_comp_air_epa	decimalnullable	—	0.0000	Cumulative home completion air EPA
total_home_comp_air_wpa	decimalnullable	—	0.0000	Cumulative home completion air WPA
total_home_comp_yac_epa	decimalnullable	—	0.0000	Cumulative home completion YAC EPA
total_home_comp_yac_wpa	decimalnullable	—	0.0000	Cumulative home completion YAC WPA
total_home_epa	decimalnullable	—	0.0000	Cumulative home EPA
total_home_pass_epa	decimalnullable	—	0.0000	Cumulative home passing EPA
total_home_pass_wpa	decimalnullable	—	0.0000	Cumulative home passing WPA
total_home_raw_air_epa	decimalnullable	—	0.0000	Cumulative home raw air EPA
total_home_raw_air_wpa	decimalnullable	—	0.0000	Cumulative home raw air WPA
total_home_raw_yac_epa	decimalnullable	—	0.0000	Cumulative home raw YAC EPA
total_home_raw_yac_wpa	decimalnullable	—	0.0000	Cumulative home raw YAC WPA
total_home_rush_epa	decimalnullable	—	0.0000	Cumulative home rushing EPA
total_home_rush_wpa	decimalnullable	—	0.0000	Cumulative home rushing WPA
total_home_score	integernullable	—	0	Home score at play start
total_line	decimalnullable	—	41.5000	Vegas total line
touchback	boolean	—	false	Touchback Values`falsetrue`
touchdown	boolean	—	false	Touchdown scored Values`falsetrue`
two_point_attempt	boolean	—	false	Two-point conversion attempt Values`falsetrue`
two_point_conv_result	stringnullable	—	failure	success, failure, safety, return Values`failuresuccess`
two_point_conversion_prob	decimalnullable	—	0.0000	Two-point conversion probability
vegas_home_wp	decimalnullable	—	1.0000	Vegas home win probability
vegas_home_wpa	decimalnullable	—	0.0000	Vegas home WPA
vegas_wp	decimalnullable	—	0.9999	Vegas win probability
vegas_wpa	decimalnullable	—	0.0000	Vegas-adjusted WPA
weather	stringnullable	—	Temp: 63° F, Humidity: 87%, Wind: SE 4 mph	Weather conditions description
wind	integernullable	—	10	Wind speed (mph)
wp	decimalnullable	—	0.5463	Win probability for possession team
wpa	decimalnullable	—	0.0000	Win probability added
xpass	decimalnullable	—	0.9759	Dropback probability
xyac_epa	decimalnullable	—	0.2981	Expected EPA after catch
xyac_fd	decimalnullable	—	1.0000	First down probability (xYAC)
xyac_mean_yardage	decimalnullable	—	3.9685	Average expected YAC
xyac_median_yardage	decimalnullable	—	2.0000	Median expected YAC
xyac_success	decimalnullable	—	1.0000	Positive EPA probability
yac_epa	decimalnullable	—	0.0000	EPA from yards after catch
yac_wpa	decimalnullable	—	0.0000	WPA from yards after catch
yard_line	integernullable	—	—	Yard line number (0-50)
yardline_100	integernullable	—	35	Yards from opponent endzone (0-100)
yds_after_catch	integernullable	—	0	YAC yards
yds_gained	integernullable	—	0	Yards gained on play
ydsnet	integernullable	—	70	Total net yards on drive
ydstogo	integernullable	—	10	Yards to first down/goal
yrdln	stringnullable	—	MID 50	Yard line string (e.g., "KC 25")

Stats

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
season_id	bigint	→ nfl.seasons	2025	—
team_id	bigint	→ nfl.teams	1	—
completions	integer	—	0	—
defensive_interceptions	integer	—	11	—
defensive_sacks	decimal	—	49.0000	Sacks recorded by this team's defense (half-sacks supported as decimals).
defensive_tds	integer	—	0	Touchdowns scored by the defense (interception return + fumble recovery TD); excludes special-teams returns.
extra_pts_attempted	integer	—	35	—
extra_pts_made	integer	—	33	—
field_goals_attempted	integer	—	30	—
field_goals_made	integer	—	30	—
first_downs	integer	—	301	—
fourth_down_attempts	integer	—	21	Total fourth-down plays attempted (excludes punts and field-goal attempts).
fourth_down_conversions	integer	—	13	Fourth-down attempts converted to a first down or touchdown.
fumbles_recovered	integer	—	9	—
games_played	integer	—	17	—
losses	integer	—	8	—
pass_attempts	integer	—	0	—
passing_tds	integer	—	0	—
passing_yds	integer	—	3703	—
pts_allowed	integer	—	407	—
pts_scored	integer	—	364	—
red_zone_attempts	integer	—	0	Possessions reaching the red zone (inside the opponent's 20-yard line).
red_zone_conversions	integer	—	0	Red-zone trips that ended in a touchdown.
rushing_tds	integer	—	0	—
rushing_yds	integer	—	2662	—
third_down_attempts	integer	—	224	Total third-down plays attempted.
third_down_conversions	integer	—	82	Third-down attempts converted to a first down or touchdown.
ties	integer	—	0	—
total_yds	integer	—	6299	—
turnovers	integer	—	24	Possessions lost via interception or fumble.
wins	integer	—	8	—

nfl.game_player_stats141 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	90	—
opponent_team_id	bigint	→ nfl.teams	15	—
player_id	bigint	→ nfl.players	298	—
team_id	bigint	→ nfl.teams	10	—
air_yds_share	decimal	—	0.0000	Percentage of team air yards
assisted_tackles	integernullable	—	1	Assisted tackles
blocked_kick_return_tds	integernullable	—	0	Blocked kick return touchdowns
blocked_kick_return_yds	integernullable	—	0	Blocked kick return yards
blocked_kicks	integernullable	—	0	Blocked kicks (FG, XP, punts)
completions	integer	—	0	—
dakota	decimalnullable	—	0.1798	DAKOTA: adjusted completion % + EPA metric
defensive_interceptions	integernullable	—	0	Defensive interceptions
defensive_sack_yds	integernullable	—	0	Yards lost on defensive sacks
defensive_sacks	decimalnullable	—	0.0000	Defensive sacks (can be half sacks)
defensive_snaps	integernullable	—	0	Defensive snaps played
defensive_tds	integernullable	—	0	Total defensive touchdowns (INT + fumble return TDs)
defensive_team_snaps	integernullable	—	1	Total team defensive snaps (for calculating snap %)
depth_order	integernullable	—	1	Depth order within position (1=starter, 2=backup, etc.) - joined from depth charts
depth_position	stringnullable	—	WR	Depth chart position (QB1, RB2, etc.) - joined from depth charts
extra_pts_attempted	integernullable	—	0	Extra points attempted
extra_pts_had_blocked	integernullable	—	0	Extra points blocked by opponent
extra_pts_made	integernullable	—	0	Extra points made
fantasy_pts	decimal	—	0.0000	Standard fantasy points (nflverse calculation)
fantasy_pts_ppr	decimal	—	0.0000	PPR fantasy points (nflverse calculation)
field_goal_percentage	decimalnullable	—	—	Field goal percentage
field_goal_return_tds	integernullable	—	—	Field goal return touchdowns
field_goal_return_yds	integernullable	—	—	Field goal return yards (missed FG returns)
field_goals_attempted	integernullable	—	0	Field goals attempted
field_goals_had_blocked	integernullable	—	0	Field goals blocked by opponent
field_goals_longest	integernullable	—	—	Longest field goal made (yards)
field_goals_made	integernullable	—	0	Field goals made
field_goals_made_0_19	integernullable	—	0	Field goals made 0-19 yards
field_goals_made_20_29	integernullable	—	0	Field goals made 20-29 yards
field_goals_made_30_39	integernullable	—	0	Field goals made 30-39 yards
field_goals_made_40_49	integernullable	—	0	Field goals made 40-49 yards
field_goals_made_50_plus	integernullable	—	0	Field goals made 50+ yards
forced_fumbles	integernullable	—	1	Forced fumbles
fumble_return_tds	integernullable	—	0	Fumble return touchdowns
fumble_return_yds	integernullable	—	0	Fumble return yards
fumbles_out_of_bounds	integernullable	—	1	Fumbles out of bounds
fumbles_own_recoveries	integernullable	—	1	Own fumbles recovered
fumbles_recovered	integernullable	—	1	Fumbles recovered
humidity	integernullable	—	—	Humidity percentage
interception_return_tds	integernullable	—	0	Interception return touchdowns
interception_return_yds	integernullable	—	0	Interception return yards
interceptions_thrown	integer	—	0	—
is_home	boolean	—	false	True if player's team is the home team Values`falsetrue`
kick_return_avg	floatnullable	—	260	Kick return average (yards per return)
kick_return_fair_catches	integernullable	—	0	Fair catches on kick returns
kick_return_fumbles	integernullable	—	0	Fumbles on kick returns
kick_return_fumbles_lost	integernullable	—	0	Fumbles lost on kick returns
kick_return_long	integernullable	—	31	Longest kick return (yards)
kick_return_tds	integernullable	—	0	Kick return touchdowns
kick_return_yds	integernullable	—	0	Total kick return yards
kick_returns	integernullable	—	1	Number of kick returns
misc_assisted_tackles	integernullable	—	—	Miscellaneous assisted tackles
misc_fumbles_forced	integernullable	—	—	Miscellaneous fumbles forced
misc_fumbles_recovered	integernullable	—	—	Miscellaneous fumbles recovered
misc_solo_tackles	integernullable	—	—	Miscellaneous solo tackles
offensive_snaps	integernullable	—	14	Offensive snaps played
offensive_team_snaps	integernullable	—	64	Total team offensive snaps (for calculating snap %)
pacr	decimalnullable	—	2.0000	Passer air conversion ratio
pass_attempts	integer	—	0	—
passes_defended	integernullable	—	1	Passes defended
passing_2pt_conversions	integer	—	0	—
passing_air_yds	integer	—	0	—
passing_completion_percentage	decimalnullable	—	10.0000	Completion percentage
passing_epa	decimal	—	0.0000	Expected points added from passing
passing_first_downs	integer	—	0	—
passing_long	integernullable	—	25	Longest pass completion (yards)
passing_rating	decimalnullable	—	39.5833	Passer rating
passing_tds	integer	—	0	—
passing_yds	integer	—	0	—
passing_yds_after_catch	integer	—	0	—
playing_surface	stringnullable	—	—	Playing surface type (grass, turf, etc.)
position	string	—	DEF	Player position at time of game Values`DEFWRTEDBRBOL`
position_group	string	—	DEF	Position group (QB, RB, WR, TE, etc.) Values`DEFWRTERBOLSPEC`
punt_average	decimalnullable	—	510.0000	Punt average (yards)
punt_inside_20	integernullable	—	1	Punts inside 20 yard line
punt_long	integernullable	—	60	Longest punt (yards)
punt_net_average	floatnullable	—	—	Net punt average (gross - return yards)
punt_net_yds	integernullable	—	—	Net punt yards (gross - return yards)
punt_return_avg	floatnullable	—	100	Punt return average (yards per return)
punt_return_fair_catches	integernullable	—	0	Fair catches on punt returns
punt_return_fumbles	integernullable	—	0	Fumbles on punt returns (includes muffs)
punt_return_fumbles_lost	integernullable	—	0	Fumbles lost on punt returns
punt_return_long	integernullable	—	8	Longest punt return (yards)
punt_return_tds	integernullable	—	0	Punt return touchdowns
punt_return_yds	integernullable	—	0	Total punt return yards
punt_returns	integernullable	—	1	Number of punt returns
punt_touchbacks	integernullable	—	0	Punt touchbacks
punt_yds	integernullable	—	0	Total punt yards
punts	integernullable	—	2	Number of punts
punts_had_blocked	integernullable	—	0	Punts blocked by opponent
quarterback_hits	integernullable	—	0	Quarterback hits
racr	decimalnullable	—	0.0000	Receiver air conversion ratio
receiving_2pt_conversions	integer	—	0	—
receiving_air_yds	integer	—	0	—
receiving_epa	decimal	—	0.0000	Expected points added from receiving
receiving_first_downs	integer	—	0	—
receiving_fumbles	integer	—	0	—
receiving_fumbles_lost	integer	—	0	—
receiving_long	integernullable	—	9	Longest reception (yards)
receiving_tds	integer	—	0	—
receiving_yds	integer	—	0	—
receiving_yds_after_catch	integer	—	0	—
receiving_yds_per_reception	decimalnullable	—	50.0000	Yards per reception
reception_percentage	decimalnullable	—	10.0000	Reception percentage (receptions/targets)
receptions	integer	—	0	—
rushing_2pt_conversions	integer	—	0	—
rushing_attempts	integer	—	0	—
rushing_epa	decimal	—	0.0000	Expected points added from rushing
rushing_first_downs	integer	—	0	—
rushing_fumbles	integer	—	0	—
rushing_fumbles_lost	integer	—	0	—
rushing_long	integernullable	—	9	Longest rush (yards)
rushing_tds	integer	—	0	—
rushing_yds	integer	—	0	—
rushing_yds_per_attempt	decimalnullable	—	20.0000	Rushing yards per attempt
sack_fumbles	integer	—	0	—
sack_fumbles_lost	integer	—	0	—
sack_yds	integer	—	0	—
sacks_allowed	integer	—	0	—
safeties	integernullable	—	0	Safeties
solo_tackles	integernullable	—	1	Solo tackles
special_teams_assisted_tackles	integernullable	—	1	Assisted tackles on special teams
special_teams_fumbles_forced	integernullable	—	0	Fumbles forced on special teams
special_teams_fumbles_recovered	integernullable	—	0	Fumbles recovered on special teams
special_teams_snaps	integernullable	—	0	Special teams snaps played
special_teams_solo_tackles	integernullable	—	1	Solo tackles on special teams
special_teams_tds	integer	—	0	—
special_teams_team_snaps	integernullable	—	13	Total team special teams snaps (for calculating snap %)
stadium	stringnullable	—	—	Stadium name
tackles_for_loss	integernullable	—	0	Tackles for loss
target_share	decimal	—	0.0000	Percentage of team targets
targets	integer	—	0	—
temperature	integernullable	—	—	Game temperature (Fahrenheit)
two_pt_returns	integernullable	—	—	Two-point conversion returns (defensive)
wind_speed	integernullable	—	—	Wind speed (mph)
wopr	decimalnullable	—	0.0000	Weighted opportunity rating

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	4718	—
team_id	bigint	→ nfl.teams	16	—
blocked_extra_pts	integer	—	0	—
blocked_field_goals	integer	—	0	—
blocked_kick_return_tds	integer	—	0	Blocked kick return touchdowns
blocked_kick_return_yds	integer	—	0	Blocked kick return yards
blocked_kicks	integer	—	0	Total blocked kicks (FGs + XPs + punts) for DST fantasy scoring
blocked_punts	integer	—	0	—
completion_percentage	decimal	—	66.6667	—
completions	integer	—	22	—
defensive_interceptions	integer	—	0	—
defensive_sacks	integer	—	2	—
defensive_tds	integer	—	0	—
defensive_team_snaps	integer	—	715	Total defensive snaps by team in game
extra_pt_percentage	decimal	—	100.0000	Extra point conversion percentage
extra_pts_attempted	integer	—	2	—
extra_pts_blocked	integer	—	0	Extra points that were blocked
extra_pts_made	integer	—	2	—
field_goal_percentage	decimal	—	100.0000	—
field_goal_return_tds	integer	—	0	Field goal return touchdowns
field_goal_return_yds	integer	—	0	Field goal return yards (missed FGs)
field_goals_attempted	integer	—	2	—
field_goals_blocked	integer	—	0	Field goals that were blocked
field_goals_made	integer	—	1	—
first_downs	integer	—	22	—
first_downs_passing	integer	—	11	—
first_downs_penalty	integer	—	1	—
first_downs_rushing	integer	—	5	—
forced_fumbles	integer	—	0	—
fourth_down_attempts	integer	—	1	—
fourth_down_conversions	integer	—	0	—
fourth_down_percentage	decimal	—	0.0000	—
fumble_return_tds	integer	—	0	Fumble return touchdowns
fumble_return_yds	integer	—	0	Fumble return yards
fumbles_lost	integer	—	0	—
fumbles_recovered	integer	—	0	—
interception_percentage	decimal	—	0.0000	Percentage of passes intercepted
interception_return_tds	integer	—	0	Interception return touchdowns
interception_return_yds	integer	—	0	Interception return yards
interception_returns	integer	—	0	Number of interception returns
interceptions_thrown	integer	—	0	—
is_home	boolean	—	true	True if team is the home team Values`truefalse`
kick_return_avg	decimal	—	0.0000	Average yards per kick return
kick_return_long	integer	—	0	Longest kick return
kick_return_tds	integer	—	0	—
kick_return_yds	integer	—	0	—
kick_return_yds_differential	integer	—	0	Kick return yards minus opponent kick return yards
kick_returns	integer	—	0	Number of kick returns
kickoff_touchbacks	integer	—	0	Kickoffs resulting in touchbacks
kickoffs	integer	—	0	Number of kickoffs
kickoffs_in_endzone	integer	—	0	Kickoffs that reached the end zone
loss	integer	—	0	—
offensive_plays	integer	—	64	Total offensive plays run
offensive_team_snaps	integer	—	748	Total offensive snaps by team in game
offensive_yds	integer	—	367	Total offensive yards gained
pass_attempts	integer	—	30	—
passer_rating	decimal	—	97.9167	—
passes_defended	integer	—	3	—
passing_dropbacks	integer	—	30	Number of passing dropbacks
passing_tds	integer	—	1	—
passing_yds	integer	—	215	—
penalties	integer	—	5	—
penalty_yds	integer	—	30	—
penalty_yds_differential	integer	—	0	Opponent penalty yards minus own penalty yards
point_differential	integer	—	3	Points scored minus points allowed
pts	integer	—	20	—
pts_allowed_def	integer	—	20	Points allowed for DEF scoring (FanDuel). Excludes return TDs against - only offensive points allowed.
pts_allowed_dst	integer	—	20	Points allowed for DST scoring (DraftKings/Yahoo). Includes return TDs against - real scoreboard points.
punt_average	decimal	—	45.0000	—
punt_net_average	decimal	—	45.0000	Net punt average yards
punt_net_yds	integer	—	0	Total net punt yards
punt_return_avg	decimal	—	0.0000	Average yards per punt return
punt_return_long	integer	—	0	Longest punt return
punt_return_tds	integer	—	0	—
punt_return_yds	integer	—	0	—
punt_return_yds_differential	integer	—	0	Punt return yards minus opponent punt return yards
punt_returns	integer	—	0	Number of punt returns
punt_yds	integer	—	0	—
punts	integer	—	4	—
punts_blocked	integer	—	0	Number of punts blocked
qb_hits_differential	integer	—	0	QB hits made minus QB hits allowed
qb_hits_percentage	decimal	—	0.0000	Percentage of dropbacks resulting in QB hit
quarterback_hits	integer	—	5	—
receiving_tds	integer	—	1	—
receiving_yds	integer	—	215	—
receptions	integer	—	22	—
red_zone_attempts	integer	—	4	—
red_zone_conversions	integer	—	3	—
red_zone_percentage	decimal	—	100.0000	—
rushing_attempts	integer	—	25	—
rushing_tds	integer	—	0	—
rushing_yds	integer	—	96	—
rushing_yds_per_attempt	decimal	—	4.0000	Rushing yards per attempt
sack_yds	integer	—	0	—
sacked_percentage	decimal	—	0.0000	Percentage of dropbacks resulting in sack
sacks_allowed	integer	—	2	—
sacks_differential	integer	—	0	Sacks made minus sacks allowed
safeties	integer	—	0	—
score_ot	integer	—	0	Points scored in overtime
score_q1	integer	—	0	Points scored in Q1
score_q2	integer	—	0	Points scored in Q2
score_q3	integer	—	0	Points scored in Q3
score_q4	integer	—	0	Points scored in Q4
special_teams_team_snaps	integer	—	275	Total special teams snaps by team in game
tackles	integer	—	51	—
tackles_for_loss	integer	—	2	—
tfl_differential	integer	—	0	Tackles for loss made minus allowed
tfl_percentage	decimal	—	0.0000	Percentage of plays resulting in TFL
third_down_attempts	integer	—	13	—
third_down_conversions	integer	—	5	—
third_down_percentage	decimal	—	50.0000	—
tie	integer	—	0	—
time_of_possession	integer	—	1696	—
total_return_yds	integer	—	0	Total punt and kick return yards
total_yds	integer	—	367	—
touchdowns	integer	—	2	Total touchdowns scored
turnover_differential	integer	—	0	—
turnovers	integer	—	1	—
two_point_conversion_attempts	integer	—	0	—
two_point_conversions	integer	—	0	—
two_pt_conversion_returns	integer	—	0	Defensive two-point conversion returns
two_pt_pass_attempts	integer	—	0	Two-point conversion pass attempts
two_pt_pass_conversions	integer	—	0	Two-point conversion pass conversions
two_pt_rush_attempts	integer	—	0	Two-point conversion rush attempts
two_pt_rush_conversions	integer	—	0	Two-point conversion rush conversions
win	integer	—	0	—
yds_per_carry	decimal	—	4.0000	—
yds_per_completion	decimal	—	11.0000	Passing yards per completion
yds_per_pass_attempt	decimal	—	6.0000	—
yds_per_play	decimal	—	5.0000	Average yards per offensive play

nfl.projected_player_snaps35 fields· 4 refsendpoints →

Pre-kickoff projected and post-game realized offensive snaps, snap shares, touch rates, and volume opportunities for NFL players.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	56	—
player_id	bigint	→ nfl.players	1505	—
season_id	bigint	→ nfl.seasons	2024	—
team_id	bigint	→ nfl.teams	3	—
actual_pass_attempts	integernullable	—	0	Realized post-game actual pass attempts.
actual_pass_completions	integernullable	—	0	Realized post-game actual pass completions.
actual_receptions	integernullable	—	0	Realized post-game actual pass receptions.
actual_rush_attempts	integernullable	—	0	Realized post-game actual rushing attempts.
actual_snap_share	decimalnullable	—	0.0000	Realized post-game actual snap share percentage.
actual_snaps	integernullable	—	0	Realized post-game actual offensive snaps played.
actual_targets	integernullable	—	0	Realized post-game actual receiving targets.
actual_team_snaps	integernullable	—	56	Realized post-game actual total team offensive snaps.
as_of	timestamptz	—	2026-09-19T21:45:25.265Z	Point in time the projection reflects (UTC). Set when the projection is published; a backfilled row is never later than its write time.
depth_order	integernullable	—	1	Official pre-game depth chart order (1 = starter, 2 = primary backup).
is_inactive	boolean	—	false	True if player was declared inactive prior to kickoff. Values`falsetrue`
is_starter	boolean	—	true	True if player is designated as the starter at kickoff. Values`truefalse`
position	string	—	WR	Player position for this matchup (QB, RB, WR, TE, FB, DST). Values`WRRBTEQBDSTFB`
projected_pass_attempts	decimalnullable	—	0.00	Pre-kickoff projected pass attempts (QB only).
projected_pass_completions	decimalnullable	—	0.00	Pre-kickoff projected pass completions (QB only).
projected_receptions	decimalnullable	—	0.00	Pre-kickoff projected pass receptions.
projected_rush_attempts	decimalnullable	—	0.00	Pre-kickoff projected rushing attempts.
projected_rush_share	decimalnullable	—	0.0101	Pre-kickoff projected percentage of team rushing attempts.
projected_snap_share	decimal	—	0.0000	Pre-kickoff projected percentage of team offensive snaps (0.0000 - 1.0000).
projected_snaps	decimal	—	0.00	Pre-kickoff projected offensive snaps.
projected_target_share	decimalnullable	—	0.1200	Pre-kickoff projected percentage of team targets.
projected_targets	decimalnullable	—	0.00	Pre-kickoff projected receiving targets.
projected_team_snaps	decimal	—	62.00	Pre-kickoff projected total offensive snaps for the player's team.
rush_attempts_error	decimalnullable	—	0.00	Calibration error: actual_rush_attempts minus projected_rush_attempts.
snap_error	decimalnullable	—	0.00	Calibration error: actual_snaps minus projected_snaps.
snap_share_error	decimalnullable	—	0.0000	Calibration error: actual_snap_share minus projected_snap_share.
source	string	—	STAT_API_SOTA	SOTA model source version (e.g. STAT_API_SOTA).
targets_error	decimalnullable	—	0.00	Calibration error: actual_targets minus projected_targets.
touch_rate_per_snap	decimalnullable	—	0.2800	Pre-kickoff projected touches (rushes + receptions) per offensive snap.
week	integer	—	1	NFL regular season week number.

nfl.projected_team_snaps33 fields· 4 refsendpoints →

Pre-kickoff projected and post-game realized pace, offensive plays, pass/run playcalling mix, and personnel rates for NFL teams.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	141	—
opponent_team_id	bigint	→ nfl.teams	10	—
season_id	bigint	→ nfl.seasons	2024	—
team_id	bigint	→ nfl.teams	23	—
actual_defensive_snaps	integernullable	—	61	Realized post-game actual defensive plays faced.
actual_offensive_snaps	integernullable	—	61	Realized post-game actual offensive plays executed.
actual_pass_attempts	integernullable	—	30	Realized post-game actual pass attempts.
actual_pass_rate	decimalnullable	—	0.5000	Realized post-game actual pass playcalling rate.
actual_rush_attempts	integernullable	—	25	Realized post-game actual rushing attempts.
actual_rush_rate	decimalnullable	—	0.5000	Realized post-game actual rush playcalling rate.
as_of	timestamptz	—	2026-09-19T21:45:25.265Z	Point in time the projection reflects (UTC). Set when the projection is published; a backfilled row is never later than its write time.
implied_team_total	decimalnullable	—	20.50	Pre-kickoff implied team points based on Vegas spread and total.
is_home	boolean	—	true	True if playing at home, false if away. Values`truefalse`
no_huddle_rate	decimalnullable	—	0.1000	Pre-kickoff projected no-huddle rate percentage.
pass_attempts_error	decimalnullable	—	-3.63	Calibration error: actual_pass_attempts minus projected_pass_attempts.
pass_oe	decimalnullable	—	0.0000	Pre-kickoff pass rate over expectation (PROE).
projected_defensive_snaps	decimalnullable	—	64.00	Pre-kickoff projected team defensive snaps (opponent offensive snaps).
projected_offensive_snaps	decimal	—	63.40	Pre-kickoff projected team offensive plays/snaps.
projected_pass_attempts	decimal	—	33.32	Pre-kickoff projected team pass attempts.
projected_pass_rate	decimal	—	0.5825	Pre-kickoff projected pass playcalling percentage (0.0000 - 1.0000).
projected_personnel_11_rate	decimalnullable	—	0.6500	Pre-kickoff projected 11-personnel grouping rate (1 RB, 1 TE, 3 WR).
projected_personnel_12_rate	decimalnullable	—	0.2200	Pre-kickoff projected 12-personnel grouping rate (1 RB, 2 TE, 2 WR).
projected_personnel_21_rate	decimalnullable	—	0.0800	Pre-kickoff projected 21-personnel grouping rate (2 RB, 1 TE, 2 WR).
projected_rush_attempts	decimal	—	26.26	Pre-kickoff projected team rushing attempts.
projected_rush_rate	decimal	—	0.4175	Pre-kickoff projected rush playcalling percentage (0.0000 - 1.0000).
rush_attempts_error	decimalnullable	—	-4.54	Calibration error: actual_rush_attempts minus projected_rush_attempts.
seconds_per_play	decimalnullable	—	27.5	Pre-kickoff projected pace in neutral-game seconds per offensive play.
snap_error	decimalnullable	—	-3.62	Calibration error: actual_offensive_snaps minus projected_offensive_snaps.
source	string	—	STAT_API_SOTA	SOTA model source version (e.g. STAT_API_SOTA).
vegas_spread	decimalnullable	—	3.00	Pre-kickoff consensus closing spread from this team's perspective.
vegas_total	decimalnullable	—	44.50	Pre-kickoff consensus closing over/under game total.
week	integer	—	1	NFL regular season week number.

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ nfl.players	2	—
season_id	bigint	→ nfl.seasons	2025	—
completion_percentage	decimal	—	0.0000	—
completions	integer	—	0	—
defensive_tds	integer	—	0	—
extra_pts_attempted	integer	—	0	—
extra_pts_made	integer	—	0	—
fair_catches	integer	—	0	—
field_goal_percentage	decimal	—	0.0000	—
field_goals_attempted	integer	—	0	—
field_goals_made	integer	—	0	—
field_goals_made_0_19	integer	—	0	—
field_goals_made_20_29	integer	—	0	—
field_goals_made_30_39	integer	—	0	—
field_goals_made_40_49	integer	—	0	—
field_goals_made_50_plus	integer	—	0	—
forced_fumbles	integer	—	0	—
fumble_return_yds	integer	—	0	—
fumble_tds	integer	—	0	—
fumbles	integer	—	0	—
fumbles_lost	integer	—	0	—
fumbles_receiving	integer	—	0	—
fumbles_recovered	integer	—	0	—
fumbles_rushing	integer	—	0	—
games_played	integer	—	1	—
games_started	integer	—	0	—
interception_return_yds	integer	—	0	—
interception_tds	integer	—	0	—
interceptions_defense	integer	—	0	—
interceptions_thrown	integer	—	0	—
kick_return_average	decimal	—	0.0000	—
kick_return_tds	integer	—	0	—
kick_return_yds	integer	—	0	—
kick_returns	integer	—	0	—
longest_field_goal	integer	—	0	—
longest_kick_return	integer	—	0	—
longest_punt	integer	—	0	—
longest_punt_return	integer	—	0	—
longest_reception	integer	—	0	—
longest_rush	integer	—	0	—
pass_attempts	integer	—	0	—
passer_rating	decimal	—	0.0000	—
passes_defended	integer	—	0	—
passing_air_yds	integer	—	0	Total passing air yards
passing_first_downs	integer	—	0	Total passing first downs
passing_long	integer	—	0	Longest pass (season max)
passing_tds	integer	—	0	—
passing_yds	integer	—	0	—
passing_yds_after_catch	integer	—	0	Total YAC from passes
punt_average	decimal	—	0.0000	—
punt_net_average	decimal	—	0.0000	—
punt_return_average	decimal	—	0.0000	—
punt_return_tds	integer	—	0	—
punt_return_yds	integer	—	0	—
punt_returns	integer	—	0	—
punt_touchbacks	integer	—	0	—
punt_yds	integer	—	0	—
punts	integer	—	0	—
punts_blocked	integer	—	0	—
punts_inside_20	integer	—	0	—
quarterback_hits	integer	—	0	—
receiving_air_yds	integer	—	0	Total receiving air yards
receiving_first_downs	integer	—	0	Total receiving first downs
receiving_fumbles_lost	integer	—	0	Total receiving fumbles lost
receiving_tds	integer	—	0	—
receiving_yds	integer	—	0	—
receiving_yds_after_catch	integer	—	0	Total receiving YAC
receptions	integer	—	0	—
rushing_attempts	integer	—	0	—
rushing_first_downs	integer	—	0	Total rushing first downs
rushing_fumbles_lost	integer	—	0	Total rushing fumbles lost
rushing_tds	integer	—	0	—
rushing_yds	integer	—	0	—
sack_fumbles	integer	—	0	Total fumbles on sacks
sack_fumbles_lost	integer	—	0	Total sack fumbles lost
sack_yds_lost	integer	—	0	—
sacks	decimal	—	0.0000	—
sacks_taken	integer	—	0	—
safeties	integer	—	0	—
special_teams_tds	integer	—	0	Total special teams touchdowns
tackles_assisted	integer	—	0	—
tackles_for_loss	integer	—	0	—
tackles_solo	integer	—	0	—
targets	integer	—	0	—
total_tackles	integer	—	0	—
yds_per_attempt	decimal	—	0.0000	—
yds_per_carry	decimal	—	0.0000	—
yds_per_reception	decimal	—	0.0000	—

Advanced Stats

nfl.coach_scheme_tendencies58 fields· 4 refsendpoints →

Analytical coaching scheme tendencies, tempo, neutral PROE, personnel grouping distributions (11/12/21/13), opportunity concentration, and situational playcalling tendencies computed with strict pre-kickoff timewalls.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigintnullable	→ nfl.games	52	—
opponent_team_id	bigintnullable	→ nfl.teams	4	—
season_id	bigint	→ nfl.seasons	2024	—
team_id	bigint	→ nfl.teams	1	—
as_of	timestamptz	—	2024-09-15T17:00:00.000Z	Temporal timewall timestamp when metrics were computed.
avg_rb_capacity	decimalnullable	—	1.10	Average running backs on the field per offensive snap.
avg_te_capacity	decimalnullable	—	1.25	Average tight ends on the field per offensive snap.
avg_wr_capacity	decimalnullable	—	2.50	Average wide receivers on the field per offensive snap.
def_blitz_rate	decimalnullable	—	0.2500	Rate of opponent dropbacks where 5 or more pass rushers were sent.
def_cover_1_rate	decimalnullable	—	0.2200	Rate of defensive snaps with Cover 1 (Man-Free) coverage shell.
def_cover_2_rate	decimalnullable	—	0.1400	Rate of defensive snaps with Cover 2 coverage shell.
def_cover_3_rate	decimalnullable	—	0.3500	Rate of defensive snaps with Cover 3 coverage shell.
def_cover_4_rate	decimalnullable	—	0.0000	Rate of defensive snaps with Cover 4 (Quarters) coverage shell.
def_early_down_pass_rate_allowed	decimalnullable	—	0.5000	Opponent pass play rate allowed on 1st and 2nd down.
def_man_coverage_rate	decimalnullable	—	0.3500	Rate of defensive pass coverage snaps played in Man coverage.
def_neutral_pass_oe_allowed	decimalnullable	—	-0.2311	Opponent neutral pass rate over expected allowed in neutral game scripts (-6 to +6 score margin).
def_pressure_rate	decimalnullable	—	0.3000	Rate of opponent dropbacks where defensive pressure was generated.
def_rb_target_rate_allowed	decimalnullable	—	0.1667	Opponent target share allowed to Running Backs.
def_rz_rush_rate_allowed	decimalnullable	—	0.5000	Opponent designed rush rate allowed inside the 20-yard line (red zone).
def_slot_target_rate_allowed	decimalnullable	—	0.2000	Opponent middle/slot target share allowed.
def_te_target_rate_allowed	decimalnullable	—	0.2222	Opponent target share allowed to Tight Ends.
def_two_high_shell_rate	decimalnullable	—	0.4200	Rate of defensive snaps with Two-High safety shells (Cover 2, Cover 4, Cover 6, 2-Man).
def_zone_coverage_rate	decimalnullable	—	0.6500	Rate of defensive pass coverage snaps played in Zone coverage.
defensive_coordinator	stringnullable	—	Nick Rallis	Team defensive coordinator.
early_down_pass_rate	decimalnullable	—	0.5000	Pass play frequency on 1st and 2nd down.
fourth_down_go_rate	decimalnullable	—	0.0000	Fourth down aggressiveness rate of going for 4th down conversions in eligible situations.
gl_rush_rate	decimalnullable	—	0.5000	Designed rush play rate inside opponent 5-yard line (goal-to-go).
head_coach	string	—	Jonathan Gannon	Team head coach.
leading_pass_oe	decimalnullable	—	-12.3105	Pass rate over expected when leading by 7+ points.
leading_tempo_delta	decimalnullable	—	2.50	Seconds per play delta when leading by 7+ points vs neutral.
neutral_pass_oe	decimalnullable	—	-11.8521	Pass rate over expected in neutral game scripts (-6 to +6 score margin) in percentage points.
no_huddle_rate	decimalnullable	—	0.0000	Fraction of offensive plays run with no-huddle / hurry-up tempo.
offensive_coordinator	stringnullable	—	Drew Petzing	Team offensive coordinator.
offensive_plays_per_game	decimalnullable	—	79.00	Average offensive snaps per game.
overall_pass_oe	decimalnullable	—	-14.8083	Pass rate over expected across all game situations in percentage points.
primary_playcaller	stringnullable	—	Drew Petzing	Active primary offensive playcaller.
rate_11_personnel	decimalnullable	—	0.6500	Fraction of offensive snaps in 11-personnel (1 RB, 1 TE, 3 WR).
rate_12_personnel	decimalnullable	—	0.2000	Fraction of offensive snaps in 12-personnel (1 RB, 2 TE, 2 WR).
rate_13_personnel	decimalnullable	—	0.0200	Fraction of offensive snaps in 13-personnel (1 RB, 3 TE, 1 WR).
rate_21_personnel	decimalnullable	—	0.0800	Fraction of offensive snaps in 21-personnel (2 RB, 1 TE, 2 WR).
rb_bellcow_index	decimalnullable	—	0.5675	Bellcow concentration index (0.0 to 1.0) measuring lead back monopoly over carries and snaps.
rb1_carry_share	decimalnullable	—	0.5000	Lead running back share of total team designed rush attempts.
rb1_snap_share	decimalnullable	—	0.6500	Lead running back share of total offensive snaps.
rz_pass_rate	decimalnullable	—	0.5000	Pass play rate inside opponent 20-yard line (red zone).
rz_rush_rate	decimalnullable	—	0.5000	Designed rush play rate inside opponent 20-yard line (red zone).
sample_games	integer	—	2	Number of recent games in sample window.
seconds_per_play	decimalnullable	—	27.50	Average seconds between offensive plays across all game scripts.
seconds_per_play_neutral	decimalnullable	—	28.00	Seconds per play in neutral game scripts (score margin between -6 and +6).
slot_target_rate	decimalnullable	—	0.3200	Fraction of team targets directed to slot-aligned receivers.
te_archetype	stringnullable	—	HEAVY_12_PERSONNEL	Primary tight end deployment archetype (11_HEAVY, 12_HEAVY, 13_HEAVY, BALANCED). Values`HEAVY_12_PERSONNELSOLO_INLINE_MANDATESPREAD_MINIMAL`
third_down_pass_rate_long	decimalnullable	—	1.0000	Pass frequency on 3rd down with > 3 yards to go.
third_down_pass_rate_short	decimalnullable	—	0.5000	Pass frequency on 3rd down with <= 3 yards to go.
trailing_pass_oe	decimalnullable	—	5.3599	Pass rate over expected when trailing by 7+ points.
trailing_tempo_delta	decimalnullable	—	-2.50	Seconds per play delta when trailing by 7+ points vs neutral.
week	integer	—	1	NFL regular season week number (1-18).
wr_triad_concentration	decimalnullable	—	0.8800	Combined target share captured by top 3 wide receivers.
wr1_target_share	decimalnullable	—	0.5000	WR1 target share of team passing targets.

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	61	—
opponent_team_id	bigint	→ nfl.teams	10	—
player_id	bigint	→ nfl.players	657	—
team_id	bigint	→ nfl.teams	9	—
assisted_tackles	integer	—	0	Assisted tackles on first down
defensive_tds	integer	—	0	Total defensive touchdowns on first down
forced_fumbles	integer	—	0	Forced fumbles on first down
fumble_recovery_tds	integer	—	0	Fumble recovery touchdowns on first down
fumble_recovery_yds	integer	—	0	Fumble recovery yards on first down
fumbles	integer	—	0	Fumbles on first down
fumbles_lost	integer	—	0	Fumbles lost on first down
fumbles_recovered	integer	—	0	Fumbles recovered on first down
interception_tds	integer	—	0	Interception return touchdowns on first down
interception_yds	integer	—	0	Interception return yards on first down
interceptions	integer	—	0	Interceptions on first down
is_home	boolean	—	true	True if player's team is the home team Values`truefalse`
offensive_snaps	integer	—	0	Offensive snaps played on first down
offensive_tds	integer	—	0	Total offensive touchdowns on first down
passes_defended	integer	—	0	Passes defended on first down
passing_attempts	integer	—	0	Passing attempts on first down
passing_completion_percentage	decimal	—	0.0000	Completion percentage on first down
passing_completions	integer	—	0	Completed passes on first down
passing_interceptions	integer	—	0	Interceptions thrown on first down
passing_long	integer	—	0	Longest pass completion on first down
passing_rating	decimal	—	0.0000	Passer rating on first down
passing_sack_yds	integer	—	0	Yards lost to sacks on first down
passing_sacks	integer	—	0	Times sacked on first down
passing_tds	integer	—	0	Passing touchdowns on first down
passing_yds	integer	—	0	Passing yards on first down
passing_yds_per_attempt	decimal	—	0.0000	Passing yards per attempt on first down
passing_yds_per_completion	decimal	—	0.0000	Passing yards per completion on first down
position	string	—	WR	Player position at time of game Values`WRRBTEQBDBDLLBDEFOL`
quarterback_hits	integer	—	0	QB hits on first down
receiving_long	integer	—	0	Longest reception on first down
receiving_tds	integer	—	0	Receiving touchdowns on first down
receiving_yds	integer	—	0	Receiving yards on first down
receiving_yds_per_reception	decimal	—	0.0000	Yards per reception on first down
receiving_yds_per_target	decimal	—	0.0000	Receiving yards per target on first down
reception_percentage	decimal	—	0.0000	Reception percentage (receptions/targets) on first down
receptions	integer	—	0	Receptions on first down
rushing_attempts	integer	—	0	Rushing attempts on first down
rushing_long	integer	—	0	Longest rush on first down
rushing_tds	integer	—	0	Rushing touchdowns on first down
rushing_yds	integer	—	0	Rushing yards on first down
rushing_yds_per_attempt	decimal	—	0.0000	Rushing yards per attempt on first down
sacks	decimal	—	0.0000	Sacks on first down (0.5 for half sacks)
solo_tackles	integer	—	0	Solo tackles on first down
tackles_for_loss	integer	—	0	Tackles for loss on first down
targets	integer	—	0	Times targeted on first down
total_tds	integer	—	0	Total touchdowns scored on first down
two_pt_pass_conversions	integer	—	0	—
two_pt_reception_conversions	integer	—	0	—
two_pt_rush_conversions	integer	—	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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	121	—
player_gsis_id	string	—	00-0034857	GSIS ID for cross-reference
player_id	bigint	→ nfl.players	689	—
team_id	bigint	→ nfl.teams	28	—
aggressiveness	decimalnullable	—	16.6667	Percentage of throws into tight windows (defender within 1 yard)
attempts	integernullable	—	30	—
avg_air_distance	decimalnullable	—	20.1294	Average ball travel distance on all attempts
avg_air_yds_differential	decimalnullable	—	-0.8631	Difference between intended and completed air yards
avg_air_yds_to_sticks	decimalnullable	—	-3.6553	Average air yards relative to first down marker
avg_completed_air_yds	decimalnullable	—	7.1294	Average air yards on completed passes
avg_intended_air_yds	decimalnullable	—	7.2488	Average air yards on all pass attempts
avg_time_to_throw	decimalnullable	—	2.8413	Average time from snap to throw (seconds)
completion_percentage	decimalnullable	—	66.6667	—
completion_percentage_above_expectation	decimalnullable	—	12.5840	CPOE - Actual completion % minus expected (positive = better than expected)
completions	integernullable	—	22	—
expected_completion_percentage	decimalnullable	—	67.4160	Model-predicted completion percentage based on throw difficulty
interceptions	integernullable	—	0	—
max_air_distance	decimalnullable	—	42.0642	Maximum ball travel distance
max_completed_air_distance	decimalnullable	—	38.0455	Longest completed pass distance (ball travel)
pass_tds	integernullable	—	1	—
pass_yds	integernullable	—	235	—
passer_rating	decimalnullable	—	158.3333	—
season	integer	—	2024	—
season_type	string	—	regular_season	Canonical season phase.
week	integer	—	1	—

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	42034	—
player_gsis_id	string	—	00-0036322	GSIS ID for cross-reference
player_id	bigint	→ nfl.players	1156	—
team_id	bigint	→ nfl.teams	9	—
avg_cushion	decimalnullable	—	6.3400	Average distance from nearest defender at snap (yards)
avg_expected_yac	decimalnullable	—	0.0000	Model-predicted YAC based on catch location/defenders
avg_intended_air_yds	decimalnullable	—	13.6800	Average depth of targets
avg_separation	decimalnullable	—	2.2577	Average distance from nearest defender at catch point (yards)
avg_yac	decimalnullable	—	0.0000	Average yards after catch
avg_yac_above_expectation	decimalnullable	—	0.0000	Actual YAC minus expected (positive = creates extra yards)
catch_percentage	decimalnullable	—	66.6667	—
percent_share_of_intended_air_yds	decimalnullable	—	24.4521	Percentage of team total intended air yards (deep target share)
rec_tds	integernullable	—	0	—
receptions	integernullable	—	4	—
season	integer	—	2020	—
season_type	string	—	regular_season	Canonical season phase.
targets	integernullable	—	5	—
week	integer	—	1	—
yards	integernullable	—	41	—

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	4904	—
player_gsis_id	string	—	00-0032764	GSIS ID for cross-reference
player_id	bigint	→ nfl.players	252	—
team_id	bigint	→ nfl.teams	11	—
avg_rush_yds	decimalnullable	—	4.0000	—
avg_time_to_los	decimalnullable	—	2.6169	Average time to reach line of scrimmage (seconds)
efficiency	decimalnullable	—	3.5208	Distance traveled per rushing yard gained (lower = more efficient)
expected_rush_yds	decimalnullable	—	46.0428	Model-predicted rushing yards based on blocking/defense
percent_attempts_gte_eight_defenders	decimalnullable	—	0.0000	Percentage of rushes facing 8+ defenders in box
rush_attempts	integernullable	—	10	—
rush_pct_over_expected	decimalnullable	—	0.5000	RYOE as percentage over expected
rush_tds	integernullable	—	0	—
rush_yds	integernullable	—	45	—
rush_yds_over_expected	decimalnullable	—	37.9572	RYOE - Actual yards minus expected (positive = better)
rush_yds_over_expected_per_att	decimalnullable	—	-0.6101	RYOE per attempt
season	integer	—	2025	—
season_type	string	—	regular_season	Canonical season phase.
week	integer	—	1	—

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	57	—
opponent_team_id	bigint	→ nfl.teams	10	Opposing team in this matchup (FK to `teams`).
player_id	bigint	→ nfl.players	657	—
team_id	bigint	→ nfl.teams	10	—
carries	integernullable	—	0	Rushing attempts.
def_adot	decimalnullable	—	0.0000	Average depth of target (yards) when this defender was in coverage.
def_air_yds_completed	integernullable	—	0	Air yards completed on receptions allowed.
def_completion_pct	decimalnullable	—	0.0000	Completion percentage allowed (0.0-100.0).
def_completions_allowed	integernullable	—	0	Receptions allowed in coverage.
def_ints	integernullable	—	0	Interceptions made by this defender in coverage.
def_missed_tackle_pct	decimalnullable	—	0.0000	Missed-tackle rate on tackle opportunities (0.0-100.0).
def_missed_tackles	integernullable	—	0	Tackle attempts missed by this defender.
def_passer_rating_allowed	decimalnullable	—	0.0000	Passer rating allowed when targeted (0-158.3).
def_pressures	integernullable	—	0	Total pressures generated (hurries + hits + sacks).
def_receiving_td_allowed	integernullable	—	0	Receiving touchdowns allowed in coverage.
def_sacks	decimalnullable	—	0.0000	Sacks recorded (half-sacks supported as decimals).
def_tackles_combined	integernullable	—	0	Combined tackles (solo + assisted).
def_targets	integernullable	—	0	Pass targets thrown at this defender's coverage assignment.
def_times_blitzed	integernullable	—	0	Pass-rushing snaps as a blitzer.
def_times_hitqb	integernullable	—	0	QB hits generated as a pass rusher.
def_times_hurried	integernullable	—	0	Hurries generated as a pass rusher.
def_yds_after_catch	integernullable	—	0	Yards-after-catch allowed in coverage.
def_yds_allowed	integernullable	—	0	Receiving yards allowed in coverage.
def_yds_allowed_per_cmp	decimalnullable	—	0.0000	Yards allowed per reception.
def_yds_allowed_per_tgt	decimalnullable	—	0.0000	Yards allowed per target.
passing_bad_throw_pct	decimalnullable	—	0.0000	Bad-throw rate on pass attempts (0.0-100.0).
passing_bad_throws	integernullable	—	0	Pass attempts charged as bad throws by PFR scoring.
passing_drop_pct	decimalnullable	—	0.0000	Drop rate on catchable passes (0.0-100.0).
passing_drops	integernullable	—	0	Pass attempts dropped by the receiver (charged to the QB's catchable-target count).
receiving_broken_tackles	integernullable	—	0	Tackles the receiver broke on receiving plays.
receiving_drop	integernullable	—	0	Drops charged to this receiver.
receiving_drop_pct	decimalnullable	—	0.0000	Receiver drop rate on catchable targets (0.0-100.0).
receiving_int	integernullable	—	0	Interceptions thrown when this player was the target.
receiving_rat	decimalnullable	—	0.0000	Passer rating generated when targeted (0-158.3).
rushing_broken_tackles	integernullable	—	0	Tackles the runner broke on rushing plays.
rushing_yds_after_contact	integernullable	—	0	Total rushing yards gained after first contact.
rushing_yds_after_contact_avg	decimalnullable	—	0.0000	Yards after contact averaged per rush.
rushing_yds_before_contact	integernullable	—	0	Total rushing yards gained before first contact.
rushing_yds_before_contact_avg	decimalnullable	—	0.0000	Yards before contact averaged per rush.
times_blitzed	integernullable	—	0	Dropbacks the QB faced a blitz.
times_hit	integernullable	—	0	QB hits (defender contacted the QB on the throw).
times_hurried	integernullable	—	0	Dropbacks the QB was hurried but not pressured.
times_pressured	integernullable	—	0	Total pressures faced (sum of hurries/hits/sacks-allowed indicators).
times_pressured_pct	decimalnullable	—	0.0000	Pressure rate per dropback (0.0-100.0).
times_sacked	integernullable	—	0	Sacks 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	95	—
opponent_team_id	bigint	→ nfl.teams	16	—
player_id	bigint	→ nfl.players	657	—
team_id	bigint	→ nfl.teams	16	—
assisted_tackles	integer	—	0	Assisted tackles in red zone
defensive_tds	integer	—	0	Total defensive touchdowns in red zone
forced_fumbles	integer	—	0	Forced fumbles in red zone
fumble_recovery_tds	integer	—	0	Fumble recovery touchdowns in red zone
fumble_recovery_yds	integer	—	0	Fumble recovery yards in red zone
fumbles	integer	—	0	Fumbles in the red zone
fumbles_lost	integer	—	0	Fumbles lost in the red zone
fumbles_recovered	integer	—	0	Fumbles recovered in red zone
interception_tds	integer	—	0	Interception return touchdowns in red zone
interception_yds	integer	—	0	Interception return yards in red zone
interceptions	integer	—	0	Interceptions in red zone
is_home	boolean	—	false	True if player's team is the home team Values`falsetrue`
offensive_snaps	integer	—	0	Offensive snaps played in red zone situations
offensive_tds	integer	—	0	Total offensive touchdowns in the red zone
passes_defended	integer	—	0	Passes defended in red zone
passing_attempts	integer	—	0	Passing attempts in the red zone
passing_completion_percentage	decimal	—	0.0000	Completion percentage in the red zone
passing_completions	integer	—	0	Completed passes in the red zone
passing_interceptions	integer	—	0	Interceptions thrown in the red zone
passing_long	integer	—	0	Longest pass completion in the red zone
passing_rating	decimal	—	0.0000	Passer rating in the red zone
passing_sack_yds	integer	—	0	Yards lost to sacks in the red zone
passing_sacks	integer	—	0	Times sacked in the red zone
passing_tds	integer	—	0	Passing touchdowns in the red zone
passing_yds	integer	—	0	Passing yards in the red zone
passing_yds_per_attempt	decimal	—	0.0000	Passing yards per attempt in the red zone
passing_yds_per_completion	decimal	—	0.0000	Passing yards per completion in the red zone
position	string	—	WR	Player position at time of game Values`WRRBDBLBDLQBTEDEFOLP`
quarterback_hits	integer	—	0	QB hits in red zone
receiving_long	integer	—	0	Longest reception in the red zone
receiving_tds	integer	—	0	Receiving touchdowns in the red zone
receiving_yds	integer	—	0	Receiving yards in the red zone
receiving_yds_per_reception	decimal	—	0.0000	Yards per reception in the red zone
receiving_yds_per_target	decimal	—	0.0000	Receiving yards per target in the red zone
reception_percentage	decimal	—	0.0000	Reception percentage (receptions/targets) in the red zone
receptions	integer	—	0	Receptions in the red zone
rushing_attempts	integer	—	0	Rushing attempts in the red zone
rushing_long	integer	—	0	Longest rush in the red zone
rushing_tds	integer	—	0	Rushing touchdowns in the red zone
rushing_yds	integer	—	0	Rushing yards in the red zone
rushing_yds_per_attempt	decimal	—	0.0000	Rushing yards per attempt in the red zone
sacks	decimal	—	0.0000	Sacks in red zone (0.5 for half sacks)
solo_tackles	integer	—	0	Solo tackles in red zone
tackles_for_loss	integer	—	0	Tackles for loss in red zone
targets	integer	—	0	Times targeted in the red zone
total_tds	integer	—	0	Total touchdowns scored in the red zone
two_pt_pass_conversions	integer	—	0	Successful two-point conversion passes in the red zone
two_pt_reception_conversions	integer	—	0	Successful two-point conversion receptions in the red zone
two_pt_rush_conversions	integer	—	0	Successful two-point conversion runs in the red zone

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	60	—
opponent_team_id	bigint	→ nfl.teams	8	—
player_id	bigint	→ nfl.players	657	—
team_id	bigint	→ nfl.teams	10	—
assisted_tackles	integer	—	0	Assisted tackles on third down
defensive_tds	integer	—	0	Total defensive touchdowns on third down
forced_fumbles	integer	—	0	Forced fumbles on third down
fumble_recovery_tds	integer	—	0	Fumble recovery touchdowns on third down
fumble_recovery_yds	integer	—	0	Fumble recovery yards on third down
fumbles	integer	—	0	Fumbles on third down
fumbles_lost	integer	—	0	Fumbles lost on third down
fumbles_recovered	integer	—	0	Fumbles recovered on third down
interception_tds	integer	—	0	Interception return touchdowns on third down
interception_yds	integer	—	0	Interception return yards on third down
interceptions	integer	—	0	Interceptions on third down
is_home	boolean	—	false	True if player's team is the home team Values`falsetrue`
offensive_snaps	integer	—	0	Offensive snaps played on third down
offensive_tds	integer	—	0	Total offensive touchdowns on third down
passes_defended	integer	—	0	Passes defended on third down
passing_attempts	integer	—	0	Passing attempts on third down
passing_completion_percentage	decimal	—	0.0000	Completion percentage on third down
passing_completions	integer	—	0	Completed passes on third down
passing_interceptions	integer	—	0	Interceptions thrown on third down
passing_long	integer	—	0	Longest pass completion on third down
passing_rating	decimal	—	0.0000	Passer rating on third down
passing_sack_yds	integer	—	0	Yards lost to sacks on third down
passing_sacks	integer	—	0	Times sacked on third down
passing_tds	integer	—	0	Passing touchdowns on third down
passing_yds	integer	—	0	Passing yards on third down
passing_yds_per_attempt	decimal	—	0.0000	Passing yards per attempt on third down
passing_yds_per_completion	decimal	—	0.0000	Passing yards per completion on third down
position	string	—	WR	Player position at time of game Values`WRRBDBQBTELBDLDEFOL`
quarterback_hits	integer	—	0	QB hits on third down
receiving_long	integer	—	0	Longest reception on third down
receiving_tds	integer	—	0	Receiving touchdowns on third down
receiving_yds	integer	—	0	Receiving yards on third down
receiving_yds_per_reception	decimal	—	0.0000	Yards per reception on third down
receiving_yds_per_target	decimal	—	0.0000	Receiving yards per target on third down
reception_percentage	decimal	—	0.0000	Reception percentage (receptions/targets) on third down
receptions	integer	—	0	Receptions on third down
rushing_attempts	integer	—	0	Rushing attempts on third down
rushing_long	integer	—	0	Longest rush on third down
rushing_tds	integer	—	0	Rushing touchdowns on third down
rushing_yds	integer	—	0	Rushing yards on third down
rushing_yds_per_attempt	decimal	—	0.0000	Rushing yards per attempt on third down
sacks	decimal	—	0.0000	Sacks on third down (0.5 for half sacks)
solo_tackles	integer	—	0	Solo tackles on third down
tackles_for_loss	integer	—	0	Tackles for loss on third down
targets	integer	—	0	Times targeted on third down
total_tds	integer	—	0	Total touchdowns scored on third down
two_pt_pass_conversions	integer	—	0	—
two_pt_reception_conversions	integer	—	0	—
two_pt_rush_conversions	integer	—	0	—

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ nfl.players	2	—
season_id	bigint	→ nfl.seasons	2020	—
assisted_tackles	integer	—	0	Assisted tackles on first down
defensive_tds	integer	—	0	Total defensive touchdowns on first down
forced_fumbles	integer	—	0	Forced fumbles on first down
fumble_recovery_tds	integer	—	0	Fumble recovery touchdowns on first down
fumble_recovery_yds	integer	—	0	Fumble recovery yards on first down
fumbles	integer	—	0	Fumbles on first down
fumbles_lost	integer	—	0	Fumbles lost on first down
fumbles_recovered	integer	—	0	Fumbles recovered on first down
games_played	integer	—	1	Number of games with first down involvement
games_started	integer	—	0	Number of games started
interception_tds	integer	—	0	Interception return touchdowns on first down
interception_yds	integer	—	0	Interception return yards on first down
interceptions	integer	—	0	Interceptions on first down
offensive_snaps	integer	—	0	Offensive snaps played on first down
offensive_tds	integer	—	0	Total offensive touchdowns on first down
passes_defended	integer	—	0	Passes defended on first down
passing_attempts	integer	—	0	Passing attempts on first down
passing_completion_percentage	decimal	—	0.0000	Completion percentage on first down
passing_completions	integer	—	0	Completed passes on first down
passing_interceptions	integer	—	0	Interceptions thrown on first down
passing_long	integer	—	0	Longest pass completion on first down
passing_rating	decimal	—	0.0000	Passer rating on first down
passing_sack_yds	integer	—	0	Yards lost to sacks on first down
passing_sacks	integer	—	0	Times sacked on first down
passing_tds	integer	—	0	Passing touchdowns on first down
passing_yds	integer	—	0	Passing yards on first down
passing_yds_per_attempt	decimal	—	0.0000	Passing yards per attempt on first down
passing_yds_per_completion	decimal	—	0.0000	Passing yards per completion on first down
quarterback_hits	integer	—	0	QB hits on first down
receiving_long	integer	—	0	Longest reception on first down
receiving_tds	integer	—	0	Receiving touchdowns on first down
receiving_yds	integer	—	0	Receiving yards on first down
receiving_yds_per_reception	decimal	—	0.0000	Yards per reception on first down
receiving_yds_per_target	decimal	—	0.0000	Receiving yards per target on first down
reception_percentage	decimal	—	0.0000	Reception percentage (receptions/targets) on first down
receptions	integer	—	0	Receptions on first down
rushing_attempts	integer	—	0	Rushing attempts on first down
rushing_long	integer	—	0	Longest rush on first down
rushing_tds	integer	—	0	Rushing touchdowns on first down
rushing_yds	integer	—	0	Rushing yards on first down
rushing_yds_per_attempt	decimal	—	0.0000	Rushing yards per attempt on first down
sacks	decimal	—	0.0000	Sacks on first down (0.5 for half sacks)
solo_tackles	integer	—	0	Solo tackles on first down
tackles_for_loss	integer	—	0	Tackles for loss on first down
targets	integer	—	0	Times targeted on first down
total_tds	integer	—	0	Total touchdowns scored on first down
two_pt_pass_conversions	integer	—	0	—
two_pt_reception_conversions	integer	—	0	—
two_pt_rush_conversions	integer	—	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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ nfl.players	2	—
season_id	bigint	→ nfl.seasons	2025	—
assisted_tackles	integer	—	0	Assisted tackles in red zone
defensive_tds	integer	—	0	Total defensive touchdowns in red zone
forced_fumbles	integer	—	0	Forced fumbles in red zone
fumble_recovery_tds	integer	—	0	Fumble recovery touchdowns in red zone
fumble_recovery_yds	integer	—	0	Fumble recovery yards in red zone
fumbles	integer	—	0	Fumbles in the red zone
fumbles_lost	integer	—	0	Fumbles lost in the red zone
fumbles_recovered	integer	—	0	Fumbles recovered in red zone
games_played	integer	—	1	Number of games with red zone involvement
games_started	integer	—	0	Number of games started
interception_tds	integer	—	0	Interception return touchdowns in red zone
interception_yds	integer	—	0	Interception return yards in red zone
interceptions	integer	—	0	Interceptions in red zone
offensive_snaps	integer	—	0	Offensive snaps played in red zone situations
offensive_tds	integer	—	0	Total offensive touchdowns in the red zone
passes_defended	integer	—	0	Passes defended in red zone
passing_attempts	integer	—	0	Passing attempts in the red zone
passing_completion_percentage	decimal	—	0.0000	Completion percentage in the red zone
passing_completions	integer	—	0	Completed passes in the red zone
passing_interceptions	integer	—	0	Interceptions thrown in the red zone
passing_long	integer	—	0	Longest pass completion in the red zone
passing_rating	decimal	—	0.0000	Passer rating in the red zone
passing_sack_yds	integer	—	0	Yards lost to sacks in the red zone
passing_sacks	integer	—	0	Times sacked in the red zone
passing_tds	integer	—	0	Passing touchdowns in the red zone
passing_yds	integer	—	0	Passing yards in the red zone
passing_yds_per_attempt	decimal	—	0.0000	Passing yards per attempt in the red zone
passing_yds_per_completion	decimal	—	0.0000	Passing yards per completion in the red zone
quarterback_hits	integer	—	0	QB hits in red zone
receiving_long	integer	—	0	Longest reception in the red zone
receiving_tds	integer	—	0	Receiving touchdowns in the red zone
receiving_yds	integer	—	0	Receiving yards in the red zone
receiving_yds_per_reception	decimal	—	0.0000	Yards per reception in the red zone
receiving_yds_per_target	decimal	—	0.0000	Receiving yards per target in the red zone
reception_percentage	decimal	—	0.0000	Reception percentage (receptions/targets) in the red zone
receptions	integer	—	0	Receptions in the red zone
rushing_attempts	integer	—	0	Rushing attempts in the red zone
rushing_long	integer	—	0	Longest rush in the red zone
rushing_tds	integer	—	0	Rushing touchdowns in the red zone
rushing_yds	integer	—	0	Rushing yards in the red zone
rushing_yds_per_attempt	decimal	—	0.0000	Rushing yards per attempt in the red zone
sacks	decimal	—	0.0000	Sacks in red zone (0.5 for half sacks)
solo_tackles	integer	—	0	Solo tackles in red zone
tackles_for_loss	integer	—	0	Tackles for loss in red zone
targets	integer	—	0	Times targeted in the red zone
total_tds	integer	—	0	Total touchdowns scored in the red zone
two_pt_pass_conversions	integer	—	0	Successful two-point conversion passes in the red zone
two_pt_reception_conversions	integer	—	0	Successful two-point conversion receptions in the red zone
two_pt_rush_conversions	integer	—	0	Successful two-point conversion runs in the red zone

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
player_id	bigint	→ nfl.players	9	—
season_id	bigint	→ nfl.seasons	2021	—
assisted_tackles	integer	—	0	Assisted tackles on third down
defensive_tds	integer	—	0	Total defensive touchdowns on third down
forced_fumbles	integer	—	0	Forced fumbles on third down
fumble_recovery_tds	integer	—	0	Fumble recovery touchdowns on third down
fumble_recovery_yds	integer	—	0	Fumble recovery yards on third down
fumbles	integer	—	0	Fumbles on third down
fumbles_lost	integer	—	0	Fumbles lost on third down
fumbles_recovered	integer	—	0	Fumbles recovered on third down
games_played	integer	—	0	Number of games with third down involvement
games_started	integer	—	0	Number of games started
interception_tds	integer	—	0	Interception return touchdowns on third down
interception_yds	integer	—	0	Interception return yards on third down
interceptions	integer	—	0	Interceptions on third down
offensive_snaps	integer	—	0	Offensive snaps played on third down
offensive_tds	integer	—	0	Total offensive touchdowns on third down
passes_defended	integer	—	0	Passes defended on third down
passing_attempts	integer	—	0	Passing attempts on third down
passing_completion_percentage	decimal	—	0.0000	Completion percentage on third down
passing_completions	integer	—	0	Completed passes on third down
passing_interceptions	integer	—	0	Interceptions thrown on third down
passing_long	integer	—	0	Longest pass completion on third down
passing_rating	decimal	—	0.0000	Passer rating on third down
passing_sack_yds	integer	—	0	Yards lost to sacks on third down
passing_sacks	integer	—	0	Times sacked on third down
passing_tds	integer	—	0	Passing touchdowns on third down
passing_yds	integer	—	0	Passing yards on third down
passing_yds_per_attempt	decimal	—	0.0000	Passing yards per attempt on third down
passing_yds_per_completion	decimal	—	0.0000	Passing yards per completion on third down
quarterback_hits	integer	—	0	QB hits on third down
receiving_long	integer	—	0	Longest reception on third down
receiving_tds	integer	—	0	Receiving touchdowns on third down
receiving_yds	integer	—	0	Receiving yards on third down
receiving_yds_per_reception	decimal	—	0.0000	Yards per reception on third down
receiving_yds_per_target	decimal	—	0.0000	Receiving yards per target on third down
reception_percentage	decimal	—	0.0000	Reception percentage (receptions/targets) on third down
receptions	integer	—	0	Receptions on third down
rushing_attempts	integer	—	0	Rushing attempts on third down
rushing_long	integer	—	0	Longest rush on third down
rushing_tds	integer	—	0	Rushing touchdowns on third down
rushing_yds	integer	—	0	Rushing yards on third down
rushing_yds_per_attempt	decimal	—	0.0000	Rushing yards per attempt on third down
sacks	decimal	—	0.0000	Sacks on third down (0.5 for half sacks)
solo_tackles	integer	—	0	Solo tackles on third down
tackles_for_loss	integer	—	0	Tackles for loss on third down
targets	integer	—	0	Times targeted on third down
total_tds	integer	—	0	Total touchdowns scored on third down
two_pt_pass_conversions	integer	—	0	—
two_pt_reception_conversions	integer	—	0	—
two_pt_rush_conversions	integer	—	0	—

Odds

nfl.game_lines18 fields· 3 refsendpoints →

NFL game betting lines — point spreads, moneylines, and over/under totals, one row per capture. `source` says where a row came from - `espn` rows are live captures before kickoff (2026 on); `nflverse` rows are one closing line per Final game with `captured_at` equal to kickoff (2020-2025, and a post-game fallback). Regular-season games only.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	43434	—
operator_id	bigint	→ main.operators	6	Data source (ESPN, DraftKings, FanDuel, nflverse, etc.)
season_id	bigint	→ nfl.seasons	2024	Denormalized for efficient season-level queries
captured_at	timestamptz	—	2024-09-15T17:00:00.000Z	When this snapshot was captured
implied_away_score	decimalnullable	—	21.5000	Calculated from spread + total
implied_away_win_pct	decimalnullable	—	0.4464	From moneyline, 0-1
implied_home_score	decimalnullable	—	23.0000	Calculated from spread + total
implied_home_win_pct	decimalnullable	—	0.5968	From moneyline, 0-1
is_opening	boolean	—	false	True if this is the opening line Values`falsetrue`
moneyline_away	integernullable	—	124	American odds for away team win
moneyline_home	integernullable	—	-148	American odds for home team win
over_odds	integernullable	—	-110	American odds for over
spread	decimalnullable	—	3.0000	Home team spread (e.g., -3.5 means home favored by 3.5)
spread_away_odds	integernullable	—	-110	American odds for away spread
spread_home_odds	integernullable	—	-110	American odds for home spread (e.g., -110)
total	decimalnullable	—	44.5000	Combined score total line (e.g., 47.5)
under_odds	integernullable	—	-110	American odds for under

nfl.game_player_props18 fields· 4 refsendpoints →

NFL player prop bets for each game — passing yards, rushing touchdowns, receptions, and other player-statistic markets offered by sportsbooks.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	43403	—
operator_id	bigint	→ main.operators	6	Usually consensus
player_id	bigint	→ nfl.players	693	—
season_id	bigint	→ nfl.seasons	2026	Denormalized for efficient season-level queries
book_count	integer	—	2	Number of curated books contributing to this consensus value
captured_at	timestamptz	—	2026-09-07T11:18:42.386Z	—
category	string	—	anytime_td	Canonical prop category. Common values: - passing_yds, passing_tds, passing_attempts, completions, interceptions - rushing_yds, rushing_tds, rushing_attempts - receiving_yds, receiving_tds, receptions, targets - longest_reception, longest_rush, longest_pass - sacks, tackles, interceptions_def - anytime_td, first_td Values`anytime_tdreceiving_ydsreceptionslast_tdfirst_tdrushing_ydspassing_tdscompletionsrushing_attemptsinterceptionspassing_ydspassing_attempts`
is_opening	boolean	—	true	True for the first capture of a (game, player, market, line) Values`truefalse`
line	decimalnullable	—	1.5000	Prop line for over/under markets (275.5 yards, 1.5 TDs). NULL for yes/no markets.
market_key	string	—	player_anytime_td	Raw market key from source API (e.g., player_reception_yds) Values`player_anytime_tdplayer_reception_ydsplayer_receptionsplayer_last_tdplayer_1st_tdplayer_rush_ydsplayer_pass_tdsplayer_pass_completionsplayer_rush_attemptsplayer_pass_interceptionsplayer_pass_ydsplayer_pass_attempts`
no_odds	integernullable	—	—	American odds for no (anytime_td, first_td)
outcome_type	string	—	ou	ou \| yes_no Values`ouyes_no`
over_odds	integernullable	—	-114	American odds for over
period_code	stringnullable	—	—	Optional period code (1Q, 1H). NULL = full game.
subcategory	stringnullable	—	—	Optional subtype (alternate, boosted, etc.)
under_odds	integernullable	—	-114	American odds for under
yes_odds	integernullable	—	4000	American odds for yes (anytime_td, first_td)

Lineups & Roster

nfl.coaching_staff_tenures11 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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
season_id	bigint	→ nfl.seasons	2024	Reference to the season
team_id	bigint	→ nfl.teams	6	Reference to the team
effective_date	date	—	2023-01-01	Date this coach started in this role
end_date	datenullable	—	2024-11-29	Date this coach ended (null if current)
first_name	stringnullable	—	Mike	—
full_name	string	—	Kyle Shanahan	Coach full name
is_interim	boolean	—	false	— Values`falsetrue`
last_name	stringnullable	—	Harbaugh	—
position	string	—	HC	Coaching position (HC, OC, DC) Values`HCOCDC`
reason	stringnullable	—	fired	Reason for change (fired, resigned, hired, promoted)

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
season_id	bigint	→ nfl.seasons	2024	—
team_id	bigint	→ nfl.teams	1	—
experience	integernullable	—	—	—
first_name	string	—	Mike	—
full_name	string	—	Thomas Brown	—
last_name	string	—	Harbaugh	—
position	string	—	DC	— Values`DCHCOC`

nfl.depth_charts15 fields· 4 refsendpoints →

One player's depth-chart slot for a given team in a given NFL game — position, depth order (starter, backup, …), roster status, and game context. Exactly one active depth chart per game.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
elias_id	stringnullable	—	—	Elias Sports Bureau player identifier (nullable — populated only when the source feed includes Elias IDs).
game_id	bigint	→ nfl.games	120	FK to nfl.games — the game this depth chart is associated with.
player_id	bigint	→ nfl.players	19	FK to nfl.players — the player occupying this depth-chart slot.
season_id	bigint	→ nfl.seasons	2024	FK to nfl.seasons — the season containing this game.
team_id	bigint	→ nfl.teams	32	FK to nfl.teams — the team whose depth chart this row belongs to.
depth_order	integernullable	—	1	Depth-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_position	string	—	DT	Position 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). Values`DTWRDETQBLSGTECBILBKOLBCFSPSSNTRBFBMLB`
depth_team	stringnullable	—	—	Sub-team designation within the depth chart when present (e.g., a formation-specific team grouping). Sparse — typically NULL.
formation	stringnullable	—	offense	Formation unit this slot belongs to (e.g., OFF, DEF, ST). Sparse — typically NULL. Values`offensedefensespecial_teams`
game_type	string	—	REG	Phase of the season: REG (regular season), WC (Wild Card), DIV (Divisional), CON (Conference Championship), SB (Super Bowl). Values`REGDIVWCCONSB`
jersey_number	integernullable	—	—	Player's jersey number on the team for this game (nullable — populated when the depth chart includes uniform numbers).
position	string	—	WR	Player's listed position abbreviation (e.g., QB, RB, WR, T, DT, CB, MLB, K, P).
status	stringnullable	—	Active	NFL 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). Values`ActiveReservePracticeSquadInactiveRetiredCutExempt`
week	integer	—	15	NFL week number within the season (1-18 regular season; postseason weeks use higher numbers per league convention).

nfl.game_team_rosters12 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	120	—
player_id	bigint	→ nfl.players	19	—
team_id	bigint	→ nfl.teams	32	—
comment	stringnullable	—	Knee	Optional note from the gameday roster report (e.g., reason for inactive).
depth_order	integernullable	—	1	Depth-chart rank at this position for this game (1 = starter, 2 = backup, etc.).
depth_position	stringnullable	—	WR	Position slot on the depth chart for this game (e.g. QB, RB, WR, LT, CB).
formation	stringnullable	—	offense	Formation unit this slot belongs to (offense, defense, special_teams). Values`offensedefensespecial_teams`
injury_status	stringnullable	—	Questionable	Final game injury report designation as of kickoff lock (e.g. Questionable, Doubtful, Out, or NULL if uninjured). Values`QuestionableOutDoubtfulNote`
position	stringnullable	—	DL	Position the player suited up at for this game. Values`DLOLDBWRLBQBLSTEKPRB`
starter	boolean	—	true	True if the player started this game. Values`truefalse`
status	stringnullable	—	Active	Roster status for the game, readable single-word vocabulary (`Active`, `Inactive`, `PracticeSquad`, `Reserve`, `Cut`, `Retired`, `Exempt`, `PracticeSquadReleased`). Values`ActiveReservePracticeSquadInactiveRetiredCutExempt`

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	49	Reference to the game
team_id	bigint	→ nfl.teams	16	Reference to the team
defensive_coordinator	stringnullable	—	Aaron Glenn	Defensive coordinator name
head_coach	stringnullable	—	Andy Reid	Head coach name (from nflverse)
offensive_coordinator	stringnullable	—	Ben Johnson	Offensive coordinator name

nfl.team_player_rosters17 fields· 4 refsendpoints →

Each NFL club's roster today — the players on the club's current game roster (its next game not yet kicked off, else its latest game), one row per player, with the game's status and injury report. Between seasons, until 21 days before a club's next game, it shows the club's last game roster as it stood at that kickoff. For past weeks, use the game rosters (game_team_rosters).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	—	The club's current game — its next game not yet kicked off, else its latest game.
player_id	bigint	→ nfl.players	765	—
season_id	bigint	→ nfl.seasons	2024	—
team_id	bigint	→ nfl.teams	32	—
day	integer	—	20240905	The first game day of the current game's week (YYYYMMDD, Eastern), usually its Thursday; the same value for every club that week.
depth_order	integernullable	—	1	Depth-chart order at this position for the current game (1 = starter); empty when not on the chart or not active.
game_time	timestamptznullable	—	—	Kickoff time of the current game.
injury_status	stringnullable	—	—	Injury designation on the current game roster (e.g. Questionable, Doubtful, Out; empty when healthy).
position	stringnullable	—	DB	The player's position on the club (a position from the filter list when the game roster has one, else his primary position). Values`DBOLDLLBWRRBTEQBKPLS`
position_group	stringnullable	—	Offense	Position group (`Offense`, `Defense`, `Special Teams`). Values`OffenseDefenseSpecial Teams`
practice_status	stringnullable	—	—	The injury report's practice participation for the current game, as the report words it (`DNP`, `LP`, `FP`, or the long form such as `Did Not Participate In Practice`); empty when the player is not on the practice report.
report_primary_injury	stringnullable	—	—	The injury report's primary injury for the current game.
report_status	stringnullable	—	—	The official injury report's game status for the current game, as the report words it (e.g. `Out`, `Doubtful`, `Questionable`, `Active`, `Injured Reserve`), from the injury report of that same game only; empty when the player is not on it.
season_type	stringnullable	—	—	Season type of the current game (regular_season, postseason, preseason).
status	stringnullable	—	—	Roster status for the current game (`Active`, `Inactive`, `PracticeSquad`, `Reserve`, `Exempt`, `PhysicallyUnableToPerform`, `NonFootballInjury`, `Suspended`, ...); only players on the club appear.
week	integernullable	—	—	Week of the current game within its season type.

Misc

nfl.stadiums20 fieldsendpoints →

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
league_stadium_id	stringnullable	—	00081065-961a-76b2-de6a-b6da2602a129	Official NFL stadium ID from API
address	stringnullable	—	1 Patriot Pl, Foxborough, MA 02035	Street address of the stadium.
capacity	integernullable	—	65000	Approximate seating capacity for football configuration.
city	string	—	Santa Clara	—
closed_date	timestamptznullable	—	—	Date the stadium closed (null if currently in use).
country	stringnullable	—	USA	— Values`USADEUGBRMEXBRAESPIRLAUSFRA`
description	stringnullable	—	—	—
elevation	floatnullable	—	256	Elevation in feet above sea level
image_url	stringnullable	—	https://upload.wikimedia.org/wikipedia/commons/thumb/7/70/Gillette_Stadium_%28aerial%29.jpg/1280px-…	URL to aerial/overview image of stadium
latitude	floatnullable	—	37.4033	Latitude of the stadium centroid (decimal degrees, WGS84).
longitude	floatnullable	—	-121.9694	Longitude of the stadium centroid (decimal degrees, WGS84).
name	string	—	Gillette Stadium	—
opened_date	timestamptznullable	—	2002-01-01T00:00:00.000Z	Date the stadium opened for play.
orientation	floatnullable	—	0	Field orientation in degrees (0-360). Direction end zones face, measured from south end zone. 0/360=North, 90=East, 180=South, 270=West
roof_type	stringnullable	—	Open	Roof type (e.g., `open`, `dome`, `retractable`). Values`OpenRetractableDome`
state	stringnullable	—	FL	—
surface	stringnullable	—	Grass	Playing surface type (e.g., `grass`, `FieldTurf`, `Astroturf`). Values`GrassFieldTurfHybrid GrassA-Turf TitanBermuda GrassUBU Sports Speed Series S5-M`
team_name	stringnullable	—	NE	Team commonly associated with this stadium at the time (display string, not a foreign key).
timezone	stringnullable	—	America/New_York	IANA timezone (e.g., America/New_York) Values`America/New_YorkAmerica/ChicagoAmerica/Los_AngelesEurope/BerlinEurope/LondonAmerica/Mexico_CityAmerica/Sao_PauloEurope/MadridAmerica/Indiana/IndianapolisAmerica/DenverAmerica/DetroitAmerica/PhoenixEurope/DublinAustralia/SydneyEurope/Paris`

nfl.referees8 fieldsendpoints →

NFL on-field officials — the seven-person crew of referees, umpires, head linesmen, line judges, field judges, side judges, and back judges who work each game.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
nfl_referee_id	integer	—	83	Official NFL identifier for the referee.
active	boolean	—	true	True for currently-active officials; false for retired.
experience	integernullable	—	—	Years of NFL officiating experience.
first_name	string	—	Mark	—
full_name	string	—	Scott Helverson	—
last_name	string	—	Hill	—
position	string	—	Line Judge	On-field crew position (e.g., `Referee`, `Umpire`, `Head Linesman`, `Side Judge`).

nfl.operator_team_lookups6 fields· 2 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
operator_id	bigint	→ main.operators	4	Reference to main.operator entity
operator_team_id	string	—	28	External team ID from operator
team_id	bigint	→ nfl.teams	32	Internal nfl.teams.id reference
abbreviation	stringnullable	—	—	Team abbreviation for reconciliation
team_name	stringnullable	—	Washington Commanders	Team name for reconciliation

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
away_team_id	bigint	→ nfl.teams	19	—
home_team_id	bigint	→ nfl.teams	16	—
season_id	bigint	→ nfl.seasons	2024	—
winner_team_id	bigintnullable	→ nfl.teams	16	Winning team (FK to `teams`); null until the game completes.
away_team_seed	integer	—	0	Playoff seed (1-7) of the away team for this matchup.
conference	stringnullable	—	AFC	Conference the matchup is contested within (`AFC`, `NFC`); null for the Super Bowl (inter-conference). Values`AFCNFC`
game_number	integer	—	1	Sequence number within the round (used to order multiple games in the same round).
home_team_seed	integer	—	0	Playoff seed (1-7) of the home team for this matchup.
playoff_round	string	—	Wild Card	Postseason round (`WildCard`, `Divisional`, `Conference Championship`, `Super Bowl`). Values`Wild CardDivisionalConference ChampionshipSuper Bowl`
status	string	—	Final	Matchup 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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
cfb_id	stringnullable	—	kaytron-allen-1	College Football Reference player ID (external lookup).
pfr_id	stringnullable	—	AlleKa01	Pro Football Reference player ID (external lookup).
player_id	bigint	→ nfl.players	2707	—
team_id	bigintnullable	→ nfl.teams	—	—
bench	integernullable	—	21	Bench press repetitions at 225 lbs.
broad_jump	integernullable	—	124	Broad jump distance in inches.
cone	decimalnullable	—	7.0000	3-cone drill time in seconds.
forty	decimalnullable	—	4.4800	40-yard dash time in seconds.
ht	stringnullable	—	6-4	Height as reported by the Combine (e.g., `6-2` for 6 feet 2 inches). Values`6-46-26-36-16-06-55-116-65-105-95-86-76-85-76-95-65-5`
position	string	—	WR	Position the player was measured as (e.g., QB, WR, RB, CB).
school	stringnullable	—	Georgia	College or last-affiliation school name.
season	integer	—	2021	Calendar year of the Combine (e.g., 2024 for the February 2024 combine).
shuttle	decimalnullable	—	4.4000	20-yard shuttle time in seconds.
vertical	decimalnullable	—	34.5000	Vertical jump in inches.
wt	integernullable	—	205	Weight in pounds.

nfl.draft_picks38 fields· 2 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).

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
cfb_player_id	stringnullable	—	caleb-williams-3	College Football Reference player ID.
gsis_id	string	—	—	Game Statistics and Information System ID (NFL official cross-system join key).
pfr_player_id	string	—	WillCa03	Pro Football Reference player ID.
player_id	bigint	→ nfl.players	3180	—
team_id	bigint	→ nfl.teams	15	—
age	integernullable	—	23	Player age at the time of the draft.
allpro_count	integer	—	0	Career All-Pro selections.
car_av	integernullable	—	—	Career Approximate Value (Pro Football Reference, unweighted sum across seasons).
career_to_year	integernullable	—	2025	Most recent NFL season the player appeared in (calendar year).
category	string	—	DB	Position category (e.g., `OFF`, `DEF`, `ST`). Values`DBDLOLWRLBRBTEQBPKLSFSOG`
college	string	—	Georgia	College the player was drafted out of.
def_ints	integer	—	0	Career defensive interceptions.
def_sacks	decimal	—	0.0000	Career sacks (defensive; half-sacks supported as decimals).
def_solo_tackles	integer	—	0	Career solo defensive tackles.
dr_av	integernullable	—	0	Approximate Value accumulated while with the drafting team.
games_played	integer	—	0	Total career regular-season games played.
is_hof	boolean	—	false	True if the player is enshrined in the Pro Football Hall of Fame.
pass_attempts	integer	—	0	Career pass attempts.
pass_completions	integer	—	0	Career pass completions.
pass_ints	integer	—	0	Career interceptions thrown.
pass_tds	integer	—	0	Career passing touchdowns.
pass_yds	integer	—	0	Career passing yards.
pfr_player_name	stringnullable	—	Tyler Davis	Player name as recorded on Pro Football Reference.
pick	integer	—	1	Pick number within the round.
position	string	—	WR	Position the player was drafted at (e.g., QB, WR, DE).
probowl_count	integer	—	0	Career Pro Bowl selections.
rec_tds	integer	—	0	Career receiving touchdowns.
rec_yds	integer	—	0	Career receiving yards.
receptions	integer	—	0	Career receptions.
round	integer	—	6	Draft round (1-7).
rush_atts	integer	—	0	Career rushing attempts.
rush_tds	integer	—	0	Career rushing touchdowns.
rush_yds	integer	—	0	Career rushing yards.
season	integer	—	2022	Calendar year of the draft.
seasons_started	integer	—	0	Number of NFL seasons in which the player was a primary starter.
side	string	—	O	Side of the ball (`OFF` or `DEF`). Values`ODS`
w_av	integernullable	—	0	Weighted Approximate Value (Pro Football Reference career composite metric).

nfl.game_referees4 fields· 2 refsendpoints →

The officiating crew working each NFL game — who refereed, who umpired, who judged each part of the field.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	42276	—
referee_id	bigint	→ nfl.referees	30	—
position	string	—	Back Judge	— Values`Back JudgeRefereeDown JudgeLine JudgeField JudgeSide JudgeUmpireAlternate 1Alternate 2Alternate 4Alternate 3Alternate 5AlternateAlternate 7Alternate 6Replay OfficialAlternate 8`

nfl.game_weathers23 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	4992	—
stadium_id	bigint	→ nfl.stadiums	16	—
dew_point	floatnullable	—	52	Dew point (°F) at this interval.
feels_like_temperature	integernullable	—	72	—
field_condition	stringnullable	—	—	—
humidity	floatnullable	—	50	—
is_dome	boolean	—	false	— Values`falsetrue`
minutes_from_start	integer	—	0	Minutes from game start (0, 30, 60, 90, 120, 150)
precipitation	floatnullable	—	0	—
precipitation_probability	floatnullable	—	0	—
rain_accum	floatnullable	—	0	Cumulative liquid rain (inches) from 3 hours before kickoff through this interval.
recorded_at	timestamptz	—	2024-09-15T17:00:00.000Z	—
roof_status	stringnullable	—	Open	— Values`OpenDomeRetractable`
snow_accum	floatnullable	—	0	Cumulative snowfall (inches) from 3 hours before kickoff through this interval.
snow_depth	floatnullable	—	0	Snow depth on the ground (inches) at this interval.
snowfall	floatnullable	—	0	Snowfall rate (inches/hour) at this interval.
temperature	integernullable	—	72	—
weather_condition	stringnullable	—	INDOOR	— Values`INDOOROVERCASTCLEARDRIZZLEMAINLY_CLEARPARTLY_CLOUDYSNOWRAIN`
weather_description	stringnullable	—	Indoor stadium - controlled environment	— Values`Indoor stadium - controlled environmentOvercastClear skyMainly clearLight drizzlePartly cloudyModerate drizzleSlight snowSlight rainModerate rainModerate snowDense drizzleHeavy rainHeavy snow`
wind_direction	floatnullable	—	0	—
wind_gust	floatnullable	—	0	—
wind_speed	floatnullable	—	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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
game_id	bigint	→ nfl.games	151	—
player_id	bigint	→ nfl.players	936	—
season_id	bigint	→ nfl.seasons	2024	—
team_id	bigint	→ nfl.teams	4	—
date_modified	timestamptznullable	—	2024-11-08T19:11:50.000Z	Timestamp of the most recent NFL feed update for this report.
game_type	string	—	REG	Game classification for the upcoming game (`REG`, `WC`, `DIV`, `CON`, `SB`). Values`REGDIVCONWCSB`
position	string	—	LB	Position the player was listed at on the report. Values`LBWRCBTDTSDETERBGQBCKFBPLSUNKDBDL`
practice_primary_injury	stringnullable	—	Knee	Primary injury reported on the practice participation report.
practice_secondary_injury	stringnullable	—	Knee	Secondary injury reported on the practice participation report.
practice_status	stringnullable	—	Full Participation in Practice	Practice participation as long-form strings — `Did Not Participate In Practice`, `Limited Participation in Practice`, `Full Participation in Practice` (occasionally `Note` or blank). Values`Full Participation in PracticeDid Not Participate In PracticeLimited Participation in PracticeNote`
report_primary_injury	stringnullable	—	Knee	Primary injury body part listed on the official Wednesday/Thursday report (e.g., `Hamstring`, `Knee`).
report_secondary_injury	stringnullable	—	Knee	Secondary injury listed on the official injury report.
report_status	stringnullable	—	Questionable	Game-status designation (`Out`, `Doubtful`, `Questionable`; occasionally `Note` or blank when no designation was issued). Values`QuestionableOutDoubtfulNote`
week	integer	—	9	NFL 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.operator_player_lookups9 fields· 2 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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
operator_id	bigint	→ main.operators	5	Reference to main.operator entity
operator_player_id	string	—	6012	External player ID from operator
player_id	bigintnullable	→ nfl.players	2	Internal nfl.players.id reference
decided_at	timestamptznullable	—	—	When the pin or block was decided.
decided_reason	stringnullable	—	—	Evidence behind a pinned or blocked decision.
decision	stringnullable	—	derived	How this mapping was decided: 'derived' (finder answer, overwritable), 'pinned' (decided on evidence, trigger-protected), 'blocked' (no player we hold is this id; player_id NULL, never retried). DB default 'derived'; a BEFORE UPDATE trigger preserves non-derived rows.
player_name	stringnullable	—	Lamar Jackson	Player name as provided by operator
position	stringnullable	—	DB	Position as provided by operator Values`DBDLLBWRRBTEQBOLPKLS`

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.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
otc_id	string	—	9466	OverTheCap unique contract identifier (external).
player_id	bigint	→ nfl.players	1546	—
team_id	bigint	→ nfl.teams	25	—
apy	bigint	—	895000	Average annual value (APY) in U.S. dollars — total `value` divided by `years`.
apy_cap_pct	decimal	—	0.0040	APY as a percentage of the league salary cap in the signing year (0.0-100.0).
college	stringnullable	—	Florida State	—
date_of_birth	datenullable	—	—	—
guaranteed	bigint	—	0	Total guaranteed money over the life of the contract, in U.S. dollars.
height	stringnullable	—	6'3"	Height as reported by OverTheCap (e.g., `6-2`). Values`6'3"6'4"6'2"6'5"6'0"6'1"5'11"6'6"5'9"6'7"5'10"5'8"6'8"6'0'"`
inflated_apy	bigint	—	895000	`apy` adjusted to the most recent salary cap.
inflated_guaranteed	bigint	—	0	`guaranteed` adjusted to the most recent salary cap.
inflated_value	bigint	—	895000	`value` adjusted to the most recent salary cap, in U.S. dollars.
is_active	boolean	—	true	True for the player's currently-active contract; false for historical contracts.
player_page_url	stringnullable	—	https://overthecap.com/player/zach-wilson/9466/	Direct URL to the player's page on overthecap.com.
position	string	—	WR	Player position at the time the contract was signed. Values`WRCBEDSIDLLBTERBRTLTLGQBCRGKPFBLS`
season_history_json	stringnullable	—	—	JSON-encoded year-by-year cap-hit breakdown for the life of the contract (stored as a string).
value	bigint	—	895000	Total contract value in U.S. dollars as reported by OverTheCap.
weight	integernullable	—	205	Weight in pounds.
year_signed	integer	—	2022	Calendar year the contract was signed.
years	integer	—	4	Total contract length in years.

nfl.player_news22 fields· 4 refsendpoints →

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

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
external_id	stringnullable	—	sportsdata-214469	Unique identifier from the news provider.
game_id	bigintnullable	→ nfl.games	22360	Associated game ID when this news item relates to a specific game.
opponent_team_id	bigintnullable	→ nfl.teams	19	Opponent team ID when this news item relates to an upcoming or active game matchup.
player_id	bigintnullable	→ nfl.players	925	Player ID associated with the news report.
team_id	bigintnullable	→ nfl.teams	28	Team ID of the player at the time of publication.
ai_processed	boolean	—	false	Whether this story was generated or enriched via LLM summarization. Values`falsetrue`
analysis	stringnullable	—	—	Fantasy and tactical analysis of the news.
author	stringnullable	—	Staff	Reporter or author of the article.
category	stringnullable	—	injury	injury, transaction, lineup, general Values`injurytransactiongeneralcontractdepth_chartlineupsuspensiongeneral</category> <parameter name="event_type">GAME_PREVIEW_GENERAL`
content	stringnullable	—	The Kansas City Chiefs signed former Arizona Cardinals running back Emari Demercado to an undisclos…	Full text content of the news report.
description	stringnullable	—	Sam Darnold and the Seahawks prepare to face the Rams in the NFC Championship game. Rex Ryan and Ja…	Brief synopsis or summary of the news event.
first_reported_at	timestamptznullable	—	2026-09-07T01:22:45.000Z	Timestamp when this story was first reported before multi-source compaction.
link	stringnullable	—	https://www.espn.com/video/clip?id=47726158	URL link to the original article or source video.
news_time	timestamptz	—	2026-08-31T04:00:00.000Z	Publication timestamp of the news story.
priority	integer	—	5	Display priority score (1-10).
situational_impact	jsonbnullable	—	[object Object]	Structured situational impact assessment and fantasy implications for the player.
source	stringnullable	—	cbs_sports	Primary news source or publication. Values`cbs_sportssportsdataespnrotoql_sportsdatarotoworld`
sources	jsonbnullable	—	[object Object]	Source citations with source name, URL, author, and published timestamp.
status_enum	stringnullable	—	QUESTIONABLE	Standardized player status designation (RULED_OUT, DOUBTFUL, QUESTIONABLE, PROBABLE, CLEARED, MINUTES_LIMIT, MINUTES_LIFTED, STARTING, BENCHED, INACTIVE, ACTIVE, IR_PLACED, IR_ACTIVATED, TRADED, RELEASED, SIGNED, ROUTINE). Values`QUESTIONABLEACTIVESIGNEDRELEASEDINACTIVECLEAREDIR_PLACEDBENCHEDSTARTINGROUTINERULED_OUTPROBABLETRADEDIR_ACTIVATEDMINUTES_LIMITDOUBTFULUNSIGNED`
title	string	—	Dayo Odeyingbo (Achilles) questionable for Week 1 vs. Panthers	Headline of the news report.
urgency	stringnullable	—	ROUTINE	Urgency level of the news event (BREAKING_GAME_TIME, HIGH, MEDIUM, ROUTINE). Values`ROUTINEHIGHMEDIUMBREAKING_GAME_TIME`

nfl.team_news12 fields· 3 refsendpoints →

News and updates about NFL teams — game previews, coaching changes, front-office moves, and beat reports.

Field	Type	References	Example	Description
idkey	bigint	—	—	Primary Key
external_id	stringnullable	—	espn-nfl-49825684	Canonical external identifier for deduplication.
game_id	bigintnullable	→ nfl.games	43413	Associated game ID when news relates to a specific game.
opponent_team_id	bigintnullable	→ nfl.teams	18	Opponent team ID when news relates to an upcoming or completed game matchup.
team_id	bigint	→ nfl.teams	20	Team ID that this news event pertains to.
ai_processed	booleannullable	—	true	Whether this story was generated or enriched via LLM summarization.
category	stringnullable	—	transaction	game_preview, coaching, transaction, general Values`transactiongeneraldepth_chartgame_previewcoachingdraft`
news_time	timestamptz	—	2026-05-08T04:00:00.000Z	Publication timestamp of the team story.
sources	jsonbnullable	—	[object Object]	Source citations with publisher name, URL, author, and published timestamp.
summary	string	—	ESPN releases comprehensive preview coverage for the 2026 NFL regular season, featuring all 32 team…	Concise journalistic summary of the team news event.
title	string	—	Kendrick Law Out with ACL Knee Injury	Headline of the team news story.
urgency	stringnullable	—	ROUTINE	ROUTINE, MEDIUM, HIGH, BREAKING_GAME_TIME Values`ROUTINEMEDIUMHIGHBREAKING_GAME_TIME`