STAT-API

NFL GraphQL Reference

Every scheduled and played NFL game — preseason exhibitions, the 18-week regular season, and the playoffs from Wild Card weekend through the Super Bowl — plus the players, teams, coaching staffs, depth charts, injuries, betting markets, and play-by-play behind them.

Every GraphQL type, relation, and argument — generated from the served schema, so it can never disagree with the API. Root fields take the same filters as REST; requests are metered by rows resolved, nested lists included.

Main

seasonsNflSeasons
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.
Relations
  • coaching_staff_tenures[NflCoachingStaffTenures!]!nfl.coaching_staff_tenures rows whose season_id references this row.
  • coaching_staffs[NflCoachingStaffs!]!nfl.coaching_staffs rows whose season_id references this row.
  • game_lines[NflGameLines!]!nfl.game_lines rows whose season_id references this row.
  • games[NflGames!]!nfl.games rows whose season_id references this row.
  • injuries[NflInjuries!]!nfl.injuries rows whose season_id references this row.
  • playoffs[NflPlayoffs!]!nfl.playoffs rows whose season_id references this row.
  • season_player_firstdown_stats[NflSeasonPlayerFirstdownStats!]!nfl.season_player_firstdown_stats rows whose season_id references this row.
  • season_player_redzone_stats[NflSeasonPlayerRedzoneStats!]!nfl.season_player_redzone_stats rows whose season_id references this row.
  • season_player_stats[NflSeasonPlayerStats!]!nfl.season_player_stats rows whose season_id references this row.
  • season_player_thirddown_stats[NflSeasonPlayerThirddownStats!]!nfl.season_player_thirddown_stats rows whose season_id references this row.
  • season_team_stats[NflSeasonTeamStats!]!nfl.season_team_stats rows whose season_id references this row.
  • team_player_rosters[NflTeamPlayerRosters!]!nfl.team_player_rosters rows whose season_id references this row.
Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
Columns (10) — full docs in the data dictionary
id: BigInt
start_date: String
end_date: String
start_year: Int
regular_season_start_date: String
post_season_start_date: String
super_bowl_date: String
regular_season_weeks: Int
created_at: String
updated_at: String
teamsNflTeams
The 32 NFL franchises plus historical predecessors — teams that have since relocated, renamed, or merged into the current league.
Relations
  • stadiumNflStadiumsThe nfl.stadiums row referenced by stadium_id; null when unlinked.
  • game_player_thirddown_stats_by_team_id[NflGamePlayerThirddownStats!]!nfl.game_player_thirddown_stats rows whose team_id references this row.
  • game_player_firstdown_stats_by_team_id[NflGamePlayerFirstdownStats!]!nfl.game_player_firstdown_stats rows whose team_id references this row.
  • players[NflPlayers!]!nfl.players rows whose team_id references this row.
  • combine_results[NflCombineResults!]!nfl.combine_results rows whose team_id references this row.
  • player_contracts[NflPlayerContracts!]!nfl.player_contracts rows whose team_id references this row.
  • depth_chart_snapshots[NflDepthChartSnapshots!]!nfl.depth_chart_snapshots rows whose team_id references this row.
  • depth_charts[NflDepthCharts!]!nfl.depth_charts rows whose team_id references this row.
  • player_news[NflPlayerNews!]!nfl.player_news rows whose team_id references this row.
  • game_team_staffs[NflGameTeamStaffs!]!nfl.game_team_staffs rows whose team_id references this row.
  • coaching_staffs[NflCoachingStaffs!]!nfl.coaching_staffs rows whose team_id references this row.
  • coaching_staff_tenures[NflCoachingStaffTenures!]!nfl.coaching_staff_tenures rows whose team_id references this row.
  • injuries[NflInjuries!]!nfl.injuries rows whose team_id references this row.
  • game_player_ngs_passings[NflGamePlayerNgsPassings!]!nfl.game_player_ngs_passings rows whose team_id references this row.
  • game_player_ngs_rushings[NflGamePlayerNgsRushings!]!nfl.game_player_ngs_rushings rows whose team_id references this row.
  • game_player_ngs_receivings[NflGamePlayerNgsReceivings!]!nfl.game_player_ngs_receivings rows whose team_id references this row.
  • game_player_redzone_stats_by_team_id[NflGamePlayerRedzoneStats!]!nfl.game_player_redzone_stats rows whose team_id references this row.
  • operator_team_lookups[NflOperatorTeamLookups!]!nfl.operator_team_lookups rows whose team_id references this row.
  • game_player_pfr_advstats_by_team_id[NflGamePlayerPfrAdvstats!]!nfl.game_player_pfr_advstats rows whose team_id references this row.
  • game_team_rosters[NflGameTeamRosters!]!nfl.game_team_rosters rows whose team_id references this row.
  • team_player_rosters[NflTeamPlayerRosters!]!nfl.team_player_rosters rows whose team_id references this row.
  • draft_picks[NflDraftPicks!]!nfl.draft_picks rows whose team_id references this row.
  • season_team_stats[NflSeasonTeamStats!]!nfl.season_team_stats rows whose team_id references this row.
  • game_team_stats[NflGameTeamStats!]!nfl.game_team_stats rows whose team_id references this row.
  • game_player_stats_by_team_id[NflGamePlayerStats!]!nfl.game_player_stats rows whose team_id references this row.
  • games_by_home_team_id[NflGames!]!nfl.games rows whose home_team_id references this row.
  • games_by_away_team_id[NflGames!]!nfl.games rows whose away_team_id references this row.
  • game_drives[NflGameDrives!]!nfl.game_drives rows whose possession_team_id references this row.
  • play_by_plays_by_possession_team_id[NflPlayByPlays!]!nfl.play_by_plays rows whose possession_team_id references this row.
  • play_by_plays_by_defensive_team_id[NflPlayByPlays!]!nfl.play_by_plays rows whose defensive_team_id references this row.
  • game_player_stats_by_opponent_team_id[NflGamePlayerStats!]!nfl.game_player_stats rows whose opponent_team_id references this row.
  • game_player_firstdown_stats_by_opponent_team_id[NflGamePlayerFirstdownStats!]!nfl.game_player_firstdown_stats rows whose opponent_team_id references this row.
  • game_player_redzone_stats_by_opponent_team_id[NflGamePlayerRedzoneStats!]!nfl.game_player_redzone_stats rows whose opponent_team_id references this row.
  • game_player_thirddown_stats_by_opponent_team_id[NflGamePlayerThirddownStats!]!nfl.game_player_thirddown_stats rows whose opponent_team_id references this row.
  • game_player_pfr_advstats_by_opponent_team_id[NflGamePlayerPfrAdvstats!]!nfl.game_player_pfr_advstats rows whose opponent_team_id references this row.
  • playoffs_by_home_team_id[NflPlayoffs!]!nfl.playoffs rows whose home_team_id references this row.
  • playoffs_by_away_team_id[NflPlayoffs!]!nfl.playoffs rows whose away_team_id references this row.
  • playoffs_by_winner_team_id[NflPlayoffs!]!nfl.playoffs rows whose winner_team_id references this row.
