STAT-APIGet your API key

Data Dictionary

Every table in the public API, its fields and types, and how it connects to the rest of the model. Foreign keys are shown both ways — what each table references and what references it.

Cross-sport betting and DFS rows point at an underlying event through a polymorphic (league_code, competition_id) pair, resolved through the main.competitions view — competition_id is a team-sport games.id or a golf.tournaments.id.

NFL40 tables

nfl.seasons10 fields· 14 referenced-byendpoints →

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.

References
—
FieldTypeDescription
idkeybigintPrimary Key
short_idstringShort identifier used by the NFL feed (e.g., `2024REG` for the 2024 regular season).
descriptionstringnullable—
end_datetimestamptznullableLast day of the season (Super Bowl date or shortly after).
post_season_start_datetimestamptznullableFirst day of the postseason (Wild Card weekend).
regular_season_start_datetimestamptznullableFirst day of regular-season play (typically the Thursday after Labor Day).
regular_season_weeksintegerNumber of regular-season weeks (18 since 2021; 17 in 2020 and earlier).
start_datetimestamptzFirst day of the season (typically the start of preseason in early August).
start_yearintegerCalendar year in which the season starts (e.g., 2025 = the 2025-26 season).
super_bowl_datetimestamptznullableDate of the Super Bowl for this season.
nfl.stadiums20 fields· 1 refs· 5 referenced-byendpoints →

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.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
league_stadium_idstringnullableOfficial NFL stadium ID from API
addressstringnullableStreet address of the stadium.
capacityintegernullableApproximate seating capacity for football configuration.
citystring—
closed_datetimestamptznullableDate the stadium closed (null if currently in use).
countrystringnullable—
descriptionstringnullable—
elevationfloatnullableElevation in feet above sea level
image_urlstringnullableURL to aerial/overview image of stadium
latitudefloatnullableLatitude of the stadium centroid (decimal degrees, WGS84).
longitudefloatnullableLongitude of the stadium centroid (decimal degrees, WGS84).
namestring—
opened_datetimestamptznullableDate the stadium opened for play.
orientationfloatnullableField orientation in degrees (0-360). Direction end zones face, measured from south end zone. 0/360=North, 90=East, 180=South, 270=West
roof_typestringnullableRoof type (e.g., `open`, `dome`, `retractable`).
statestringnullable—
surfacestringnullablePlaying surface type (e.g., `grass`, `FieldTurf`, `Astroturf`).
team_namestringnullableTeam commonly associated with this stadium at the time (display string, not a foreign key).
timezonestringnullableIANA timezone (e.g., America/New_York)
nfl.teams13 fields· 2 refs· 40 referenced-byendpoints →

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

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
league_team_idstringOfficial NFL team UUID from api.nfl.com
stadium_idbigintPrimary home stadium (FK to `stadiums`); null if unknown or shared.
abbreviationstringThree-letter team code (e.g., KC, NE, GB).
activebooleanTrue for currently-active franchises; false for relocated or defunct teams retained for historical references.
citystring—
conferencestringConference assignment (AFC or NFC).
divisionstringDivision within the conference (e.g., AFC East, NFC West).
full_namestring—
logo_urlstringnullableURL to team logo image
namestring—
primary_colorstringnullableHex color code for the team's primary uniform color (e.g., `#A71930`).
secondary_colorstringnullableHex color code for the team's secondary uniform color.
nfl.players28 fields· 2 refs· 69 referenced-byendpoints →

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

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
gsis_idstringGame Statistics and Information System ID (e.g. 00-0028830)
league_player_idstringOfficial NFL player ID (UUID) from nfl.com
team_idbigintnullableCurrent NFL team (FK to `teams`); null for free agents and retired players.
birth_citystringnullable—
birth_countrystringnullable—
birth_datedatenullable—
birth_statestringnullable—
collegestringnullableCollege or last football affiliation before turning pro.
draft_numberstringnullablePick number within the round; null or `UDFA` if undrafted.
draft_roundstringnullableDraft round (1-7); null or `UDFA` if undrafted.
draft_yearstringnullableCalendar year the player was drafted; null or `UDFA` if undrafted.
experienceintegernullableYears of NFL experience (rookies = 0).
first_namestring—
full_namestring—
full_position_liststringnullableAll positions the player is eligible at (semicolon-joined when multiple, e.g., `RB;WR`).
heightintegernullableHeight in inches.
is_teambooleanTrue for synthetic team-level entities (DST, team defense). Used to distinguish team defense 'players' from individual players.
jerseystringnullableJersey number with the player's current team (string to preserve leading zeros and special codes).
last_namestring—
nfl_slugstringnullableURL slug used on nfl.com (e.g., `patrick-mahomes`).
overall_pickintegernullableOverall pick number across all rounds (1-262); null if undrafted.
position_groupstringnullableBroad position group classification used by nflverse (e.g., `OFFENSE`, `DEFENSE`, `ST`).
primary_positionstringPrimary roster position (e.g., QB, WR, RB, CB).
profile_pic_urlstringnullableURL to player profile picture image
roster_statusstringnullableActive roster status code from the NFL feed (separate from `status`; e.g., `A` = active, `P` = practice squad).
statusstringnullableRoster status, readable single-word vocabulary (`Active`, `Cut`, `PracticeSquad`, `Reserve`, `Inactive`, `Retired`, `PracticeSquadReleased`, `Exempt`).
weightintegernullableWeight in pounds.
nfl.games31 fields· 5 refs· 21 referenced-byendpoints →

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

