[ ≡ ]
════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════
┌─[ 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.
COLLEGE SEASON STATS
statpad.college_season_stats
> Per-season NCAA player production, curated from cfbfastR play-level data.
── ID
Name
player_name
Short / abbreviated player name (e.g. P.Mahomes).
CFB ID
cfb_player_id
cfbfastR player identifier for NCAA stats.
GSIS
gsis_id
NFL Game Statistics & Information System ID.
Season
season
NFL season year (e.g. 2024 = 2024-25 season).
Team
team
— self-explanatory.
Conf
conference
Conference abbreviation (e.g. SEC, B1G, ACC).
G
games
Games played in the period.
── PASSING
Pass Att
pass_attempts
College pass attempts.
Pass Cmp
pass_completions
College pass completions.
Cmp%
pass_completion_pct
Completion percentage for college passing.
Pass Yds
passing_yards
Net passing yards.
Pass TD
passing_tds
Passing touchdowns.
Pass INT
passing_interceptions
Interceptions thrown.
YPA
yards_per_pass_attempt
Passing yards divided by pass attempts (college).
── RUSHING
Rush Att
rush_attempts
Rush attempts (NGS naming).
Rush Yds
rushing_yards
Net rushing yards.
Rush TD
rushing_tds
Rushing touchdowns.
YPC
yards_per_carry
Rushing yards ÷ carries (Y/C).
── RECEIVING
Tgt
targets
Times targeted as the intended receiver.
Rec
receptions
Catches.
Rec Yds
receiving_yards
Receiving yards.
Rec TD
receiving_tds
Receiving touchdowns.
YPR
yards_per_reception
Receiving yards divided by receptions (college).
── OTHER
Scrim Yds
scrimmage_yards
Rushing + receiving yards.
Total TD
total_tds
Passing + rushing + receiving touchdowns.
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.
PLAYCALLING TENDENCIES
statpad.playcalling_tendencies
> Team/coach playcalling tendencies by situation (2016–present), sliced by split_type. Defaults to the 'overall' split — switch it for neutral, down, half, score_state, or field_zone.
── ID
Play Caller
play_caller
Person who called the offensive plays for the stint.
Team
team
— self-explanatory.
Season
season
NFL season year (e.g. 2024 = 2024-25 season).
Role
role
Play caller's role — HC (head coach) or OC (offensive coordinator).
Head Coach
head_coach
Head coach during the stint.
Midszn Chg
has_midseason_change
True if the play caller changed midseason for this team-season.
Split
split_type
Situational slice: overall, neutral (competitive game state), down, half, score_state (leading/tied/trailing), or field_zone.
Split Val
split_value
Value within the split_type (e.g. '1'/'2'/'3' for down, 'redzone' for field_zone, 'all' for overall/neutral).
Stint
stint_key
Team-season play-calling stint key (e.g. ARI-2016).
── VOLUME
Plays
plays
Offensive plays run in the split.
G
games
Games played in the period.
Dropbacks
dropbacks
Pass plays including scrambles and sacks (pass attempts + sacks + scrambles).
Rush Att
rush_attempts
Rush attempts (NGS naming).
── TENDENCY
Pass%
pass_rate
Percentage of plays that were dropbacks (0–100).
PROE
proe
Pass Rate Over Expected — actual pass rate minus the model's situational expectation, in percentage points. Positive = pass-happier than league norm.
Shotgun%
shotgun_rate
Percentage of plays run from shotgun (0–100).
Under Ctr%
under_center_rate
Percentage of plays run from under center (0–100).
No Huddle%
no_huddle_rate
Percentage of plays run without a huddle (0–100).
Sec/Play
sec_per_play
Average seconds of game clock elapsed per play (tempo — lower = faster).
Run Out%
run_outside_rate
Percentage of designed runs directed outside the tackles (0–100).
4th Go%
fourth_down_go_rate
Percentage of 4th downs the offense went for it (0–100).
── SCHEME
PA%
play_action_rate
Percentage of dropbacks using play action (0–100). Needs FTN charting — null for uncharted stints.
RPO%
rpo_rate
Percentage of plays that were run-pass options (0–100). Needs FTN charting.
Screen%
screen_rate
Percentage of dropbacks thrown as screens (0–100). Needs FTN charting.
Motion%
motion_rate
Percentage of plays with pre-snap motion (0–100). Needs FTN charting.
Deep%
deep_rate
Percentage of pass attempts thrown 20+ air yards downfield (0–100).
ADOT
adot
Average depth of target — mean air yards on pass attempts.
── PERSONNEL
11 Pers%
personnel_11_rate
Percentage of plays in 11 personnel (1 RB, 1 TE, 3 WR).
12 Pers%
personnel_12_rate
Percentage of plays in 12 personnel (1 RB, 2 TE, 2 WR).
21 Pers%
personnel_21_rate
Percentage of plays in 21 personnel (2 RB, 1 TE, 2 WR).
── EFFICIENCY
EPA/Play
epa_per_play
Expected Points Added per play for the offense in the split.
Success%
success_rate
Percentage of plays with positive EPA (0–100).
Explosive%
explosive_rate
Percentage of plays gaining 20+ pass / 10+ rush yards (0–100).
── RANKS
PROE Pctl
proe_pctl
PROE percentile vs. peer play callers in the same split (100 = most pass-happy).
Pass% Pctl
pass_rate_pctl
Pass rate percentile vs. peers in the same split (0–100).
EPA Pctl
epa_per_play_pctl
EPA/play percentile vs. peers in the same split (100 = most efficient).
Success Pctl
success_rate_pctl
Success rate percentile vs. peers in the same split (0–100).
Motion Pctl
motion_rate_pctl
Motion rate percentile vs. peers in the same split (0–100).
PA Pctl
play_action_rate_pctl
Play-action rate percentile vs. peers in the same split (0–100).
Tempo Pctl
tempo_pctl
Tempo percentile vs. peers in the same split (100 = fastest / lowest sec/play).
── INDEX (A→Z)
adot
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
cfb_player_id
completion_percentage
completion_percentage_above_expectation
completions
cone
conference
deep_rate
draft_pick
draft_round
draft_team
draft_year
dropbacks
efficiency
epa_per_play
epa_per_play_pctl
espn_id
expected_completion_percentage
expected_rush_yards
explosive_rate
fantasy_points
fantasy_points_ppr
fantasypros_id
forty
fourth_down_go_rate
games
gsis_id
has_midseason_change
head_coach
height
height_display
interceptions
last_season
max_air_distance
max_completed_air_distance
mfl_id
motion_rate
motion_rate_pctl
no_huddle_rate
pacr
pass_attempts
pass_completion_pct
pass_completions
pass_rate
pass_rate_pctl
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
personnel_11_rate
personnel_12_rate
personnel_21_rate
pfr_id
play_action_rate
play_action_rate_pctl
play_caller
player_display_name
player_id
player_name
plays
position_group
ppg
ppr_ppg
proe
proe_pctl
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
role
rookie_season
rpo_rate
run_outside_rate
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
screen_rate
scrimmage_yards
season
season_type
sec_per_play
shotgun_rate
shuttle
sleeper_id
special_teams_tds
split_type
split_value
stat_type
status
stint_key
success_rate
success_rate_pctl
target_share
targets
tempo_pctl
total_tds
under_center_rate
vertical
week
weight
wopr
yahoo_id
yards
yards_per_attempt
yards_per_carry
yards_per_pass_attempt
yards_per_reception
yards_per_target
years_experience
© 2026 STATPAD.co · not affiliated with the NFL
[ TERMS ]
·
[ PRIVACY ]