Arguments (3)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • activeBooleanFilter by active status (defaults to true to show only currently-active rows; pass active=false to include inactive).
Columns (15) — full docs in the data dictionary
id: BigInt
abbreviation: String
city: String
league_team_id: String
conference: String
division: String
full_name: String
name: String
active: Boolean
stadium_id: BigInt
logo_url: String
primary_color: String
secondary_color: String
created_at: String
updated_at: String
playersNflPlayers
Every individual who has played in the NFL — current rosters, free agents, retired veterans — plus team-defense entries used for fantasy and DST scoring.
Required filters: one of team_id | roster_status | gsis_id | primary_position.
Relations
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • game_player_thirddown_stats[NflGamePlayerThirddownStats!]!nfl.game_player_thirddown_stats rows whose player_id references this row.
  • game_player_firstdown_stats[NflGamePlayerFirstdownStats!]!nfl.game_player_firstdown_stats rows whose player_id references this row.
  • season_player_firstdown_stats[NflSeasonPlayerFirstdownStats!]!nfl.season_player_firstdown_stats rows whose player_id references this row.
  • combine_results[NflCombineResults!]!nfl.combine_results rows whose player_id references this row.
  • player_contracts[NflPlayerContracts!]!nfl.player_contracts rows whose player_id references this row.
  • depth_chart_entries[NflDepthChartEntries!]!nfl.depth_chart_entries rows whose player_id references this row.
  • depth_charts[NflDepthCharts!]!nfl.depth_charts rows whose player_id references this row.
  • player_news[NflPlayerNews!]!nfl.player_news rows whose player_id references this row.
  • injuries[NflInjuries!]!nfl.injuries rows whose player_id references this row.
  • game_player_ngs_passings[NflGamePlayerNgsPassings!]!nfl.game_player_ngs_passings rows whose player_id references this row.
  • game_player_ngs_rushings[NflGamePlayerNgsRushings!]!nfl.game_player_ngs_rushings rows whose player_id references this row.
  • game_player_ngs_receivings[NflGamePlayerNgsReceivings!]!nfl.game_player_ngs_receivings rows whose player_id references this row.
  • season_player_redzone_stats[NflSeasonPlayerRedzoneStats!]!nfl.season_player_redzone_stats rows whose player_id references this row.
  • game_player_redzone_stats[NflGamePlayerRedzoneStats!]!nfl.game_player_redzone_stats rows whose player_id references this row.
  • operator_player_lookups[NflOperatorPlayerLookups!]!nfl.operator_player_lookups rows whose player_id references this row.
  • game_player_pfr_advstats[NflGamePlayerPfrAdvstats!]!nfl.game_player_pfr_advstats rows whose player_id references this row.
  • game_team_rosters[NflGameTeamRosters!]!nfl.game_team_rosters rows whose player_id references this row.
  • team_player_rosters[NflTeamPlayerRosters!]!nfl.team_player_rosters rows whose player_id references this row.
  • draft_picks[NflDraftPicks!]!nfl.draft_picks rows whose player_id references this row.
  • season_player_thirddown_stats[NflSeasonPlayerThirddownStats!]!nfl.season_player_thirddown_stats rows whose player_id references this row.
  • season_player_stats[NflSeasonPlayerStats!]!nfl.season_player_stats rows whose player_id references this row.
  • game_player_stats[NflGamePlayerStats!]!nfl.game_player_stats rows whose player_id references this row.
  • play_by_plays_by_passer_id[NflPlayByPlays!]!nfl.play_by_plays rows whose passer_id references this row.
  • play_by_plays_by_rusher_id[NflPlayByPlays!]!nfl.play_by_plays rows whose rusher_id references this row.
  • play_by_plays_by_receiver_id[NflPlayByPlays!]!nfl.play_by_plays rows whose receiver_id references this row.
Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • roster_statusStringFilter by canonical roster status (shared cross-league vocabulary). The "on a team now" set is {active, injured_reserve, practice_squad, reserve, suspended}.
  • gsis_idStringFilter by GSIS external player id.
  • primary_positionStringFilter by player primary position (e.g. QB, WR, RB).
Columns (29) — full docs in the data dictionary
id: BigInt
first_name: String
last_name: String
full_name: String
league_player_id: String
jersey: String
gsis_id: String
primary_position: String
position_group: String
full_position_list: String
team_id: BigInt
nfl_slug: String
height: Int
weight: Int
birth_date: String
birth_city: String
birth_state: String
birth_country: String
college: String
experience: Int
draft_year: String
draft_round: String
draft_number: String
overall_pick: Int
roster_status: String
profile_pic_url: String
is_team: Boolean
created_at: String
updated_at: String
gamesNflGames
Every scheduled and played NFL game — preseason exhibitions, the 18-week regular season, the playoffs from Wild Card weekend through the Super Bowl.
Required filters: one of season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • home_team_refNflTeamsThe nfl.teams row referenced by home_team_id; null when unlinked.
  • away_team_refNflTeamsThe nfl.teams row referenced by away_team_id; null when unlinked.
  • stadiumNflStadiumsThe nfl.stadiums row referenced by stadium_id; null when unlinked.
  • game_player_thirddown_stats[NflGamePlayerThirddownStats!]!nfl.game_player_thirddown_stats rows whose game_id references this row.
  • game_player_firstdown_stats[NflGamePlayerFirstdownStats!]!nfl.game_player_firstdown_stats rows whose game_id references this row.
  • depth_charts[NflDepthCharts!]!nfl.depth_charts rows whose game_id references this row.
  • game_weathers[NflGameWeathers!]!nfl.game_weathers rows whose game_id references this row.
  • game_referees[NflGameReferees!]!nfl.game_referees rows whose game_id references this row.
  • game_team_staffs[NflGameTeamStaffs!]!nfl.game_team_staffs rows whose game_id references this row.
  • game_lines[NflGameLines!]!nfl.game_lines rows whose game_id references this row.
  • injuries[NflInjuries!]!nfl.injuries rows whose game_id references this row.
  • game_player_ngs_passings[NflGamePlayerNgsPassings!]!nfl.game_player_ngs_passings rows whose game_id references this row.
  • game_player_ngs_rushings[NflGamePlayerNgsRushings!]!nfl.game_player_ngs_rushings rows whose game_id references this row.
  • game_player_ngs_receivings[NflGamePlayerNgsReceivings!]!nfl.game_player_ngs_receivings rows whose game_id references this row.
  • game_player_redzone_stats[NflGamePlayerRedzoneStats!]!nfl.game_player_redzone_stats rows whose game_id references this row.
  • play_participations[NflPlayParticipations!]!nfl.play_participations rows whose game_id references this row.
  • game_player_pfr_advstats[NflGamePlayerPfrAdvstats!]!nfl.game_player_pfr_advstats rows whose game_id references this row.
  • game_drives[NflGameDrives!]!nfl.game_drives rows whose game_id references this row.
  • play_by_plays[NflPlayByPlays!]!nfl.play_by_plays rows whose game_id references this row.
  • game_team_rosters[NflGameTeamRosters!]!nfl.game_team_rosters rows whose game_id references this row.
  • game_team_stats[NflGameTeamStats!]!nfl.game_team_stats rows whose game_id references this row.
  • game_player_stats[NflGamePlayerStats!]!nfl.game_player_stats rows whose game_id references this row.
Arguments (11)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • weekIntFilter by week of the season.
  • week__gteIntgte comparison on week.
  • week__lteIntlte comparison on week.
  • week__betweenStringRange filter on week — pass "lo,hi".
  • season_typeStringFilter by season phase. Postseason round detail is in playoff_round.
  • home_team_idIntFilter by home team.
  • away_team_idIntFilter by away team.
  • statusStringFilter by row status.
Columns (33) — full docs in the data dictionary
id: BigInt
season_id: BigInt
game_time: String
league_game_id: String
home_team_id: BigInt
away_team_id: BigInt
type: String
status: String
start_time: String
end_time: String
season_type: String
week: Int
day: Int
away_team: String
home_team: String
stadium_id: Int
channel: String
attendance: Int
away_team_score: Int
home_team_score: Int
home_rotation_number: Int
away_rotation_number: Int
neutral_venue: Boolean
playoff_round: String
playoff_seed_home: Int
playoff_seed_away: Int
game_label: String
game_sub_label: String
postponed_status: String
overtime: Boolean
overtime_periods: Int
created_at: String
updated_at: String

Plays

game_drivesNflGameDrives
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.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • possession_teamNflTeamsThe nfl.teams row referenced by possession_team_id; null when unlinked.
  • first_playNflPlayByPlaysThe nfl.play_by_plays row referenced by first_play_id; null when unlinked.
  • last_playNflPlayByPlaysThe nfl.play_by_plays row referenced by last_play_id; null when unlinked.
  • play_by_plays[NflPlayByPlays!]!nfl.play_by_plays rows whose drive_id references this row.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • possession_team_idIntFilter by team in possession.