References
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
league_game_idstringOfficial NFL game ID from league source
season_idbigint—
stadium_idintegerStadium hosting the game (FK to `stadiums`).
attendanceintegernullableReported attendance count; null when not published.
away_rotation_numberintegernullableSportsbook rotation number for the away team (3-4 digit cross-book reference).
away_teamstringDenormalized team abbreviation for the away side at game time (snapshot copy of `teams.abbreviation`).
away_team_scoreintegerFinal away-team score; 0 (not null) until the game completes.
channelstringnullablePrimary broadcast network/channel (e.g., `CBS`, `FOX`, `Prime Video`).
dayintegerCalendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern.
end_timetimestamptznullableActual game end timestamp; null until the game completes.
game_labelstringnullableDisplay label for special games (e.g., `Thanksgiving Day`, `Monday Night Football`).
game_sub_labelstringnullableSecondary label or sub-category for the game.
game_timetimestamptzScheduled kickoff time (timezone-aware).
home_rotation_numberintegernullableSportsbook rotation number for the home team (3-4 digit cross-book reference).
home_teamstringDenormalized team abbreviation for the home side at game time (snapshot copy of `teams.abbreviation`).
home_team_scoreintegerFinal home-team score; 0 (not null) until the game completes.
neutral_venuebooleanTrue if the game is played at a neutral site (Super Bowl, international games, etc.).
overtimebooleanTrue if the game went to overtime.
overtime_periodsintegernullableNumber of overtime periods played (1+ when `overtime` is true).
playoff_roundstringnullablePostseason round (`WildCard`, `Divisional`, `Conference Championship`, `Super Bowl`); null outside the postseason.
playoff_seed_awayintegernullableAway-team playoff seed (1-7); null outside the postseason.
playoff_seed_homeintegernullableHome-team playoff seed (1-7); null outside the postseason.
postponed_statusstringnullableReason for postponement (e.g., `Weather`, `COVID`); null for games played as scheduled.
season_typestringStage within the season (`Regular Season`, `Preseason`, `Playoff` = Wild Card round, `Divisional`, `Conference Championship`, `Super Bowl`).
start_timetimestamptzActual kickoff timestamp; null before the game starts.
statusstringGame status. Currently always `Scheduled` (status reconciliation is pending) — detect completed games via populated scores, not this field.
typestringGame classification (`Regular`, `Playoff`, `Super Bowl`, `Preseason`).
weekintegerWeek 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.coaching_staff_tenures13 fields· 2 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigintReference to the season
team_idbigintReference to the team
effective_datedateDate this coach started in this role
end_datedatenullableDate this coach ended (null if current)
first_namestringnullable—
full_namestringCoach full name
is_interimboolean—
last_namestringnullable—
positionstringCoaching position (HC, OC, DC)
reasonstringnullableReason for change (fired, resigned, hired, promoted)
sourcestringnullableData source (pfr, cbs_sports, espn, manual)
source_urlstringnullable—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
experienceintegernullable—
first_namestring—
full_namestring—
last_namestring—
positionstring—
nfl.depth_chart_snapshots8 fields· 2 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
entry_countintegerNumber of entries in this snapshot
is_baselinebooleanTrue if this is the season baseline snapshot
snapshot_attimestamptzWhen this snapshot was taken
sourcestringData source (nflverse, espn, etc.)
weekintegerNFL week number (0=preseason)
nfl.operator_team_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintReference to main.operator entity
operator_team_idstringExternal team ID from operator
team_idbigintInternal nfl.teams.id reference
abbreviationstringnullableTeam abbreviation for reconciliation
team_namestringnullableTeam 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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
season_idbigint—
winner_team_idbigintnullableWinning team (FK to `teams`); null until the game completes.
away_team_seedintegerPlayoff seed (1-7) of the away team for this matchup.
conferencestringnullableConference the matchup is contested within (`AFC`, `NFC`); null for the Super Bowl (inter-conference).
game_numberintegerSequence number within the round (used to order multiple games in the same round).
home_team_seedintegerPlayoff seed (1-7) of the home team for this matchup.
playoff_roundstringPostseason round (`WildCard`, `Divisional`, `Conference Championship`, `Super Bowl`).
statusstringMatchup status (`Scheduled`, `InProgress`, `Final`).
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
completionsinteger—
defensive_interceptionsinteger—
defensive_sacksdecimalSacks recorded by this team's defense (half-sacks supported as decimals).
defensive_tdsintegerTouchdowns scored by the defense (interception return + fumble recovery TD); excludes special-teams returns.
extra_pts_attemptedinteger—
extra_pts_madeinteger—
field_goals_attemptedinteger—
field_goals_madeinteger—
first_downsinteger—
fourth_down_attemptsintegerTotal fourth-down plays attempted (excludes punts and field-goal attempts).
fourth_down_conversionsintegerFourth-down attempts converted to a first down or touchdown.
fumbles_recoveredinteger—
games_playedinteger—
lossesinteger—
pass_attemptsinteger—
passing_tdsinteger—
passing_ydsinteger—
pts_allowedinteger—
pts_scoredinteger—
red_zone_attemptsintegerPossessions reaching the red zone (inside the opponent's 20-yard line).
red_zone_conversionsintegerRed-zone trips that ended in a touchdown.
rushing_tdsinteger—
rushing_ydsinteger—
third_down_attemptsintegerTotal third-down plays attempted.
third_down_conversionsintegerThird-down attempts converted to a first down or touchdown.
tiesinteger—
total_ydsinteger—
turnoversintegerPossessions lost via interception or fumble.
winsinteger—
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).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
cfb_idstringnullableCollege Football Reference player ID (external lookup).
pfr_idstringnullablePro Football Reference player ID (external lookup).
player_idbigint—
team_idbigintnullable—
benchintegernullableBench press repetitions at 225 lbs.
broad_jumpintegernullableBroad jump distance in inches.
conedecimalnullable3-cone drill time in seconds.
fortydecimalnullable40-yard dash time in seconds.
htstringnullableHeight as reported by the Combine (e.g., `6-2` for 6 feet 2 inches).
positionstringPosition the player was measured as (e.g., QB, WR, RB, CB).
schoolstringnullableCollege or last-affiliation school name.
seasonintegerCalendar year of the Combine (e.g., 2024 for the February 2024 combine).
shuttledecimalnullable20-yard shuttle time in seconds.
verticaldecimalnullableVertical jump in inches.
wtintegernullableWeight in pounds.
nfl.depth_chart_entries8 fields· 1 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
snapshot_idbigint—
depth_orderintegerOrder within position (1=starter, 2=backup, etc.)
depth_positionstringSpecific depth position (QB1, RB2, etc.)
formationstringnullableFormation group (offense, defense, special_teams)
jersey_numberintegernullable—
positionstringPosition abbreviation (QB, RB, WR, etc.)
nfl.depth_charts15 fields· 4 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary key — sequential row identifier.
elias_idstringnullableElias Sports Bureau player identifier (nullable — populated only when the source feed includes Elias IDs).
game_idbigintFK to nfl.games — the game this depth chart is associated with.
player_idbigintFK to nfl.players — the player occupying this depth-chart slot.
season_idbigintFK to nfl.seasons — the season containing this game.
team_idbigintFK to nfl.teams — the team whose depth chart this row belongs to.
depth_orderintegernullableDepth-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_positionstringPosition 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).
depth_teamstringnullableSub-team designation within the depth chart when present (e.g., a formation-specific team grouping). Sparse — typically NULL.
formationstringnullableFormation unit this slot belongs to (e.g., OFF, DEF, ST). Sparse — typically NULL.
game_typestringPhase of the season: REG (regular season), WC (Wild Card), DIV (Divisional), CON (Conference Championship), SB (Super Bowl).
jersey_numberintegernullablePlayer's jersey number on the team for this game (nullable — populated when the depth chart includes uniform numbers).
positionstringPlayer's listed position abbreviation (e.g., QB, RB, WR, T, DT, CB, MLB, K, P).
statusstringnullableNFL 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).
weekintegerNFL week number within the season (1-18 regular season; postseason weeks use higher numbers per league convention).
nfl.draft_picks38 fields· 4 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
cfb_player_idstringnullableCollege Football Reference player ID.
gsis_idstringGame Statistics and Information System ID (NFL official cross-system join key).
pfr_player_idstringPro Football Reference player ID.
player_idbigint—
team_idbigint—
ageintegernullablePlayer age at the time of the draft.
allpro_countintegerCareer All-Pro selections.
car_avintegernullableCareer Approximate Value (Pro Football Reference, unweighted sum across seasons).
career_to_yearintegernullableMost recent NFL season the player appeared in (calendar year).
categorystringPosition category (e.g., `OFF`, `DEF`, `ST`).
collegestringCollege the player was drafted out of.
def_intsintegerCareer defensive interceptions.
def_sacksdecimalCareer sacks (defensive; half-sacks supported as decimals).
def_solo_tacklesintegerCareer solo defensive tackles.
dr_avintegernullableApproximate Value accumulated while with the drafting team.
games_playedintegerTotal career regular-season games played.
is_hofbooleanTrue if the player is enshrined in the Pro Football Hall of Fame.
pass_attemptsintegerCareer pass attempts.
pass_completionsintegerCareer pass completions.
pass_intsintegerCareer interceptions thrown.
pass_tdsintegerCareer passing touchdowns.
pass_ydsintegerCareer passing yards.
pfr_player_namestringnullablePlayer name as recorded on Pro Football Reference.
pickintegerPick number within the round.
positionstringPosition the player was drafted at (e.g., QB, WR, DE).
probowl_countintegerCareer Pro Bowl selections.
rec_tdsintegerCareer receiving touchdowns.
rec_ydsintegerCareer receiving yards.
receptionsintegerCareer receptions.
roundintegerDraft round (1-7).
rush_attsintegerCareer rushing attempts.
rush_tdsintegerCareer rushing touchdowns.
rush_ydsintegerCareer rushing yards.
seasonintegerCalendar year of the draft.
seasons_startedintegerNumber of NFL seasons in which the player was a primary starter.
sidestringSide of the ball (`OFF` or `DEF`).
w_avintegernullableWeighted Approximate Value (Pro Football Reference career composite metric).
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
first_play_idbigintplay_id of first play in drive
game_idbigint—
last_play_idbigintplay_id of last play in drive
possession_team_idbigintTeam with possession (FK to teams)
drive_numberintegerDrive sequence number in game (1-indexed)
end_transitionstringnullableHow possession ended (PUNT, TOUCHDOWN, TURNOVER, etc.)
end_yard_linestringnullableEnding field position (e.g., "OPP 10")
ended_with_scorebooleanDrive resulted in points
first_downsintegernullableFirst downs gained
fixed_driveintegerCorrected drive number from nflverse
game_clock_endstringnullableGame clock at drive end (mm:ss)
game_clock_startstringnullableGame clock at drive start (mm:ss)
inside_20booleanDrive reached red zone
play_countintegernullableNumber of plays in drive
quarter_endintegernullableQuarter when drive ended
quarter_startintegernullableQuarter when drive started
resultstringnullableDrive outcome (Touchdown, Field goal, Punt, Turnover, etc.)
start_transitionstringnullableHow possession was gained (KICKOFF, PUNT, TURNOVER, etc.)
start_yard_linestringnullableStarting field position (e.g., "KC 25")
time_of_possessionstringnullableDrive duration (mm:ss format)
yds_penalizedintegernullablePenalty yards on drive
nfl.game_lines18 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigintData source (ESPN, DraftKings, FanDuel, nflverse, etc.)
season_idbigintDenormalized for efficient season-level queries
captured_attimestamptzWhen this snapshot was captured
implied_away_scoredecimalnullableCalculated from spread + total
implied_away_win_pctdecimalnullableFrom moneyline, 0-1
implied_home_scoredecimalnullableCalculated from spread + total
implied_home_win_pctdecimalnullableFrom moneyline, 0-1
is_openingbooleanTrue if this is the opening line
moneyline_awayintegernullableAmerican odds for away team win
moneyline_homeintegernullableAmerican odds for home team win
over_oddsintegernullableAmerican odds for over
spreaddecimalnullableHome team spread (e.g., -3.5 means home favored by 3.5)
spread_away_oddsintegernullableAmerican odds for away spread
spread_home_oddsintegernullableAmerican odds for home spread (e.g., -110)
totaldecimalnullableCombined score total line (e.g., 47.5)
under_oddsintegernullableAmerican odds for under
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
opponent_team_idbigint—
player_idbigint—
team_idbigint—
assisted_tacklesintegerAssisted tackles on first down
defensive_tdsintegerTotal defensive touchdowns on first down
forced_fumblesintegerForced fumbles on first down
fumble_recovery_tdsintegerFumble recovery touchdowns on first down
fumble_recovery_ydsintegerFumble recovery yards on first down
fumblesintegerFumbles on first down
fumbles_lostintegerFumbles lost on first down
fumbles_recoveredintegerFumbles recovered on first down
interception_tdsintegerInterception return touchdowns on first down
interception_ydsintegerInterception return yards on first down
interceptionsintegerInterceptions on first down
is_homebooleanTrue if player's team is the home team
offensive_snapsintegerOffensive snaps played on first down
offensive_tdsintegerTotal offensive touchdowns on first down
passes_defendedintegerPasses defended on first down
passing_attemptsintegerPassing attempts on first down
passing_completion_percentagedecimalCompletion percentage on first down
passing_completionsintegerCompleted passes on first down
passing_interceptionsintegerInterceptions thrown on first down
passing_longintegerLongest pass completion on first down
passing_ratingdecimalPasser rating on first down
passing_sack_ydsintegerYards lost to sacks on first down
passing_sacksintegerTimes sacked on first down
passing_tdsintegerPassing touchdowns on first down
passing_ydsintegerPassing yards on first down
passing_yds_per_attemptdecimalPassing yards per attempt on first down
passing_yds_per_completiondecimalPassing yards per completion on first down
positionstringPlayer position at time of game
quarterback_hitsintegerQB hits on first down
receiving_longintegerLongest reception on first down
receiving_tdsintegerReceiving touchdowns on first down
receiving_ydsintegerReceiving yards on first down
receiving_yds_per_receptiondecimalYards per reception on first down
receiving_yds_per_targetdecimalReceiving yards per target on first down
reception_percentagedecimalReception percentage (receptions/targets) on first down
receptionsintegerReceptions on first down
rushing_attemptsintegerRushing attempts on first down
rushing_longintegerLongest rush on first down
rushing_tdsintegerRushing touchdowns on first down
rushing_ydsintegerRushing yards on first down
rushing_yds_per_attemptdecimalRushing yards per attempt on first down
sacksdecimalSacks on first down (0.5 for half sacks)
solo_tacklesintegerSolo tackles on first down
tackles_for_lossintegerTackles for loss on first down
targetsintegerTimes targeted on first down
total_tdsintegerTotal touchdowns scored on first down
two_pt_pass_conversionsinteger—
two_pt_reception_conversionsinteger—
two_pt_rush_conversionsinteger—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_gsis_idstringGSIS ID for cross-reference
player_idbigint—
team_idbigint—
aggressivenessdecimalnullablePercentage of throws into tight windows (defender within 1 yard)
attemptsintegernullable—
avg_air_distancedecimalnullableAverage ball travel distance on all attempts
avg_air_yds_differentialdecimalnullableDifference between intended and completed air yards
avg_air_yds_to_sticksdecimalnullableAverage air yards relative to first down marker
avg_completed_air_ydsdecimalnullableAverage air yards on completed passes
avg_intended_air_ydsdecimalnullableAverage air yards on all pass attempts
avg_time_to_throwdecimalnullableAverage time from snap to throw (seconds)
completion_percentagedecimalnullable—
completion_percentage_above_expectationdecimalnullableCPOE - Actual completion % minus expected (positive = better than expected)
completionsintegernullable—
expected_completion_percentagedecimalnullableModel-predicted completion percentage based on throw difficulty
interceptionsintegernullable—
max_air_distancedecimalnullableMaximum ball travel distance
max_completed_air_distancedecimalnullableLongest completed pass distance (ball travel)
pass_tdsintegernullable—
pass_ydsintegernullable—
passer_ratingdecimalnullable—
seasoninteger—
season_typestringREG, POST, etc.
weekinteger—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_gsis_idstringGSIS ID for cross-reference
player_idbigint—
team_idbigint—
avg_cushiondecimalnullableAverage distance from nearest defender at snap (yards)
avg_expected_yacdecimalnullableModel-predicted YAC based on catch location/defenders
avg_intended_air_ydsdecimalnullableAverage depth of targets
avg_separationdecimalnullableAverage distance from nearest defender at catch point (yards)
avg_yacdecimalnullableAverage yards after catch
avg_yac_above_expectationdecimalnullableActual YAC minus expected (positive = creates extra yards)
catch_percentagedecimalnullable—
percent_share_of_intended_air_ydsdecimalnullablePercentage of team total intended air yards (deep target share)
rec_tdsintegernullable—
receptionsintegernullable—
seasoninteger—
season_typestringREG, POST, etc.
targetsintegernullable—
weekinteger—
yardsintegernullable—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_gsis_idstringGSIS ID for cross-reference
player_idbigint—
team_idbigint—
avg_rush_ydsdecimalnullable—
avg_time_to_losdecimalnullableAverage time to reach line of scrimmage (seconds)
efficiencydecimalnullableDistance traveled per rushing yard gained (lower = more efficient)
expected_rush_ydsdecimalnullableModel-predicted rushing yards based on blocking/defense
percent_attempts_gte_eight_defendersdecimalnullablePercentage of rushes facing 8+ defenders in box
rush_attemptsintegernullable—
rush_pct_over_expecteddecimalnullableRYOE as percentage over expected
rush_tdsintegernullable—
rush_ydsintegernullable—
rush_yds_over_expecteddecimalnullableRYOE - Actual yards minus expected (positive = better)
rush_yds_over_expected_per_attdecimalnullableRYOE per attempt
seasoninteger—
season_typestringREG, POST, etc.
weekinteger—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
opponent_team_idbigintOpposing team in this matchup (FK to `teams`).
player_idbigint—
team_idbigint—
carriesintegernullableRushing attempts.
def_adotdecimalnullableAverage depth of target (yards) when this defender was in coverage.
def_air_yds_completedintegernullableAir yards completed on receptions allowed.
def_completion_pctdecimalnullableCompletion percentage allowed (0.0-100.0).
def_completions_allowedintegernullableReceptions allowed in coverage.
def_intsintegernullableInterceptions made by this defender in coverage.
def_missed_tackle_pctdecimalnullableMissed-tackle rate on tackle opportunities (0.0-100.0).
def_missed_tacklesintegernullableTackle attempts missed by this defender.
def_passer_rating_alloweddecimalnullablePasser rating allowed when targeted (0-158.3).
def_pressuresintegernullableTotal pressures generated (hurries + hits + sacks).
def_receiving_td_allowedintegernullableReceiving touchdowns allowed in coverage.
def_sacksdecimalnullableSacks recorded (half-sacks supported as decimals).
def_tackles_combinedintegernullableCombined tackles (solo + assisted).
def_targetsintegernullablePass targets thrown at this defender's coverage assignment.
def_times_blitzedintegernullablePass-rushing snaps as a blitzer.
def_times_hitqbintegernullableQB hits generated as a pass rusher.
def_times_hurriedintegernullableHurries generated as a pass rusher.
def_yds_after_catchintegernullableYards-after-catch allowed in coverage.
def_yds_allowedintegernullableReceiving yards allowed in coverage.
def_yds_allowed_per_cmpdecimalnullableYards allowed per reception.
def_yds_allowed_per_tgtdecimalnullableYards allowed per target.
passing_bad_throw_pctdecimalnullableBad-throw rate on pass attempts (0.0-100.0).
passing_bad_throwsintegernullablePass attempts charged as bad throws by PFR scoring.
passing_drop_pctdecimalnullableDrop rate on catchable passes (0.0-100.0).
passing_dropsintegernullablePass attempts dropped by the receiver (charged to the QB's catchable-target count).
receiving_broken_tacklesintegernullableTackles the receiver broke on receiving plays.
receiving_dropintegernullableDrops charged to this receiver.
receiving_drop_pctdecimalnullableReceiver drop rate on catchable targets (0.0-100.0).
receiving_intintegernullableInterceptions thrown when this player was the target.
receiving_ratdecimalnullablePasser rating generated when targeted (0-158.3).
rushing_broken_tacklesintegernullableTackles the runner broke on rushing plays.
rushing_yds_after_contactintegernullableTotal rushing yards gained after first contact.
rushing_yds_after_contact_avgdecimalnullableYards after contact averaged per rush.
rushing_yds_before_contactintegernullableTotal rushing yards gained before first contact.
rushing_yds_before_contact_avgdecimalnullableYards before contact averaged per rush.
times_blitzedintegernullableDropbacks the QB faced a blitz.
times_hitintegernullableQB hits (defender contacted the QB on the throw).
times_hurriedintegernullableDropbacks the QB was hurried but not pressured.
times_pressuredintegernullableTotal pressures faced (sum of hurries/hits/sacks-allowed indicators).
times_pressured_pctdecimalnullablePressure rate per dropback (0.0-100.0).
times_sackedintegernullableSacks 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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
opponent_team_idbigint—
player_idbigint—
team_idbigint—
assisted_tacklesintegerAssisted tackles in red zone
defensive_tdsintegerTotal defensive touchdowns in red zone
forced_fumblesintegerForced fumbles in red zone
fumble_recovery_tdsintegerFumble recovery touchdowns in red zone
fumble_recovery_ydsintegerFumble recovery yards in red zone
fumblesintegerFumbles in the red zone
fumbles_lostintegerFumbles lost in the red zone
fumbles_recoveredintegerFumbles recovered in red zone
interception_tdsintegerInterception return touchdowns in red zone
interception_ydsintegerInterception return yards in red zone
interceptionsintegerInterceptions in red zone
is_homebooleanTrue if player's team is the home team
offensive_snapsintegerOffensive snaps played in red zone situations
offensive_tdsintegerTotal offensive touchdowns in the red zone
passes_defendedintegerPasses defended in red zone
passing_attemptsintegerPassing attempts in the red zone
passing_completion_percentagedecimalCompletion percentage in the red zone
passing_completionsintegerCompleted passes in the red zone
passing_interceptionsintegerInterceptions thrown in the red zone
passing_longintegerLongest pass completion in the red zone
passing_ratingdecimalPasser rating in the red zone
passing_sack_ydsintegerYards lost to sacks in the red zone
passing_sacksintegerTimes sacked in the red zone
passing_tdsintegerPassing touchdowns in the red zone
passing_ydsintegerPassing yards in the red zone
passing_yds_per_attemptdecimalPassing yards per attempt in the red zone
passing_yds_per_completiondecimalPassing yards per completion in the red zone
positionstringPlayer position at time of game
quarterback_hitsintegerQB hits in red zone
receiving_longintegerLongest reception in the red zone
receiving_tdsintegerReceiving touchdowns in the red zone
receiving_ydsintegerReceiving yards in the red zone
receiving_yds_per_receptiondecimalYards per reception in the red zone
receiving_yds_per_targetdecimalReceiving yards per target in the red zone
reception_percentagedecimalReception percentage (receptions/targets) in the red zone
receptionsintegerReceptions in the red zone
rushing_attemptsintegerRushing attempts in the red zone
rushing_longintegerLongest rush in the red zone
rushing_tdsintegerRushing touchdowns in the red zone
rushing_ydsintegerRushing yards in the red zone
rushing_yds_per_attemptdecimalRushing yards per attempt in the red zone
sacksdecimalSacks in red zone (0.5 for half sacks)
solo_tacklesintegerSolo tackles in red zone
tackles_for_lossintegerTackles for loss in red zone
targetsintegerTimes targeted in the red zone
total_tdsintegerTotal touchdowns scored in the red zone
two_pt_pass_conversionsintegerSuccessful two-point conversion passes in the red zone
two_pt_reception_conversionsintegerSuccessful two-point conversion receptions in the red zone
two_pt_rush_conversionsintegerSuccessful two-point conversion runs in the red zone
nfl.game_player_stats142 fields· 4 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
opponent_team_idbigint—
player_idbigint—
team_idbigint—
air_yds_sharedecimalPercentage of team air yards
assisted_tacklesintegernullableAssisted tackles
blocked_kick_return_tdsintegernullableBlocked kick return touchdowns
blocked_kick_return_ydsintegernullableBlocked kick return yards
blocked_kicksintegernullableBlocked kicks (FG, XP, punts)
completionsinteger—
dakotadecimalnullableDAKOTA: adjusted completion % + EPA metric
data_sourcestringnullableData source (nflverse, nfl_api, sportsdata)
defensive_interceptionsintegernullableDefensive interceptions
defensive_sack_ydsintegernullableYards lost on defensive sacks
defensive_sacksdecimalnullableDefensive sacks (can be half sacks)
defensive_snapsintegernullableDefensive snaps played
defensive_tdsintegernullableTotal defensive touchdowns (INT + fumble return TDs)
defensive_team_snapsintegernullableTotal team defensive snaps (for calculating snap %)
depth_orderintegernullableDepth order within position (1=starter, 2=backup, etc.) - joined from depth charts
depth_positionstringnullableDepth chart position (QB1, RB2, etc.) - joined from depth charts
extra_pts_attemptedintegernullableExtra points attempted
extra_pts_had_blockedintegernullableExtra points blocked by opponent
extra_pts_madeintegernullableExtra points made
fantasy_ptsdecimalStandard fantasy points (nflverse calculation)
fantasy_pts_pprdecimalPPR fantasy points (nflverse calculation)
field_goal_percentagedecimalnullableField goal percentage
field_goal_return_tdsintegernullableField goal return touchdowns
field_goal_return_ydsintegernullableField goal return yards (missed FG returns)
field_goals_attemptedintegernullableField goals attempted
field_goals_had_blockedintegernullableField goals blocked by opponent
field_goals_longestintegernullableLongest field goal made (yards)
field_goals_madeintegernullableField goals made
field_goals_made_0_19integernullableField goals made 0-19 yards
field_goals_made_20_29integernullableField goals made 20-29 yards
field_goals_made_30_39integernullableField goals made 30-39 yards
field_goals_made_40_49integernullableField goals made 40-49 yards
field_goals_made_50_plusintegernullableField goals made 50+ yards
forced_fumblesintegernullableForced fumbles
fumble_return_tdsintegernullableFumble return touchdowns
fumble_return_ydsintegernullableFumble return yards
fumbles_out_of_boundsintegernullableFumbles out of bounds
fumbles_own_recoveriesintegernullableOwn fumbles recovered
fumbles_recoveredintegernullableFumbles recovered
humidityintegernullableHumidity percentage
interception_return_tdsintegernullableInterception return touchdowns
interception_return_ydsintegernullableInterception return yards
interceptions_throwninteger—
is_homebooleanTrue if player's team is the home team
kick_return_avgfloatnullableKick return average (yards per return)
kick_return_fair_catchesintegernullableFair catches on kick returns
kick_return_fumblesintegernullableFumbles on kick returns
kick_return_fumbles_lostintegernullableFumbles lost on kick returns
kick_return_longintegernullableLongest kick return (yards)
kick_return_tdsintegernullableKick return touchdowns
kick_return_ydsintegernullableTotal kick return yards
kick_returnsintegernullableNumber of kick returns
misc_assisted_tacklesintegernullableMiscellaneous assisted tackles
misc_fumbles_forcedintegernullableMiscellaneous fumbles forced
misc_fumbles_recoveredintegernullableMiscellaneous fumbles recovered
misc_solo_tacklesintegernullableMiscellaneous solo tackles
offensive_snapsintegernullableOffensive snaps played
offensive_team_snapsintegernullableTotal team offensive snaps (for calculating snap %)
pacrdecimalnullablePasser air conversion ratio
pass_attemptsinteger—
passes_defendedintegernullablePasses defended
passing_2pt_conversionsinteger—
passing_air_ydsinteger—
passing_completion_percentagedecimalnullableCompletion percentage
passing_epadecimalExpected points added from passing
passing_first_downsinteger—
passing_longintegernullableLongest pass completion (yards)
passing_ratingdecimalnullablePasser rating
passing_tdsinteger—
passing_ydsinteger—
passing_yds_after_catchinteger—
playing_surfacestringnullablePlaying surface type (grass, turf, etc.)
positionstringPlayer position at time of game
position_groupstringPosition group (QB, RB, WR, TE, etc.)
punt_averagedecimalnullablePunt average (yards)
punt_inside_20integernullablePunts inside 20 yard line
punt_longintegernullableLongest punt (yards)
punt_net_averagefloatnullableNet punt average (gross - return yards)
punt_net_ydsintegernullableNet punt yards (gross - return yards)
punt_return_avgfloatnullablePunt return average (yards per return)
punt_return_fair_catchesintegernullableFair catches on punt returns
punt_return_fumblesintegernullableFumbles on punt returns (includes muffs)
punt_return_fumbles_lostintegernullableFumbles lost on punt returns
punt_return_longintegernullableLongest punt return (yards)
punt_return_tdsintegernullablePunt return touchdowns
punt_return_ydsintegernullableTotal punt return yards
punt_returnsintegernullableNumber of punt returns
punt_touchbacksintegernullablePunt touchbacks
punt_ydsintegernullableTotal punt yards
puntsintegernullableNumber of punts
punts_had_blockedintegernullablePunts blocked by opponent
quarterback_hitsintegernullableQuarterback hits
racrdecimalnullableReceiver air conversion ratio
receiving_2pt_conversionsinteger—
receiving_air_ydsinteger—
receiving_epadecimalExpected points added from receiving
receiving_first_downsinteger—
receiving_fumblesinteger—
receiving_fumbles_lostinteger—
receiving_longintegernullableLongest reception (yards)
receiving_tdsinteger—
receiving_ydsinteger—
receiving_yds_after_catchinteger—
receiving_yds_per_receptiondecimalnullableYards per reception
reception_percentagedecimalnullableReception percentage (receptions/targets)
receptionsinteger—
rushing_2pt_conversionsinteger—
rushing_attemptsinteger—
rushing_epadecimalExpected points added from rushing
rushing_first_downsinteger—
rushing_fumblesinteger—
rushing_fumbles_lostinteger—
rushing_longintegernullableLongest rush (yards)
rushing_tdsinteger—
rushing_ydsinteger—
rushing_yds_per_attemptdecimalnullableRushing yards per attempt
sack_fumblesinteger—
sack_fumbles_lostinteger—
sack_ydsinteger—
sacks_allowedinteger—
safetiesintegernullableSafeties
solo_tacklesintegernullableSolo tackles
special_teams_assisted_tacklesintegernullableAssisted tackles on special teams
special_teams_fumbles_forcedintegernullableFumbles forced on special teams
special_teams_fumbles_recoveredintegernullableFumbles recovered on special teams
special_teams_snapsintegernullableSpecial teams snaps played
special_teams_solo_tacklesintegernullableSolo tackles on special teams
special_teams_tdsinteger—
special_teams_team_snapsintegernullableTotal team special teams snaps (for calculating snap %)
stadiumstringnullableStadium name
tackles_for_lossintegernullableTackles for loss
target_sharedecimalPercentage of team targets
targetsinteger—
temperatureintegernullableGame temperature (Fahrenheit)
two_pt_returnsintegernullableTwo-point conversion returns (defensive)
wind_speedintegernullableWind speed (mph)
woprdecimalnullableWeighted opportunity rating
nfl.game_player_thirddown_stats54 fields· 4 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
opponent_team_idbigint—
player_idbigint—
team_idbigint—
assisted_tacklesintegerAssisted tackles on third down
defensive_tdsintegerTotal defensive touchdowns on third down
forced_fumblesintegerForced fumbles on third down
fumble_recovery_tdsintegerFumble recovery touchdowns on third down
fumble_recovery_ydsintegerFumble recovery yards on third down
fumblesintegerFumbles on third down
fumbles_lostintegerFumbles lost on third down
fumbles_recoveredintegerFumbles recovered on third down
interception_tdsintegerInterception return touchdowns on third down
interception_ydsintegerInterception return yards on third down
interceptionsintegerInterceptions on third down
is_homebooleanTrue if player's team is the home team
offensive_snapsintegerOffensive snaps played on third down
offensive_tdsintegerTotal offensive touchdowns on third down
passes_defendedintegerPasses defended on third down
passing_attemptsintegerPassing attempts on third down
passing_completion_percentagedecimalCompletion percentage on third down
passing_completionsintegerCompleted passes on third down
passing_interceptionsintegerInterceptions thrown on third down
passing_longintegerLongest pass completion on third down
passing_ratingdecimalPasser rating on third down
passing_sack_ydsintegerYards lost to sacks on third down
passing_sacksintegerTimes sacked on third down
passing_tdsintegerPassing touchdowns on third down
passing_ydsintegerPassing yards on third down
passing_yds_per_attemptdecimalPassing yards per attempt on third down
passing_yds_per_completiondecimalPassing yards per completion on third down
positionstringPlayer position at time of game
quarterback_hitsintegerQB hits on third down
receiving_longintegerLongest reception on third down
receiving_tdsintegerReceiving touchdowns on third down
receiving_ydsintegerReceiving yards on third down
receiving_yds_per_receptiondecimalYards per reception on third down
receiving_yds_per_targetdecimalReceiving yards per target on third down
reception_percentagedecimalReception percentage (receptions/targets) on third down
receptionsintegerReceptions on third down
rushing_attemptsintegerRushing attempts on third down
rushing_longintegerLongest rush on third down
rushing_tdsintegerRushing touchdowns on third down
rushing_ydsintegerRushing yards on third down
rushing_yds_per_attemptdecimalRushing yards per attempt on third down
sacksdecimalSacks on third down (0.5 for half sacks)
solo_tacklesintegerSolo tackles on third down
tackles_for_lossintegerTackles for loss on third down
targetsintegerTimes targeted on third down
total_tdsintegerTotal touchdowns scored on third down
two_pt_pass_conversionsinteger—
two_pt_reception_conversionsinteger—
two_pt_rush_conversionsinteger—
nfl.game_team_rosters9 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_idbigint—
team_idbigint—
commentstringnullableOptional note from the gameday roster report (e.g., reason for inactive).
dayintegerDay-of-year integer (matches `game.day` for partitioning).
positionstringnullablePosition the player suited up at for this game.
starterbooleanTrue if the player started this game.
statusstringnullableRoster status for the game, readable single-word vocabulary (`Active`, `Inactive`, `PracticeSquad`, `Reserve`, `Cut`, `Retired`, `Exempt`, `PracticeSquadReleased`).
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigintReference to the game
team_idbigintReference to the team
defensive_coordinatorstringnullableDefensive coordinator name
head_coachstringnullableHead coach name (from nflverse)
offensive_coordinatorstringnullableOffensive coordinator name
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
team_idbigint—
blocked_extra_ptsinteger—
blocked_field_goalsinteger—
blocked_kick_return_tdsintegerBlocked kick return touchdowns
blocked_kick_return_ydsintegerBlocked kick return yards
blocked_kicksintegerTotal blocked kicks (FGs + XPs + punts) for DST fantasy scoring
blocked_puntsinteger—
completion_percentagedecimal—
completionsinteger—
defensive_interceptionsinteger—
defensive_sacksinteger—
defensive_tdsinteger—
defensive_team_snapsintegerTotal defensive snaps by team in game
extra_pt_percentagedecimalExtra point conversion percentage
extra_pts_attemptedinteger—
extra_pts_blockedintegerExtra points that were blocked
extra_pts_madeinteger—
field_goal_percentagedecimal—
field_goal_return_tdsintegerField goal return touchdowns
field_goal_return_ydsintegerField goal return yards (missed FGs)
field_goals_attemptedinteger—
field_goals_blockedintegerField goals that were blocked
field_goals_madeinteger—
first_downsinteger—
first_downs_passinginteger—
first_downs_penaltyinteger—
first_downs_rushinginteger—
forced_fumblesinteger—
fourth_down_attemptsinteger—
fourth_down_conversionsinteger—
fourth_down_percentagedecimal—
fumble_return_tdsintegerFumble return touchdowns
fumble_return_ydsintegerFumble return yards
fumbles_lostinteger—
fumbles_recoveredinteger—
interception_percentagedecimalPercentage of passes intercepted
interception_return_tdsintegerInterception return touchdowns
interception_return_ydsintegerInterception return yards
interception_returnsintegerNumber of interception returns
interceptions_throwninteger—
is_homebooleanTrue if team is the home team
kick_return_avgdecimalAverage yards per kick return
kick_return_longintegerLongest kick return
kick_return_tdsinteger—
kick_return_ydsinteger—
kick_return_yds_differentialintegerKick return yards minus opponent kick return yards
kick_returnsintegerNumber of kick returns
kickoff_touchbacksintegerKickoffs resulting in touchbacks
kickoffsintegerNumber of kickoffs
kickoffs_in_endzoneintegerKickoffs that reached the end zone
lossinteger—
offensive_playsintegerTotal offensive plays run
offensive_team_snapsintegerTotal offensive snaps by team in game
offensive_ydsintegerTotal offensive yards gained
pass_attemptsinteger—
passer_ratingdecimal—
passes_defendedinteger—
passing_dropbacksintegerNumber of passing dropbacks
passing_tdsinteger—
passing_ydsinteger—
penaltiesinteger—
penalty_ydsinteger—
penalty_yds_differentialintegerOpponent penalty yards minus own penalty yards
point_differentialintegerPoints scored minus points allowed
ptsinteger—
pts_allowed_defintegerPoints allowed for DEF scoring (FanDuel). Excludes return TDs against - only offensive points allowed.
pts_allowed_dstintegerPoints allowed for DST scoring (DraftKings/Yahoo). Includes return TDs against - real scoreboard points.
punt_averagedecimal—
punt_net_averagedecimalNet punt average yards
punt_net_ydsintegerTotal net punt yards
punt_return_avgdecimalAverage yards per punt return
punt_return_longintegerLongest punt return
punt_return_tdsinteger—
punt_return_ydsinteger—
punt_return_yds_differentialintegerPunt return yards minus opponent punt return yards
punt_returnsintegerNumber of punt returns
punt_ydsinteger—
puntsinteger—
punts_blockedintegerNumber of punts blocked
qb_hits_differentialintegerQB hits made minus QB hits allowed
qb_hits_percentagedecimalPercentage of dropbacks resulting in QB hit
quarterback_hitsinteger—
receiving_tdsinteger—
receiving_ydsinteger—
receptionsinteger—
red_zone_attemptsinteger—
red_zone_conversionsinteger—
red_zone_percentagedecimal—
rushing_attemptsinteger—
rushing_tdsinteger—
rushing_ydsinteger—
rushing_yds_per_attemptdecimalRushing yards per attempt
sack_ydsinteger—
sacked_percentagedecimalPercentage of dropbacks resulting in sack
sacks_allowedinteger—
sacks_differentialintegerSacks made minus sacks allowed
safetiesinteger—
score_otintegerPoints scored in overtime
score_q1integerPoints scored in Q1
score_q2integerPoints scored in Q2
score_q3integerPoints scored in Q3
score_q4integerPoints scored in Q4
special_teams_team_snapsintegerTotal special teams snaps by team in game
tacklesinteger—
tackles_for_lossinteger—
tfl_differentialintegerTackles for loss made minus allowed
tfl_percentagedecimalPercentage of plays resulting in TFL
third_down_attemptsinteger—
third_down_conversionsinteger—
third_down_percentagedecimal—
tieinteger—
time_of_possessioninteger—
total_return_ydsintegerTotal punt and kick return yards
total_ydsinteger—
touchdownsintegerTotal touchdowns scored
turnover_differentialinteger—
turnoversinteger—
two_point_conversion_attemptsinteger—
two_point_conversionsinteger—
two_pt_conversion_returnsintegerDefensive two-point conversion returns
two_pt_pass_attemptsintegerTwo-point conversion pass attempts
two_pt_pass_conversionsintegerTwo-point conversion pass conversions
two_pt_rush_attemptsintegerTwo-point conversion rush attempts
two_pt_rush_conversionsintegerTwo-point conversion rush conversions
wininteger—
yds_per_carrydecimal—
yds_per_completiondecimalPassing yards per completion
yds_per_pass_attemptdecimal—
yds_per_playdecimalAverage yards per offensive play
nfl.game_weathers18 fields· 2 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
stadium_idbigint—
feels_like_temperatureintegernullable—
field_conditionstringnullable—
humidityfloatnullable—
is_domeboolean—
minutes_from_startintegerMinutes from game start (0, 30, 60, 90, 120, 150)
precipitationfloatnullable—
precipitation_probabilityfloatnullable—
recorded_attimestamptz—
roof_statusstringnullable—
temperatureintegernullable—
weather_conditionstringnullable—
weather_descriptionstringnullable—
wind_directionfloatnullable—
wind_gustfloatnullable—
wind_speedfloatnullable—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_idbigint—
season_idbigint—
team_idbigint—
date_modifiedtimestamptznullableTimestamp of the most recent NFL feed update for this report.
game_typestringGame classification for the upcoming game (`REG`, `WC`, `DIV`, `CON`, `SB`).
positionstringPosition the player was listed at on the report.
practice_primary_injurystringnullablePrimary injury reported on the practice participation report.
practice_secondary_injurystringnullableSecondary injury reported on the practice participation report.
practice_statusstringnullablePractice participation as long-form strings — `Did Not Participate In Practice`, `Limited Participation in Practice`, `Full Participation in Practice` (occasionally `Note` or blank).
report_primary_injurystringnullablePrimary injury body part listed on the official Wednesday/Thursday report (e.g., `Hamstring`, `Knee`).
report_secondary_injurystringnullableSecondary injury listed on the official injury report.
report_statusstringnullableGame-status designation (`Out`, `Doubtful`, `Questionable`; occasionally `Note` or blank when no designation was issued).
weekintegerNFL 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_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintReference to main.operator entity
operator_player_idstringExternal player ID from operator
player_idbigintInternal nfl.players.id reference
player_namestringnullablePlayer name as provided by operator
positionstringnullablePosition as provided by operator
nfl.play_by_plays372 fields· 49 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
assist_tackle_1_player_idstringnullableAssist tackler 1 GSIS ID
assist_tackle_2_player_idstringnullableAssist tackler 2 GSIS ID
assist_tackle_3_player_idstringnullableAssist tackler 3 GSIS ID
assist_tackle_4_player_idstringnullableAssist tackler 4 GSIS ID
blocked_player_idstringnullableBlocked kick player GSIS ID
defensive_team_idbigintnullableFK to teams table for defensive team
drive_idbigintnullableFK to game_drives table
fantasy_idstringnullableFantasy identifier
fantasy_player_idstringnullableFantasy designation player ID
forced_fumble_player_1_player_idstringnullableForced fumble player 1 GSIS ID
forced_fumble_player_2_player_idstringnullableForced fumble player 2 GSIS ID
fumble_recovery_1_player_idstringnullableRecovery player 1 GSIS ID
fumble_recovery_2_player_idstringnullableRecovery player 2 GSIS ID
fumbled_1_player_idstringnullableFirst fumbler GSIS ID
fumbled_2_player_idstringnullableSecond fumbler GSIS ID
game_idbigintFK to games table
half_sack_1_player_idstringnullableHalf-sack player 1 GSIS ID
half_sack_2_player_idstringnullableHalf-sack player 2 GSIS ID
interception_player_idstringnullableInterceptor GSIS ID
kicker_player_idstringnullableKicker GSIS ID
kickoff_returner_player_idstringnullableKickoff returner GSIS ID
lateral_interception_player_idstringnullableLateral after INT GSIS ID
lateral_kickoff_returner_player_idstringnullableLateral kickoff returner GSIS ID
lateral_punt_returner_player_idstringnullableLateral punt returner GSIS ID
lateral_receiver_player_idstringnullableLateral receiver GSIS ID (pass)
lateral_rusher_player_idstringnullableLateral receiver GSIS ID (rush)
lateral_sack_player_idstringnullableLateral after sack GSIS ID
nfl_api_idstringnullableUUID from NFL API
nflverse_game_idstringnullableTen digit identifier for NFL game (nflverse format)
old_game_idstringnullableLegacy NFL game ID format
own_kickoff_recovery_player_idstringnullableOwn kickoff recovery player GSIS ID
pass_defense_1_player_idstringnullablePass defense player 1 GSIS ID
pass_defense_2_player_idstringnullablePass defense player 2 GSIS ID
passer_idbigintnullableFK to players table
passer_player_idstringnullablePasser GSIS ID
penalty_player_idstringnullablePenalized player GSIS ID
play_idstringNumeric play identifier unique to game
possession_team_idbigintnullableFK to teams table for possession team
primary_player_gsis_idstringnullablePrimary player GSIS ID
punt_returner_player_idstringnullablePunt returner GSIS ID
punter_player_idstringnullablePunter GSIS ID
qb_hit_1_player_idstringnullableQB hitter GSIS ID
qb_hit_2_player_idstringnullableSecond QB hitter GSIS ID
receiver_idbigintnullableFK to players table
receiver_player_idstringnullableReceiver GSIS ID
rusher_idbigintnullableFK to players table
rusher_player_idstringnullableRusher GSIS ID
sack_player_idstringnullableSacker GSIS ID
safety_player_idstringnullableSafety scorer GSIS ID
solo_tackle_1_player_idstringnullableSolo tackler 1 GSIS ID
solo_tackle_2_player_idstringnullableSolo tackler 2 GSIS ID
stadium_idintegernullableStadium ID
tackle_for_loss_1_player_idstringnullableTFL player 1 GSIS ID
tackle_for_loss_2_player_idstringnullableTFL player 2 GSIS ID
tackle_with_assist_1_player_idstringnullableTackle-assist player 1 GSIS ID
tackle_with_assist_2_player_idstringnullableTackle-assist player 2 GSIS ID
td_player_idstringnullableTD scorer GSIS ID
aborted_playbooleanPlay was aborted
air_epadecimalnullableEPA from air yards
air_wpadecimalnullableWPA from air yards
air_ydsintegernullableYards in air (perpendicular to LOS)
assist_tacklebooleanAssist tackle on play
assist_tackle_1_player_namestringnullableAssist tackler 1 name
assist_tackle_1_teamstringnullableAssist tackler 1 team
assist_tackle_2_player_namestringnullableAssist tackler 2 name
assist_tackle_2_teamstringnullableAssist tackler 2 team
assist_tackle_3_player_namestringnullableAssist tackler 3 name
assist_tackle_3_teamstringnullableAssist tackler 3 team
assist_tackle_4_player_namestringnullableAssist tackler 4 name
assist_tackle_4_teamstringnullableAssist tackler 4 team
away_coachstringnullableAway team head coach
away_scoreintegernullableTotal away points
away_teamstringnullableAway team abbreviation
away_timeouts_remainingintegernullableAway timeouts remaining
away_wpdecimalnullableAway team win probability
away_wp_postdecimalnullableAway WP after play
blocked_player_namestringnullableBlocked kick player name
comp_air_epadecimalnullableCompletion air EPA
comp_air_wpadecimalnullableCompletion air WPA
comp_yac_epadecimalnullableCompletion YAC EPA
comp_yac_wpadecimalnullableCompletion YAC WPA
complete_passbooleanPass completed
cpdecimalnullableCompletion probability
cpoedecimalnullableCompletion percentage over expected
def_wpdecimalnullableWin probability for defense
defensive_extra_point_attemptbooleanDefense extra point attempt
defensive_extra_point_convbooleanDefense extra point success
defensive_two_point_attemptbooleanDefense two-point attempt
defensive_two_point_convbooleanDefense two-point conversion success
defteamstringnullableDefensive team abbreviation
defteam_scoreintegernullableDefense team score at start
defteam_score_postintegernullableDefense team score at end
defteam_timeouts_remainingintegernullableDefensive team timeouts
descstringnullableFull play description text
div_gamebooleanDivision game
downintegernullableDown (1-4)
driveintegernullableDrive number in game
drive_end_transitionstringnullableHow drive ended
drive_end_yard_linestringnullableYard line at drive end
drive_ended_with_scorebooleanDrive resulted in score
drive_first_downsintegernullableFirst downs gained in drive
drive_game_clock_endstringnullableGame clock at drive end
drive_game_clock_startstringnullableGame clock at drive start
drive_inside20booleanDrive reached red zone
drive_play_countintegernullableNumber of plays in drive
drive_play_id_endedstringnullableLast play_id of drive
drive_play_id_startedstringnullableFirst play_id of drive
drive_quarter_endintegernullableQuarter when drive ended
drive_quarter_startintegernullableQuarter when drive started
drive_real_start_timestringnullableDrive start time (real clock)
drive_start_transitionstringnullableHow possession was obtained
drive_start_yard_linestringnullableYard line at drive start
drive_time_of_possessionstringnullableDrive time of possession (mm:ss)
drive_yds_penalizedintegernullablePenalty yards during drive
end_clock_timestringnullableGame clock at play end
end_yard_linestringnullableYard line at play end
epdecimalnullableExpected points before play
epadecimalnullableExpected points added
extra_point_attemptbooleanExtra point attempt
extra_point_probdecimalnullableExtra point probability
extra_point_resultstringnullablegood, failed, blocked, safety, aborted
fantasystringnullableFantasy designation
fantasy_player_namestringnullableFantasy designation player name
fg_probdecimalnullableFG probability
field_goal_attemptbooleanField goal attempt
field_goal_resultstringnullablemade, missed, or blocked
first_downbooleanFirst down achieved
first_down_passbooleanPassing first down
first_down_penaltybooleanFirst down via penalty
first_down_rushbooleanRushing first down
fixed_driveintegernullableManual drive number correction
fixed_drive_resultstringnullableManual drive result correction
forced_fumble_player_1_player_namestringnullableForced fumble player 1 name
forced_fumble_player_1_teamstringnullableForced fumble team 1
forced_fumble_player_2_player_namestringnullableForced fumble player 2 name
forced_fumble_player_2_teamstringnullableForced fumble team 2
fourth_down_convertedbooleanFourth down conversion
fourth_down_failedbooleanFourth down failure
fumblebooleanFumble occurred
fumble_forcedbooleanFumble was forced
fumble_lostbooleanFumble was lost
fumble_not_forcedbooleanFumble was not forced
fumble_out_of_boundsbooleanFumble went OOB
fumble_recovery_1_player_namestringnullableRecovery player 1 name
fumble_recovery_1_teamstringnullableRecovery team 1
fumble_recovery_1_ydsintegernullableRecovery yards 1
fumble_recovery_2_player_namestringnullableRecovery player 2 name
fumble_recovery_2_teamstringnullableRecovery team 2
fumble_recovery_2_ydsintegernullableRecovery yards 2
fumbled_1_player_namestringnullableFirst fumbler name
fumbled_1_teamstringnullableFirst fumbler team
fumbled_2_player_namestringnullableSecond fumbler name
fumbled_2_teamstringnullableSecond fumbler team
game_halfstringnullableHalf1, Half2, or Overtime
game_seconds_remainingintegerSeconds remaining in game
game_stadiumstringnullableGame stadium name
goal_to_gobooleanGoal-to-go situation
half_sack_1_player_namestringnullableHalf-sack player 1 name
half_sack_2_player_namestringnullableHalf-sack player 2 name
half_seconds_remainingintegerSeconds remaining in half
home_coachstringnullableHome team head coach
home_opening_kickoffbooleanHome team had opening kickoff
home_scoreintegernullableTotal home points
home_teamstringnullableHome team abbreviation
home_timeouts_remainingintegernullableHome timeouts remaining
home_wpdecimalnullableHome team win probability
home_wp_postdecimalnullableHome WP after play
incomplete_passbooleanPass incomplete
interceptionbooleanInterception indicator
interception_player_namestringnullableInterceptor name
jersey_numberintegernullablePrimary player jersey
kick_distanceintegernullableKick distance in yards
kicker_player_namestringnullableKicker name
kickoff_attemptbooleanKickoff attempt
kickoff_downedbooleanKickoff downed
kickoff_fair_catchbooleanKickoff fair catch
kickoff_in_endzonebooleanKickoff in endzone
kickoff_inside_twentybooleanKickoff inside 20
kickoff_out_of_boundsbooleanKickoff OOB
kickoff_returner_player_namestringnullableKickoff returner name
lateral_interception_player_namestringnullableLateral after INT name
lateral_kickoff_returner_player_namestringnullableLateral kickoff returner name
lateral_punt_returner_player_namestringnullableLateral punt returner name
lateral_receiver_player_namestringnullableLateral receiver name (pass)
lateral_receiving_ydsintegernullableYards after lateral (pass)
lateral_receptionbooleanLateral on pass play
lateral_returnbooleanLateral on return
lateral_rushbooleanLateral on rush play
lateral_rusher_player_namestringnullableLateral receiver name (rush)
lateral_rushing_ydsintegernullableYards after lateral (rush)
lateral_sack_player_namestringnullableLateral after sack name
locationstringnullableHome or Neutral
namestringnullablePrimary player name (passer or rusher)
no_huddlebooleanNo-huddle offense
no_score_probdecimalnullableProbability of no score
opp_fg_probdecimalnullableOpponent FG probability
opp_safety_probdecimalnullableOpponent safety probability
opp_td_probdecimalnullableOpponent TD probability
order_sequencedecimalnullableNFL play-ordering column
out_of_boundsbooleanRan/pushed/sacked out of bounds
own_kickoff_recoverybooleanOwn kickoff recovery
own_kickoff_recovery_player_namestringnullableOwn kickoff recovery player name
own_kickoff_recovery_tdbooleanOwn kickoff recovery TD
passbooleanPass play indicator
pass_attemptbooleanPass attempt (includes sacks)
pass_defense_1_player_namestringnullablePass defense player 1 name
pass_defense_2_player_namestringnullablePass defense player 2 name
pass_lengthstringnullableshort or deep
pass_locationstringnullableleft, middle, or right
pass_oedecimalnullableDropback percent over expected
pass_touchdownbooleanPassing touchdown
passerstringnullableDropback player name (includes scrambles)
passer_jersey_numberintegernullablePasser jersey number
passer_player_namestringnullablePasser name
passing_ydsintegernullableOfficial passing yards
penaltybooleanPenalty on play
penalty_player_namestringnullablePenalized player name
penalty_teamstringnullablePenalized team
penalty_typestringnullableType of penalty
penalty_ydsintegernullablePenalty yards
playbooleanRegular play (1) vs special event (0)
play_clockintegernullablePlay clock at snap
play_deletedbooleanPlay was deleted
play_typestringnullablepass, run, punt, field_goal, kickoff, extra_point, qb_kneel, qb_spike, no_play
play_type_nflstringnullableNFL source play type
posteamstringnullablePossession team abbreviation
posteam_scoreintegernullablePossession team score at start
posteam_score_postintegernullablePossession team score at end
posteam_timeouts_remainingintegernullablePossession team timeouts
posteam_typestringnullablehome or away
punt_attemptbooleanPunt attempt
punt_blockedbooleanPunt blocked
punt_downedbooleanPunt downed
punt_fair_catchbooleanPunt fair catch
punt_in_endzonebooleanPunt in endzone
punt_inside_twentybooleanPunt inside 20
punt_out_of_boundsbooleanPunt OOB
punt_returner_player_namestringnullablePunt returner name
punter_player_namestringnullablePunter name
qb_dropbackbooleanQB dropback (pass or scramble)
qb_epadecimalnullableQB EPA credit
qb_hitbooleanQB was hit
qb_hit_1_player_namestringnullableQB hitter name
qb_hit_2_player_namestringnullableSecond QB hitter name
qb_kneelbooleanQB kneel
qb_scramblebooleanQB scramble
qb_spikebooleanQB spike
quarterintegerQuarter (1-4, 5=OT)
quarter_endbooleanBinary quarter-end marker
quarter_seconds_remainingintegerSeconds remaining in quarter
receiverstringnullableTargeted receiver name
receiver_jersey_numberintegernullableReceiver jersey number
receiver_player_namestringnullableReceiver name
receiving_ydsintegernullableOfficial receiving yards
replay_or_challengebooleanReplay/challenge occurred
replay_or_challenge_resultstringnullableReplay result
resultintegernullableHome score - Away score
return_teamstringnullableReturning team
return_touchdownbooleanReturn touchdown
return_ydsintegernullableReturn yards
roofstringnullabledome, outdoors, closed, open
run_gapstringnullableend, guard, or tackle
run_locationstringnullableleft, middle, or right
rushbooleanRush play (no scrambles)
rush_attemptbooleanRushing play indicator
rush_touchdownbooleanRushing touchdown
rusher_jersey_numberintegernullableRusher jersey number
rusher_player_namestringnullableRusher name
rushing_ydsintegernullableOfficial rushing yards
sackbooleanSack indicator
sack_player_namestringnullableSacker name
safetybooleanSafety scored
safety_player_namestringnullableSafety scorer name
safety_probdecimalnullableSafety probability
score_differentialintegernullableScore gap at play start
score_differential_postintegernullableScore gap at play end
seriesintegernullableSeries counter within game
series_resultstringnullableFirst down, Touchdown, Punt, etc.
series_successbooleanSeries resulted in first down or TD
shotgunbooleanShotgun formation
side_of_fieldstringnullableTeam abbreviation whose side of field
solo_tacklebooleanSolo tackle on play
solo_tackle_1_player_namestringnullableSolo tackler 1 name
solo_tackle_1_teamstringnullableSolo tackler 1 team
solo_tackle_2_player_namestringnullableSolo tackler 2 name
solo_tackle_2_teamstringnullableSolo tackler 2 team
spbooleanScoring play indicator
specialbooleanSpecial teams indicator
special_teams_playbooleanSpecial teams play indicator
spread_linedecimalnullableVegas spread line
st_play_typestringnullableType of special teams play
stadiumstringnullableStadium name
start_timestringnullableKickoff time (eastern)
successbooleannullablePlay success (based on down/distance)
surfacestringnullablePlaying surface type
tackle_for_loss_1_player_namestringnullableTFL player 1 name
tackle_for_loss_2_player_namestringnullableTFL player 2 name
tackle_with_assistbooleanTackle with assistance
tackle_with_assist_1_player_namestringnullableTackle-assist player 1 name
tackle_with_assist_1_teamstringnullableTackle-assist player 1 team
tackle_with_assist_2_player_namestringnullableTackle-assist player 2 name
tackle_with_assist_2_teamstringnullableTackle-assist player 2 team
tackled_for_lossbooleanTackle for loss
td_player_namestringnullableTD scorer name
td_probdecimalnullableTD probability
td_teamstringnullableTeam scoring TD
tempintegernullableTemperature
third_down_convertedbooleanThird down conversion
third_down_failedbooleanThird down failure
timestringnullableGame clock at play start (mm:ss)
time_of_daystringnullablePlay time in UTC
timeoutbooleanTimeout called
timeout_teamstringnullableTeam calling timeout
totalintegernullableHome score + Away score
total_away_comp_air_epadecimalnullableCumulative away completion air EPA
total_away_comp_air_wpadecimalnullableCumulative away completion air WPA
total_away_comp_yac_epadecimalnullableCumulative away completion YAC EPA
total_away_comp_yac_wpadecimalnullableCumulative away completion YAC WPA
total_away_epadecimalnullableCumulative away EPA
total_away_pass_epadecimalnullableCumulative away passing EPA
total_away_pass_wpadecimalnullableCumulative away passing WPA
total_away_raw_air_epadecimalnullableCumulative away raw air EPA
total_away_raw_air_wpadecimalnullableCumulative away raw air WPA
total_away_raw_yac_epadecimalnullableCumulative away raw YAC EPA
total_away_raw_yac_wpadecimalnullableCumulative away raw YAC WPA
total_away_rush_epadecimalnullableCumulative away rushing EPA
total_away_rush_wpadecimalnullableCumulative away rushing WPA
total_away_scoreintegernullableAway score at play start
total_home_comp_air_epadecimalnullableCumulative home completion air EPA
total_home_comp_air_wpadecimalnullableCumulative home completion air WPA
total_home_comp_yac_epadecimalnullableCumulative home completion YAC EPA
total_home_comp_yac_wpadecimalnullableCumulative home completion YAC WPA
total_home_epadecimalnullableCumulative home EPA
total_home_pass_epadecimalnullableCumulative home passing EPA
total_home_pass_wpadecimalnullableCumulative home passing WPA
total_home_raw_air_epadecimalnullableCumulative home raw air EPA
total_home_raw_air_wpadecimalnullableCumulative home raw air WPA
total_home_raw_yac_epadecimalnullableCumulative home raw YAC EPA
total_home_raw_yac_wpadecimalnullableCumulative home raw YAC WPA
total_home_rush_epadecimalnullableCumulative home rushing EPA
total_home_rush_wpadecimalnullableCumulative home rushing WPA
total_home_scoreintegernullableHome score at play start
total_linedecimalnullableVegas total line
touchbackbooleanTouchback
touchdownbooleanTouchdown scored
two_point_attemptbooleanTwo-point conversion attempt
two_point_conv_resultstringnullablesuccess, failure, safety, return
two_point_conversion_probdecimalnullableTwo-point conversion probability
vegas_home_wpdecimalnullableVegas home win probability
vegas_home_wpadecimalnullableVegas home WPA
vegas_wpdecimalnullableVegas win probability
vegas_wpadecimalnullableVegas-adjusted WPA
weatherstringnullableWeather conditions description
windintegernullableWind speed (mph)
wpdecimalnullableWin probability for possession team
wpadecimalnullableWin probability added
xpassdecimalnullableDropback probability
xyac_epadecimalnullableExpected EPA after catch
xyac_fddecimalnullableFirst down probability (xYAC)
xyac_mean_yardagedecimalnullableAverage expected YAC
xyac_median_yardagedecimalnullableMedian expected YAC
xyac_successdecimalnullablePositive EPA probability
yac_epadecimalnullableEPA from yards after catch
yac_wpadecimalnullableWPA from yards after catch
yard_lineintegernullableYard line number (0-50)
yardline_100integernullableYards from opponent endzone (0-100)
yds_after_catchintegernullableYAC yards
yds_gainedintegernullableYards gained on play
ydsnetintegernullableTotal net yards on drive
ydstogointegernullableYards to first down/goal
yrdlnstringnullableYard line string (e.g., "KC 25")
nfl.play_participations20 fields· 2 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
play_idstringPlay identifier matching `play_by_plays.play_id` for the same game.
possession_team_idbigintTeam in possession on this play (FK to `teams`).
defenders_in_boxintegernullableNumber of defenders within ~8 yards of the line of scrimmage at the snap.
defense_coverage_typestringnullableSpecific coverage scheme (e.g., `COVER_1`, `COVER_2_MAN`, `COVER_3`, `COVER_4`).
defense_man_zone_typestringnullableMan- vs. zone-coverage classification (`MAN`, `ZONE`).
defense_personnelstringnullableDefensive personnel grouping (e.g., `4 DL, 2 LB, 5 DB`).
defense_players_gsis_idsstringnullableGSIS IDs of defensive players on the field for this play.
n_defenseintegernullableCount of defensive players on the field (typically 11).
n_offenseintegernullableCount of offensive players on the field (typically 11).
ngs_air_ydsdecimalnullableAir yards traveled by the pass from the line of scrimmage to where the receiver caught/dropped it (Next Gen Stats).
number_of_pass_rushersintegernullableNumber of defenders who rushed the passer on this play (Next Gen Stats).
offense_formationstringnullableOffensive formation alignment (e.g., `SHOTGUN`, `SINGLEBACK`, `I_FORM`, `PISTOL`).
offense_personnelstringnullableOffensive personnel grouping in `RB-TE-WR` shorthand (e.g., `1 RB, 2 TE, 2 WR` → `12 personnel`).
offense_players_gsis_idsstringnullableGSIS IDs of offensive players on the field for this play.
players_on_play_gsis_idsstringnullableGSIS IDs of every player on the field for this play (comma-separated or JSON-encoded depending on source vintage).
routestringnullableRoute the targeted receiver ran (e.g., `GO`, `SLANT`, `OUT`, `POST`).
time_to_throwdecimalnullableTime from snap to pass release in seconds (Next Gen Stats).
was_pressurebooleannullableTrue if the quarterback faced pass-rush pressure on this play.
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
otc_idstringOverTheCap unique contract identifier (external).
player_idbigint—
team_idbigint—
apybigintAverage annual value (APY) in U.S. dollars — total `value` divided by `years`.
apy_cap_pctdecimalAPY as a percentage of the league salary cap in the signing year (0.0-100.0).
collegestringnullable—
date_of_birthdatenullable—
guaranteedbigintTotal guaranteed money over the life of the contract, in U.S. dollars.
heightstringnullableHeight as reported by OverTheCap (e.g., `6-2`).
inflated_apybigint`apy` adjusted to the most recent salary cap.
inflated_guaranteedbigint`guaranteed` adjusted to the most recent salary cap.
inflated_valuebigint`value` adjusted to the most recent salary cap, in U.S. dollars.
is_activebooleanTrue for the player's currently-active contract; false for historical contracts.
player_page_urlstringnullableDirect URL to the player's page on overthecap.com.
positionstringPlayer position at the time the contract was signed.
season_history_jsonstringnullableJSON-encoded year-by-year cap-hit breakdown for the life of the contract (stored as a string).
valuebigintTotal contract value in U.S. dollars as reported by OverTheCap.
weightintegernullableWeight in pounds.
year_signedintegerCalendar year the contract was signed.
yearsintegerTotal contract length in years.
nfl.player_news16 fields· 2 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
external_idstringnullable—
player_idbigintnullable—
team_idbigintnullable—
ai_processedboolean—
analysisstringnullable—
authorstringnullable—
categorystringnullableinjury, transaction, lineup, general
contentstringnullable—
descriptionstringnullable—
linkstringnullable—
news_timetimestamptz—
priorityinteger—
situational_impactjsonbnullable—
sourcestringnullable—
titlestring—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
assisted_tacklesintegerAssisted tackles on first down
defensive_tdsintegerTotal defensive touchdowns on first down
forced_fumblesintegerForced fumbles on first down
fumble_recovery_tdsintegerFumble recovery touchdowns on first down
fumble_recovery_ydsintegerFumble recovery yards on first down
fumblesintegerFumbles on first down
fumbles_lostintegerFumbles lost on first down
fumbles_recoveredintegerFumbles recovered on first down
games_playedintegerNumber of games with first down involvement
games_startedintegerNumber of games started
interception_tdsintegerInterception return touchdowns on first down
interception_ydsintegerInterception return yards on first down
interceptionsintegerInterceptions on first down
offensive_snapsintegerOffensive snaps played on first down
offensive_tdsintegerTotal offensive touchdowns on first down
passes_defendedintegerPasses defended on first down
passing_attemptsintegerPassing attempts on first down
passing_completion_percentagedecimalCompletion percentage on first down
passing_completionsintegerCompleted passes on first down
passing_interceptionsintegerInterceptions thrown on first down
passing_longintegerLongest pass completion on first down
passing_ratingdecimalPasser rating on first down
passing_sack_ydsintegerYards lost to sacks on first down
passing_sacksintegerTimes sacked on first down
passing_tdsintegerPassing touchdowns on first down
passing_ydsintegerPassing yards on first down
passing_yds_per_attemptdecimalPassing yards per attempt on first down
passing_yds_per_completiondecimalPassing yards per completion on first down
quarterback_hitsintegerQB hits on first down
receiving_longintegerLongest reception on first down
receiving_tdsintegerReceiving touchdowns on first down
receiving_ydsintegerReceiving yards on first down
receiving_yds_per_receptiondecimalYards per reception on first down
receiving_yds_per_targetdecimalReceiving yards per target on first down
reception_percentagedecimalReception percentage (receptions/targets) on first down
receptionsintegerReceptions on first down
rushing_attemptsintegerRushing attempts on first down
rushing_longintegerLongest rush on first down
rushing_tdsintegerRushing touchdowns on first down
rushing_ydsintegerRushing yards on first down
rushing_yds_per_attemptdecimalRushing yards per attempt on first down
sacksdecimalSacks on first down (0.5 for half sacks)
solo_tacklesintegerSolo tackles on first down
tackles_for_lossintegerTackles for loss on first down
targetsintegerTimes targeted on first down
total_tdsintegerTotal touchdowns scored on first down
two_pt_pass_conversionsinteger—
two_pt_reception_conversionsinteger—
two_pt_rush_conversionsinteger—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
assisted_tacklesintegerAssisted tackles in red zone
defensive_tdsintegerTotal defensive touchdowns in red zone
forced_fumblesintegerForced fumbles in red zone
fumble_recovery_tdsintegerFumble recovery touchdowns in red zone
fumble_recovery_ydsintegerFumble recovery yards in red zone
fumblesintegerFumbles in the red zone
fumbles_lostintegerFumbles lost in the red zone
fumbles_recoveredintegerFumbles recovered in red zone
games_playedintegerNumber of games with red zone involvement
games_startedintegerNumber of games started
interception_tdsintegerInterception return touchdowns in red zone
interception_ydsintegerInterception return yards in red zone
interceptionsintegerInterceptions in red zone
offensive_snapsintegerOffensive snaps played in red zone situations
offensive_tdsintegerTotal offensive touchdowns in the red zone
passes_defendedintegerPasses defended in red zone
passing_attemptsintegerPassing attempts in the red zone
passing_completion_percentagedecimalCompletion percentage in the red zone
passing_completionsintegerCompleted passes in the red zone
passing_interceptionsintegerInterceptions thrown in the red zone
passing_longintegerLongest pass completion in the red zone
passing_ratingdecimalPasser rating in the red zone
passing_sack_ydsintegerYards lost to sacks in the red zone
passing_sacksintegerTimes sacked in the red zone
passing_tdsintegerPassing touchdowns in the red zone
passing_ydsintegerPassing yards in the red zone
passing_yds_per_attemptdecimalPassing yards per attempt in the red zone
passing_yds_per_completiondecimalPassing yards per completion in the red zone
quarterback_hitsintegerQB hits in red zone
receiving_longintegerLongest reception in the red zone
receiving_tdsintegerReceiving touchdowns in the red zone
receiving_ydsintegerReceiving yards in the red zone
receiving_yds_per_receptiondecimalYards per reception in the red zone
receiving_yds_per_targetdecimalReceiving yards per target in the red zone
reception_percentagedecimalReception percentage (receptions/targets) in the red zone
receptionsintegerReceptions in the red zone
rushing_attemptsintegerRushing attempts in the red zone
rushing_longintegerLongest rush in the red zone
rushing_tdsintegerRushing touchdowns in the red zone
rushing_ydsintegerRushing yards in the red zone
rushing_yds_per_attemptdecimalRushing yards per attempt in the red zone
sacksdecimalSacks in red zone (0.5 for half sacks)
solo_tacklesintegerSolo tackles in red zone
tackles_for_lossintegerTackles for loss in red zone
targetsintegerTimes targeted in the red zone
total_tdsintegerTotal touchdowns scored in the red zone
two_pt_pass_conversionsintegerSuccessful two-point conversion passes in the red zone
two_pt_reception_conversionsintegerSuccessful two-point conversion receptions in the red zone
two_pt_rush_conversionsintegerSuccessful two-point conversion runs in the red zone
nfl.season_player_stats89 fields· 2 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
completion_percentagedecimal—
completionsinteger—
defensive_tdsinteger—
extra_pts_attemptedinteger—
extra_pts_madeinteger—
fair_catchesinteger—
field_goal_percentagedecimal—
field_goals_attemptedinteger—
field_goals_madeinteger—
field_goals_made_0_19integer—
field_goals_made_20_29integer—
field_goals_made_30_39integer—
field_goals_made_40_49integer—
field_goals_made_50_plusinteger—
forced_fumblesinteger—
fumble_return_ydsinteger—
fumble_tdsinteger—
fumblesinteger—
fumbles_lostinteger—
fumbles_receivinginteger—
fumbles_recoveredinteger—
fumbles_rushinginteger—
games_playedinteger—
games_startedinteger—
interception_return_ydsinteger—
interception_tdsinteger—
interceptions_defenseinteger—
interceptions_throwninteger—
kick_return_averagedecimal—
kick_return_tdsinteger—
kick_return_ydsinteger—
kick_returnsinteger—
longest_field_goalinteger—
longest_kick_returninteger—
longest_puntinteger—
longest_punt_returninteger—
longest_receptioninteger—
longest_rushinteger—
pass_attemptsinteger—
passer_ratingdecimal—
passes_defendedinteger—
passing_air_ydsintegerTotal passing air yards
passing_first_downsintegerTotal passing first downs
passing_longintegerLongest pass (season max)
passing_tdsinteger—
passing_ydsinteger—
passing_yds_after_catchintegerTotal YAC from passes
punt_averagedecimal—
punt_net_averagedecimal—
punt_return_averagedecimal—
punt_return_tdsinteger—
punt_return_ydsinteger—
punt_returnsinteger—
punt_touchbacksinteger—
punt_ydsinteger—
puntsinteger—
punts_blockedinteger—
punts_inside_20integer—
quarterback_hitsinteger—
receiving_air_ydsintegerTotal receiving air yards
receiving_first_downsintegerTotal receiving first downs
receiving_fumbles_lostintegerTotal receiving fumbles lost
receiving_tdsinteger—
receiving_ydsinteger—
receiving_yds_after_catchintegerTotal receiving YAC
receptionsinteger—
rushing_attemptsinteger—
rushing_first_downsintegerTotal rushing first downs
rushing_fumbles_lostintegerTotal rushing fumbles lost
rushing_tdsinteger—
rushing_ydsinteger—
sack_fumblesintegerTotal fumbles on sacks
sack_fumbles_lostintegerTotal sack fumbles lost
sack_yds_lostinteger—
sacksdecimal—
sacks_takeninteger—
safetiesinteger—
special_teams_tdsintegerTotal special teams touchdowns
tackles_assistedinteger—
tackles_for_lossinteger—
tackles_solointeger—
targetsinteger—
total_tacklesinteger—
yds_per_attemptdecimal—
yds_per_carrydecimal—
yds_per_receptiondecimal—
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.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
assisted_tacklesintegerAssisted tackles on third down
defensive_tdsintegerTotal defensive touchdowns on third down
forced_fumblesintegerForced fumbles on third down
fumble_recovery_tdsintegerFumble recovery touchdowns on third down
fumble_recovery_ydsintegerFumble recovery yards on third down
fumblesintegerFumbles on third down
fumbles_lostintegerFumbles lost on third down
fumbles_recoveredintegerFumbles recovered on third down
games_playedintegerNumber of games with third down involvement
games_startedintegerNumber of games started
interception_tdsintegerInterception return touchdowns on third down
interception_ydsintegerInterception return yards on third down
interceptionsintegerInterceptions on third down
offensive_snapsintegerOffensive snaps played on third down
offensive_tdsintegerTotal offensive touchdowns on third down
passes_defendedintegerPasses defended on third down
passing_attemptsintegerPassing attempts on third down
passing_completion_percentagedecimalCompletion percentage on third down
passing_completionsintegerCompleted passes on third down
passing_interceptionsintegerInterceptions thrown on third down
passing_longintegerLongest pass completion on third down
passing_ratingdecimalPasser rating on third down
passing_sack_ydsintegerYards lost to sacks on third down
passing_sacksintegerTimes sacked on third down
passing_tdsintegerPassing touchdowns on third down
passing_ydsintegerPassing yards on third down
passing_yds_per_attemptdecimalPassing yards per attempt on third down
passing_yds_per_completiondecimalPassing yards per completion on third down
quarterback_hitsintegerQB hits on third down
receiving_longintegerLongest reception on third down
receiving_tdsintegerReceiving touchdowns on third down
receiving_ydsintegerReceiving yards on third down
receiving_yds_per_receptiondecimalYards per reception on third down
receiving_yds_per_targetdecimalReceiving yards per target on third down
reception_percentagedecimalReception percentage (receptions/targets) on third down
receptionsintegerReceptions on third down
rushing_attemptsintegerRushing attempts on third down
rushing_longintegerLongest rush on third down
rushing_tdsintegerRushing touchdowns on third down
rushing_ydsintegerRushing yards on third down
rushing_yds_per_attemptdecimalRushing yards per attempt on third down
sacksdecimalSacks on third down (0.5 for half sacks)
solo_tacklesintegerSolo tackles on third down
tackles_for_lossintegerTackles for loss on third down
targetsintegerTimes targeted on third down
total_tdsintegerTotal touchdowns scored on third down
two_pt_pass_conversionsinteger—
two_pt_reception_conversionsinteger—
two_pt_rush_conversionsinteger—
nfl.team_player_rosters8 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigint—
dayintegerDay-of-year integer; the row is valid for that single day.
depth_orderintegernullableDepth-chart order at this position on this date (1 = starter).
positionstringnullablePosition assigned to the player for this season-day.
position_groupstringnullablePosition group (`OFFENSE`, `DEFENSE`, `ST`).

NBA29 tables

nba.seasons8 fields· 11 referenced-byendpoints →

Each NBA league year, running from October through June — the 82-game regular season, the play-in tournament, and the four-round playoffs that end with the NBA Finals.

References
—
FieldTypeDescription
idkeybigintPrimary Key
short_idstring—
descriptionstringnullable—
end_datetimestamptznullable—
post_season_start_datetimestamptznullable—
regular_season_start_datetimestamptznullable—
start_datetimestamptz—
start_yearinteger—
nba.stadiums19 fields· 1 refs· 3 referenced-byendpoints →

NBA arenas — current home venues and historical buildings the league's teams have played in.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
league_stadium_idintegernullableOfficial NBA arena ID from stats.nba.com
addressstringnullable—
capacityintegernullable—
citystring—
closed_datetimestamptznullable—
countrystringnullable—
descriptionstringnullable—
elevationfloatnullableElevation in feet above sea level
image_urlstringnullableURL to aerial/overview image of arena
latitudefloatnullable—
longitudefloatnullable—
namestring—
opened_datetimestamptznullable—
roof_typestringnullableArena roof type (all indoor)
statestringnullable—
surfacestringnullable—
team_namestringnullable—
timezonestringnullableIANA timezone (e.g., America/New_York)
nba.referees13 fields· 1 refs· 2 referenced-byendpoints →

NBA officials — the three-person crew of referees who work each game.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
nba_referee_idinteger—
activeboolean—
birth_citystringnullable—
birth_countrystringnullable—
birth_datedatenullable—
birth_statestringnullable—
collegestringnullable—
experienceintegernullable—
first_namestring—
full_namestring—
jersey_numberstringnullable—
last_namestring—
nba.coaching_staffs5 fieldsendpoints →

NBA coaches and staff — head coaches, lead assistants, player-development coaches, and other basketball-operations staff who appear on team benches.

FieldTypeDescription
idkeybigintPrimary Key
coach_idintegerOfficial NBA coach/staff ID from stats.nba.com
first_namestring—
last_namestring—
namestring—
nba.teams10 fields· 2 refs· 24 referenced-byendpoints →

The 30 NBA franchises, organized into the Eastern and Western Conferences with three divisions in each.

References
FieldTypeDescription
idkeybigintPrimary Key
league_team_idintegernullableOfficial NBA team ID from stats.nba.com
stadium_idbigintnullable—
abbreviationstring—
activeboolean—
citystring—
conferencestring—
divisionstring—
full_namestring—
namestring—
nba.games28 fields· 5 refs· 13 referenced-byendpoints →

Every scheduled and played NBA game from the 2020-21 season onward — preseason, the 82-game regular season, the In-Season Tournament, the play-in round, and the four-round playoffs through the NBA Finals. All-Star exhibitions are not included.

References
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
league_game_idstringnullableOfficial NBA game ID from stats.nba.com
season_idbigint—
stadium_idintegernullable—
attendanceintegernullable—
away_rotation_numberintegernullable—
away_teamstring—
away_team_scoreinteger—
channelstringnullable—
dayinteger—
end_timetimestamptznullable—
game_labelstringnullable—
game_sub_labelstringnullable—
game_timetimestamptz—
home_rotation_numberintegernullable—
home_teamstring—
home_team_scoreinteger—
if_necessarybooleannullable—
neutral_venueboolean—
postponed_statusstringnullable—
season_typestring—
series_game_numberstringnullable—
series_namestringnullable—
series_textstringnullable—
start_timetimestamptz—
statusstring—
nba.players41 fields· 2 refs· 10 referenced-byendpoints →

Every individual who has played in the NBA — current rosters, two-way and 10-day contracts, G-League call-ups, free agents, and retired veterans. NBA `players` has no boolean `active` column; the roster signal lives in `status` / `roster_status` (text) and `team_id` (null for free agents and retired players). Pass `?team_id=` to scope to one franchise's current roster, or omit it to scan the full historical roster pool.

References
FieldTypeDescription
idkeybigintPrimary Key
league_player_idintegerOfficial NBA player ID from stats.nba.com. Stable across seasons; use for cross-API joins to nba_stats sources.
team_idbigintnullableFK to nba.teams. Null for free agents and retired players.
birth_citystringnullableCity of birth.
birth_countrystringnullableCountry of birth (ISO English name).
birth_datedatenullableBirth date in YYYY-MM-DD form.
birth_statestringnullableState / province of birth (US/Canadian players).
display_fi_laststringnullableDisplay name in "F. Last" form.
display_last_comma_firststringnullableDisplay name in "Last, First" form. Useful for sorted lists.
dleague_flagstringnullableTwo-character bit-string from stats.nba.com: "00" no G-League history, "01" G-League experience, "11" currently G-League-affiliated (two-way / assignment).
draft_numberstringnullableOverall pick number within the draft (string). Empty for undrafted.
draft_roundstringnullableDraft round (string). Empty for undrafted players.
draft_yearstringnullableYear the player was drafted (string form). Empty for undrafted players.
experienceintegernullableYears of NBA experience as of the most recent season. Rookies = 0.
first_namestringPlayer's legal first name as registered with the league.
from_yearstringnullablePlayer's NBA debut year as a string (per stats.nba.com).
full_namestringConvenience concatenation of first_name + last_name. Use this for display.
full_position_liststringnullableHyphenated full-word position list (e.g., "Guard-Forward", "Center-Forward").
games_played_flagstringnullableString "Y"/"N" indicating whether the player has played at least one regular-season game.
heightintegernullableHeight in inches.
injury_body_partstringnullableAffected body part for the most recent injury (e.g., "Knee", "Ankle"). Null when injury_status is null.
injury_detailstringnullableFree-text injury description from the source feed.
injury_sincetimestamptznullableTimestamp of the injury status snapshot. Updated when player_news produces a new injury entry.
injury_statusstringnullableCurrent injury status snapshot derived from player_news. Values: "OUT", "QUESTIONABLE"; null = no active injury designation (healthy).
jerseystringnullableCurrent jersey number as a string (some leagues allow leading zeros, e.g., "00").
last_affiliationstringnullableMost recent pre-NBA affiliation (school, league, or team).
last_namestringPlayer's legal last name.
league_slugstringnullableNBA-issued URL slug (e.g., for stats.nba.com player page).
nba_flagstringnullableString "Y"/"N" indicating NBA experience. Almost always "Y" in this table.
playercodestringnullableNBA-issued player code (lastname_firstname format).
position_categorystringnullableCoarse positional grouping. One of Guard, Forward, Center, Utility.
primary_positionstringPrimary position. One of G, F, C, G-F, F-C. (True PG/SG/SF/PF splits live in team_depth_charts.position.)
roster_statusstringnullableRoster flag from stats.nba.com: "1" on an active NBA roster, "0" not. (Contract type — two-way / 10-day — is not exposed; dleague_flag is the closest signal.)
schoolstringnullableLast school attended before the NBA (college, prep, or international club).
statusstringnullableRoster status. One of "Active", "Inactive"; null for a few legacy rows.
team_abbreviationstringnullableCurrent team's tri-letter code.
team_citystringnullableCurrent team's city name.
team_codestringnullableCurrent team's lowercase URL slug.
team_namestringnullableCurrent team's mascot name (denormalized from teams.name for read convenience).
to_yearstringnullablePlayer's most recent NBA season year. Equal to from_year for rookies.
weightintegernullableListed weight in pounds.
nba.broadcasters12 fields· 2 refs· 2 referenced-byendpoints →

Networks, regional sports networks, and streaming services that air NBA games — ESPN, TNT, ABC, NBA TV, plus team-local RSNs like YES, MSG, and Bally Sports.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
broadcaster_idinteger—
broadcaster_team_idinteger—
region_idinteger—
broadcaster_abbreviationstring—
broadcaster_descriptionstringnullable—
broadcaster_displaystring—
broadcaster_mediastring—
broadcaster_rankinginteger—
broadcaster_scopestring—
broadcaster_video_linkstringnullable—
tape_delay_commentsstringnullable—
nba.operator_team_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintReference to main.operator entity
operator_team_idstringExternal team ID from operator
team_idbigintInternal nba.teams.id reference
abbreviationstringnullableTeam abbreviation for reconciliation
team_namestringnullableTeam name for reconciliation
nba.playoffs12 fields· 3 refsendpoints →

The NBA postseason bracket — the play-in tournament, the four conference series rounds, and the NBA Finals, tracked as best-of-seven matchups with seeds, wins, and outcomes.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
season_idbigint—
series_idbigint—
away_team_winsinteger—
games_playedinteger—
home_team_winsinteger—
max_gamesinteger—
series_namestring—
series_textstring—
statusstring—
nba.season_team_stats9 fields· 2 refsendpoints →

Season totals for each NBA team — wins and losses, points scored and allowed, pace, offensive and defensive ratings, rebounding margins, shooting splits, and turnover differentials. Regular-season games only; playoff, play-in, and preseason totals are not included.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
games_playedinteger—
lossesinteger—
pts_allowedinteger—
pts_scoredinteger—
tiesinteger—
winsinteger—
nba.team_coaching_staffs9 fields· 2 refsendpoints →

The coaching staff each NBA team carries through the season — head coach, assistants, trainers — with the dates each staff member started and ended their tenure.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
coaching_staff_idbigint—
season_idbigintFirst season of this tenure
team_idbigint—
coach_typestringHead Coach, Assistant Coach, Trainer
end_datedatenullableTenure end date. NULL = still active.
is_assistantboolean—
sort_sequenceintegernullable—
start_datedateTenure start date (derived from season start)
nba.team_standings21 fields· 2 refsendpoints →

Conference and division standings throughout the NBA season — wins, losses, win percentage, games behind, last-10 record, win/loss streak, and home/away splits as of each date.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
away_lossesinteger—
away_winsinteger—
conference_gbdecimalGames back from conference leader
conference_rankinteger1-15 within conference
dayintegerYYYYMMDD — standings as of this date (before games on this day)
division_rankinteger1-5 within division
games_playedinteger—
games_remaininginteger—
home_lossesinteger—
home_winsinteger—
l10_lossesinteger—
l10_winsinteger—
lossesinteger—
playin_gbdecimalGames back from 10th seed (play-in cutoff)
playoff_gbdecimalGames back from 6th seed (auto-qualify cutoff)
streakintegerPositive = win streak, negative = loss streak
win_pctdecimal—
winsinteger—
nba.game_broadcasters4 fields· 2 refsendpoints →

Which networks broadcast each NBA game — the national TV partner, home and away regional carriers, radio calls, and streaming providers.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
broadcaster_idbigint—
game_idbigint—
broadcaster_typestring—
nba.game_lines30 fields· 3 refsendpoints →

NBA game betting lines — point spreads, moneylines, and over/under totals from sportsbooks, captured over time as the lines move from opening to closing.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigintSportsbook id: 6 Consensus (full history); per-book ids (1 DraftKings, 2 FanDuel, 1683 Pinnacle, 1684 BetMGM, 1685 Caesars, 1686 BetRivers, 1687 ESPN BET) begin 2026-05.
season_idbigintDenormalized for efficient season-level queries
captured_attimestamptzWhen this snapshot was captured
implied_away_scoredecimalnullable—
implied_away_win_pctdecimalnullable—
implied_home_scoredecimalnullableCalculated from spread + total
implied_home_win_pctdecimalnullableFrom moneyline, 0-1
is_openingbooleanTrue if this is the opening line
moneyline_awayintegernullableAmerican odds for away team win
moneyline_bet_pct_awayintegernullable—
moneyline_bet_pct_homeintegernullable—
moneyline_homeintegernullableAmerican odds for home team win
moneyline_money_pct_awayintegernullable—
moneyline_money_pct_homeintegernullable—
over_oddsintegernullableAmerican odds for over
spreaddecimalnullableHome team spread (e.g., -3.5 means home favored by 3.5)
spread_away_oddsintegernullableAmerican odds for away spread
spread_bet_pct_awayintegernullable—
spread_bet_pct_homeintegernullable—
spread_home_oddsintegernullableAmerican odds for home spread (e.g., -110)
spread_money_pct_awayintegernullable—
spread_money_pct_homeintegernullable—
totaldecimalnullableCombined score total line (e.g., 224.5)
total_bet_pct_overintegernullable—
total_bet_pct_underintegernullable—
total_money_pct_overintegernullable—
total_money_pct_underintegernullable—
under_oddsintegernullableAmerican odds for under
nba.game_period_lines17 fields· 3 refsendpoints →

Period-specific NBA betting lines — first-half, second-half, and individual-quarter spreads, moneylines, and totals offered alongside the full-game markets.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigintData source (consensus, DraftKings, FanDuel, etc.)
season_idbigintDenormalized for efficient season-level queries
captured_attimestamptzWhen this snapshot was captured
implied_away_win_pctdecimalnullable—
implied_home_win_pctdecimalnullableFrom moneyline, 0-1
is_openingbooleanTrue if this is the first captured line for this period
moneyline_awayintegernullableAmerican odds for away team win in this period
moneyline_homeintegernullableAmerican odds for home team win in this period
over_oddsintegernullableAmerican odds for over
period_codestringMarket period code (1H, 2H, Q1, Q2, Q3, Q4)
spreaddecimalnullableHome team spread for this period
spread_away_oddsintegernullableAmerican odds for away spread
spread_home_oddsintegernullableAmerican odds for home spread (e.g., -110)
totaldecimalnullableCombined score total line for this period
under_oddsintegernullableAmerican odds for under
nba.game_player_props18 fields· 4 refsendpoints →

NBA player prop bets for each game — points, rebounds, assists, threes made, steals, blocks, and other player-statistic markets offered by sportsbooks.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigintUsually consensus
player_idbigint—
season_idbigintDenormalized for efficient season-level queries
book_countintegerNumber of curated books contributing to this consensus value
captured_attimestamptzWhen this snapshot was captured
categorystringCanonical category (points, rebounds, assists, pra, etc.)
is_openingbooleanTrue if this is the first captured line for this player/market
linedecimalnullableProp line for over/under markets (e.g., 24.5)
market_keystringRaw market key from source API (e.g., player_points)
no_oddsintegernullableAmerican odds for no
outcome_typestringou | yes_no
over_oddsintegernullableAmerican odds for over
period_codestringnullableOptional period code (Q1, 1H)
subcategorystringnullableOptional subtype (alternate, boosted, etc.)
under_oddsintegernullableAmerican odds for under
yes_oddsintegernullableAmerican odds for yes
nba.game_player_stats116 fields· 3 refsendpoints →

Each NBA player's stat line for each game — points, rebounds, assists, steals, blocks, shooting line, three-point line, free-throw line, plus-minus, and minutes played.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_idbigint—
team_idbigint—
abnormal_exit_clockinteger—
abnormal_exit_periodinteger—
alley_oopsinteger—
and_onesinteger—
assist_percentagedecimalnullable—
assist_ratiodecimalnullable—
assist_to_turnoverdecimalnullable—
assistsinteger—
avg_dribbles_per_touchdecimalnullable—
avg_seconds_per_touchdecimalnullable—
backcourt_violationsinteger—
balls_stolenintegernullable—
basket_interference_violationsinteger—
blocksinteger—
box_outsintegernullable—
carrying_palming_violationsinteger—
challenges_requestedinteger—
charges_takenintegernullable—
clear_path_foulsinteger—
commentstringnullable—
competitive_minutesdecimal—
contestsintegernullable—
defensive_ratingdecimalnullable—
defensive_rebound_percentagedecimalnullable—
defensive_reboundsinteger—
deflectionsintegernullable—
double_doublesinteger—
double_dribble_violationsinteger—
drivesintegernullable—
dunksinteger—
effective_field_goal_percentagedecimalnullable—
ejectionsinteger—
elbow_touchesintegernullable—
estimated_defensive_ratingdecimalnullable—
estimated_net_ratingdecimalnullable—
estimated_offensive_ratingdecimalnullable—
estimated_pacedecimalnullable—
estimated_usage_percentagedecimalnullable—
fast_break_ptsinteger—
field_goal_percentagedecimalnullable—
field_goals_attemptedinteger—
field_goals_madeinteger—
flagrant_fouls_type_1integer—
flagrant_fouls_type_2integer—
foul_trouble_severityinteger—
foulsinteger—
fouls_drawninteger—
free_throw_percentagedecimalnullable—
free_throws_attemptedinteger—
free_throws_madeinteger—
front_court_touchesintegernullable—
game_dateinteger—
garbage_time_minutesdecimal—
goaltending_violationsinteger—
hockey_assistsintegernullable—
jump_balls_lostinteger—
jump_balls_woninteger—
lane_violationsinteger—
layupsinteger—
loose_balls_recoveredintegernullable—
minutesdecimal—
minutes_deviation_pctdecimal—
net_ratingdecimalnullable—
offensive_foulsinteger—
offensive_ratingdecimalnullable—
offensive_rebound_percentagedecimalnullable—
offensive_reboundsinteger—
paint_touchesintegernullable—
pass_percentagedecimalnullable—
passesintegernullable—
passes_deflectedintegernullable—
personal_foulsinteger—
player_impact_estimatedecimal—
plus_minusinteger—
possessionsinteger—
post_touchesintegernullable—
potential_assistsintegernullable—
ptsinteger—
pts_per_elbow_touchdecimalnullable—
pts_per_paint_touchdecimalnullable—
pts_per_post_touchdecimalnullable—
pts_per_touchdecimalnullable—
put_backsinteger—
rebound_percentagedecimalnullable—
reboundsinteger—
role_anomalous_gameboolean—
role_archetypestringnullable—
role_archetype_confidencedecimal—
rotation_contextstringnullable—
rotation_context_confidencedecimal—
screen_assistsintegernullable—
second_chance_ptsinteger—
shot_clock_violationsinteger—
shot_contested_countintegernullable—
shots_blockedintegernullable—
start_positionstringnullable—
stealsinteger—
substitutions_ininteger—
substitutions_outinteger—
technical_foulsinteger—
three_point_percentagedecimalnullable—
three_pointers_attemptedinteger—
three_pointers_madeinteger—
time_of_possessiondecimalnullable—
timeouts_calledinteger—
touchesintegernullable—
traveling_violationsinteger—
triple_doublesinteger—
true_shooting_percentagedecimalnullable—
turnover_ratiodecimalnullable—
turnoversinteger—
usage_percentagedecimalnullable—
nba.game_possessions29 fields· 2 refsendpoints →

Each offensive possession in an NBA game (regular season, play-in, IST, and playoffs — no preseason) — which team had the ball, how the possession started, how it ended (made shot, missed shot, turnover, foul), and how long it lasted.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
team_idbigintnullable—
astinteger—
away_scoreinteger—
blkinteger—
cum_away_possinteger—
cum_home_possinteger—
drebinteger—
end_clockintegernullable—
end_nba_event_numinteger—
fg3ainteger—
fg3minteger—
fgainteger—
fgminteger—
ftainteger—
ftminteger—
game_seconds_elapsedinteger—
home_scoreinteger—
orebinteger—
periodinteger—
pfinteger—
ptsinteger—
start_clockinteger—
start_nba_event_numinteger—
stlinteger—
time_actual_endtimestamptznullable—
time_actual_starttimestamptznullable—
tovinteger—
nba.game_referees4 fields· 2 refsendpoints →

The officiating crew assigned to each NBA game — the three referees who worked the matchup.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
referee_idbigint—
positionstringnullable—
nba.game_team_lineup_stints25 fields· 2 refsendpoints →

Each continuous stretch an NBA team had the same five players on the floor (regular season, play-in, IST, and playoffs — no preseason) — the five-man unit, when it started and ended, and the team's net production while it was in.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player1_idbigint—
player2_idbigint—
player3_idbigint—
player4_idbigint—
player5_idbigint—
team_idbigint—
assist_pctdecimal—
defensive_ratingdecimal—
defensive_rebound_pctdecimal—
end_clockinteger—
end_event_seqinteger—
net_ratingdecimal—
offensive_ratingdecimal—
offensive_rebound_pctdecimal—
pacedecimal—
periodinteger—
player_statsjsonb—
possessionsinteger—
pts_allowedinteger—
pts_scoredinteger—
start_clockinteger—
start_event_seqinteger—
turnover_pctdecimal—
nba.game_team_rosters15 fields· 3 refsendpoints →

The gameday roster for each NBA game — every player available that night, who started, who sat, and who was on a minutes restriction, with the pre-tip snapshot and the reconciled post-game truth side by side.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_idbigint—
team_idbigint—
commentstringnullable—
confirmedbooleannullableWhether the starter truth was established from post-game evidence
dayinteger—
injury_statusstringnullableReconciled final injury designation for the roster row
positionstringnullable—
pre_game_confirmedbooleannullablePre-tip lineup confidence from source (e.g. RotoWire confirmed vs expected)
pre_game_injury_statusstringnullablePre-tip injury designation: OUT, DOUBTFUL, QUESTIONABLE, PROBABLE
pre_game_starterbooleannullablePre-tip expected starter flag from lineup sources
pre_game_statusintegernullablePre-tip roster availability: 1=Active, 2=Inactive, 3=Out
starterbooleannullableWhether the player was in the starting five (reconciled post-game)
statusintegernullableReconciled final roster availability: 1=Active, 2=Inactive, 3=Out
nba.game_team_stats70 fields· 2 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
team_idbigint—
assist_percentagedecimal—
assist_ratiodecimal—
assistsinteger—
assists_to_turnoversdecimal—
bench_ptsinteger—
blocksinteger—
conference_rankintegerConference rank entering game
defensive_ratingdecimal—
defensive_rebound_percentagedecimal—
defensive_reboundsinteger—
effective_field_goal_percentagedecimal—
estimated_defensive_ratingdecimal—
estimated_net_ratingdecimal—
estimated_offensive_ratingdecimal—
estimated_pacedecimal—
fast_break_ptsinteger—
field_goal_percentagedecimal—
field_goals_attemptedinteger—
field_goals_madeinteger—
foulsinteger—
free_throw_attempt_ratedecimal—
free_throw_percentagedecimal—
free_throws_attemptedinteger—
free_throws_madeinteger—
lossinteger—
lossesintegerCumulative losses
minutesinteger—
net_ratingdecimal—
offensive_ratingdecimal—
offensive_rebound_percentagedecimal—
offensive_reboundsinteger—
pacedecimal—
pace_per40decimal—
pct_ast_2pmdecimal—
pct_ast_3pmdecimal—
pct_ast_fgmdecimal—
pct_fga_2ptdecimal—
pct_fga_3ptdecimal—
pct_pts_2ptdecimal—
pct_pts_2pt_mrdecimal—
pct_pts_3ptdecimal—
pct_pts_fbdecimal—
pct_pts_ftdecimal—
pct_pts_off_tovdecimal—
pct_pts_paintdecimal—
pct_uast_2pmdecimal—
pct_uast_3pmdecimal—
pct_uast_fgmdecimal—
player_impact_estimatedecimal—
possessionsinteger—
ptsinteger—
pts_in_paintinteger—
pts_off_turnoversinteger—
rebound_percentagedecimal—
reboundsinteger—
second_chance_ptsinteger—
stealsinteger—
steals_to_turnoversdecimal—
three_point_percentagedecimal—
three_pointers_attemptedinteger—
three_pointers_madeinteger—
timeouts_remaininginteger—
true_shooting_percentagedecimal—
turnover_percentagedecimal—
turnoversinteger—
wininteger—
winsintegerCumulative wins
nba.operator_player_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintOperator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io, 83 stats.nba.com.
operator_player_idstringExternal player ID from operator
player_idbigintInternal nba.players.id reference
player_namestringnullablePlayer name for reconciliation
positionstringnullablePosition for reconciliation
nba.play_by_plays21 fields· 5 refsendpoints →

Every individual event in every NBA game (regular season, play-in, IST, and playoffs — no preseason) — made and missed shots, rebounds, assists, fouls, turnovers, blocks, steals, substitutions, and timeouts, with the game clock at the moment. Period and score context live on game_possessions (FK game_possession_id).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
game_possession_idbigint—
play_idstring—
player_idbigintnullable—
player2_idbigintnullable—
player2_team_idbigintnullable—
player3_idbigintnullable—
player3_team_idbigintnullable—
team_idbigintnullable—
end_clockintegernullable—
event_seqinteger—
event_sub_typeinteger—
event_typeinteger—
home_descriptionstring—
nba_event_numinteger—
neutral_descriptionstring—
possession_seqinteger—
start_clockinteger—
time_actualtimestamptznullable—
visitor_descriptionstring—
nba.player_news16 fields· 2 refsendpoints →

News about NBA players — trades, injuries, lineup decisions, suspensions, and general beat-reporter updates.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
external_idstringnullable—
player_idbigintnullable—
team_idbigintnullable—
ai_processedboolean—
analysisstringnullable—
authorstringnullable—
categorystringnullableinjury, transaction, lineup, general
contentstringnullable—
descriptionstringnullable—
linkstringnullable—
news_timetimestamptz—
priorityinteger—
situational_impactjsonbnullable—
sourcestringnullable—
titlestring—
nba.season_player_stats49 fields· 2 refsendpoints →

Season totals for each NBA player — scoring, rebounding, assists, steals, blocks, shooting splits, advanced metrics, plus-minus, and minutes played. Regular-season games only; playoff, play-in, and preseason totals are not included. Players traded mid-season have one merged row (no per-team split).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
assist_percentagedecimal—
assist_ratiodecimal—
assist_to_turnoverdecimal—
assistsinteger—
avg_dribbles_per_touchdecimal—
avg_seconds_per_touchdecimal—
blocksinteger—
defensive_ratingdecimal—
defensive_rebound_percentagedecimal—
defensive_reboundsinteger—
double_doublesinteger—
effective_field_goal_percentagedecimal—
field_goal_percentagedecimal—
field_goals_attemptedinteger—
field_goals_madeinteger—
foulsinteger—
free_throw_percentagedecimal—
free_throws_attemptedinteger—
free_throws_madeinteger—
front_court_touchesinteger—
games_playedinteger—
lossesinteger—
minutesdecimal—
net_ratingdecimal—
offensive_ratingdecimal—
offensive_rebound_percentagedecimal—
offensive_reboundsinteger—
pacedecimal—
player_impact_estimatedecimal—
plus_minusinteger—
possessionsinteger—
ptsinteger—
rebound_percentagedecimal—
reboundsinteger—
stealsinteger—
three_point_percentagedecimal—
three_pointers_attemptedinteger—
three_pointers_madeinteger—
time_of_possessiondecimal—
touchesinteger—
triple_doublesinteger—
true_shooting_percentagedecimal—
turnover_percentagedecimal—
turnoversinteger—
usage_percentagedecimal—
winsinteger—
nba.team_depth_charts8 fields· 3 refsendpoints →

Each NBA team's depth chart by position on each date — the starter, second-unit, and bench order at point guard, shooting guard, small forward, power forward, and center, with injury designations layered in.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigint—
dayintegerYYYYMMDD snapshot day
depth_rankinteger1-based rank within position (1 = starter)
injury_statusstringnullableDay-To-Day, Out, etc. from ESPN
positionstringPG, SG, SF, PF, C
nba.team_game_contexts20 fields· 4 refsendpoints →

Situational context for each NBA team in each game — how much the game matters (playoff push, tanking, contender mode, In-Season Tournament stakes), what phase of the season it's in, and how far along the schedule the team is.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
opponent_team_idbigint—
season_idbigint—
team_idbigint—
conference_rankinteger—
game_typestringregular, playoff, play_in, ist_group, ist_knockout, preseason, allstar
games_remaininginteger—
intensityinteger1-10 motivation intensity scale
is_back_to_backboolean—
is_clinchboolean—
is_eliminationboolean—
ist_group_rankintegernullable—
ist_group_recordstringnullablee.g. 2-1
motivationstringcontender, playoff_lock, seeding_battle, playoff_push, play_in, fringe, tanking, eliminated, early_season, playoff_comfortable, playoff_competitive, playoff_desperate, playoff_elimination, playoff_clinch, ist_contending, ist_eliminated, ist_knockout
rest_daysinteger—
season_pctdecimal0.0-1.0 how far through regular season
season_phasestringearly, mid, late, final_push, postseason
team_series_winsinteger—
win_pctdecimal—

MLB38 tables

mlb.seasons9 fields· 14 referenced-byendpoints →

Each MLB season — spring training, the 162-game regular season, the Wild Card Series, the Division Series, the League Championship Series, and the World Series.

References
—
FieldTypeDescription
idkeybigintPrimary Key
league_idstringnullableOfficial MLB season identifier
short_idstring—
descriptionstringnullable—
end_datetimestamptznullable—
post_season_start_datetimestamptznullable—
regular_season_start_datetimestamptznullable—
start_datetimestamptz—
start_yearinteger—
mlb.venues21 fields· 1 refs· 7 referenced-byendpoints →

MLB ballparks — current home stadiums and historical venues, with dimensions, surface, capacity, and roof type.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
league_venue_idintegernullableOfficial MLB venue ID from statsapi.mlb.com
addressstringnullable—
capacityintegernullable—
citystring—
closed_datetimestamptznullable—
countrystringnullable—
descriptionstringnullable—
elevationfloatnullableElevation in feet above sea level
hr_factordecimalnullableHistorical home run park factor (1.0 = neutral)
image_urlstringnullableURL to aerial/overview image of ballpark
latitudefloatnullable—
longitudefloatnullable—
namestring—
opened_datetimestamptznullable—
orientationfloatnullableField orientation in degrees (0-360). Direction home plate faces. 0/360=North, 90=East, 180=South, 270=West
roof_typestringnullableOpen, Dome, Retractable
statestringnullable—
surfacestringnullable—
team_namestringnullable—
timezonestringnullableIANA timezone (e.g., America/New_York)
mlb.umpires11 fields· 1 refs· 2 referenced-byendpoints →

MLB umpires — the four-person crew of home-plate, first-base, second-base, and third-base umpires who work each game (six in the postseason with outfield umpires added).

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
mlb_umpire_idinteger—
activeboolean—
birth_citystringnullable—
birth_countrystringnullable—
birth_datedatenullable—
birth_statestringnullable—
experienceintegernullable—
first_namestring—
full_namestring—
last_namestring—
mlb.teams11 fields· 2 refs· 22 referenced-byendpoints →

The 30 MLB franchises, organized into the American and National Leagues with three divisions in each.

References
FieldTypeDescription
idkeybigintPrimary Key
league_team_idintegernullableOfficial MLB team ID from statsapi.mlb.com
venue_idbigintnullable—
abbreviationstring—
activeboolean—
citystring—
divisionstring—
full_namestring—
leaguestring—
logo_urlstringnullableURL to team logo image
namestring—
mlb.park_factors18 fields· 2 refsendpoints →

How each MLB ballpark inflates or suppresses run-scoring categories — runs, home runs, doubles, triples, and batting average relative to a neutral park, computed per season.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
venue_idbigint—
basic_park_factordecimalOverall park factor for runs (1.0 = neutral)
double_factordecimalPark factor for doubles
fly_ball_factordecimalnullablePark factor for fly balls
ground_ball_factordecimalnullablePark factor for ground balls
handedness_factordecimalPark effect on handedness advantage
home_run_factordecimalPark factor for home runs (1.0 = neutral)
left_handed_factordecimalPark factor for left-handed batters
right_handed_factordecimalPark factor for right-handed batters
run_factordecimalnullablePark factor for total runs
single_factordecimalPark factor for singles
strikeout_factordecimalPark factor for strikeouts
triple_factordecimalPark factor for triples
updated_datetimestamptz—
walk_factordecimalPark factor for walks
years_of_dataintegerNumber of years used to calculate factors
mlb.season_run_environments10 fields· 1 refsendpoints →

League-wide offensive context per MLB season — average runs per game, league batting line, ERA, and the offensive baseline used to normalize player and team stats across eras.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
batting_average_on_balls_in_playdecimalLeague average BABIP
fip_constantdecimalFIP constant to scale FIP to ERA
home_run_per_fly_balldecimalLeague average HR/FB rate
runs_per_outdecimalLeague average runs per out made
runs_per_plate_appearancedecimalLeague average runs per plate appearance
strikeout_ratedecimalLeague average strikeout rate
updated_datetimestamptz—
walk_ratedecimalLeague average walk rate
mlb.venue_dimensions21 fields· 2 refsendpoints →

Outfield dimensions and wall heights for each MLB ballpark — distances to left field, center field, right field, and the power alleys, plus the height of the outfield walls.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
mlb_venue_idinteger—
venue_idbigint—
altitude_ftfloatnullableVenue altitude in feet (denormalized from venue for query convenience)
backstop_distancefloatnullableDistance from home plate to backstop (feet)
center_fieldfloat—
center_field_fence_heightfloat—
descriptionstringnullable—
fair_territory_sq_ftfloatnullable—
foul_territory_ratingdecimalnullableRelative foul territory size (1.0 = average, >1 = large)
foul_territory_sq_ftfloatnullable—
left_center_fieldfloatnullable—
left_fieldfloat—
left_field_fence_heightfloat—
orientationfloat—
right_center_fieldfloatnullable—
right_fieldfloat—
right_field_fence_heightfloat—
total_territory_sq_ftfloatnullable—
venue_namestringnullable—
yearinteger—
mlb.woba_weights12 fields· 1 refsendpoints →

The weighted on-base average coefficients for each MLB season — the run values assigned to walks, singles, doubles, triples, and home runs, used to compute wOBA and wRC+.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
double_weightdecimalWeight for doubles (w2B)
hit_by_pitch_weightdecimalWeight for hit by pitch (wHBP)
home_run_weightdecimalWeight for home runs (wHR)
league_obpdecimalLeague average OBP for calibration
league_wobadecimalLeague average wOBA for the season
single_weightdecimalWeight for singles (w1B)
triple_weightdecimalWeight for triples (w3B)
updated_datetimestamptzWhen these weights were last updated
walk_weightdecimalWeight for unintentional walks (wBB)
woba_scaledecimalScale factor to convert wOBA to runs
mlb.games31 fields· 5 refs· 17 referenced-byendpoints →

Every scheduled and played MLB game — spring training exhibitions, the 162-game regular season, the Wild Card Series, the Division and Championship Series, and the World Series.

References
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
league_game_idintegernullableOfficial MLB gamePk from statsapi.mlb.com
league_idstringnullableOfficial MLB game identifier
losing_pitcher_idbigintnullableLosing pitcher of record
save_pitcher_idbigintnullableSave pitcher (if any)
season_idbigint—
venue_idbigintnullable—
winning_pitcher_idbigintnullableWinning pitcher of record
attendanceintegernullable—
away_team_scoreinteger—
channelstringnullable—
dayinteger—
day_nightstringnullableD=Day, N=Night
doubleheaderboolean—
duration_minutesintegernullableTotal game duration in minutes
end_timetimestamptznullable—
game_labelstringnullable—
game_numberintegerFor doubleheaders: 1 or 2
game_timetimestamptzCanonical game start time (use this over start_time)
game_typestringR=Regular, S=Spring, F=Wild Card, D=Division, L=League, W=World Series, E=Exhibition, A=All-Star
home_team_scoreinteger—
if_necessarybooleannullable—
neutral_venueboolean—
postponed_statusstringnullable—
season_typestringRegular Season, Postseason, Spring Training, All-Star
series_game_numberstringnullable—
series_namestringnullable—
series_textstringnullable—
statusstringFinal, Live, Scheduled, Postponed, Suspended, Cancelled
mlb.players30 fields· 2 refs· 14 referenced-byendpoints →

Every individual who has played in Major League Baseball — current 26-man and 40-man rosters, minor-league call-ups, players on the injured list, free agents, and retired players.

References
FieldTypeDescription
idkeybigintPrimary Key
league_idstringnullableOfficial MLB player identifier
league_player_idintegerOfficial MLB player ID from statsapi.mlb.com
team_idbigintnullable—
batsstringnullable—
birth_citystringnullable—
birth_countrystringnullable—
birth_datedatenullable—
birth_statestringnullable—
debut_datetimestamptznullable—
display_fi_laststringnullable—
display_last_comma_firststringnullable—
draft_numberstringnullable—
draft_roundstringnullable—
draft_yearstringnullable—
first_namestring—
full_namestring—
full_position_liststringnullable—
heightintegernullable—
jerseystringnullable—
last_namestring—
league_slugstringnullable—
position_categorystringnullable—
primary_positionstring—
profile_pic_urlstringnullableURL to player profile picture image
roster_statusstringnullable—
schoolstringnullable—
statusstringnullable—
throwsstringnullable—
weightintegernullable—
mlb.broadcasters12 fields· 2 refs· 2 referenced-byendpoints →

Networks, regional sports networks, and streaming services that air MLB games — Apple TV+, ESPN, FOX, TBS, MLB Network, MLB.TV, plus team-local RSNs.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
broadcaster_idinteger—
broadcaster_team_idinteger—
region_idinteger—
broadcaster_abbreviationstring—
broadcaster_descriptionstringnullable—
broadcaster_displaystring—
broadcaster_mediastring—
broadcaster_rankinginteger—
broadcaster_scopestring—
broadcaster_video_linkstringnullable—
tape_delay_commentsstringnullable—
mlb.operator_team_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintOperator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_team_idstringExternal team ID from operator
team_idbigintInternal mlb.teams.id reference
abbreviationstringnullableTeam abbreviation for reconciliation
team_namestringnullableTeam name for reconciliation
mlb.playoffs12 fields· 3 refsendpoints →

The MLB postseason bracket — Wild Card Series, Division Series, League Championship Series, and the World Series, tracked as the seeded matchups and outcomes.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
season_idbigint—
series_idbigint—
away_team_winsinteger—
games_playedinteger—
home_team_winsinteger—
max_gamesinteger—
series_namestring—
series_textstring—
statusstring—
mlb.season_team_stats36 fields· 2 refsendpoints →

Season totals for each MLB team — wins and losses, runs scored and allowed, batting and pitching aggregates, fielding stats, and advanced team metrics (BaseRuns, pythagorean expectation, run differential).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
at_batsinteger—
batting_averagedecimal—
blown_savesinteger—
caught_stealinginteger—
complete_gamesinteger—
double_playsinteger—
doublesinteger—
earned_run_averagedecimal—
earned_runsinteger—
errorsinteger—
fielding_percentagedecimal—
games_playedinteger—
hitsinteger—
holdsinteger—
home_runsinteger—
innings_pitcheddecimalInnings pitched in MLB notation (6.2 = 6 and 2/3 innings)
lossesinteger—
on_base_percentagedecimal—
on_base_plus_sluggingdecimal—
runs_allowedinteger—
runs_batted_ininteger—
runs_scoredinteger—
save_opportunitiesinteger—
savesinteger—
shutoutsinteger—
slugging_percentagedecimal—
stolen_basesinteger—
strikeoutsinteger—
tiesinteger—
triplesinteger—
walksinteger—
whipdecimal—
winsinteger—
mlb.series_odds11 fields· 4 refsendpoints →

Series-level odds for postseason MLB matchups — who wins each series and how many games it goes, with the price updating game by game as the series unfolds. MLB playoff series are best-of-5 (LDS/WC) or best-of-7 (LCS/WS).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
operator_idbigint—
season_idbigint—
away_oddsintegerAmerican odds for away team to win series
captured_attimestamptz—
games_playedintegernullable—
home_oddsintegerAmerican odds for home team to win series
series_namestringALDS, NLDS, ALCS, NLCS, World Series, Wild Card
series_scorestringnullableCurrent series score (e.g., "3-2" home-away)
mlb.innings10 fields· 1 refs· 2 referenced-byendpoints →

Each half-inning of every MLB game — runs scored, hits, errors, base traffic, plate appearances, who pitched, and how the offense ended each frame.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
away_team_errorsinteger—
away_team_hitsinteger—
away_team_runsinteger—
home_team_errorsinteger—
home_team_hitsinteger—
home_team_runsinteger—
inning_halfstring—
inning_numberinteger—
mlb.game_alt_lines6 fields· 2 refsendpoints →

Alternate MLB game lines — the full ladder of run-line and total offerings at non-standard prices that sportsbooks publish alongside the headline line.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigint—
alt_spreadsjsonbnullableArray of {line, home_odds, away_odds}
alt_totalsjsonbnullableArray of {line, over_odds, under_odds}
captured_attimestamptz—
mlb.game_broadcasters4 fields· 2 refsendpoints →

Which networks broadcast each MLB game — the national TV partner, regional carriers, radio calls, and streaming providers.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
broadcaster_idbigint—
game_idbigint—
broadcaster_typestring—
mlb.game_lines18 fields· 3 refsendpoints →

MLB game betting lines — moneylines, run lines (the baseball point-spread equivalent), and over/under totals from sportsbooks, captured over time as the lines move from opening to closing. In MLB, spread = run line (typically +/- 1.5).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigintData source (consensus, DraftKings, FanDuel, etc.)
season_idbigintDenormalized for efficient season-level queries
captured_attimestamptzWhen this snapshot was captured
implied_away_scoredecimalnullable—
implied_away_win_pctdecimalnullable—
implied_home_scoredecimalnullableCalculated from spread + total
implied_home_win_pctdecimalnullableFrom moneyline, 0-1
is_openingbooleanTrue if this is the opening line
moneyline_awayintegernullableAmerican odds for away team win
moneyline_homeintegernullableAmerican odds for home team win
over_oddsintegernullableAmerican odds for over
spreaddecimalnullableHome team run line (e.g., -1.5 means home favored by 1.5 runs)
spread_away_oddsintegernullableAmerican odds for away run line
spread_home_oddsintegernullableAmerican odds for home run line (e.g., -130)
totaldecimalnullableCombined run total line (e.g., 8.5)
under_oddsintegernullableAmerican odds for under
mlb.game_period_lines17 fields· 3 refsendpoints →

Period-specific MLB betting lines — first-five-innings markets (F5), individual-inning bets, and other partial-game spreads, moneylines, and totals. Each row is a time-series snapshot - only captured when values change.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigintData source (consensus, DraftKings, FanDuel, etc.)
season_idbigintDenormalized for efficient season-level queries
captured_attimestamptz—
implied_away_win_pctdecimalnullable—
implied_home_win_pctdecimalnullable—
is_openingboolean—
moneyline_awayintegernullable—
moneyline_homeintegernullable—
over_oddsintegernullable—
period_codestringMarket period code (F5 = first 5 innings, F3, F7)
spreaddecimalnullableHome team run line for this period
spread_away_oddsintegernullable—
spread_home_oddsintegernullable—
totaldecimalnullableCombined run total line for this period
under_oddsintegernullable—
mlb.game_player_batter_stats42 fields· 3 refsendpoints →

Each batter's box-score stat line for each MLB game — at-bats, hits, doubles, triples, home runs, RBIs, walks, strikeouts, stolen bases, and runs scored.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_idbigint—
team_idbigint—
air_outsinteger—
at_batsinteger—
at_bats_per_home_rundecimal—
babipdecimal—
balls_in_playinteger—
batting_averagedecimal—
catchers_interferenceinteger—
caught_stealinginteger—
double_playsinteger—
doublesinteger—
fly_outsinteger—
ground_into_double_playinteger—
ground_into_triple_playinteger—
ground_outsinteger—
hit_by_pitchinteger—
hitsinteger—
home_runsinteger—
intentional_walksinteger—
isolated_powerdecimal—
left_on_baseinteger—
line_outsinteger—
on_base_percentagedecimal—
on_base_plus_sluggingdecimal—
pickoffsinteger—
plate_appearancesinteger—
pop_outsinteger—
runsinteger—
runs_batted_ininteger—
sacrifice_fliesinteger—
sacrificesinteger—
singlesinteger—
slugging_percentagedecimal—
stolen_basesinteger—
strikeoutsinteger—
total_basesinteger—
triplesinteger—
walksinteger—
wobadecimal—
mlb.game_player_pitching_stats68 fields· 3 refsendpoints →

Each pitcher's box-score stat line for each MLB game — innings pitched, hits and runs allowed, earned runs, walks, strikeouts, home runs allowed, and pitches thrown.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_idbigint—
team_idbigint—
air_outsinteger—
babipdecimal—
balksinteger—
ballsinteger—
balls_in_playinteger—
batters_facedinteger—
blown_saveinteger—
catchers_interferenceinteger—
complete_gamesinteger—
double_playsinteger—
doubles_allowedinteger—
earned_run_averagedecimal—
earned_runsinteger—
fipdecimal—
fly_outsinteger—
games_finishedinteger—
games_pitchedinteger—
games_startedinteger—
grand_slams_allowedinteger—
ground_into_double_playinteger—
ground_outsinteger—
hit_by_pitchinteger—
hits_allowedinteger—
holdinteger—
home_runs_allowedinteger—
home_runs_per_ninedecimal—
inherited_runnersinteger—
inherited_runners_scoredinteger—
inning_startedinteger—
innings_pitcheddecimalInnings pitched in MLB notation (6.2 = 6 and 2/3 innings)
intentional_walksinteger—
left_on_basedecimal—
line_outsinteger—
lossinteger—
no_hittersinteger—
on_base_percentagedecimal—
on_base_plus_sluggingdecimal—
outsinteger—
perfect_gamesinteger—
pickoffsinteger—
pitches_throwninteger—
plate_appearancesinteger—
pop_outsinteger—
quality_startsinteger—
runs_allowedinteger—
runs_scored_per_ninedecimal—
sacrifice_flies_allowedinteger—
sacrifices_allowedinteger—
saveinteger—
shutoutsinteger—
singles_allowedinteger—
slugging_percentagedecimal—
strike_percentagedecimal—
strikeouts_per_ninedecimal—
strikeouts_pitchedinteger—
strikesinteger—
total_bases_allowedinteger—
triples_allowedinteger—
walks_allowedinteger—
walks_per_ninedecimal—
whipdecimal—
wild_pitchesinteger—
wininteger—
wobadecimal—
mlb.game_player_props18 fields· 4 refsendpoints →

MLB player prop bets for each game — hits, runs, RBIs, total bases, home runs, strikeouts (for pitchers), and other player-statistic markets offered by sportsbooks.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
operator_idbigint—
player_idbigint—
season_idbigintDenormalized for efficient season-level queries
book_countintegerNumber of curated books contributing to this consensus value
captured_attimestamptz—
categorystringCanonical category. Pitcher props: - strikeouts_pitcher, hits_allowed, walks_allowed, - earned_runs, outs_recorded, pitching_outs, win, quality_start Batter props: - hits, home_runs, rbis, total_bases, runs, walks, - stolen_bases, strikeouts_batter, hits_runs_rbis
is_openingboolean—
linedecimalnullableProp line for over/under markets (e.g., 5.5 strikeouts)
market_keystringRaw market key from source API (e.g., pitcher_strikeouts)
no_oddsintegernullable—
outcome_typestringou | yes_no
over_oddsintegernullable—
period_codestringnullableOptional period code (F5)
subcategorystringnullableOptional subtype (alternate, boosted, etc.)
under_oddsintegernullable—
yes_oddsintegernullable—
mlb.game_team_rosters10 fields· 3 refsendpoints →

The active gameday roster for each MLB team in each game — the 26 players in uniform that day, with positions and any pre-game lineup designations.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
player_idbigint—
team_idbigint—
batting_orderintegernullable—
commentstringnullable—
dayinteger—
positionstringnullable—
starterboolean—
statusstringnullable—
mlb.game_team_stats37 fields· 2 refsendpoints →

Each MLB team's stat line for each game — runs, hits, errors, batting averages, pitching lines, broken out per game with home/away context.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
team_idbigint—
assistsinteger—
balksinteger—
batters_facedinteger—
batting_averagedecimal—
caught_stealinginteger—
double_plays_turnedinteger—
doublesinteger—
earned_run_averagedecimal—
earned_runsinteger—
errorsinteger—
grounded_into_double_playinteger—
hit_by_pitchinteger—
hitsinteger—
home_runsinteger—
innings_pitcheddecimalInnings pitched in MLB notation (6.2 = 6 and 2/3 innings)
left_on_baseinteger—
lossinteger—
on_base_percentagedecimal—
on_base_plus_sluggingdecimal—
passed_ballsinteger—
pitches_throwninteger—
putoutsinteger—
runsinteger—
runs_batted_ininteger—
sacrifice_fliesinteger—
sacrifice_hitsinteger—
slugging_percentagedecimal—
stolen_basesinteger—
strikeoutsinteger—
strikesinteger—
triplesinteger—
walksinteger—
wild_pitchesinteger—
wininteger—
mlb.game_umpires4 fields· 2 refsendpoints →

The umpiring crew assigned to each MLB game — who worked home plate, who worked each base.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
umpire_idbigint—
positionstringnullable—
mlb.operator_player_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintOperator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_player_idstringExternal player ID from operator
player_idbigintInternal mlb.players.id reference
player_namestringnullablePlayer name for reconciliation
positionstringnullablePosition for reconciliation
mlb.pitches72 fields· 1 refsendpoints →

Every individual pitch thrown in every MLB game — the pitch type, velocity, location, movement, spin, and the result (called strike, swinging strike, foul, ball, hit, walk).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
at_bat_idbigint—
batter_idbigint—
game_idbigint—
pitcher_idbigint—
play_idbigint—
air_outbooleanWhether this pitch resulted in an air out
ballboolean—
barrelbooleannullableOptimal combination of exit velocity and launch angle
break_anglefloatnullable—
break_lengthfloatnullable—
break_yfloatnullable—
breaking_ballbooleannullableBreaking ball (curveball, slider, knuckleball)
callstring—
catchers_interferencebooleanWhether this pitch resulted in catchers interference
chasebooleannullableWhether batter swung at pitch outside zone
doublebooleanWhether this pitch resulted in a double
effective_speedfloatnullablePerceived speed to batter (mph)
expected_batting_avgdecimalnullablexBA based on exit velocity and launch angle
expected_wobadecimalnullablexwOBA based on exit velocity and launch angle
extensionfloatnullable—
fastballbooleannullableFastball variant (4-seam, 2-seam, sinker, cutter)
flare_burnerbooleannullableLaunch angle 10-25 AND exit velocity < 95
fly_outbooleanWhether this pitch resulted in a fly out
ground_into_double_playbooleanWhether this pitch resulted in grounding into double play
ground_into_triple_playbooleanWhether this pitch resulted in grounding into triple play
ground_outbooleanWhether this pitch resulted in a ground out
hard_hitbooleannullableExit velocity >= 95 MPH
hit_by_pitchbooleanWhether this pitch resulted in hit by pitch
hit_coord_xfloatnullableHit coordinate X (feet from home plate)
hit_coord_yfloatnullableHit coordinate Y (feet from home plate)
hit_distanceintegernullableDistance of batted ball (feet)
hit_exit_velocityfloatnullableExit velocity of batted ball (mph)
hit_launch_anglefloatnullableLaunch angle of batted ball (degrees)
home_runbooleanWhether this pitch resulted in a home run
in_playboolean—
in_strike_zonebooleannullableWhether pitch was in the strike zone
intentional_walkbooleanWhether this pitch resulted in an intentional walk
launch_speed_angle_zoneintegernullable1=Weak, 2=Topped, 3=Under, 4=Flare/Burner, 5=Solid, 6=Barrel
line_outbooleanWhether this pitch resulted in a line out
offspeedbooleannullableOffspeed pitch (changeup, splitter, forkball)
pitch_numberinteger—
pitch_speedfloatnullable—
pitch_typestringnullable—
pitch_xfloatnullable—
pitch_yfloatnullable—
pitch_zfloatnullable—
pitch_zoneintegernullable—
plate_xfloatnullable—
plate_zfloatnullable—
pop_outbooleanWhether this pitch resulted in a pop out
release_speedfloatnullableSpeed at release point (mph)
resultstring—
sacrifice_flybooleanWhether this pitch resulted in a sacrifice fly
sacrifice_hitbooleanWhether this pitch resulted in a sacrifice bunt
singlebooleanWhether this pitch resulted in a single
solid_contactbooleannullableLaunch angle 20-25 AND exit velocity 95-100
spin_axisfloatnullableSpin axis (degrees)
spin_directionfloatnullable—
spin_ratefloatnullable—
spray_anglefloatnullableHorizontal angle from center field (degrees)
statcast_quality_scoredecimalnullableStatcast data quality score (0.0-1.0)
strikeboolean—
strike_zone_bottomfloatnullable—
strike_zone_topfloatnullable—
strikeoutbooleanWhether this pitch resulted in a strikeout
sweet_spotbooleannullableLaunch angle between 8-32 degrees
toppedbooleannullableLaunch angle < 10 AND exit velocity < 90
tracking_confidencedecimalnullableConfidence in tracking data accuracy
triplebooleanWhether this pitch resulted in a triple
underbooleannullableLaunch angle less than 10 degrees
walkbooleanWhether this pitch resulted in a walk
mlb.player_awards8 fields· 3 refsendpoints →

MLB player awards — MVP, Cy Young, Rookie of the Year, Gold Gloves, Silver Sluggers, All-Star selections, and other end-of-season honors.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigintnullable—
award_datedatenullableDate the award was announced
award_namestring—
award_typestring—
is_winnerbooleanstatsapi publishes recipients (winners) only — always true
mlb.player_injuries16 fields· 3 refsendpoints →

The ongoing injury record for each MLB player — body part, severity, IL designation (10-day, 15-day, 60-day), and expected return timeline.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigint—
body_partstring—
descriptionstringnullable—
end_datetimestamptznullable—
expected_return_datetimestamptznullable—
games_missedintegernullable—
injury_typestring—
is_surgery_requiredbooleannullable—
sidestringnullable—
sourcestringnullable—
start_datetimestamptz—
statusstring—
updated_datetimestamptz—
mlb.player_news17 fields· 2 refsendpoints →

News about MLB players — trades, IL placements, lineup decisions, suspensions, and general beat-reporter updates, unified from beat-writer scrapers, operator feeds, and AI summarization.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
external_idstringSource-specific unique identifier
player_idbigintnullable—
team_idbigintnullable—
ai_processedboolean—
analysisstringnullable—
authorstringnullable—
categorystringnullableinjury, transaction, lineup, general
contentstringnullable—
descriptionstringnullable—
linkstringnullable—
news_timetimestamptz—
priorityinteger—
processed_attimestamptznullable—
situational_impactjsonbnullable—
sourcestringNews source identifier (cbs, espn, rotoworld, sportsdata, etc.)
titlestring—
mlb.season_player_stats69 fields· 2 refsendpoints →

Season totals for each MLB player — the full batting line (AVG, OBP, SLG, OPS), counting stats (HR, RBI, SB, R), and pitching line (W, L, ERA, WHIP, K, BB). Advanced run-value metrics (wRC+, FIP, WAR) are not carried here. Scope is not split by season type.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
assistsinteger—
at_batsinteger—
ballsintegernullable—
batters_facedinteger—
batting_averagedecimal—
blown_savesinteger—
caught_stealinginteger—
caught_stealing_byinteger—
complete_gamesinteger—
double_playsinteger—
doublesinteger—
earned_run_averagedecimal—
earned_runsinteger—
errorsinteger—
fielding_gamesinteger—
fielding_games_startedinteger—
fielding_percentagedecimal—
fielding_positionstring—
games_pitchedinteger—
games_playedinteger—
games_startedinteger—
games_started_pitchinginteger—
grounded_into_double_playinteger—
hit_by_pitchinteger—
hitsinteger—
hits_allowedinteger—
hits_per_ninedecimal—
holdsinteger—
home_runsinteger—
home_runs_allowedinteger—
home_runs_per_ninedecimal—
innings_pitcheddecimalInnings pitched in MLB notation (6.2 = 6 and 2/3 innings)
intentional_walksintegernullable—
left_on_baseintegernullable—
lossesinteger—
on_base_percentagedecimal—
on_base_plus_sluggingdecimal—
passed_ballsinteger—
pitches_thrownintegernullable—
plate_appearancesinteger—
putoutsinteger—
quality_startsintegernullable—
runsinteger—
runs_allowedinteger—
runs_batted_ininteger—
sacrifice_fliesinteger—
sacrifice_hitsinteger—
save_opportunitiesinteger—
savesinteger—
shutoutsinteger—
singlesintegernullableDerivable from hits - doubles - triples - home_runs
slugging_percentagedecimal—
stolen_basesinteger—
stolen_bases_allowedinteger—
strikeoutsinteger—
strikeouts_per_ninedecimal—
strikeouts_pitchedinteger—
strikesintegernullable—
total_basesintegernullableDerivable: 1B + 2*2B + 3*3B + 4*HR
total_chancesinteger—
triplesinteger—
walksinteger—
walks_allowedinteger—
walks_per_ninedecimal—
whipdecimal—
winsinteger—
mlb.team_player_rosters9 fields· 3 refsendpoints →

Day-by-day player-to-team affiliations across the MLB season — who was on each 40-man roster, who was on the IL, who was optioned to the minors, and who was designated for assignment.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigint—
dayinteger—
positionstringnullable—
position_depthintegernullable—
position_groupstringnullable—
roster_typestring—
mlb.team_starting_lineup_batters5 fields· 1 refsendpoints →

Each batter in each MLB starting lineup — position in the order (1 through 9), defensive position, and batting handedness for the day.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
team_starting_lineup_idbigint—
batting_orderstring—
positionstring—
mlb.team_starting_lineups6 fields· 2 refsendpoints →

Each MLB team's starting lineup for each game — the nine batters in batting order plus the starting pitcher (and DH where applicable).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
pitcher_idbigintnullable—
team_idbigint—
batter_statusinteger—
pitcher_statusinteger—
mlb.venue_weathers27 fields· 2 refsendpoints →

On-field weather throughout each MLB game — temperature, wind direction and speed, humidity, and precipitation captured at fixed intervals from first pitch.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
venue_idbigint—
air_densityfloatnullableCalculated air density (lb/ft³)
ball_carry_factordecimalnullableEstimated ball carry factor (1.0 = neutral, >1 = carries more)
cloud_coverfloatnullable—
dew_pointfloatnullable—
feels_like_temperaturefloatnullable—
humidityfloatnullable—
is_domebooleannullable—
precipitationfloatnullable—
precipitation_probabilityfloatnullable—
pressurefloatnullable—
recorded_attimestamptznullable—
roof_statusstringnullableopen, closed, retractable_open, retractable_closed
temperaturefloatnullable—
time_minutesintegerMinutes from game start (0, 30, 60, 90, 120, 150, 180 for 3-hour game)
uv_indexfloatnullable—
visibilityfloatnullable—
weather_conditionstringnullable—
weather_descriptionstringnullable—
wind_blowing_outbooleannullableTrue if wind is blowing from home plate toward outfield
wind_component_outfloatnullableWind speed component blowing out to CF (mph, negative = blowing in)
wind_directionfloatnullable—
wind_direction_relativefloatnullableWind direction relative to batter's box (degrees)
wind_gustfloatnullable—
wind_speedfloatnullable—
mlb.at_bats35 fields· 2 refsendpoints →

Every plate appearance in every MLB game — the batter, the pitcher, the count, the pitch sequence, and the outcome (single, double, home run, strikeout, walk, hit-by-pitch, etc.).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
batter_idbigint—
game_idbigint—
inning_idbigint—
pitcher_idbigint—
at_bat_numberinteger—
ballsinteger—
end_outsinteger—
end_runnersinteger—
expected_batting_avgdecimalnullable—
expected_wobadecimalnullable—
hit_coord_xfloatnullable—
hit_coord_yfloatnullable—
hit_distanceintegernullable—
hit_exit_velocityfloatnullable—
hit_launch_anglefloatnullable—
hit_locationstringnullable—
hit_typestringnullable—
is_barrelbooleannullable—
is_flare_burnerbooleannullableLaunch angle 10-25 AND exit velocity < 95
is_hard_hitbooleannullable—
is_solid_contactbooleannullableLaunch angle 20-25 AND exit velocity 95-100
is_sweet_spotbooleannullableLaunch angle between 8-32 degrees
is_toppedbooleannullableLaunch angle < 10 AND exit velocity < 90
is_underbooleannullableLaunch angle less than 10 degrees
launch_speed_angle_zoneintegernullable—
pitch_countinteger—
resultstring—
runs_scoredinteger—
spray_anglefloatnullableHorizontal angle from center field (degrees)
start_outsinteger—
start_runnersinteger—
statcast_quality_scoredecimalnullableStatcast data quality score (0.0-1.0)
strikesinteger—
tracking_confidencedecimalnullableConfidence in tracking data accuracy
mlb.play_by_plays22 fields· 4 refsendpoints →

Every individual play of every MLB game — every plate appearance, baserunning event, defensive play, and substitution with the inning, outs, base state, and score at the moment.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
at_bat_idbigintnullable—
batter_idbigintnullable—
catcher_idbigintnullable—
first_base_runner_idbigintnullable—
game_idbigint—
inning_idbigint—
pitcher_idbigintnullable—
play_idbigint—
player_idbigintnullable—
second_base_runner_idbigintnullable—
team_idbigint—
third_base_runner_idbigintnullable—
count_ballsinteger—
count_strikesinteger—
event_sub_typeinteger—
event_typeinteger—
hit_locationstringnullable—
hit_typestringnullable—
mlb_event_numinteger—
outsinteger—
runners_on_baseinteger—

NHL (coming soon)22 tables

nhl.seasons10 fields· 8 referenced-byendpoints →

Each NHL season — preseason exhibitions, the 82-game regular season, and the Stanley Cup Playoffs (Wild Card, Divisional, Conference Finals, Stanley Cup Finals).

References
—
FieldTypeDescription
idkeybigintPrimary Key
league_idstringnullableOfficial NHL season identifier
short_idstring—
descriptionstringnullable—
end_datetimestamptznullable—
post_season_start_datetimestamptznullable—
regular_season_start_datetimestamptznullable—
stanley_cup_finals_datetimestamptznullable—
start_datetimestamptz—
start_yearinteger—
nhl.arenas19 fields· 1 refs· 3 referenced-byendpoints →

NHL arenas — current home venues and historical buildings, with capacity, surface type, and ice-rink dimensions.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
league_arena_idintegernullableOfficial NHL arena ID from api-web.nhle.com
addressstringnullable—
capacityintegernullable—
citystring—
closed_datetimestamptznullable—
countrystringnullable—
descriptionstringnullable—
elevationfloatnullableElevation in feet above sea level
image_urlstringnullableURL to aerial/overview image of arena
latitudefloatnullable—
longitudefloatnullable—
namestring—
opened_datetimestamptznullable—
roof_typestringnullableArena roof type (all indoor)
statestringnullable—
surfacestringPlaying surface type
team_namestringnullable—
timezonestringnullableIANA timezone (e.g., America/New_York)
nhl.teams18 fields· 2 refs· 23 referenced-byendpoints →

The 32 NHL franchises, organized into the Eastern and Western Conferences with two divisions each (Atlantic, Metropolitan, Central, Pacific).

References
FieldTypeDescription
idkeybigintPrimary Key
arena_idbigintnullable—
league_team_idintegernullableOfficial NHL team ID from api-web.nhle.com
abbreviationstring—
activeboolean—
citystring—
conferencestring—
divisionstring—
full_namestring—
head_coachstringnullable—
logo_urlstringnullableURL to team logo image
namestring—
primary_colorstringnullable—
quaternary_colorstringnullable—
secondary_colorstringnullable—
tertiary_colorstringnullable—
wikipedia_logo_urlstringnullable—
wikipedia_wordmark_urlstringnullable—
nhl.players35 fields· 3 refs· 14 referenced-byendpoints →

Every individual who has played in the NHL — current rosters, AHL call-ups, free agents, and retired players, with their shooting hand, position, and home country.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
draft_team_idbigintnullable—
league_idstringnullableOfficial NHL player identifier
league_player_idintegerOfficial NHL player ID from api-web.nhle.com
team_idbigintnullable—
birth_citystringnullable—
birth_countrystringnullable—
birth_datedatenullable—
birth_statestringnullable—
catchesstringnullable—
collegestringnullable—
draft_overall_pickintegernullable—
draft_pickintegernullable—
draft_roundintegernullable—
draft_yearintegernullable—
experienceintegernullableYears of NHL experience
first_namestring—
full_namestring—
heightintegernullableHeight in inches
injury_body_partstringnullable—
injury_notesstringnullable—
injury_start_datetimestamptznullable—
injury_statusstringnullable—
jerseystringnullable—
last_namestring—
nationalitystringnullable—
photo_urlstringnullableURL to player headshot image
position_categorystringnullable—
primary_positionstring—
rookie_yearintegernullable—
shootsstringnullable—
statusstringnullable—
weightintegernullableWeight in pounds
youth_leaguestringnullable—
youth_teamstringnullable—
nhl.games37 fields· 5 refs· 8 referenced-byendpoints →

Every scheduled and played NHL game — preseason, the 82-game regular season, and the four-round Stanley Cup Playoffs through the Stanley Cup Final.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
arena_idbigintnullable—
away_team_idbigint—
home_team_idbigint—
league_game_idintegernullableOfficial NHL game ID from api-web.nhle.com
league_idstringnullableOfficial NHL game identifier
season_idbigint—
attendanceintegernullable—
away_team_scoreintegernullable—
away_team_score_overtimeintegernullable—
away_team_score_period1integernullable—
away_team_score_period2integernullable—
away_team_score_period3integernullable—
away_team_series_winsintegernullable—
channelstringnullable—
date_timetimestamptz—
date_time_utctimestamptznullable—
dayintegerCalendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern.
game_timetimestamptz—
home_team_scoreintegernullable—
home_team_score_overtimeintegernullable—
home_team_score_period1integernullable—
home_team_score_period2integernullable—
home_team_score_period3integernullable—
home_team_series_winsintegernullable—
is_overtimeboolean—
is_shootoutboolean—
last_playstringnullable—
neutral_siteboolean—
overtime_periodsintegernullable—
periodstringnullableCurrent period (1, 2, 3, OT, SO, Final)
playoff_roundstringnullableFirst Round, Second Round, Conference Finals, Stanley Cup Final
season_typeinteger1=Regular, 2=Preseason, 3=Postseason, 4=All-Star
series_game_numberintegernullable—
statusstring—
time_remaining_minutesintegernullable—
time_remaining_secondsintegernullable—
nhl.line_combinations11 fields· 2 refsendpoints →

NHL forward and defensive pair groupings — which players skate together as a line (first, second, third, fourth) or defensive pairing for each team.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player1_idbigint—
player2_idbigintnullable—
player3_idbigintnullable—
player4_idbigintnullable—
player5_idbigintnullable—
season_idbigint—
team_idbigint—
daydate—
line_numberinteger—
line_typestring—
nhl.operator_team_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintOperator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_team_idstringExternal team ID from operator
team_idbigintInternal nhl.teams.id reference
abbreviationstringnullableTeam abbreviation for reconciliation
team_namestringnullableTeam name for reconciliation
nhl.playoff_series15 fields· 4 refsendpoints →

NHL Stanley Cup Playoff series — best-of-seven matchups in each round (First Round, Second Round, Conference Finals, Stanley Cup Final), with seeds, wins, and series outcomes.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
away_team_idbigint—
home_team_idbigint—
season_idbigint—
series_idintegernullable—
winner_team_idbigintnullable—
away_team_seedinteger—
away_team_winsinteger—
conferencestringnullable—
games_playedinteger—
home_team_seedinteger—
home_team_winsinteger—
max_gamesinteger—
playoff_roundstring—
statusstring—
nhl.season_team_stats36 fields· 2 refsendpoints →

Season totals for each NHL team — wins, losses, overtime losses, points, goals for and against, shooting percentage, save percentage, power-play and penalty-kill efficiency, faceoff percentages.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
blocked_shotsinteger—
faceoff_lossesinteger—
faceoff_percentagedecimal—
faceoff_winsinteger—
games_playedinteger—
giveawaysinteger—
goal_differentialinteger—
goals_againstinteger—
goals_against_averagedecimal—
goals_against_per_gamedecimal—
goals_forinteger—
goals_per_gamedecimal—
hitsinteger—
lossesinteger—
overtime_lossesinteger—
penalty_kill_goals_againstinteger—
penalty_kill_percentagedecimal—
penalty_minutesinteger—
power_play_goalsinteger—
power_play_opportunitiesinteger—
power_play_percentagedecimal—
ptsinteger—
pts_percentagedecimal—
save_percentagedecimal—
season_typeinteger1=Regular, 2=Preseason, 3=Postseason
shooting_percentagedecimal—
short_handed_goalsinteger—
shots_againstinteger—
shots_forinteger—
shutoutsinteger—
takeawaysinteger—
times_shorthandedinteger—
winsinteger—
nhl.standings36 fields· 2 refsendpoints →

Current conference and division standings for the NHL season — wins, losses, overtime losses, points, points percentage, games behind, and home/away splits. One snapshot per team per season (no as-of-date history).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
season_idbigint—
team_idbigint—
away_lossesinteger—
away_overtime_lossesinteger—
away_winsinteger—
clinched_conferenceboolean—
clinched_divisionboolean—
clinched_playoffsboolean—
clinched_presidents_trophyboolean—
conferencestring—
conference_rankinteger—
divisionstring—
division_rankinteger—
games_playedinteger—
goal_differentialinteger—
goals_againstinteger—
goals_forinteger—
home_lossesinteger—
home_overtime_lossesinteger—
home_winsinteger—
last_10_lossesinteger—
last_10_overtime_lossesinteger—
last_10_winsinteger—
lossesinteger—
overtime_lossesinteger—
ptsinteger—
pts_percentagedecimal—
rankinteger—
regulation_winsinteger—
season_typeinteger—
shootout_lossesinteger—
shootout_winsinteger—
streakstringnullableCurrent streak (W3, L2, OTL1)
wild_card_rankintegernullable—
winsinteger—
nhl.draft_picks9 fields· 3 refsendpoints →

Every NHL Draft selection — round, pick number, drafting team, the league/country the player came from, and the career stats that followed.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
draft_idintegernullable—
original_team_idintegernullableTeam that originally owned the pick
player_idbigintnullable—
team_idbigint—
overall_pickinteger—
pick_in_roundinteger—
roundinteger—
yearinteger—
nhl.game_odds13 fields· 1 refsendpoints →

NHL game betting lines — moneylines, puck lines (the hockey point-spread equivalent), and over/under totals from sportsbooks, captured over time as the lines move from opening to closing.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
away_money_lineintegernullable—
away_point_spreaddecimalnullable—
away_point_spread_payoutintegernullable—
draw_money_lineintegernullable—
home_money_lineintegernullable—
home_point_spreaddecimalnullable—
home_point_spread_payoutintegernullable—
over_payoutintegernullable—
over_underdecimalnullable—
sportsbookstringnullableDraftKings, FanDuel, BetMGM, etc.
under_payoutintegernullable—
nhl.game_player_stats67 fields· 3 refsendpoints →

Each NHL player's stat line for each game — goals, assists, plus-minus, shots on goal, hits, blocks, penalties in minutes, power-play points, time on ice, plus the goaltender line (saves, shots against, goals against, save percentage).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
opponent_idbigintnullable—
player_idbigint—
team_idbigint—
assistsinteger—
blocked_shotsinteger—
empty_net_goalsinteger—
even_strength_assistsinteger—
even_strength_goalsinteger—
even_strength_time_on_ice_secondsinteger—
faceoff_percentagedecimal—
faceoffs_lostinteger—
faceoffs_woninteger—
first_period_goals_againstinteger—
game_winning_goalsinteger—
gamesinteger1 if player appeared, 0 if not
giveawaysinteger—
goalsinteger—
goals_againstinteger—
goals_against_averagedecimal—
hitsinteger—
home_or_awaystringnullable—
is_game_overboolean—
lossesinteger—
major_penaltiesinteger—
minor_penaltiesinteger—
minutes_playedintegerGoalie minutes played
overtime_goalsinteger—
overtime_goals_againstinteger—
overtime_lossesinteger—
penaltiesinteger—
penalty_minutesinteger—
plus_minusinteger—
power_play_assistsinteger—
power_play_goalsinteger—
power_play_goals_againstinteger—
power_play_ptsinteger—
power_play_savesinteger—
power_play_shots_againstinteger—
power_play_time_on_ice_secondsinteger—
ptsinteger—
save_percentagedecimal—
savesinteger—
second_period_goals_againstinteger—
shiftsinteger—
shooting_percentagedecimal—
shootout_attemptsinteger—
shootout_goalsinteger—
shootout_goals_againstinteger—
shootout_savesinteger—
short_handed_assistsinteger—
short_handed_goalsinteger—
short_handed_goals_againstinteger—
short_handed_ptsinteger—
short_handed_savesinteger—
short_handed_shots_againstinteger—
short_handed_time_on_ice_secondsinteger—
shotsinteger—
shots_againstinteger—
shots_on_goalinteger—
shutoutsinteger—
startedinteger—
takeawaysinteger—
third_period_goals_againstinteger—
time_on_ice_secondsinteger—
winsinteger—
nhl.game_team_stats30 fields· 2 refsendpoints →

Each NHL team's stat line for each game — goals scored and allowed, shots on goal, power-play and penalty-kill performance, faceoff percentage, hits, blocks, and time-on-ice splits.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
team_idbigint—
assistsinteger—
blocked_shotsinteger—
faceoff_percentagedecimal—
faceoffs_lostinteger—
faceoffs_woninteger—
giveawaysinteger—
goalsinteger—
goals_againstinteger—
hitsinteger—
lossesinteger—
overtime_lossesinteger—
penaltiesinteger—
penalty_kill_goals_againstinteger—
penalty_kill_percentagedecimal—
penalty_minutesinteger—
power_play_attemptsinteger—
power_play_goalsinteger—
power_play_percentagedecimal—
save_percentagedecimal—
savesinteger—
shooting_percentagedecimal—
short_handed_goalsinteger—
shotsinteger—
shots_on_goalinteger—
takeawaysinteger—
times_shorthandedinteger—
winsinteger—
nhl.goalie_depth_charts6 fields· 3 refsendpoints →

Each NHL team's goaltender depth — the starter, backup, and any third-string netminders, with the date the depth was last updated.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigint—
daydate—
depth_orderinteger1=Starter, 2=Backup, 3=Third string
nhl.operator_player_lookups6 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintOperator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_player_idstringExternal player ID from operator
player_idbigintInternal nhl.players.id reference
player_namestringnullablePlayer name for reconciliation
positionstringnullablePosition for reconciliation
nhl.penalties12 fields· 5 refs· 1 referenced-byendpoints →

Every penalty assessed in every NHL game — the player penalized, the infraction (hooking, tripping, slashing, etc.), the minutes assessed (2-minute minor, 4-minute double minor, 5-minute major, game misconduct, match penalty), and the resulting power play.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
drawn_by_player_idbigintnullable—
game_idbigint—
penalty_idinteger—
player_idbigintnullable—
team_idbigint—
descriptionstringnullable—
is_bench_penaltyboolean—
penalty_minutesinteger—
penalty_typestring—
period_numberinteger—
time_remainingstringTime remaining in period (MM:SS)
nhl.periods8 fields· 3 refs· 1 referenced-byendpoints →

Per-period scores for every NHL game — the three regulation periods plus any overtime and the shootout, with the away and home goals in each. (Shots and penalties per period are not carried here.)

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
league_game_idinteger—
period_idinteger—
away_team_scoreinteger—
home_team_scoreinteger—
namestring1, 2, 3, OT, OT2, SO
period_numberinteger—
nhl.player_injuries16 fields· 3 refsendpoints →

The ongoing injury record for each NHL player — body part, severity, designation (day-to-day, IR, LTIR), and expected return timeline.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigint—
body_partstring—
descriptionstringnullable—
end_datetimestamptznullable—
expected_return_datetimestamptznullable—
games_missedinteger—
injury_typestringnullable—
is_surgery_requiredbooleannullable—
sidestringnullable—
sourcestringnullable—
start_datetimestamptz—
statusstring—
updated_datetimestamptz—
nhl.player_news20 fields· 2 refsendpoints →

News about NHL players — trades, IR placements, line changes, suspensions, and general beat-reporter updates.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
external_idstringnullable—
news_idintegernullable—
player_idbigintnullable—
team_idbigintnullable—
ai_processedboolean—
authorstringnullable—
categoriesstringnullable—
categorystringnullableinjury, transaction, lineup, general
contentstringnullable—
news_timetimestamptz—
original_sourcestringnullable—
original_source_urlstringnullable—
priorityinteger—
situational_impactjsonbnullable—
sourcestringnullable—
terms_of_usestringnullable—
titlestring—
updated_timetimestamptznullable—
urlstringnullable—
nhl.scoring_plays13 fields· 5 refsendpoints →

Every goal scored in every NHL game — the scorer, the assists, the goaltender beaten, the strength (even strength, power play, short-handed), and the score state when the goal went in.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
primary_assist_player_idbigintnullable—
scored_by_player_idbigintnullable—
scoring_play_idinteger—
secondary_assist_player_idbigintnullable—
team_idbigint—
away_team_scoreinteger—
descriptionstringnullable—
goal_typestringnullable—
home_team_scoreinteger—
period_numberinteger—
time_remainingstringTime remaining in period (MM:SS)
nhl.season_player_stats62 fields· 3 refsendpoints →

Season totals for each NHL player — goals, assists, points, plus-minus, shots on goal, hits, blocks, penalty minutes, power-play and short-handed contributions, plus goaltender stats (wins, saves, shutouts, save percentage, goals-against average).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_idbigint—
team_idbigintnullable—
assistsinteger—
assists_per_gamedecimal—
blocked_shotsinteger—
empty_net_goalsinteger—
even_strength_assistsinteger—
even_strength_goalsinteger—
even_strength_time_on_ice_secondsinteger—
faceoff_percentagedecimal—
faceoffs_lostinteger—
faceoffs_woninteger—
game_winning_goalsinteger—
games_playedinteger—
games_startedinteger—
giveawaysinteger—
goalsinteger—
goals_againstinteger—
goals_against_averagedecimal—
goals_per_gamedecimal—
hat_tricksinteger—
hitsinteger—
lossesinteger—
major_penaltiesinteger—
minor_penaltiesinteger—
minutes_playedinteger—
overtime_goalsinteger—
overtime_lossesinteger—
penaltiesinteger—
penalty_minutesinteger—
plus_minusinteger—
positionstringnullable—
power_play_assistsinteger—
power_play_goalsinteger—
power_play_ptsinteger—
power_play_time_on_ice_secondsinteger—
ptsinteger—
pts_per_gamedecimal—
save_percentagedecimal—
savesinteger—
season_typeinteger1=Regular, 2=Preseason, 3=Postseason
shiftsinteger—
shooting_percentagedecimal—
shootout_attemptsinteger—
shootout_goalsinteger—
shootout_goals_againstinteger—
shootout_missesinteger—
shootout_savesinteger—
short_handed_assistsinteger—
short_handed_goalsinteger—
short_handed_ptsinteger—
short_handed_time_on_ice_secondsinteger—
shotsinteger—
shots_againstinteger—
shots_on_goalinteger—
shutoutsinteger—
takeawaysinteger—
time_on_ice_per_gamedecimal—
time_on_ice_secondsinteger—
winsinteger—

PGA15 tables

golf.players16 fields· 1 refs· 10 referenced-byendpoints →

Every professional golfer — active tour members, conditional-status players, alumni who have competed at the highest level, and country-of-origin information.

References
FieldTypeDescription
idkeybigintPrimary Key
league_idstringnullableOfficial tour player identifier
league_player_idintegerOfficial PGA Tour player id
birth_citystringnullable—
birth_countrystringnullable—
birth_datedatenullable—
birth_statestringnullable—
collegestringnullable—
countrystringnullable—
first_namestring—
full_namestring—
last_namestring—
pga_debut_yearintegernullable—
photo_urlstringnullable—
short_namestringnullable—
swingsstringnullableRight, Left
golf.tours7 fields· 1 refs· 5 referenced-byendpoints →

Professional golf tours — the PGA Tour, LIV Golf, the DP World Tour (formerly European Tour), the Korn Ferry Tour, the LPGA, and other competitive circuits.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
tour_idinteger—
activeboolean—
codestringTour code (pga, european, liv, lpga, champions, korn_ferry)
descriptionstringnullable—
logo_urlstringnullable—
namestring—
golf.courses15 fields· 1 refs· 1 referenced-byendpoints →

Golf courses that host professional events — Augusta National, Pebble Beach, St Andrews, TPC Sawgrass, and every other venue on the PGA, LIV, DP World, and Korn Ferry calendars.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
league_course_idintegernullableOfficial PGA Tour course id
addressstringnullable—
citystringnullable—
countrystringnullable—
elevationfloatnullableElevation in feet above sea level
image_urlstringnullableURL to aerial/overview image of course
latitudefloatnullable—
longitudefloatnullable—
namestring—
parinteger—
statestringnullable—
timezonestringnullableIANA timezone (e.g., America/New_York)
yardsinteger—
zipstringnullable—
golf.seasons6 fieldsendpoints →

Each season on a professional golf tour — the year-long schedule of tournaments leading up to the FedExCup playoffs (PGA), the major championships, and the season-ending Tour Championship.

FieldTypeDescription
start_yearkeyinteger—
tour_idkeybigint—
league_idstringnullableOfficial tour season identifier
descriptionstringnullable—
end_datetimestamptznullable—
start_datetimestamptz—
golf.tournaments23 fields· 3 refs· 10 referenced-byendpoints →

Every professional golf tournament — the four majors (Masters, PGA Championship, U.S. Open, Open Championship), the PGA Tour stops, LIV events, the FedExCup playoffs, and Korn Ferry Tour events.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
league_idstringnullableOfficial tour tournament identifier
season_tour_idbigintnullable—
tour_idbigintnullable—
tournament_idinteger—
canceledboolean—
citystringnullable—
countrystringnullable—
end_datetimestamptznullable—
is_in_progressboolean—
is_overboolean—
namestring—
parintegernullable—
pursebigintnullableTotal prize money in cents
roundsintegernullable—
season_start_yearintegernullable—
start_datetimestamptz—
start_date_timetimestamptznullable—
statestringnullable—
time_zonestringnullable—
venuestringnullable—
yardsintegernullable—
zipstringnullable—
golf.operator_player_lookups5 fields· 3 refsendpoints →

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

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
operator_idbigintOperator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io.
operator_player_idstringExternal player ID from operator
player_idbigintInternal golf.players.id reference
player_namestringnullablePlayer name for reconciliation
golf.player_season_stats41 fields· 3 refsendpoints →

Season totals for each professional golfer — events played, cuts made, top-10 finishes, wins, and prize money earned. Ball-striking and strokes-gained metrics are not carried here.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
season_tour_idbigintnullable—
tour_idbigintnullable—
birdiesintegernullable—
bogey_free_roundsintegernullable—
bogeysintegernullable—
bounce_back_countintegernullable—
consecutive_birdie_or_better_countintegernullable—
cuts_madeintegernullable—
double_bogeysintegernullable—
double_eaglesintegernullable—
driving_accuracy_pctdecimalnullable—
driving_distancedecimalnullableAverage driving distance in yards
eaglesintegernullable—
eventsintegernullable—
gir_pctdecimalnullableGreens in regulation percentage
holes_in_oneintegernullable—
parsintegernullable—
putts_per_rounddecimalnullable—
roundsintegernullable—
rounds_under_seventyintegernullable—
scrambling_pctdecimalnullable—
season_start_yearintegernullable—
second_placeintegernullable—
sg_approachdecimalnullable—
sg_around_greendecimalnullable—
sg_off_teedecimalnullable—
sg_puttingdecimalnullable—
sg_totaldecimalnullable—
streaks_of_three_birdies_or_betterintegernullable—
third_placeintegernullable—
top_fiveintegernullable—
top_tenintegernullable—
top_twenty_fiveintegernullable—
total_scoreintegernullableTotal score relative to par
total_strokesintegernullable—
triple_bogeysintegernullable—
winsintegernullable—
worse_than_double_bogeyintegernullable—
worse_than_triple_bogeyintegernullable—
golf.course_hole_stats15 fields· 1 refsendpoints →

Per-hole scoring statistics for each round of a tournament — par, yardage, the field's scoring average and its relation to par, and the distribution of eagles, birdies, pars, and bogeys, plus difficulty rank.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
tournament_idbigint—
birdiesintegernullable—
bogeysintegernullable—
course_codestringPGA Tour course code (e.g., 014 = Augusta National)
double_bogeysintegernullable—
eaglesintegernullable—
hole_numberinteger—
parintegernullable—
parsintegernullable—
rankintegernullableDifficulty rank among holes (1 = hardest)
round_numberinteger—
scoring_averagedecimalnullable—
scoring_average_diffdecimalnullableScoring average relative to par
yardsintegernullable—
golf.leaderboards23 fields· 3 refsendpoints →

The full leaderboard of every professional golf tournament — each player's position, score relative to par, total strokes, made cut/missed cut status, and prize money.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
player_tournament_idinteger—
tournament_idbigint—
earningsbigintnullablePrize money earned in cents
fedex_ptsintegernullable—
is_alternatebooleannullable—
is_withdrawnbooleannullable—
made_cutintegernullable1 if made cut, 0 if missed
made_cut_did_not_finishbooleannullable—
rankintegernullable—
sg_approachdecimalnullable—
sg_around_greendecimalnullable—
sg_off_teedecimalnullable—
sg_puttingdecimalnullable—
sg_tee_to_greendecimalnullable—
sg_totaldecimalnullable—
tee_timetimestamptznullable—
total_scoreintegernullableScore relative to par
total_strokesintegernullable—
total_throughintegernullableCurrent hole of player for current round
tournament_statusstringnullableout, active, etc.
winintegernullable1 if won tournament
golf.player_holes17 fields· 2 refsendpoints →

Hole-by-hole scoring for each player at each professional tournament — strokes and score relative to par per hole. (Shot-level tracking — drive distance, approach result, putts — is not carried here.)

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
player_round_idbigint—
tournament_idbigint—
birdiebooleannullable—
bogeybooleannullable—
double_bogeybooleannullable—
double_eaglebooleannullable—
eaglebooleannullable—
hole_in_onebooleannullable—
hole_numberinteger—
is_parbooleannullable—
parintegernullable—
round_numberinteger—
scoreintegernullable—
to_parintegernullableScore relative to par for this hole
worse_than_double_bogeybooleannullable—
golf.player_news18 fields· 2 refsendpoints →

News about professional golfers — equipment changes, swing coach updates, sponsorships, tour-status changes, suspensions, and general beat-reporter updates.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigintnullable—
tournament_idbigintnullable—
ai_processedboolean—
authorstringnullable—
categoriesstringnullable—
contentstringnullable—
news_timetimestamptz—
original_sourcestringnullable—
original_source_urlstringnullable—
priorityinteger—
situational_impactjsonbnullable—
sourcestringnullable—
source_keystringnullable—
terms_of_usestringnullable—
titlestring—
updated_timetimestamptznullable—
urlstringnullable—
golf.player_rounds26 fields· 2 refsendpoints →

Each player's scoring line for each round of every professional golf tournament — total strokes, score relative to par, eagles, birdies, bogeys, and double-bogeys. (Ball-striking detail — fairways, greens in regulation, putts — is not carried here.)

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
player_round_idinteger—
tournament_idbigint—
back_nine_startbooleannullable—
birdiesintegernullable—
bogeysintegernullable—
daydatenullable—
double_bogeysintegernullable—
double_eaglesintegernullable—
eaglesintegernullable—
holes_in_oneintegernullable—
parintegernullable—
parsintegernullable—
round_numberinteger—
scoreintegernullableTotal strokes for round
sg_approachdecimalnullable—
sg_around_greendecimalnullable—
sg_off_teedecimalnullable—
sg_puttingdecimalnullable—
sg_tee_to_greendecimalnullable—
sg_totaldecimalnullable—
tee_timetimestamptznullable—
triple_bogeysintegernullable—
worse_than_double_bogeyintegernullable—
worse_than_triple_bogeyintegernullable—
golf.player_shots30 fields· 2 refsendpoints →

Shot-by-shot tracking for each player at each professional tournament — every stroke with its type, start/end location, distance, ShotLink/TOURCAST course coordinates, and TrackMan radar metrics (club & ball speed, spin, launch angle, apex, carry). Available for regular PGA Tour events with ShotLink; majors such as the Masters do not publish shot tracking.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
player_idbigint—
tournament_idbigint—
apex_heightfloatnullable—
ball_speedfloatnullable—
carry_distancefloatnullable—
club_speedfloatnullable—
distance_remaining_yardsfloatnullableDistance to the hole after the shot, in yards
distance_yardsfloatnullableShot distance in yards (null when the source reports feet near the green)
final_strokebooleannullable—
from_locationstringnullable—
from_location_codestringnullable—
from_xfloatnullable—
from_yfloatnullable—
from_zfloatnullable—
hole_numberinteger—
launch_anglefloatnullableVertical launch angle (degrees)
launch_spinfloatnullable—
parintegernullable—
play_by_playstringnullable—
round_numberinteger—
shot_numberintegerStroke sequence within the hole (1 = first stroke)
smash_factorfloatnullable—
spin_axisfloatnullable—
stroke_typestringnullableSTROKE, PENALTY, DROP, PROVISIONAL
to_locationstringnullable—
to_location_codestringnullable—
to_xfloatnullable—
to_yfloatnullable—
to_zfloatnullable—
golf.tournament_odds22 fields· 2 refsendpoints →

Outright betting odds for professional golf tournaments — who wins the event, top-5/top-10/top-20 finish markets, head-to-head matchups, and other tournament-level wagers from sportsbooks.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
matchup_opponent_idbigintnullable—
player_idbigint—
round_matchup_opponent_idbigintnullable—
three_ball_opponent1_idbigintnullable—
three_ball_opponent2_idbigintnullable—
tournament_idbigint—
first_round_leader_oddsintegernullable—
is_alternatebooleannullable—
is_availablebooleannullable—
make_cut_oddsintegernullable—
matchup_oddsintegernullable—
matchup_opponent_oddsintegernullable—
miss_cut_oddsintegernullable—
outright_oddsintegernullableOdds to win tournament (American format)
round_matchup_oddsintegernullable—
round_matchup_opponent_oddsintegernullable—
sportsbookstringnullableDraftKings, FanDuel, BetMGM, etc.
three_ball_oddsintegernullable—
top_five_oddsintegernullable—
top_ten_oddsintegernullable—
top_twenty_oddsintegernullable—
golf.tournament_rounds5 fields· 1 refsendpoints →

Each round of every professional golf tournament — round 1 (Thursday), round 2 (Friday cut day), and the weekend rounds (Saturday and Sunday) plus any playoff holes.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
round_idinteger—
tournament_idbigint—
daydate—
round_numberinteger—

Kalshi7 tables

kalshi.series9 fields· 2 referenced-byendpoints →

Families of related Kalshi binary markets organized around a common theme — all NBA game-winner markets, all NBA spread markets, all NFL totals markets, election markets, weather markets. Tracks series-level metadata and sync state.

References
—
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
categorystringe.g. "Sports > Basketball > NBA"
contract_typestringnullable"gw", "spread", "ou"
fetched_attimestamptz—
frequencystringnullable"daily", "weekly"
is_activeboolean—
league_codestringnullablee.g. "nba", "nfl", null for non-sport
series_tickerstringe.g. "KXNBAGAME"
titlestring—
kalshi.market_statuses6 fieldsendpoints →

The trading-status period log for each Kalshi market — one row per state change with start/end timestamps, recording when the market was open, closed, settled, etc. Sparse coverage — captured 2025-10 through 2026-02 for ~1,500 markets; not currently updating.

FieldTypeDescription
idkeybigintPrimary Key
detailsjsonbnullable—
end_tstimestamptz—
start_tstimestamptz—
statusstring"open", "closed", "settled", etc.
tickerstring—
kalshi.events15 fields· 1 refs· 1 referenced-byendpoints →

A real-world event that anchors a set of Kalshi markets — for sports, a specific game or matchup; for politics, an election or vote; for finance, a price level on a target date. E.g., MEM@POR game-winner event has 2 markets (MEM wins, POR wins).

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
competition_idbigintnullablePolymorphic cross-schema ref — {league}.games (team sports) or golf.tournaments (golf), resolved during sync by league_code. Dereference via main.competitions. NULL until linked.
league_game_idstringnullableNBA CDN game ID for fallback cross-ref
series_idbigint—
away_teamstringnullableTricode: "MEM"
categorystring—
event_tickerstringe.g. "KXNBAGAME-26FEB06MEMPOR"
fetched_attimestamptz—
game_datedatenullableGame date for sport events
home_teamstringnullableTricode: "POR"
league_codestringnullableDenormalized for filtering
market_countintegernullable—
settled_attimestamptznullable—
statusstring"open", "closed", "settled"
titlestring—
kalshi.markets23 fields· 2 refs· 3 referenced-byendpoints →

An individual binary contract on Kalshi — a YES/NO question with a defined resolution date and rule, priced between 0 and 100 cents. Stores latest known state (overwritten on sync).

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
competition_idbigintnullablePolymorphic cross-schema ref (denormalized from event) — {league}.games or golf.tournaments, by league_code. Dereference via main.competitions. NULL until linked.
event_idbigint—
series_idbigintDenormalized from event for direct queries
close_timetimestamptznullable—
contract_typestring"gw", "spread", "ou"
expiration_timetimestamptznullable—
fetched_attimestamptz—
last_priceintegernullableCents (1-99)
linedecimalnullableSpread line for spread markets (e.g., -3.5). UNRELIABLE for ou (totals) markets — mostly null, and populated values hold the playoff series game number, not the total; parse the numeric ticker suffix (e.g. …-238 ⇒ 238) for the O/U line.
liquidityinteger—
open_interestinteger—
open_timetimestamptznullable—
resultstringnullable"yes", "no", "scalar", null if undetermined
settled_attimestamptznullableSettlement timestamp from Kalshi settlement_ts
settlement_valueintegernullableSettlement payout for YES side in cents (0-100 for binary, 1-99 possible for scalar)
statusstring"initialized", "inactive", "active", "closed", "determined", "disputed", "amended", "finalized"
subtitlestringnullable—
tickerstringe.g. "KXNBAGAME-26FEB06MEMPOR-POR"
titlestring—
volumeintegerLifetime volume
yes_askintegernullableCents. 1-99 while an order book exists; 100 when there is no resting ask (the common state on settled markets).
yes_bidintegernullableCents. 1-99 while an order book exists; 0 when there is no resting bid (the common state on settled markets).
kalshi.candles15 fields· 1 refsendpoints →

OHLC candlestick price summaries for Kalshi markets — the open, high, low, and close prices over standard time bins (1 minute, 5 minute, 1 hour, 1 day), with traded volume per bin. Flattened columns (not JSON) for SQL queryability.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigint—
end_period_tsintegerUnix timestamp of period end
open_interestintegerOI at period end
period_intervalintegerSeconds (1, 60, 3600, 86400)
tickerstringDenormalized
volumeintegerPeriod volume
yes_ask_closeintegernullable—
yes_ask_highintegernullable—
yes_ask_lowintegernullable—
yes_ask_openintegernullable—
yes_bid_closeintegernullable—
yes_bid_highintegernullable—
yes_bid_lowintegernullable—
yes_bid_openintegernullableCents
kalshi.market_snapshots11 fields· 1 refsendpoints →

Time-series price captures for Kalshi markets — the YES bid/ask and NO bid/ask, last trade price, and order-book depth recorded as prices move throughout the trading session. Same pattern as nba.game_line.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigint—
captured_attimestamptz—
is_openingbooleanFirst snapshot for this market
last_priceintegernullable—
liquidityinteger—
open_interestinteger—
tickerstringDenormalized for efficient queries
volumeintegerCumulative at capture time
yes_askintegernullable—
yes_bidintegernullable—
kalshi.public_trades14 fields· 1 refsendpoints →

Every executed trade on Kalshi — price, size, side (YES or NO), and timestamp, comprising the public market tape. Represents completed market trades across all users.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigint—
trade_idstring—
countinteger—
count_fpstringnullable—
created_timetimestamptznullable—
no_priceintegernullable—
no_price_dollarsstringnullable—
pricefloatnullable—
raw_payloadjsonb—
taker_sidestringnullable"yes" | "no"
tickerstring—
yes_priceintegernullable—
yes_price_dollarsstringnullable—

Polymarket10 tables

polymarket.events18 fields· 2 referenced-byendpoints →

A real-world event that anchors a set of Polymarket markets — a single sports game, an election, a futures question, or any other resolvable scenario. E.g., "Mavericks vs Suns" game event or "2026 NBA Champion" futures event.

References
—
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
competition_idbigintnullablePolymorphic cross-schema ref — {league}.games (team sports) or golf.tournaments (golf), resolved at app level by slug parsing via league_code. Dereference via main.competitions. NULL until linked.
condition_idstringPolymarket event condition ID (stable identifier)
away_teamstringnullableTricode: "DAL"
descriptionstringnullable—
end_datetimestamptznullable—
fetched_attimestamptz—
game_datedatenullableGame date parsed from slug
home_teamstringnullableTricode: "PHX"
league_codestringnullablee.g. "nba", denormalized for filtering
liquiditybigintnullableCurrent liquidity in USDC minor units
market_countintegernullable—
neg_riskbooleanTrue for multi-outcome groups (e.g., 30-team NBA Champion)
slugstringURL slug, e.g. "nba-dal-phx-2026-04-08"
start_datetimestamptznullable—
statusstring"active", "closed", "resolved"
titlestring—
volumebigintnullableLifetime volume in USDC minor units
polymarket.sports5 fields· 1 refs· 1 referenced-byendpoints →

Sport categories used on Polymarket — basketball, football, baseball, hockey, soccer, MMA, and other tags that organize sports markets. Small reference table (~20 rows).

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
sport_idintegernullablePolymarket sport ID from API
fetched_attimestamptz—
namestringDisplay name, e.g. "NBA"
tag_slugstringe.g. "nba", "nfl", "soccer"
polymarket.tokens10 fields· 3 refs· 7 referenced-byendpoints →

The tradable outcome tokens within a Polymarket market — YES and NO for binary markets, or one token per outcome for multi-outcome markets (e.g., each team in a championship futures market). The clobTokenId is used to query CLOB API for pricing and trades.

References
FieldTypeDescription
idkeybigintPrimary Key
event_idbigintnullableDenormalized for direct event queries
market_idbigint—
token_idstringPolymarket clobTokenId (used for CLOB API queries)
fetched_attimestamptz—
final_price_bpsintegernullableSettlement price (10000 for winner, 0 for loser)
outcomestringOutcome label: team name, "Yes", "No"
outcome_indexinteger0-based index of this outcome within the market
price_bpsintegernullableLatest price in basis points (0-10000)
winnerbooleannullableTrue if this outcome won, null if unresolved
polymarket.markets21 fields· 2 refs· 7 referenced-byendpoints →

An individual prediction market on Polymarket — a specific question tied to an event, resolved on-chain, with one or more tradable outcome tokens. Each market has 2+ tokens representing outcome positions.

References
FieldTypeDescription
idkeybigintPrimary Key
competition_idbigintnullablePolymorphic cross-schema ref (denormalized from event) resolved at app level by league_code. Dereference via main.competitions. NULL until linked.
condition_idstringPolymarket market condition ID (stable identifier)
event_idbigint—
payout_token_idstringnullableToken ID that paid out at 1.00 (winner)
activeboolean—
best_ask_bpsintegernullableBasis points (0-10000)
best_bid_bpsintegernullableBasis points (0-10000)
closedboolean—
fetched_attimestamptz—
last_trade_price_bpsintegernullableBasis points (0-10000)
liquiditybigintnullable—
neg_riskboolean—
outcome_countintegerNumber of tokens/outcomes (2 for binary, N for multi-outcome)
questionstringnullableFull question text
resolution_sourcestringnullable"uma", "manual", etc.
resolved_attimestamptznullableWhen the market was resolved
resultstringnullableWinning outcome string, null if unresolved
slugstringnullable—
statusstring"active", "closed", "resolved"
volumebigintnullable—
polymarket.candles11 fields· 2 refsendpoints →

OHLC candlestick price summaries for Polymarket outcome tokens — the open, high, low, close, and volume over standard time bins (1 minute, 5 minute, 1 hour, 1 day). Bucketed by (token_id, period_interval, end_period_ts).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigint—
token_idstring—
close_bpsintegernullable—
end_period_tsintegerUnix epoch second of period end
high_bpsintegernullable—
low_bpsintegernullable—
open_bpsintegernullable—
period_intervalintegerPeriod length in seconds (1, 60, 300, 3600)
sizebigintTotal share size in micro-units
volumeintegerTrade count in period
polymarket.market_snapshots9 fields· 1 refsendpoints →

Market-level snapshots on Polymarket — aggregate volume, open interest, last trade price, and resolution status captured over time as the market trades. Tracks bid/ask/last and volume/liquidity over time. Coverage begins 2026-04; cadence is roughly hourly.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
condition_idstringDenormalized for efficient queries
market_idbigint—
best_ask_bpsintegernullable—
best_bid_bpsintegernullable—
captured_attimestamptz—
last_trade_price_bpsintegernullable—
liquiditybigintnullable—
volumebigintnullableCumulative at capture time
polymarket.order_book_snapshots10 fields· 2 refsendpoints →

Order-book depth snapshots for Polymarket outcome tokens — the bid and ask ladders captured at a point in time, showing the resting liquidity at each price level. Top 10 levels per side per token at capture time. Coverage begins 2026-04; pregame cadence (captures generally stop shortly after tip-off).

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigint—
token_idstring—
captured_attimestamptz—
depth_rankinteger0=best (top of book), 1=second best, etc.
midpoint_bpsintegernullableMidpoint price at capture time
price_bpsintegerPrice level in basis points
sidestring"BID" or "ASK"
sizebigintSize at this level in micro-units
spread_bpsintegernullableBid-ask spread at capture time (top of book only)
polymarket.price_histories10 fields· 2 refsendpoints →

Historical price tracks for each Polymarket outcome token — the full time-series of trading prices since the market opened. Analogous to kalshi.candle.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigintDenormalized for market-level queries
token_idstringPolymarket clobTokenId
close_bpsinteger—
high_bpsinteger—
interval_secondsintegerPeriod length in seconds (60, 3600, 86400)
low_bpsinteger—
open_bpsintegerOpening price in basis points
period_starttimestamptzStart of this OHLC period
volumebigintnullablePeriod volume
polymarket.public_trades10 fields· 2 refsendpoints →

Every executed trade on Polymarket — price, size, side (buy or sell of each token), and timestamp, comprising the public market tape. Represents completed market trades.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigintDenormalized for market-level queries
token_idstringPolymarket clobTokenId
trade_idstringTrade ID from Polymarket API
maker_addressstringnullableMaker address (limit order provider) from on-chain event
price_bpsintegerTrade price in basis points (0-10000)
sidestring"BUY" or "SELL"
sizebigintTrade size (number of shares)
taker_addressstringnullableTaker address (market order) from on-chain event
traded_attimestamptz—
polymarket.token_snapshots5 fields· 2 refsendpoints →

Token-level snapshots on Polymarket — the bid, ask, and last trade price for each outcome token captured over time as the market trades. Critical for multi-outcome markets where each token moves independently. Coverage begins 2026-04; cadence is roughly 1-2 hours.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
market_idbigintDenormalized for market-level queries
token_idstringPolymarket clobTokenId
captured_attimestamptz—
price_bpsintegerPrice in basis points (0-10000)

DFS13 tables

dfs.slates9 fields· 1 refs· 3 referenced-byendpoints →

DFS contest slate. A slate is one operator + one league + a fixed game pool + scoring rules; users build lineups against it.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
external_idbigintOperator-side slate identifier (e.g., DraftKings contest group ID).
league_idbigintFK to the league this slate belongs to.
operator_idbigintFK to the DFS operator (DraftKings, FanDuel, Yahoo, etc.).
slate_setting_idbigintFK to slate_settings — the scoring format and roster constraints for this slate.
datedateCalendar day of the slate in US Eastern time (DB-generated from start_time — read-only).
mainbooleanWhether this is the main slate for this operator/league. Currently never populated (always false) — identify main slates by name/start_time until the loader fills it.
namestringnullableHuman-readable slate label (e.g., "Sunday Main", "Showdown: TB vs KC").
start_timetimestamptzLock time — first scheduled tip/kickoff of any game in the pool.
dfs.contest_user_lineup_player_entries6 fieldsendpoints →

A single roster slot within a submitted contest lineup — one slate player in one position, with the fantasy points they scored.

FieldTypeDescription
idkeybigintPrimary Key
contest_user_lineup_idbigintFK to the submitted lineup this roster slot belongs to.
slate_player_idbigintReferences slate_player (player_id, salary, position)
display_orderinteger—
pointsdecimalnullableFantasy points scored by this player
roster_positionstringPosition slot: PG, SG, SF, PF, C, UTIL, etc.
dfs.contest_users4 fields· 1 refsendpoints →

A contest entrant — one operator-side user who submitted at least one lineup. Identified by the operator's user id, not a statview account.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
external_idstringOperator user ID
operator_idbigint—
namestringnullable—
dfs.game_stats4 fieldsendpoints →

Per-game results for the games in a slate's pool (coming soon).

FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
league_idbigint—
datajsonb—
dfs.player_stats6 fieldsendpoints →

Per-player fantasy scoring results for a slate's games (coming soon — populated after the DFS stat loader ships).

FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
league_idbigint—
player_idbigint—
team_idbigint—
datajsonb—
dfs.slate_player_projections8 fieldsendpoints →

Fantasy-points projection for one player in one slate from one source. Multiple sources produce multiple rows per (slate_player).

FieldTypeDescription
idkeybigintPrimary Key
slate_player_idbigintFK to dfs.slate_players — which slate-player this projection covers.
slate_projection_source_idbigintFK to dfs.slate_projection_sources — which provider produced this projection.
ceilingdecimalnullable85th percentile projection (upside)
floordecimalnullable15th percentile projection (conservative)
projectiondecimalMedian (P50) projected fantasy points.
statsjsonbnullableComponent stat projections by sport. NFL example: {"pass_yds": 275.5, "pass_tds": 1.5, "pass_ints": 0.5, "rush_yds": 22.5, "rush_tds": 0.3, "rec": 4.5, "rec_yds": 45.0, "rec_tds": 0.4}
std_devdecimalnullableStandard deviation for simulation/distribution
dfs.slate_projection_sources7 fieldsendpoints →

A registered projection provider for a slate (e.g., RotoGrinders consensus, an in-house model, a user upload).

FieldTypeDescription
idkeybigintPrimary Key
slate_setting_idbigintFK to dfs.slate_settings — which slate format this source provides projections for.
descriptionstringnullableFree-text description of the source methodology.
display_orderintegerSort order for UI display.
enabledbooleanFalse hides this source from lineup-builder dropdowns.
namestringDisplay name of the projection source.
source_typeintegerSource-type enum (0=manual upload, 1=consensus, 2=model, etc.).
dfs.slate_settings8 fields· 1 refsendpoints →

The scoring format and roster-construction ruleset a slate is built on — salary cap, position slots, and scoring rules per operator / league / game-type combination. A small reference table that many slates point at.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
league_idbigint—
operator_idbigint—
contest_typeinteger—
game_stylestringnullable—
game_typeinteger—
namestring—
settingsjsonbFull ruleset as JSON: salary cap, roster slots, and the per-stat scoring rules (e.g. DK NBA: 1.25/rebound, 1.5/assist, double-double bonuses, CPT 1.5x). With this plus per-game box scores you can recompute any lineup's fantasy points exactly.
dfs.team_stats5 fieldsendpoints →

Per-team fantasy-relevant results for a slate's games (coming soon).

FieldTypeDescription
idkeybigintPrimary Key
game_idbigint—
league_idbigint—
team_idbigint—
datajsonb—
dfs.contests11 fields· 1 refs· 1 referenced-byendpoints →

A DFS contest run on a slate — its entry fee, prize pool, entry caps, and type (GPP vs cash). One slate hosts many contests.

References
Referenced by
FieldTypeDescription
idkeybigintPrimary Key
external_idbigintOperator contest ID
slate_idbigintFK to the slate this contest runs on.
contest_typeinteger0=GPP, 1=Cash
entry_countintegerEntries submitted at load time.
entry_feeintegerEntry fee in cents
guaranteedbooleanWhether the prize pool is guaranteed regardless of entries filled.
max_entriesintegerMaximum total entries the contest accepts.
max_entries_per_userintegerMaximum lineups a single entrant may submit.
namestringOperator-facing contest name (e.g. "$5 NBA Mini-MAX").
prize_poolintegerTotal prize pool in cents
dfs.slate_games6 fields· 1 refsendpoints →

Many-to-many bridge between a DFS slate and the sport games included in its pool.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
external_idstringnullableOperator-side game identifier.
game_idbigintPolymorphic reference to {nfl,nba,mlb}.games based on league_id
league_idbigintLeague key disambiguating the polymorphic game_id (nfl/nba/mlb/nhl).
slate_idbigintFK to dfs.slates.
datajsonbnullableOperator-provided game-level metadata (e.g., totals/spreads at slate snapshot).
dfs.slate_players17 fields· 1 refsendpoints →

Player pool for a DFS slate — one row per (slate, player, roster slot). Carries operator salary, positions, and any operator-side metadata.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
export_idstringnullableOperator player ID used for CSV export/import
external_idstringnullableOperator player identifier in this slate.
league_idbigintLeague key disambiguating player_id.
player_idbigintPolymorphic FK to {nfl,nba,mlb,nhl}.players based on league_id.
slate_game_idbigintFK to dfs.slate_games — the specific slate-game this player is rostered to.
slate_idbigintFK to dfs.slates.
team_idbigintnullablePolymorphic FK to {league}.teams. Null for golfers and other player-only sports.
avg_pointsfloatnullableAverage fantasy points from operator
display_namestringnullableFull display name from operator
first_namestringnullablePlayer first name from operator
injury_detailsstringnullableInjury body part/details
injury_statusstringnullableInjury status (Q, D, O, IR)
last_namestringnullablePlayer last name from operator
positionstringPrimary position label per operator (e.g., RB, WR, PG, SP).
roster_positionstringRoster slot the player can fill (RB, FLEX, UTIL, CPT, etc.) — distinguishes multi-slot eligibility. Legacy showdown rows may carry an empty string for the non-captain slot.
salaryintegerOperator-assigned DFS salary (whole dollars; e.g., 8400 = $8,400).
dfs.contest_user_lineups7 fields· 1 refsendpoints →

A single lineup submitted to a contest by an entrant, with its finishing rank, total fantasy points, and winnings where the contest has settled.

References
Referenced by
—
FieldTypeDescription
idkeybigintPrimary Key
contest_idbigint—
contest_user_idbigint—
external_idbigintOperator entry ID
pointsdecimalnullableTotal fantasy points scored
rankintegernullable—
winningsintegernullablePrize won in cents

Reference1 tables

main.operators7 fields· 21 referenced-byendpoints →

The operators referenced by every operator_id filter across the public API — DFS sites (1 DraftKings, 2 FanDuel, 3 Yahoo), sportsbooks (1683 Pinnacle, 1684 BetMGM, 1685 Caesars, 1686 BetRivers, 1687 ESPN BET), and data providers (6 Consensus, 13 sportsdata.io). A small read-only lookup table.

References
—
FieldTypeDescription
idkeybigintPrimary Key
codestringStable machine code (e.g. draftkings, fanduel, consensus, pinnacle).
descriptionstringnullable—
is_activebooleanFalse for operators no longer ingested.
namestringDisplay name (e.g. DraftKings, FanDuel, Pinnacle).
operator_typestringOperator class — DFS, betting, media, or data provider (mixed-case legacy values exist).
website_urlstringnullable—