[ ≡ ]
════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════
┌─[ GLOSSARY.txt ]
// GLOSSARY_
> what every column in the query builder actually measures. grouped by table and category. unfamiliar acronyms (epa, cpoe, wopr, racr, pacr) explained.
PLAYERS
statpad.players
> One row per NFL player — full bio & draft data.
── ID
Name
name
— self-explanatory.
First
first_name
— self-explanatory.
Last
last_name
— self-explanatory.
Pos
position
— self-explanatory.
Pos Grp
position_group
Coarse position bucket (QB, RB, WR, TE, OL, DL, LB, DB, ST, SPEC).
Team
team
— self-explanatory.
Status
status
Roster status (e.g. ACT, RES, DEV).
── BIO
Age
age
— self-explanatory.
Exp
years_experience
Number of completed NFL seasons (0 = rookie).
Height
height
Listed height in inches.
Weight
weight
Listed weight in pounds.
Born
birth_date
Date of birth (YYYY-MM-DD).
College
college
— self-explanatory.
── DRAFT
Draft Team
draft_team
Team that drafted the player.
Draft Yr
draft_year
Year the player was drafted.
Draft Rd
draft_round
Round in which the player was drafted (1–7).
Draft Pk
draft_pick
Overall pick number in the draft.
Rookie Szn
rookie_season
First NFL season the player appeared in.
Last Szn
last_season
Most recent NFL season the player appeared in.
── EXT_IDS
GSIS
gsis_id
NFL Game Statistics & Information System ID.
Sleeper
sleeper_id
Sleeper platform player ID.
Yahoo
yahoo_id
Yahoo Fantasy player ID.
ESPN
espn_id
ESPN Fantasy player ID.
FP ID
fantasypros_id
FantasyPros player ID.
MFL ID
mfl_id
MyFantasyLeague player ID.
SEASON STATS
statpad.season_stats
> Per-season NFL stats — REG + POST.
── ID
Name
player_display_name
Full player name as displayed on broadcasts.
Short Name
player_name
Short / abbreviated player name (e.g. P.Mahomes).
GSIS
player_id
GSIS player ID — stable across seasons.
Season
season
NFL season year (e.g. 2024 = 2024-25 season).
Type
season_type
REG (regular season) or POST (playoffs).
Pos
position
— self-explanatory.
Team
team
— self-explanatory.
G
games
Games played in the period.
── FANTASY
Pts
fantasy_points
Standard fantasy points (no PPR bonus).
PPR Pts
fantasy_points_ppr
Full-PPR fantasy points (1.0 per reception).
PPG
ppg
Standard fantasy points per game played.
PPR PPG
ppr_ppg
Full-PPR fantasy points per game played.
── PASSING
Cmp
completions
Completed passes.
Att
attempts
Pass attempts.
Cmp%
completion_percentage
Completions ÷ attempts × 100.
Pass Yds
passing_yards
Net passing yards.
Pass TD
passing_tds
Passing touchdowns.
INT
passing_interceptions
Interceptions thrown.
Y/A
yards_per_attempt
Passing yards ÷ pass attempts (Y/A).
Pass AirY
passing_air_yards
Sum of air yards on all targets thrown by the QB.
Pass YAC
passing_yards_after_catch
Yards gained by receivers after the catch on QB throws.
Pass 1D
passing_first_downs
First downs gained via passing.
── RUSHING
Car
carries
Rushing attempts.
Rush Yds
rushing_yards
Net rushing yards.
Rush TD
rushing_tds
Rushing touchdowns.
Y/C
yards_per_carry
Rushing yards ÷ carries (Y/C).
Rush 1D
rushing_first_downs
First downs gained via rushing.
── RECEIVING
Rec
receptions
Catches.
Tgt
targets
Times targeted as the intended receiver.
Rec Yds
receiving_yards
Receiving yards.
Rec TD
receiving_tds
Receiving touchdowns.
Y/T
yards_per_target
Receiving yards ÷ targets (Y/T).
Rec AirY
receiving_air_yards
Sum of air yards on the receiver's targets (includes incompletions).
Rec YAC
receiving_yards_after_catch
Yards gained by the receiver after the catch.
Rec 1D
receiving_first_downs
First downs gained via receiving.
── ADVANCED
Pass EPA
passing_epa
Passing Expected Points Added — average value vs. league baseline for the situation. Positive = better than expected.
CPOE
passing_cpoe
Completion % Over Expected — how much better (or worse) the QB completes passes vs. expectation given depth, location, pressure, etc.
PACR
pacr
Passing Air Conversion Ratio — passing yards ÷ passing air yards. >1 = QB gains more than the throw's depth.
Rush EPA
rushing_epa
Rushing Expected Points Added (per the same EPA framework).
Rec EPA
receiving_epa
Receiving Expected Points Added.
Tgt%
target_share
Share of the team's pass attempts targeting this player (0.0–1.0).
AY%
air_yards_share
Share of the team's passing air yards directed at this player (0.0–1.0).
WOPR
wopr
Weighted Opportunity Rating — 1.5 × target_share + 0.7 × air_yards_share. Composite usage metric for receivers.
RACR
racr
Receiver Air Conversion Ratio — receiving yards ÷ air yards. Measures yards squeezed out of each targeted air yard.
── OTHER
Sacks
sacks_suffered
Times the QB was sacked.
Sack Yds
sack_yards_lost
Yards lost on sacks.
Sk Fum
sack_fumbles
Fumbles by the QB on sacks.
Rush Fum
rushing_fumbles
Fumbles on rushing plays.
Rush FumL
rushing_fumbles_lost
Rushing fumbles recovered by the defense.
Rec Fum
receiving_fumbles
Fumbles after a reception.
Rec FumL
receiving_fumbles_lost
Receiving fumbles recovered by the defense.
ST TD
special_teams_tds
Touchdowns scored on special teams.
WEEKLY STATS
statpad.weekly_stats
> One row per player/week of NFL data.
── ID
Name
player_display_name
Full player name as displayed on broadcasts.
Short Name
player_name
Short / abbreviated player name (e.g. P.Mahomes).
GSIS
player_id
GSIS player ID — stable across seasons.
Season
season
NFL season year (e.g. 2024 = 2024-25 season).
Week
week
Week of the season (1–18 reg, 19+ post).
Type
season_type
REG (regular season) or POST (playoffs).
Team
team
— self-explanatory.
Pos
position
— self-explanatory.
Sleeper
sleeper_id
Sleeper platform player ID.
── FANTASY
Pts
fantasy_points
Standard fantasy points (no PPR bonus).
PPR
fantasy_points_ppr
Full-PPR fantasy points (1.0 per reception).
── PASSING
Cmp
completions
Completed passes.
Att
attempts
Pass attempts.
Pass Yds
passing_yards
Net passing yards.
Pass TD
passing_tds
Passing touchdowns.
INT
passing_interceptions
Interceptions thrown.
Pass AirY
passing_air_yards
Sum of air yards on all targets thrown by the QB.
── RUSHING
Car
carries
Rushing attempts.
Rush Yds
rushing_yards
Net rushing yards.
Rush TD
rushing_tds
Rushing touchdowns.
Rush 1D
rushing_first_downs
First downs gained via rushing.
── RECEIVING
Rec
receptions
Catches.
Tgt
targets
Times targeted as the intended receiver.
Rec Yds
receiving_yards
Receiving yards.
Rec TD
receiving_tds
Receiving touchdowns.
Rec AirY
receiving_air_yards
Sum of air yards on the receiver's targets (includes incompletions).
── ADVANCED
Pass EPA
passing_epa
Passing Expected Points Added — average value vs. league baseline for the situation. Positive = better than expected.
CPOE
passing_cpoe
Completion % Over Expected — how much better (or worse) the QB completes passes vs. expectation given depth, location, pressure, etc.
PACR
pacr
Passing Air Conversion Ratio — passing yards ÷ passing air yards. >1 = QB gains more than the throw's depth.
Rush EPA
rushing_epa
Rushing Expected Points Added (per the same EPA framework).
Rec EPA
receiving_epa
Receiving Expected Points Added.
Tgt%
target_share
Share of the team's pass attempts targeting this player (0.0–1.0).
AY%
air_yards_share
Share of the team's passing air yards directed at this player (0.0–1.0).
WOPR
wopr
Weighted Opportunity Rating — 1.5 × target_share + 0.7 × air_yards_share. Composite usage metric for receivers.
RACR
racr
Receiver Air Conversion Ratio — receiving yards ÷ air yards. Measures yards squeezed out of each targeted air yard.
── OTHER
Sacks
sacks_suffered
Times the QB was sacked.
Sk Fum
sack_fumbles
Fumbles by the QB on sacks.
COMBINE
statpad.combine
> NFL Scouting Combine measurables and drills, by draft class.
── ID
Name
player_name
Short / abbreviated player name (e.g. P.Mahomes).
Pos
position
— self-explanatory.
School
school
College program the player attended.
Combine Yr
season
NFL season year (e.g. 2024 = 2024-25 season).
── DRAFT
Draft Team
draft_team
Team that drafted the player.
Draft Yr
draft_year
Year the player was drafted.
Draft Rd
draft_round
Round in which the player was drafted (1–7).
Draft Pk
draft_pick
Overall pick number in the draft.
── MEASURABLES
Height
height_display
Listed height, feet-inches format (e.g. 6-02).
Weight
weight
Listed weight in pounds.
── DRILLS
40yd
forty
40-yard dash time in seconds (lower is faster).
Bench
bench
Bench press reps at 225 lbs.
Broad
broad_jump
Broad jump distance in inches.
Vertical
vertical
Vertical jump height in inches.
3-Cone
cone
3-cone drill time in seconds (agility).
Shuttle
shuttle
20-yard shuttle time in seconds (short-area quickness).
── EXT_IDS
GSIS
gsis_id
NFL Game Statistics & Information System ID.
PFR
pfr_id
Pro Football Reference player ID.
CFB
cfb_id
College Football Reference player ID.
NEXT GEN STATS
statpad.nextgen_stats
> NFL Next Gen Stats — tracking-driven metrics, by stat_type (passing/receiving/rushing).
── ID
Name
player_name
Short / abbreviated player name (e.g. P.Mahomes).
Pos
position
— self-explanatory.
Team
team
— self-explanatory.
Season
season
NFL season year (e.g. 2024 = 2024-25 season).
Week
week
Week of the season (1–18 reg, 19+ post).
Type
season_type
REG (regular season) or POST (playoffs).
Stat Type
stat_type
Which NGS subset this row describes: passing, receiving, or rushing. Most columns are only populated for the matching type.
GSIS
gsis_id
NFL Game Statistics & Information System ID.
── PASSING
Att
attempts
Pass attempts.
Cmp
completions
Completed passes.
Pass Yds
pass_yards
Passing yards (NGS naming).
Pass TD
pass_touchdowns
Passing touchdowns (NGS naming).
INT
interceptions
Interceptions thrown (NGS naming).
Rating
passer_rating
NFL Passer Rating (0–158.3).
Cmp%
completion_percentage
Completions ÷ attempts × 100.
── RUSHING
Car
rush_attempts
Rush attempts (NGS naming).
Rush Yds
rush_yards
Rush yards (NGS naming).
Rush TD
rush_touchdowns
Rush touchdowns (NGS naming).
Y/C
avg_rush_yards
Average yards per carry (NGS naming).
── RECEIVING
Tgt
targets
Times targeted as the intended receiver.
Rec
receptions
Catches.
Rec Yds
yards
Receiving yards (NGS naming, since the row is scoped by stat_type).
Rec TD
rec_touchdowns
Receiving touchdowns (NGS naming).
Catch%
catch_percentage
Receptions ÷ targets × 100.
── ADVANCED
xCmp%
expected_completion_percentage
Expected completion % given throw depth, location, pressure, receiver separation, etc. Model baseline for CPOE.
CPOE
completion_percentage_above_expectation
Actual completion % minus expected completion %. Positive = QB is completing more than the model predicts.
Time/Throw
avg_time_to_throw
Average seconds from snap to throw.
Cmp AirY
avg_completed_air_yards
Average air yards on completions (depth of target at the catch point).
Intended AirY
avg_intended_air_yards
Average air yards on all pass attempts, whether completed or not.
AirY Diff
avg_air_yards_differential
Intended minus completed air yards — how much deeper the QB targets than his completion depth.
Aggress
aggressiveness
% of attempts thrown into tight windows (defender ≤1 yard from receiver at arrival). Higher = more downfield risk.
Max Cmp Air
max_completed_air_distance
Longest completion by air distance (yards in the air).
Avg Air Dist
avg_air_distance
Average air distance traveled per attempt.
Max Air Dist
max_air_distance
Furthest throw attempted, completed or not.
AirY to Sticks
avg_air_yards_to_sticks
Average yards past the first-down marker on throws. Negative = short of the sticks.
Cushion
avg_cushion
Average yards between receiver and nearest defender at snap. Bigger = softer coverage.
Separation
avg_separation
Average yards of separation from nearest defender at catch or incompletion.
YAC
avg_yac
Average yards after catch per reception.
xYAC
avg_expected_yac
Expected YAC given catch point, defenders near the catch, etc. Model baseline for YAC+/-.
YAC+/-
avg_yac_above_expectation
Actual YAC minus expected YAC. Positive = receiver adds more after the catch than the model predicts.
AirY Share%
percent_share_of_intended_air_yards
Share of team's intended air yards directed at this receiver while on the field.
xRush Yds
expected_rush_yards
Expected rush yards on a carry given blocking, defender spacing, and down-distance — the model's baseline.
RYOE
rush_yards_over_expected
Actual rush yards minus expected rush yards (RYOE). Positive = runner produced more than the blocking predicted.
RYOE/Att
rush_yards_over_expected_per_att
RYOE divided by rush attempts.
Rush%+/-
rush_pct_over_expected
Share of carries that gained more yards than expected.
Efficiency
efficiency
Next Gen's rusher efficiency metric — total distance travelled vs. yards gained. Lower = more downhill / direct.
8+ Box%
percent_attempts_gte_eight_defenders
% of carries against 8+ defenders in the box (stacked front).
Time to LOS
avg_time_to_los
Average seconds from handoff until the runner crosses the line of scrimmage.
── INDEX (A→Z)
aggressiveness
air_yards_share
attempts
avg_air_distance
avg_air_yards_differential
avg_air_yards_to_sticks
avg_completed_air_yards
avg_cushion
avg_expected_yac
avg_intended_air_yards
avg_rush_yards
avg_separation
avg_time_to_los
avg_time_to_throw
avg_yac
avg_yac_above_expectation
bench
birth_date
broad_jump
carries
catch_percentage
cfb_id
completion_percentage
completion_percentage_above_expectation
completions
cone
draft_pick
draft_round
draft_team
draft_year
efficiency
espn_id
expected_completion_percentage
expected_rush_yards
fantasy_points
fantasy_points_ppr
fantasypros_id
forty
games
gsis_id
height
height_display
interceptions
last_season
max_air_distance
max_completed_air_distance
mfl_id
pacr
pass_touchdowns
pass_yards
passer_rating
passing_air_yards
passing_cpoe
passing_epa
passing_first_downs
passing_interceptions
passing_tds
passing_yards
passing_yards_after_catch
percent_attempts_gte_eight_defenders
percent_share_of_intended_air_yards
pfr_id
player_display_name
player_id
player_name
position_group
ppg
ppr_ppg
racr
rec_touchdowns
receiving_air_yards
receiving_epa
receiving_first_downs
receiving_fumbles
receiving_fumbles_lost
receiving_tds
receiving_yards
receiving_yards_after_catch
receptions
rookie_season
rush_attempts
rush_pct_over_expected
rush_touchdowns
rush_yards
rush_yards_over_expected
rush_yards_over_expected_per_att
rushing_epa
rushing_first_downs
rushing_fumbles
rushing_fumbles_lost
rushing_tds
rushing_yards
sack_fumbles
sack_yards_lost
sacks_suffered
school
season
season_type
shuttle
sleeper_id
special_teams_tds
stat_type
status
target_share
targets
vertical
week
weight
wopr
yahoo_id
yards
yards_per_attempt
yards_per_carry
yards_per_target
years_experience
© 2026 STATPAD.co · not affiliated with the NFL
[ TERMS ]
·
[ PRIVACY ]