Columns (24) — full docs in the data dictionary
id: BigInt
game_id: BigInt
possession_team_id: BigInt
drive_number: Int
fixed_drive: Int
quarter_start: Int
quarter_end: Int
start_transition: String
end_transition: String
result: String
start_yard_line: String
end_yard_line: String
game_clock_start: String
game_clock_end: String
time_of_possession: String
play_count: Int
first_downs: Int
yds_penalized: Int
inside_20: Boolean
ended_with_score: Boolean
first_play_id: BigInt
last_play_id: BigInt
created_at: String
updated_at: String
play_by_playsNflPlayByPlays
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.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • passer_refNflPlayersThe nfl.players row referenced by passer_id; null when unlinked.
  • rusher_refNflPlayersThe nfl.players row referenced by rusher_id; null when unlinked.
  • receiver_refNflPlayersThe nfl.players row referenced by receiver_id; null when unlinked.
  • possession_teamNflTeamsThe nfl.teams row referenced by possession_team_id; null when unlinked.
  • defensive_teamNflTeamsThe nfl.teams row referenced by defensive_team_id; null when unlinked.
  • drive_refNflGameDrivesThe nfl.game_drives row referenced by drive_id; null when unlinked.
  • game_drives_by_first_play_id[NflGameDrives!]!nfl.game_drives rows whose first_play_id references this row.
  • game_drives_by_last_play_id[NflGameDrives!]!nfl.game_drives rows whose last_play_id references this row.
Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game. Required — querying NFL play-by-play across all games is impractical (millions of rows).
  • possession_team_idIntFilter by team in possession.
  • defensive_team_idIntFilter by team on defense.
  • drive_idIntFilter by drive.
Columns (374) — full docs in the data dictionary
id: BigInt
play_id: String
game_id: BigInt
nflverse_game_id: String
old_game_id: String
nfl_api_id: String
quarter: Int
quarter_seconds_remaining: Int
half_seconds_remaining: Int
game_seconds_remaining: Int
game_half: String
quarter_end: Boolean
time: String
play_clock: Int
start_time: String
time_of_day: String
end_clock_time: String
order_sequence: Float
home_team: String
away_team: String
posteam: String
posteam_type: String
defteam: String
possession_team_id: BigInt
defensive_team_id: BigInt
side_of_field: String
yardline_100: Int
yrdln: String
yard_line: Int
end_yard_line: String
down: Int
ydstogo: Int
goal_to_go: Boolean
ydsnet: Int
drive: Int
drive_id: BigInt
fixed_drive: Int
fixed_drive_result: String
sp: Boolean
drive_real_start_time: String
drive_play_count: Int
drive_time_of_possession: String
drive_first_downs: Int
drive_inside20: Boolean
drive_ended_with_score: Boolean
drive_quarter_start: Int
drive_quarter_end: Int
drive_yds_penalized: Int
drive_start_transition: String
drive_end_transition: String
drive_game_clock_start: String
drive_game_clock_end: String
drive_start_yard_line: String
drive_end_yard_line: String
drive_play_id_started: String
drive_play_id_ended: String
series: Int
series_success: Boolean
series_result: String
desc: String
play_type: String
play_type_nfl: String
special_teams_play: Boolean
st_play_type: String
play: Boolean
special: Boolean
aborted_play: Boolean
play_deleted: Boolean
shotgun: Boolean
no_huddle: Boolean
qb_dropback: Boolean
rush_attempt: Boolean
rush: Boolean
run_location: String
run_gap: String
yds_gained: Int
rushing_yds: Int
rusher_player_id: String
rusher_player_name: String
rusher_jersey_number: Int
rusher_id: BigInt
lateral_rusher_player_id: String
lateral_rusher_player_name: String
lateral_rushing_yds: Int
lateral_rush: Boolean
pass_attempt: Boolean
pass: Boolean
pass_length: String
pass_location: String
air_yds: Int
yds_after_catch: Int
complete_pass: Boolean
incomplete_pass: Boolean
passing_yds: Int
passer_player_id: String
passer_player_name: String
passer_jersey_number: Int
passer_id: BigInt
passer: String
receiver_player_id: String
receiver_player_name: String
receiver_jersey_number: Int
receiver_id: BigInt
receiver: String
receiving_yds: Int
lateral_receiver_player_id: String
lateral_receiver_player_name: String
lateral_receiving_yds: Int
lateral_reception: Boolean
qb_scramble: Boolean
qb_kneel: Boolean
qb_spike: Boolean
qb_hit: Boolean
qb_hit_1_player_id: String
qb_hit_1_player_name: String
qb_hit_2_player_id: String
qb_hit_2_player_name: String
sack: Boolean
sack_player_id: String
sack_player_name: String
half_sack_1_player_id: String
half_sack_1_player_name: String
half_sack_2_player_id: String
half_sack_2_player_name: String
lateral_sack_player_id: String
lateral_sack_player_name: String
interception: Boolean
interception_player_id: String
interception_player_name: String
lateral_interception_player_id: String
lateral_interception_player_name: String
fumble: Boolean
fumble_forced: Boolean
fumble_not_forced: Boolean
fumble_out_of_bounds: Boolean
fumble_lost: Boolean
fumbled_1_player_id: String
fumbled_1_player_name: String
fumbled_1_team: String
fumbled_2_player_id: String
fumbled_2_player_name: String
fumbled_2_team: String
fumble_recovery_1_team: String
fumble_recovery_1_yds: Int
fumble_recovery_1_player_id: String
fumble_recovery_1_player_name: String
fumble_recovery_2_team: String
fumble_recovery_2_yds: Int
fumble_recovery_2_player_id: String
fumble_recovery_2_player_name: String
forced_fumble_player_1_team: String
forced_fumble_player_1_player_id: String
forced_fumble_player_1_player_name: String
forced_fumble_player_2_team: String
forced_fumble_player_2_player_id: String
forced_fumble_player_2_player_name: String
solo_tackle: Boolean
solo_tackle_1_player_id: String
solo_tackle_1_player_name: String
solo_tackle_1_team: String
solo_tackle_2_player_id: String
solo_tackle_2_player_name: String
solo_tackle_2_team: String
assist_tackle: Boolean
assist_tackle_1_player_id: String
assist_tackle_1_player_name: String
assist_tackle_1_team: String
assist_tackle_2_player_id: String
assist_tackle_2_player_name: String
assist_tackle_2_team: String
assist_tackle_3_player_id: String
assist_tackle_3_player_name: String
assist_tackle_3_team: String
assist_tackle_4_player_id: String
assist_tackle_4_player_name: String
assist_tackle_4_team: String
tackle_with_assist: Boolean
tackle_with_assist_1_player_id: String
tackle_with_assist_1_player_name: String
tackle_with_assist_1_team: String
tackle_with_assist_2_player_id: String
tackle_with_assist_2_player_name: String
tackle_with_assist_2_team: String
tackled_for_loss: Boolean
tackle_for_loss_1_player_id: String
tackle_for_loss_1_player_name: String
tackle_for_loss_2_player_id: String
tackle_for_loss_2_player_name: String
pass_defense_1_player_id: String
pass_defense_1_player_name: String
pass_defense_2_player_id: String
pass_defense_2_player_name: String
field_goal_attempt: Boolean
field_goal_result: String
kick_distance: Int
kicker_player_id: String
kicker_player_name: String
blocked_player_id: String
blocked_player_name: String
extra_point_attempt: Boolean
extra_point_result: String
two_point_attempt: Boolean
two_point_conv_result: String
defensive_two_point_attempt: Boolean
defensive_two_point_conv: Boolean
defensive_extra_point_attempt: Boolean
defensive_extra_point_conv: Boolean
kickoff_attempt: Boolean
kickoff_returner_player_id: String
kickoff_returner_player_name: String
kickoff_inside_twenty: Boolean
kickoff_in_endzone: Boolean
kickoff_out_of_bounds: Boolean
kickoff_downed: Boolean
kickoff_fair_catch: Boolean
lateral_kickoff_returner_player_id: String
lateral_kickoff_returner_player_name: String
own_kickoff_recovery: Boolean
own_kickoff_recovery_td: Boolean
own_kickoff_recovery_player_id: String
own_kickoff_recovery_player_name: String
punt_attempt: Boolean
punter_player_id: String
punter_player_name: String
punt_returner_player_id: String
punt_returner_player_name: String
punt_blocked: Boolean
punt_inside_twenty: Boolean
punt_in_endzone: Boolean
punt_out_of_bounds: Boolean
punt_downed: Boolean
punt_fair_catch: Boolean
lateral_punt_returner_player_id: String
lateral_punt_returner_player_name: String
return_team: String
return_yds: Int
lateral_return: Boolean
touchdown: Boolean
pass_touchdown: Boolean
rush_touchdown: Boolean
return_touchdown: Boolean
td_team: String
td_player_name: String
td_player_id: String
safety: Boolean
safety_player_name: String
safety_player_id: String
touchback: Boolean
out_of_bounds: Boolean
first_down: Boolean
first_down_rush: Boolean
first_down_pass: Boolean
first_down_penalty: Boolean
third_down_converted: Boolean
third_down_failed: Boolean
fourth_down_converted: Boolean
fourth_down_failed: Boolean
penalty: Boolean
penalty_team: String
penalty_player_id: String
penalty_player_name: String
penalty_yds: Int
penalty_type: String
replay_or_challenge: Boolean
replay_or_challenge_result: String
timeout: Boolean
timeout_team: String
home_timeouts_remaining: Int
away_timeouts_remaining: Int
posteam_timeouts_remaining: Int
defteam_timeouts_remaining: Int
total_home_score: Int
total_away_score: Int
posteam_score: Int
defteam_score: Int
score_differential: Int
posteam_score_post: Int
defteam_score_post: Int
score_differential_post: Int
home_score: Int
away_score: Int
no_score_prob: Float
opp_fg_prob: Float
opp_safety_prob: Float
opp_td_prob: Float
fg_prob: Float
safety_prob: Float
td_prob: Float
extra_point_prob: Float
two_point_conversion_prob: Float
ep: Float
epa: Float
total_home_epa: Float
total_away_epa: Float
total_home_rush_epa: Float
total_away_rush_epa: Float
total_home_pass_epa: Float
total_away_pass_epa: Float
air_epa: Float
yac_epa: Float
comp_air_epa: Float
comp_yac_epa: Float
total_home_comp_air_epa: Float
total_away_comp_air_epa: Float
total_home_comp_yac_epa: Float
total_away_comp_yac_epa: Float
total_home_raw_air_epa: Float
total_away_raw_air_epa: Float
total_home_raw_yac_epa: Float
total_away_raw_yac_epa: Float
qb_epa: Float
xyac_epa: Float
xyac_mean_yardage: Float
xyac_median_yardage: Float
xyac_success: Float
xyac_fd: Float
wp: Float
def_wp: Float
home_wp: Float
away_wp: Float
wpa: Float
vegas_wpa: Float
vegas_home_wpa: Float
home_wp_post: Float
away_wp_post: Float
vegas_wp: Float
vegas_home_wp: Float
total_home_rush_wpa: Float
total_away_rush_wpa: Float
total_home_pass_wpa: Float
total_away_pass_wpa: Float
air_wpa: Float
yac_wpa: Float
comp_air_wpa: Float
comp_yac_wpa: Float
total_home_comp_air_wpa: Float
total_away_comp_air_wpa: Float
total_home_comp_yac_wpa: Float
total_away_comp_yac_wpa: Float
total_home_raw_air_wpa: Float
total_away_raw_air_wpa: Float
total_home_raw_yac_wpa: Float
total_away_raw_yac_wpa: Float
cp: Float
cpoe: Float
xpass: Float
pass_oe: Float
success: Boolean
name: String
jersey_number: Int
primary_player_gsis_id: String
fantasy_player_name: String
fantasy_player_id: String
fantasy: String
fantasy_id: String
stadium: String
stadium_id: Int
game_stadium: String
location: String
roof: String
surface: String
temp: Int
wind: Int
weather: String
home_coach: String
away_coach: String
div_game: Boolean
spread_line: Float
total_line: Float
result: Int
total: Int
home_opening_kickoff: Boolean
created_at: String
updated_at: String
play_participationsNflPlayParticipations
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.
Required filters: one of play_id | game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • play_idStringFilter by play.
  • game_idIntFilter to a single game.
  • possession_team_idIntFilter by team in possession.
Columns (22) — full docs in the data dictionary
id: BigInt
play_id: String
game_id: BigInt
possession_team_id: BigInt
offense_formation: String
offense_personnel: String
defenders_in_box: Int
defense_personnel: String
number_of_pass_rushers: Int
players_on_play_gsis_ids: String
offense_players_gsis_ids: String
defense_players_gsis_ids: String
n_offense: Int
n_defense: Int
ngs_air_yds: Float
time_to_throw: Float
was_pressure: Boolean
route: String
defense_man_zone_type: String
defense_coverage_type: String
created_at: String
updated_at: String

Stats

operator_team_lookupsNflOperatorTeamLookups
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.
Required filters: one of operator_id.
Relations
  • operatorReferenceOperatorsThe main.operators row referenced by operator_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • operator_idIntFilter by sportsbook / operator.
  • team_idIntFilter by team.
Columns (8) — full docs in the data dictionary
id: BigInt
operator_id: BigInt
operator_team_id: String
team_id: BigInt
team_name: String
abbreviation: String
created_at: String
updated_at: String
season_team_statsNflSeasonTeamStats
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.
Required filters: one of season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
Columns (34) — full docs in the data dictionary
id: BigInt
team_id: BigInt
season_id: BigInt
games_played: Int
wins: Int
losses: Int
ties: Int
pts_scored: Int
pts_allowed: Int
total_yds: Int
passing_yds: Int
rushing_yds: Int
completions: Int
pass_attempts: Int
passing_tds: Int
rushing_tds: Int
first_downs: Int
red_zone_attempts: Int
red_zone_conversions: Int
third_down_conversions: Int
third_down_attempts: Int
fourth_down_conversions: Int
fourth_down_attempts: Int
turnovers: Int
defensive_sacks: Float
defensive_interceptions: Int
fumbles_recovered: Int
defensive_tds: Int
field_goals_made: Int
field_goals_attempted: Int
extra_pts_made: Int
extra_pts_attempted: Int
created_at: String
updated_at: String
game_player_firstdown_statsNflGamePlayerFirstdownStats
Per-game player stats restricted to first-down plays — the same first-down production breakouts as the season aggregate, for each individual game.
Required filters: one of game_id | player_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • opponent_teamNflTeamsThe nfl.teams row referenced by opponent_team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • opponent_team_idIntFilter by opponent team.
  • positionStringFilter by player position.
Columns (56) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
opponent_team_id: BigInt
is_home: Boolean
position: String
passing_attempts: Int
passing_completions: Int
passing_yds: Int
passing_tds: Int
passing_interceptions: Int
passing_rating: Float
passing_completion_percentage: Float
passing_yds_per_attempt: Float
passing_yds_per_completion: Float
passing_long: Int
passing_sacks: Int
passing_sack_yds: Int
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
rushing_yds_per_attempt: Float
rushing_long: Int
targets: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
receiving_yds_per_reception: Float
receiving_long: Int
reception_percentage: Float
receiving_yds_per_target: Float
fumbles: Int
fumbles_lost: Int
offensive_tds: Int
total_tds: Int
two_pt_pass_conversions: Int
two_pt_rush_conversions: Int
two_pt_reception_conversions: Int
offensive_snaps: Int
created_at: String
updated_at: String
solo_tackles: Int
assisted_tackles: Int
tackles_for_loss: Int
sacks: Float
quarterback_hits: Int
passes_defended: Int
interceptions: Int
interception_yds: Int
interception_tds: Int
forced_fumbles: Int
fumbles_recovered: Int
fumble_recovery_yds: Int
fumble_recovery_tds: Int
defensive_tds: Int
game_player_ngs_passingsNflGamePlayerNgsPassings
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.
Required filters: one of game_id | player_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • seasonIntFilter by season start year.
  • weekIntFilter by week of the season.
Columns (28) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
season: Int
week: Int
season_type: String
avg_time_to_throw: Float
avg_completed_air_yds: Float
avg_intended_air_yds: Float
avg_air_yds_differential: Float
aggressiveness: Float
max_completed_air_distance: Float
avg_air_yds_to_sticks: Float
avg_air_distance: Float
max_air_distance: Float
expected_completion_percentage: Float
completion_percentage_above_expectation: Float
attempts: Int
completions: Int
completion_percentage: Float
pass_yds: Int
pass_tds: Int
interceptions: Int
passer_rating: Float
player_gsis_id: String
created_at: String
updated_at: String
game_player_ngs_receivingsNflGamePlayerNgsReceivings
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.
Required filters: one of game_id | player_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • seasonIntFilter by season start year.
  • weekIntFilter by week of the season.
Columns (22) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
season: Int
week: Int
season_type: String
avg_cushion: Float
avg_separation: Float
avg_intended_air_yds: Float
percent_share_of_intended_air_yds: Float
avg_yac: Float
avg_expected_yac: Float
avg_yac_above_expectation: Float
targets: Int
receptions: Int
catch_percentage: Float
yards: Int
rec_tds: Int
player_gsis_id: String
created_at: String
updated_at: String
game_player_ngs_rushingsNflGamePlayerNgsRushings
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.
Required filters: one of game_id | player_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • seasonIntFilter by season start year.
  • weekIntFilter by week of the season.
Columns (21) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
season: Int
week: Int
season_type: String
efficiency: Float
percent_attempts_gte_eight_defenders: Float
avg_time_to_los: Float
expected_rush_yds: Float
rush_yds_over_expected: Float
rush_yds_over_expected_per_att: Float
rush_pct_over_expected: Float
rush_attempts: Int
rush_yds: Int
avg_rush_yds: Float
rush_tds: Int
player_gsis_id: String
created_at: String
updated_at: String
game_player_pfr_advstatsNflGamePlayerPfrAdvstats
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.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • opponent_teamNflTeamsThe nfl.teams row referenced by opponent_team_id; null when unlinked.
Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • opponent_team_idIntFilter by opponent team.
Columns (48) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
opponent_team_id: BigInt
passing_drops: Int
passing_drop_pct: Float
receiving_drop: Int
receiving_drop_pct: Float
passing_bad_throws: Int
passing_bad_throw_pct: Float
times_sacked: Int
times_blitzed: Int
times_hurried: Int
times_hit: Int
times_pressured: Int
times_pressured_pct: Float
carries: Int
rushing_yds_before_contact: Int
rushing_yds_before_contact_avg: Float
rushing_yds_after_contact: Int
rushing_yds_after_contact_avg: Float
rushing_broken_tackles: Int
receiving_broken_tackles: Int
receiving_int: Int
receiving_rat: Float
def_ints: Int
def_targets: Int
def_completions_allowed: Int
def_completion_pct: Float
def_yds_allowed: Int
def_yds_allowed_per_cmp: Float
def_yds_allowed_per_tgt: Float
def_receiving_td_allowed: Int
def_passer_rating_allowed: Float
def_adot: Float
def_air_yds_completed: Int
def_yds_after_catch: Int
def_times_blitzed: Int
def_times_hurried: Int
def_times_hitqb: Int
def_sacks: Float
def_pressures: Int
def_tackles_combined: Int
def_missed_tackles: Int
def_missed_tackle_pct: Float
created_at: String
updated_at: String
game_player_redzone_statsNflGamePlayerRedzoneStats
Per-game player stats restricted to red-zone plays — the same red-zone breakouts as the season aggregate, for each individual game.
Required filters: one of game_id | player_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • opponent_teamNflTeamsThe nfl.teams row referenced by opponent_team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • opponent_team_idIntFilter by opponent team.
  • positionStringFilter by player position.
Columns (56) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
opponent_team_id: BigInt
is_home: Boolean
position: String
passing_attempts: Int
passing_completions: Int
passing_yds: Int
passing_tds: Int
passing_interceptions: Int
passing_rating: Float
passing_completion_percentage: Float
passing_yds_per_attempt: Float
passing_yds_per_completion: Float
passing_long: Int
passing_sacks: Int
passing_sack_yds: Int
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
rushing_yds_per_attempt: Float
rushing_long: Int
targets: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
receiving_yds_per_reception: Float
receiving_long: Int
reception_percentage: Float
receiving_yds_per_target: Float
fumbles: Int
fumbles_lost: Int
offensive_tds: Int
total_tds: Int
two_pt_pass_conversions: Int
two_pt_rush_conversions: Int
two_pt_reception_conversions: Int
offensive_snaps: Int
created_at: String
updated_at: String
solo_tackles: Int
assisted_tackles: Int
tackles_for_loss: Int
sacks: Float
quarterback_hits: Int
passes_defended: Int
interceptions: Int
interception_yds: Int
interception_tds: Int
forced_fumbles: Int
fumbles_recovered: Int
fumble_recovery_yds: Int
fumble_recovery_tds: Int
defensive_tds: Int
game_player_statsNflGamePlayerStats
Each NFL player's stat line for each game — every passing, rushing, receiving, defensive, special-teams, and scoring statistic recorded that day.
Required filters: one of game_id | player_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • opponent_teamNflTeamsThe nfl.teams row referenced by opponent_team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • opponent_team_idIntFilter by opponent team.
  • positionStringFilter by player position.
Columns (143) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
opponent_team_id: BigInt
is_home: Boolean
position: String
position_group: String
completions: Int
pass_attempts: Int
passing_yds: Int
passing_tds: Int
interceptions_thrown: Int
sacks_allowed: Int
sack_yds: Int
sack_fumbles: Int
sack_fumbles_lost: Int
passing_air_yds: Int
passing_yds_after_catch: Int
passing_first_downs: Int
passing_epa: Float
passing_2pt_conversions: Int
pacr: Float
dakota: Float
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
rushing_fumbles: Int
rushing_fumbles_lost: Int
rushing_first_downs: Int
rushing_epa: Float
rushing_2pt_conversions: Int
receptions: Int
targets: Int
receiving_yds: Int
receiving_tds: Int
receiving_fumbles: Int
receiving_fumbles_lost: Int
receiving_air_yds: Int
receiving_yds_after_catch: Int
receiving_first_downs: Int
receiving_epa: Float
receiving_2pt_conversions: Int
racr: Float
target_share: Float
air_yds_share: Float
wopr: Float
special_teams_tds: Int
fantasy_pts: Float
fantasy_pts_ppr: Float
passing_rating: Float
passing_long: Int
passing_completion_percentage: Float
rushing_long: Int
rushing_yds_per_attempt: Float
receiving_long: Int
receiving_yds_per_reception: Float
reception_percentage: Float
punt_returns: Int
punt_return_yds: Int
punt_return_tds: Int
punt_return_long: Int
kick_returns: Int
kick_return_yds: Int
kick_return_tds: Int
kick_return_long: Int
solo_tackles: Int
assisted_tackles: Int
tackles_for_loss: Int
defensive_sacks: Float
quarterback_hits: Int
passes_defended: Int
forced_fumbles: Int
fumbles_recovered: Int
defensive_interceptions: Int
interception_return_yds: Int
interception_return_tds: Int
safeties: Int
field_goals_made: Int
field_goals_attempted: Int
field_goal_percentage: Float
field_goals_longest: Int
field_goals_made_0_19: Int
field_goals_made_20_29: Int
field_goals_made_30_39: Int
field_goals_made_40_49: Int
field_goals_made_50_plus: Int
extra_pts_made: Int
extra_pts_attempted: Int
punts: Int
punt_yds: Int
punt_average: Float
punt_inside_20: Int
punt_touchbacks: Int
punt_long: Int
offensive_snaps: Int
defensive_snaps: Int
special_teams_snaps: Int
depth_position: String
depth_order: Int
created_at: String
updated_at: String
offensive_team_snaps: Int
defensive_team_snaps: Int
special_teams_team_snaps: Int
defensive_sack_yds: Int
fumble_return_yds: Int
fumble_return_tds: Int
blocked_kicks: Int
defensive_tds: Int
punt_return_avg: Float
punt_return_fair_catches: Int
kick_return_avg: Float
kick_return_fair_catches: Int
blocked_kick_return_yds: Int
blocked_kick_return_tds: Int
field_goal_return_yds: Int
field_goal_return_tds: Int
special_teams_solo_tackles: Int
special_teams_assisted_tackles: Int
special_teams_fumbles_forced: Int
special_teams_fumbles_recovered: Int
misc_solo_tackles: Int
misc_assisted_tackles: Int
misc_fumbles_forced: Int
misc_fumbles_recovered: Int
fumbles_own_recoveries: Int
fumbles_out_of_bounds: Int
field_goals_had_blocked: Int
extra_pts_had_blocked: Int
punt_net_average: Float
punts_had_blocked: Int
punt_net_yds: Int
two_pt_returns: Int
stadium: String
playing_surface: String
temperature: Int
humidity: Int
wind_speed: Int
punt_return_fumbles: Int
punt_return_fumbles_lost: Int
kick_return_fumbles: Int
kick_return_fumbles_lost: Int
game_player_thirddown_statsNflGamePlayerThirddownStats
Per-game player stats restricted to third-down plays — the same third-down breakouts as the season aggregate, for each individual game.
Required filters: one of game_id | player_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • opponent_teamNflTeamsThe nfl.teams row referenced by opponent_team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • opponent_team_idIntFilter by opponent team.
  • positionStringFilter by player position.
Columns (56) — full docs in the data dictionary
id: BigInt
game_id: BigInt
player_id: BigInt
team_id: BigInt
opponent_team_id: BigInt
is_home: Boolean
position: String
passing_attempts: Int
passing_completions: Int
passing_yds: Int
passing_tds: Int
passing_interceptions: Int
passing_rating: Float
passing_completion_percentage: Float
passing_yds_per_attempt: Float
passing_yds_per_completion: Float
passing_long: Int
passing_sacks: Int
passing_sack_yds: Int
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
rushing_yds_per_attempt: Float
rushing_long: Int
targets: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
receiving_yds_per_reception: Float
receiving_long: Int
reception_percentage: Float
receiving_yds_per_target: Float
fumbles: Int
fumbles_lost: Int
offensive_tds: Int
total_tds: Int
two_pt_pass_conversions: Int
two_pt_rush_conversions: Int
two_pt_reception_conversions: Int
offensive_snaps: Int
created_at: String
updated_at: String
solo_tackles: Int
assisted_tackles: Int
tackles_for_loss: Int
sacks: Float
quarterback_hits: Int
passes_defended: Int
interceptions: Int
interception_yds: Int
interception_tds: Int
forced_fumbles: Int
fumbles_recovered: Int
fumble_recovery_yds: Int
fumble_recovery_tds: Int
defensive_tds: Int
game_team_statsNflGameTeamStats
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.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
Columns (133) — full docs in the data dictionary
id: BigInt
game_id: BigInt
team_id: BigInt
is_home: Boolean
win: Int
loss: Int
tie: Int
pts: Int
total_yds: Int
passing_yds: Int
rushing_yds: Int
first_downs: Int
first_downs_passing: Int
first_downs_rushing: Int
first_downs_penalty: Int
third_down_conversions: Int
third_down_attempts: Int
third_down_percentage: Float
fourth_down_conversions: Int
fourth_down_attempts: Int
fourth_down_percentage: Float
completions: Int
pass_attempts: Int
completion_percentage: Float
yds_per_pass_attempt: Float
passing_tds: Int
interceptions_thrown: Int
sacks_allowed: Int
sack_yds: Int
passer_rating: Float
rushing_attempts: Int
yds_per_carry: Float
rushing_tds: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
tackles: Int
tackles_for_loss: Int
defensive_sacks: Int
quarterback_hits: Int
defensive_interceptions: Int
passes_defended: Int
forced_fumbles: Int
fumbles_recovered: Int
defensive_tds: Int
safeties: Int
turnovers: Int
fumbles_lost: Int
turnover_differential: Int
penalties: Int
penalty_yds: Int
time_of_possession: Int
red_zone_attempts: Int
red_zone_conversions: Int
red_zone_percentage: Float
field_goals_made: Int
field_goals_attempted: Int
field_goal_percentage: Float
extra_pts_made: Int
extra_pts_attempted: Int
two_point_conversions: Int
two_point_conversion_attempts: Int
punts: Int
punt_yds: Int
punt_average: Float
kick_return_yds: Int
kick_return_tds: Int
punt_return_yds: Int
punt_return_tds: Int
pts_allowed_dst: Int
pts_allowed_def: Int
blocked_kicks: Int
blocked_field_goals: Int
blocked_extra_pts: Int
blocked_punts: Int
offensive_team_snaps: Int
defensive_team_snaps: Int
special_teams_team_snaps: Int
score_q1: Int
score_q2: Int
score_q3: Int
score_q4: Int
score_ot: Int
offensive_plays: Int
offensive_yds: Int
yds_per_play: Float
touchdowns: Int
passing_dropbacks: Int
yds_per_completion: Float
interception_percentage: Float
rushing_yds_per_attempt: Float
punt_returns: Int
punt_return_long: Int
kick_returns: Int
kick_return_long: Int
total_return_yds: Int
kickoffs: Int
kickoffs_in_endzone: Int
kickoff_touchbacks: Int
punt_net_average: Float
punt_net_yds: Int
punts_blocked: Int
field_goals_blocked: Int
extra_pts_blocked: Int
interception_returns: Int
interception_return_yds: Int
interception_return_tds: Int
fumble_return_yds: Int
fumble_return_tds: Int
blocked_kick_return_yds: Int
blocked_kick_return_tds: Int
field_goal_return_yds: Int
field_goal_return_tds: Int
two_pt_pass_attempts: Int
two_pt_pass_conversions: Int
two_pt_rush_attempts: Int
two_pt_rush_conversions: Int
two_pt_conversion_returns: Int
point_differential: Int
qb_hits_differential: Int
tfl_differential: Int
sacks_differential: Int
penalty_yds_differential: Int
punt_return_yds_differential: Int
kick_return_yds_differential: Int
extra_pt_percentage: Float
punt_return_avg: Float
kick_return_avg: Float
tfl_percentage: Float
qb_hits_percentage: Float
sacked_percentage: Float
created_at: String
updated_at: String
operator_player_lookupsNflOperatorPlayerLookups
How each sportsbook and fantasy operator names every NFL player — the mapping from each operator's own player identifier to a unified player record.
Required filters: one of operator_id.
Relations
  • operatorReferenceOperatorsThe main.operators row referenced by operator_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • operator_idIntFilter by sportsbook / operator.
  • player_idIntFilter to a single player.
  • positionStringFilter by player position.
Columns (8) — full docs in the data dictionary
id: BigInt
operator_id: BigInt
operator_player_id: String
player_id: BigInt
player_name: String
position: String
created_at: String
updated_at: String
season_player_firstdown_statsNflSeasonPlayerFirstdownStats
Season player stats restricted to first-down plays — passing, rushing, and receiving production filtered to first-down attempts, useful for early-down efficiency analysis.
Required filters: one of season_id.
Relations
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
Columns (54) — full docs in the data dictionary
id: BigInt
player_id: BigInt
season_id: BigInt
games_played: Int
games_started: Int
passing_attempts: Int
passing_completions: Int
passing_yds: Int
passing_tds: Int
passing_interceptions: Int
passing_rating: Float
passing_completion_percentage: Float
passing_yds_per_attempt: Float
passing_yds_per_completion: Float
passing_long: Int
passing_sacks: Int
passing_sack_yds: Int
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
rushing_yds_per_attempt: Float
rushing_long: Int
targets: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
receiving_yds_per_reception: Float
receiving_long: Int
reception_percentage: Float
receiving_yds_per_target: Float
fumbles: Int
fumbles_lost: Int
offensive_tds: Int
total_tds: Int
two_pt_pass_conversions: Int
two_pt_rush_conversions: Int
two_pt_reception_conversions: Int
offensive_snaps: Int
created_at: String
updated_at: String
solo_tackles: Int
assisted_tackles: Int
tackles_for_loss: Int
sacks: Float
quarterback_hits: Int
passes_defended: Int
interceptions: Int
interception_yds: Int
interception_tds: Int
forced_fumbles: Int
fumbles_recovered: Int
fumble_recovery_yds: Int
fumble_recovery_tds: Int
defensive_tds: Int
season_player_redzone_statsNflSeasonPlayerRedzoneStats
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.
Required filters: one of season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
Columns (54) — full docs in the data dictionary
id: BigInt
player_id: BigInt
season_id: BigInt
games_played: Int
games_started: Int
passing_attempts: Int
passing_completions: Int
passing_yds: Int
passing_tds: Int
passing_interceptions: Int
passing_rating: Float
passing_completion_percentage: Float
passing_yds_per_attempt: Float
passing_yds_per_completion: Float
passing_long: Int
passing_sacks: Int
passing_sack_yds: Int
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
rushing_yds_per_attempt: Float
rushing_long: Int
targets: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
receiving_yds_per_reception: Float
receiving_long: Int
reception_percentage: Float
receiving_yds_per_target: Float
fumbles: Int
fumbles_lost: Int
offensive_tds: Int
total_tds: Int
two_pt_pass_conversions: Int
two_pt_rush_conversions: Int
two_pt_reception_conversions: Int
offensive_snaps: Int
created_at: String
updated_at: String
solo_tackles: Int
assisted_tackles: Int
tackles_for_loss: Int
sacks: Float
quarterback_hits: Int
passes_defended: Int
interceptions: Int
interception_yds: Int
interception_tds: Int
forced_fumbles: Int
fumbles_recovered: Int
fumble_recovery_yds: Int
fumble_recovery_tds: Int
defensive_tds: Int
season_player_statsNflSeasonPlayerStats
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.
Required filters: one of season_id | player_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
Columns (91) — full docs in the data dictionary
id: BigInt
player_id: BigInt
season_id: BigInt
games_played: Int
games_started: Int
completions: Int
pass_attempts: Int
passing_yds: Int
passing_tds: Int
interceptions_thrown: Int
sacks_taken: Int
sack_yds_lost: Int
sack_fumbles: Int
sack_fumbles_lost: Int
passing_air_yds: Int
passing_yds_after_catch: Int
passing_first_downs: Int
passing_long: Int
passer_rating: Float
completion_percentage: Float
yds_per_attempt: Float
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
yds_per_carry: Float
longest_rush: Int
fumbles_rushing: Int
rushing_fumbles_lost: Int
rushing_first_downs: Int
targets: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
yds_per_reception: Float
longest_reception: Int
fumbles_receiving: Int
receiving_fumbles_lost: Int
receiving_air_yds: Int
receiving_yds_after_catch: Int
receiving_first_downs: Int
tackles_solo: Int
tackles_assisted: Int
total_tackles: Int
tackles_for_loss: Int
sacks: Float
quarterback_hits: Int
interceptions_defense: Int
interception_return_yds: Int
interception_tds: Int
passes_defended: Int
forced_fumbles: Int
fumbles_recovered: Int
fumble_return_yds: Int
fumble_tds: Int
defensive_tds: Int
safeties: Int
field_goals_made: Int
field_goals_attempted: Int
field_goal_percentage: Float
field_goals_made_0_19: Int
field_goals_made_20_29: Int
field_goals_made_30_39: Int
field_goals_made_40_49: Int
field_goals_made_50_plus: Int
longest_field_goal: Int
extra_pts_made: Int
extra_pts_attempted: Int
punts: Int
punt_yds: Int
punt_average: Float
punt_net_average: Float
longest_punt: Int
punts_inside_20: Int
punt_touchbacks: Int
punts_blocked: Int
kick_returns: Int
kick_return_yds: Int
kick_return_average: Float
kick_return_tds: Int
longest_kick_return: Int
punt_returns: Int
punt_return_yds: Int
punt_return_average: Float
punt_return_tds: Int
special_teams_tds: Int
longest_punt_return: Int
fair_catches: Int
fumbles: Int
fumbles_lost: Int
created_at: String
updated_at: String
season_player_thirddown_statsNflSeasonPlayerThirddownStats
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.
Required filters: one of season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
Columns (54) — full docs in the data dictionary
id: BigInt
player_id: BigInt
season_id: BigInt
games_played: Int
games_started: Int
passing_attempts: Int
passing_completions: Int
passing_yds: Int
passing_tds: Int
passing_interceptions: Int
passing_rating: Float
passing_completion_percentage: Float
passing_yds_per_attempt: Float
passing_yds_per_completion: Float
passing_long: Int
passing_sacks: Int
passing_sack_yds: Int
rushing_attempts: Int
rushing_yds: Int
rushing_tds: Int
rushing_yds_per_attempt: Float
rushing_long: Int
targets: Int
receptions: Int
receiving_yds: Int
receiving_tds: Int
receiving_yds_per_reception: Float
receiving_long: Int
reception_percentage: Float
receiving_yds_per_target: Float
fumbles: Int
fumbles_lost: Int
offensive_tds: Int
total_tds: Int
two_pt_pass_conversions: Int
two_pt_rush_conversions: Int
two_pt_reception_conversions: Int
offensive_snaps: Int
created_at: String
updated_at: String
solo_tackles: Int
assisted_tackles: Int
tackles_for_loss: Int
sacks: Float
quarterback_hits: Int
passes_defended: Int
interceptions: Int
interception_yds: Int
interception_tds: Int
forced_fumbles: Int
fumbles_recovered: Int
fumble_recovery_yds: Int
fumble_recovery_tds: Int
defensive_tds: Int

Odds

game_linesNflGameLines
NFL game betting lines — point spreads, moneylines, and over/under totals. Currently one consensus closing line per game (nflverse-sourced; captured_at equals kickoff time); multi-snapshot open-to-close history is not yet captured. Regular-season games only.
Required filters: one of game_id | season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • operatorReferenceOperatorsThe main.operators row referenced by operator_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • operator_idIntFilter by sportsbook / operator.
Columns (20) — full docs in the data dictionary
id: BigInt
game_id: BigInt
season_id: BigInt
operator_id: BigInt
spread: Float
spread_home_odds: Int
spread_away_odds: Int
moneyline_home: Int
moneyline_away: Int
total: Float
over_odds: Int
under_odds: Int
implied_home_score: Float
implied_away_score: Float
implied_home_win_pct: Float
implied_away_win_pct: Float
captured_at: String
is_opening: Boolean
created_at: String
updated_at: String

Lineups & Roster

coaching_staff_tenuresNflCoachingStaffTenures
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).
Required filters: one of team_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • positionStringFilter by player position.
Columns (13) — full docs in the data dictionary
id: BigInt
team_id: BigInt
season_id: BigInt
position: String
full_name: String
first_name: String
last_name: String
effective_date: String
end_date: String
is_interim: Boolean
reason: String
created_at: String
updated_at: String
coaching_staffsNflCoachingStaffs
The coaching staff for each NFL team at a given season — head coach, offensive coordinator, defensive coordinator, special teams coordinator, and position coaches.
Required filters: one of season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • positionStringFilter by player position.
Columns (10) — full docs in the data dictionary
id: BigInt
team_id: BigInt
season_id: BigInt
first_name: String
last_name: String
full_name: String
position: String
experience: Int
created_at: String
updated_at: String
depth_chart_snapshotsNflDepthChartSnapshots
A team's full depth chart captured at a specific moment in the season — the season-opening baseline, plus any week the team published a fresh full chart. For the canonical per-game weekly chart use depth_charts instead; this snapshot/entry pair is the point-in-time scrape representation.
Required filters: one of team_id + season_id.
Relations
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • weekIntFilter by week of the season.
Columns (9) — full docs in the data dictionary
id: BigInt
team_id: BigInt
season_id: BigInt
snapshot_at: String
week: Int
is_baseline: Boolean
entry_count: Int
created_at: String
updated_at: String
depth_chart_entriesNflDepthChartEntries
Where each player sits on the depth chart — position, depth order (starter, second-string, backup), and the formation grouping (offense, defense, special teams). Child rows of depth_chart_snapshots; for the canonical per-game weekly chart use depth_charts instead.
Required filters: one of snapshot_id.
Relations
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • snapshot_idIntFilter by depth-chart snapshot.
  • player_idIntFilter to a single player.
  • positionStringFilter by player position.
Columns (10) — full docs in the data dictionary
id: BigInt
snapshot_id: BigInt
player_id: BigInt
position: String
depth_position: String
depth_order: Int
formation: String
jersey_number: Int
created_at: String
updated_at: String
depth_chartsNflDepthCharts
One player's depth-chart slot for a given team in a given NFL week — position, depth order (starter, backup, …), roster status, and game-type context. One row per (game × team × player × depth-position) combination.
Required filters: one of team_id.
Relations
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (8)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
  • season_idIntFilter to a single season.
  • weekIntFilter by week of the season.
  • player_idIntFilter to a single player.
  • positionStringFilter by player position.
Columns (17) — full docs in the data dictionary
id: BigInt
player_id: BigInt
game_id: BigInt
team_id: BigInt
season_id: BigInt
week: Int
game_type: String
depth_team: String
formation: String
jersey_number: Int
position: String
depth_position: String
elias_id: String
depth_order: Int
status: String
created_at: String
updated_at: String
game_team_rostersNflGameTeamRosters
The gameday roster for each NFL game — every player who suited up that day, who started, who was inactive, and at what position.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
  • player_idIntFilter to a single player.
  • positionStringFilter by player position.
  • statusStringFilter by game-roster status (readable single-word vocabulary; PracticeSquadReleased covers the nflverse TRC/TRD codes).
Columns (11) — full docs in the data dictionary
id: BigInt
game_id: BigInt
team_id: BigInt
player_id: BigInt
position: String
status: String
comment: String
starter: Boolean
day: Int
created_at: String
updated_at: String
game_team_staffsNflGameTeamStaffs
The coaching staff on the sideline for each NFL game — head coach, offensive coordinator, defensive coordinator, for both teams.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
Columns (8) — full docs in the data dictionary
id: BigInt
game_id: BigInt
team_id: BigInt
head_coach: String
offensive_coordinator: String
defensive_coordinator: String
created_at: String
updated_at: String
team_player_rostersNflTeamPlayerRosters
Day-by-day player-to-team affiliations across the season — who was on which roster, at what position, on every day from training camp through the Super Bowl.
Required filters: one of team_id + season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • player_idIntFilter to a single player.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • positionStringFilter by player position.
Columns (10) — full docs in the data dictionary
id: BigInt
team_id: BigInt
player_id: BigInt
season_id: BigInt
position: String
position_group: String
depth_order: Int
day: Int
created_at: String
updated_at: String

Misc

stadiumsNflStadiums
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.
Relations
  • teams[NflTeams!]!nfl.teams rows whose stadium_id references this row.
  • game_weathers[NflGameWeathers!]!nfl.game_weathers rows whose stadium_id references this row.
  • games[NflGames!]!nfl.games rows whose stadium_id references this row.
Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
Columns (22) — full docs in the data dictionary
id: BigInt
name: String
league_stadium_id: String
longitude: Float
latitude: Float
elevation: Float
orientation: Float
description: String
city: String
state: String
country: String
capacity: Int
surface: String
roof_type: String
opened_date: String
closed_date: String
team_name: String
timezone: String
address: String
image_url: String
created_at: String
updated_at: String
refereesNflReferees
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.
Relations
  • game_referees[NflGameReferees!]!nfl.game_referees rows whose referee_id references this row.
Arguments (3)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • activeBooleanFilter by active status (defaults to true to show only currently-active rows; pass active=false to include inactive).
Columns (10) — full docs in the data dictionary
id: BigInt
first_name: String
last_name: String
full_name: String
nfl_referee_id: Int
position: String
experience: Int
active: Boolean
created_at: String
updated_at: String
playoffsNflPlayoffs
The NFL postseason bracket — Wild Card weekend, the Divisional Round, the Conference Championships, and the Super Bowl, with seeds, scores, and outcomes.
Required filters: one of season_id | home_team_id | away_team_id | status.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • home_teamNflTeamsThe nfl.teams row referenced by home_team_id; null when unlinked.
  • away_teamNflTeamsThe nfl.teams row referenced by away_team_id; null when unlinked.
  • winner_teamNflTeamsThe nfl.teams row referenced by winner_team_id; null when unlinked.
Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • home_team_idIntFilter by home team.
  • away_team_idIntFilter by away team.
  • statusStringFilter by row status.
Columns (13) — full docs in the data dictionary
id: BigInt
season_id: BigInt
playoff_round: String
conference: String
home_team_id: BigInt
away_team_id: BigInt
home_team_seed: Int
away_team_seed: Int
game_number: Int
winner_team_id: BigInt
status: String
created_at: String
updated_at: String
combine_resultsNflCombineResults
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).
Required filters: one of player_id | season + position.
Relations
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • seasonIntFilter by season start year.
  • positionStringFilter by player position.
Columns (18) — full docs in the data dictionary
id: BigInt
player_id: BigInt
season: Int
team_id: BigInt
position: String
school: String
ht: String
wt: Int
forty: Float
bench: Int
vertical: Float
broad_jump: Int
cone: Float
shuttle: Float
pfr_id: String
cfb_id: String
created_at: String
updated_at: String
draft_picksNflDraftPicks
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).
Required filters: one of season.
Relations
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • seasonIntFilter by season start year.
  • roundIntFilter by draft round.
  • team_idIntFilter by team.
  • player_idIntFilter to a single player.
  • positionStringFilter by player position.
Columns (40) — full docs in the data dictionary
id: BigInt
season: Int
round: Int
pick: Int
team_id: BigInt
player_id: BigInt
gsis_id: String
pfr_player_id: String
cfb_player_id: String
pfr_player_name: String
is_hof: Boolean
position: String
category: String
side: String
college: String
age: Int
career_to_year: Int
allpro_count: Int
probowl_count: Int
seasons_started: Int
w_av: Int
car_av: Int
dr_av: Int
games_played: Int
pass_completions: Int
pass_attempts: Int
pass_yds: Int
pass_tds: Int
pass_ints: Int
rush_atts: Int
rush_yds: Int
rush_tds: Int
receptions: Int
rec_yds: Int
rec_tds: Int
def_solo_tackles: Int
def_ints: Int
def_sacks: Float
created_at: String
updated_at: String
game_refereesNflGameReferees
The officiating crew working each NFL game — who refereed, who umpired, who judged each part of the field.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • refereeNflRefereesThe nfl.referees row referenced by referee_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • referee_idIntFilter by referee.
  • positionStringFilter by crew position (e.g., Referee, Umpire).
Columns (6) — full docs in the data dictionary
id: BigInt
game_id: BigInt
referee_id: BigInt
position: String
created_at: String
updated_at: String
game_weathersNflGameWeathers
On-field weather throughout each NFL game — temperature, wind, humidity, and precipitation captured at fixed intervals from kickoff. Useful for outdoor-game performance analysis.
Required filters: one of game_id.
Relations
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • stadiumNflStadiumsThe nfl.stadiums row referenced by stadium_id; null when unlinked.
Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • stadium_idIntFilter by stadium.
Columns (20) — full docs in the data dictionary
id: BigInt
game_id: BigInt
stadium_id: BigInt
minutes_from_start: Int
temperature: Int
feels_like_temperature: Int
humidity: Float
wind_speed: Float
wind_direction: Float
wind_gust: Float
precipitation: Float
precipitation_probability: Float
weather_condition: String
weather_description: String
is_dome: Boolean
roof_status: String
field_condition: String
recorded_at: String
created_at: String
updated_at: String
injuriesNflInjuries
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.
Required filters: one of player_id | season_id.
Relations
  • seasonNflSeasonsThe nfl.seasons row referenced by season_id; null when unlinked.
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • gameNflGamesThe nfl.games row referenced by game_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (7)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
  • season_idIntFilter to a season by year (e.g., 2025 for the 2025-26 season). Defaults to the current season.
  • weekIntFilter by week of the season.
Columns (17) — full docs in the data dictionary
id: BigInt
player_id: BigInt
game_id: BigInt
team_id: BigInt
season_id: BigInt
week: Int
game_type: String
position: String
report_primary_injury: String
report_secondary_injury: String
report_status: String
practice_primary_injury: String
practice_secondary_injury: String
practice_status: String
date_modified: String
created_at: String
updated_at: String
player_contractsNflPlayerContracts
NFL player contracts — total value, average annual pay, guaranteed money, and salary cap impact for every signed deal, with cap-inflated comparisons across eras.
Required filters: one of player_id.
Relations
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • positionStringFilter by player position.
Columns (23) — full docs in the data dictionary
id: BigInt
player_id: BigInt
otc_id: String
team_id: BigInt
position: String
is_active: Boolean
year_signed: Int
years: Int
value: BigInt
apy: BigInt
guaranteed: BigInt
apy_cap_pct: Float
inflated_value: BigInt
inflated_apy: BigInt
inflated_guaranteed: BigInt
player_page_url: String
date_of_birth: String
height: String
weight: Int
college: String
season_history_json: String
created_at: String
updated_at: String
player_newsNflPlayerNews
News about NFL players — transactions, injuries, lineup announcements, suspensions, and general beat-reporter updates.
Required filters: one of player_id | team_id.
Relations
  • playerNflPlayersThe nfl.players row referenced by player_id; null when unlinked.
  • teamNflTeamsThe nfl.teams row referenced by team_id; null when unlinked.
Arguments (10)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • categoryStringFilter by category.
  • sourceStringFilter by source provider.
  • news_timeStringFilter by publication time (ISO 8601). Use news_time__gte to poll for items since your last check.
  • news_time__gteStringgte comparison on news_time.
  • news_time__lteStringlte comparison on news_time.
  • news_time__betweenStringRange filter on news_time — pass "lo,hi".
Columns (18) — full docs in the data dictionary
id: BigInt
player_id: BigInt
team_id: BigInt
title: String
description: String
analysis: String
source: String
news_time: String
priority: Int
created_at: String
updated_at: String
ai_processed: Boolean
situational_impact: JSON
content: String
author: String
category: String
external_id: String