NFL

Get a single play_by_play by id

get/api/v1/nfl/play_by_plays/{id}

Request

  • Base URL: https://api.stat-api.com
  • URL: https://api.stat-api.com/api/v1/nfl/play_by_plays/{id}
  • Auth: HTTP bearer

Path parameters

idinteger required

Primary Key

Primary key (id) of the play_by_plays row.

Response

Single play_by_plays row.

aborted_playboolean required

Play was aborted

air_epanumber double nullable

EPA from air yards

air_wpanumber double nullable

WPA from air yards

air_ydsinteger nullable

Yards in air (perpendicular to LOS)

assist_tackleboolean required

Assist tackle on play

assist_tackle_1_player_idstring nullable

Assist tackler 1 GSIS ID

assist_tackle_1_player_namestring nullable

Assist tackler 1 name

assist_tackle_1_teamstring nullable

Assist tackler 1 team

assist_tackle_2_player_idstring nullable

Assist tackler 2 GSIS ID

assist_tackle_2_player_namestring nullable

Assist tackler 2 name

assist_tackle_2_teamstring nullable

Assist tackler 2 team

assist_tackle_3_player_idstring nullable

Assist tackler 3 GSIS ID

assist_tackle_3_player_namestring nullable

Assist tackler 3 name

assist_tackle_3_teamstring nullable

Assist tackler 3 team

assist_tackle_4_player_idstring nullable

Assist tackler 4 GSIS ID

assist_tackle_4_player_namestring nullable

Assist tackler 4 name

assist_tackle_4_teamstring nullable

Assist tackler 4 team

away_coachstring nullable

Away team head coach

away_scoreinteger nullable

Total away points

away_teamstring nullable

Away team abbreviation

away_timeouts_remaininginteger nullable

Away timeouts remaining

away_wpnumber double nullable

Away team win probability

away_wp_postnumber double nullable

Away WP after play

blocked_player_idstring nullable

Blocked kick player GSIS ID

blocked_player_namestring nullable

Blocked kick player name

comp_air_epanumber double nullable

Completion air EPA

comp_air_wpanumber double nullable

Completion air WPA

comp_yac_epanumber double nullable

Completion YAC EPA

comp_yac_wpanumber double nullable

Completion YAC WPA

complete_passboolean required

Pass completed

cpnumber double nullable

Completion probability

cpoenumber double nullable

Completion percentage over expected

def_wpnumber double nullable

Win probability for defense

defensive_extra_point_attemptboolean required

Defense extra point attempt

defensive_extra_point_convboolean required

Defense extra point success

defensive_team_idinteger nullable

FK to teams table for defensive team

defensive_two_point_attemptboolean required

Defense two-point attempt

defensive_two_point_convboolean required

Defense two-point conversion success

defteamstring nullable

Defensive team abbreviation

defteam_scoreinteger nullable

Defense team score at start

defteam_score_postinteger nullable

Defense team score at end

defteam_timeouts_remaininginteger nullable

Defensive team timeouts

descstring nullable

Full play description text

div_gameboolean required

Division game

downinteger nullable

Down (1-4)

driveinteger nullable

Drive number in game

drive_end_transitionstring nullable

How drive ended

drive_end_yard_linestring nullable

Yard line at drive end

drive_ended_with_scoreboolean required

Drive resulted in score

drive_first_downsinteger nullable

First downs gained in drive

drive_game_clock_endstring nullable

Game clock at drive end

drive_game_clock_startstring nullable

Game clock at drive start

drive_idinteger nullable

FK to game_drives table

drive_inside20boolean required

Drive reached red zone

drive_play_countinteger nullable

Number of plays in drive

drive_play_id_endedstring nullable

Last play_id of drive

drive_play_id_startedstring nullable

First play_id of drive

drive_quarter_endinteger nullable

Quarter when drive ended

drive_quarter_startinteger nullable

Quarter when drive started

drive_real_start_timestring nullable

Drive start time (real clock)

drive_start_transitionstring nullable

How possession was obtained

drive_start_yard_linestring nullable

Yard line at drive start

drive_time_of_possessionstring nullable

Drive time of possession (mm:ss)

drive_yds_penalizedinteger nullable

Penalty yards during drive

end_clock_timestring nullable

Game clock at play end

end_yard_linestring nullable

Yard line at play end

epnumber double nullable

Expected points before play

epanumber double nullable

Expected points added

extra_point_attemptboolean required

Extra point attempt

extra_point_probnumber double nullable

Extra point probability

extra_point_resultstring nullable

good, failed, blocked, safety, aborted

fantasystring nullable

Fantasy designation

fantasy_idstring nullable

Fantasy identifier

fantasy_player_idstring nullable

Fantasy designation player ID

fantasy_player_namestring nullable

Fantasy designation player name

fg_probnumber double nullable

FG probability

field_goal_attemptboolean required

Field goal attempt

field_goal_resultstring nullable

made, missed, or blocked

first_downboolean required

First down achieved

first_down_passboolean required

Passing first down

first_down_penaltyboolean required

First down via penalty

first_down_rushboolean required

Rushing first down

fixed_driveinteger nullable

Manual drive number correction

fixed_drive_resultstring nullable

Manual drive result correction

forced_fumble_player_1_player_idstring nullable

Forced fumble player 1 GSIS ID

forced_fumble_player_1_player_namestring nullable

Forced fumble player 1 name

forced_fumble_player_1_teamstring nullable

Forced fumble team 1

forced_fumble_player_2_player_idstring nullable

Forced fumble player 2 GSIS ID

forced_fumble_player_2_player_namestring nullable

Forced fumble player 2 name

forced_fumble_player_2_teamstring nullable

Forced fumble team 2

fourth_down_convertedboolean required

Fourth down conversion

fourth_down_failedboolean required

Fourth down failure

fumbleboolean required

Fumble occurred

fumble_forcedboolean required

Fumble was forced

fumble_lostboolean required

Fumble was lost

fumble_not_forcedboolean required

Fumble was not forced

fumble_out_of_boundsboolean required

Fumble went OOB

fumble_recovery_1_player_idstring nullable

Recovery player 1 GSIS ID

fumble_recovery_1_player_namestring nullable

Recovery player 1 name

fumble_recovery_1_teamstring nullable

Recovery team 1

fumble_recovery_1_ydsinteger nullable

Recovery yards 1

fumble_recovery_2_player_idstring nullable

Recovery player 2 GSIS ID

fumble_recovery_2_player_namestring nullable

Recovery player 2 name

fumble_recovery_2_teamstring nullable

Recovery team 2

fumble_recovery_2_ydsinteger nullable

Recovery yards 2

fumbled_1_player_idstring nullable

First fumbler GSIS ID

fumbled_1_player_namestring nullable

First fumbler name

fumbled_1_teamstring nullable

First fumbler team

fumbled_2_player_idstring nullable

Second fumbler GSIS ID

fumbled_2_player_namestring nullable

Second fumbler name

fumbled_2_teamstring nullable

Second fumbler team

game_halfstring nullable

Half1, Half2, or Overtime

game_idinteger required

FK to games table

game_seconds_remaininginteger required

Seconds remaining in game

game_stadiumstring nullable

Game stadium name

goal_to_goboolean required

Goal-to-go situation

half_sack_1_player_idstring nullable

Half-sack player 1 GSIS ID

half_sack_1_player_namestring nullable

Half-sack player 1 name

half_sack_2_player_idstring nullable

Half-sack player 2 GSIS ID

half_sack_2_player_namestring nullable

Half-sack player 2 name

half_seconds_remaininginteger required

Seconds remaining in half

home_coachstring nullable

Home team head coach

home_opening_kickoffboolean required

Home team had opening kickoff

home_scoreinteger nullable

Total home points

home_teamstring nullable

Home team abbreviation

home_timeouts_remaininginteger nullable

Home timeouts remaining

home_wpnumber double nullable

Home team win probability

home_wp_postnumber double nullable

Home WP after play

idinteger required

Primary Key

incomplete_passboolean required

Pass incomplete

interceptionboolean required

Interception indicator

interception_player_idstring nullable

Interceptor GSIS ID

interception_player_namestring nullable

Interceptor name

jersey_numberinteger nullable

Primary player jersey

kick_distanceinteger nullable

Kick distance in yards

kicker_player_idstring nullable

Kicker GSIS ID

kicker_player_namestring nullable

Kicker name

kickoff_attemptboolean required

Kickoff attempt

kickoff_downedboolean required

Kickoff downed

kickoff_fair_catchboolean required

Kickoff fair catch

kickoff_in_endzoneboolean required

Kickoff in endzone

kickoff_inside_twentyboolean required

Kickoff inside 20

kickoff_out_of_boundsboolean required

Kickoff OOB

kickoff_returner_player_idstring nullable

Kickoff returner GSIS ID

kickoff_returner_player_namestring nullable

Kickoff returner name

lateral_interception_player_idstring nullable

Lateral after INT GSIS ID

lateral_interception_player_namestring nullable

Lateral after INT name

lateral_kickoff_returner_player_idstring nullable

Lateral kickoff returner GSIS ID

lateral_kickoff_returner_player_namestring nullable

Lateral kickoff returner name

lateral_punt_returner_player_idstring nullable

Lateral punt returner GSIS ID

lateral_punt_returner_player_namestring nullable

Lateral punt returner name

lateral_receiver_player_idstring nullable

Lateral receiver GSIS ID (pass)

lateral_receiver_player_namestring nullable

Lateral receiver name (pass)

lateral_receiving_ydsinteger nullable

Yards after lateral (pass)

lateral_receptionboolean required

Lateral on pass play

lateral_returnboolean required

Lateral on return

lateral_rushboolean required

Lateral on rush play

lateral_rusher_player_idstring nullable

Lateral receiver GSIS ID (rush)

lateral_rusher_player_namestring nullable

Lateral receiver name (rush)

lateral_rushing_ydsinteger nullable

Yards after lateral (rush)

lateral_sack_player_idstring nullable

Lateral after sack GSIS ID

lateral_sack_player_namestring nullable

Lateral after sack name

locationstring nullable

Home or Neutral

namestring nullable

Primary player name (passer or rusher)

nfl_api_idstring nullable

UUID from NFL API

no_huddleboolean required

No-huddle offense

no_score_probnumber double nullable

Probability of no score

old_game_idstring nullable

Legacy NFL game ID format

opp_fg_probnumber double nullable

Opponent FG probability

opp_safety_probnumber double nullable

Opponent safety probability

opp_td_probnumber double nullable

Opponent TD probability

order_sequencenumber double nullable

NFL play-ordering column

out_of_boundsboolean required

Ran/pushed/sacked out of bounds

own_kickoff_recoveryboolean required

Own kickoff recovery

own_kickoff_recovery_player_idstring nullable

Own kickoff recovery player GSIS ID

own_kickoff_recovery_player_namestring nullable

Own kickoff recovery player name

own_kickoff_recovery_tdboolean required

Own kickoff recovery TD

passboolean required

Pass play indicator

pass_attemptboolean required

Pass attempt (includes sacks)

pass_defense_1_player_idstring nullable

Pass defense player 1 GSIS ID

pass_defense_1_player_namestring nullable

Pass defense player 1 name

pass_defense_2_player_idstring nullable

Pass defense player 2 GSIS ID

pass_defense_2_player_namestring nullable

Pass defense player 2 name

pass_lengthstring nullable

short or deep

pass_locationstring nullable

left, middle, or right

pass_oenumber double nullable

Dropback percent over expected

pass_touchdownboolean required

Passing touchdown

passerstring nullable

Dropback player name (includes scrambles)

passer_idinteger nullable

FK to players table

passer_jersey_numberinteger nullable

Passer jersey number

passer_player_idstring nullable

Passer GSIS ID

passer_player_namestring nullable

Passer name

passing_ydsinteger nullable

Official passing yards

penaltyboolean required

Penalty on play

penalty_player_idstring nullable

Penalized player GSIS ID

penalty_player_namestring nullable

Penalized player name

penalty_teamstring nullable

Penalized team

penalty_typestring nullable

Type of penalty

penalty_ydsinteger nullable

Penalty yards

playboolean required

Regular play (1) vs special event (0)

play_clockinteger nullable

Play clock at snap

play_deletedboolean required

Play was deleted

play_idstring required

Numeric play identifier unique to game

play_typestring nullable

pass, run, punt, field_goal, kickoff, extra_point, qb_kneel, qb_spike, no_play

play_type_nflstring nullable

NFL source play type

possession_team_idinteger nullable

FK to teams table for possession team

posteamstring nullable

Possession team abbreviation

posteam_scoreinteger nullable

Possession team score at start

posteam_score_postinteger nullable

Possession team score at end

posteam_timeouts_remaininginteger nullable

Possession team timeouts

posteam_typestring nullable

home or away

primary_player_gsis_idstring nullable

Primary player GSIS ID

punt_attemptboolean required

Punt attempt

punt_blockedboolean required

Punt blocked

punt_downedboolean required

Punt downed

punt_fair_catchboolean required

Punt fair catch

punt_in_endzoneboolean required

Punt in endzone

punt_inside_twentyboolean required

Punt inside 20

punt_out_of_boundsboolean required

Punt OOB

punt_returner_player_idstring nullable

Punt returner GSIS ID

punt_returner_player_namestring nullable

Punt returner name

punter_player_idstring nullable

Punter GSIS ID

punter_player_namestring nullable

Punter name

qb_dropbackboolean required

QB dropback (pass or scramble)

qb_epanumber double nullable

QB EPA credit

qb_hitboolean required

QB was hit

qb_hit_1_player_idstring nullable

QB hitter GSIS ID

qb_hit_1_player_namestring nullable

QB hitter name

qb_hit_2_player_idstring nullable

Second QB hitter GSIS ID

qb_hit_2_player_namestring nullable

Second QB hitter name

qb_kneelboolean required

QB kneel

qb_scrambleboolean required

QB scramble

qb_spikeboolean required

QB spike

quarterinteger required

Quarter (1-4, 5=OT)

quarter_endboolean required

Binary quarter-end marker

quarter_seconds_remaininginteger required

Seconds remaining in quarter

receiverstring nullable

Targeted receiver name

receiver_idinteger nullable

FK to players table

receiver_jersey_numberinteger nullable

Receiver jersey number

receiver_player_idstring nullable

Receiver GSIS ID

receiver_player_namestring nullable

Receiver name

receiving_ydsinteger nullable

Official receiving yards

replay_or_challengeboolean required

Replay/challenge occurred

replay_or_challenge_resultstring nullable

Replay result

resultinteger nullable

Home score - Away score

return_teamstring nullable

Returning team

return_touchdownboolean required

Return touchdown

return_ydsinteger nullable

Return yards

roofstring nullable

dome, outdoors, closed, open

run_gapstring nullable

end, guard, or tackle

run_locationstring nullable

left, middle, or right

rushboolean required

Rush play (no scrambles)

rush_attemptboolean required

Rushing play indicator

rush_touchdownboolean required

Rushing touchdown

rusher_idinteger nullable

FK to players table

rusher_jersey_numberinteger nullable

Rusher jersey number

rusher_player_idstring nullable

Rusher GSIS ID

rusher_player_namestring nullable

Rusher name

rushing_ydsinteger nullable

Official rushing yards

sackboolean required

Sack indicator

sack_player_idstring nullable

Sacker GSIS ID

sack_player_namestring nullable

Sacker name

safetyboolean required

Safety scored

safety_player_idstring nullable

Safety scorer GSIS ID

safety_player_namestring nullable

Safety scorer name

safety_probnumber double nullable

Safety probability

score_differentialinteger nullable

Score gap at play start

score_differential_postinteger nullable

Score gap at play end

seriesinteger nullable

Series counter within game

series_resultstring nullable

First down, Touchdown, Punt, etc.

series_successboolean required

Series resulted in first down or TD

shotgunboolean required

Shotgun formation

side_of_fieldstring nullable

Team abbreviation whose side of field

solo_tackleboolean required

Solo tackle on play

solo_tackle_1_player_idstring nullable

Solo tackler 1 GSIS ID

solo_tackle_1_player_namestring nullable

Solo tackler 1 name

solo_tackle_1_teamstring nullable

Solo tackler 1 team

solo_tackle_2_player_idstring nullable

Solo tackler 2 GSIS ID

solo_tackle_2_player_namestring nullable

Solo tackler 2 name

solo_tackle_2_teamstring nullable

Solo tackler 2 team

spboolean required

Scoring play indicator

specialboolean required

Special teams indicator

special_teams_playboolean required

Special teams play indicator

spread_linenumber double nullable

Vegas spread line

st_play_typestring nullable

Type of special teams play

stadiumstring nullable

Stadium name

stadium_idinteger nullable

Stadium ID

start_timestring nullable

Kickoff time (eastern)

successboolean nullable

Play success (based on down/distance)

surfacestring nullable

Playing surface type

tackle_for_loss_1_player_idstring nullable

TFL player 1 GSIS ID

tackle_for_loss_1_player_namestring nullable

TFL player 1 name

tackle_for_loss_2_player_idstring nullable

TFL player 2 GSIS ID

tackle_for_loss_2_player_namestring nullable

TFL player 2 name

tackle_with_assistboolean required

Tackle with assistance

tackle_with_assist_1_player_idstring nullable

Tackle-assist player 1 GSIS ID

tackle_with_assist_1_player_namestring nullable

Tackle-assist player 1 name

tackle_with_assist_1_teamstring nullable

Tackle-assist player 1 team

tackle_with_assist_2_player_idstring nullable

Tackle-assist player 2 GSIS ID

tackle_with_assist_2_player_namestring nullable

Tackle-assist player 2 name

tackle_with_assist_2_teamstring nullable

Tackle-assist player 2 team

tackled_for_lossboolean required

Tackle for loss

td_player_idstring nullable

TD scorer GSIS ID

td_player_namestring nullable

TD scorer name

td_probnumber double nullable

TD probability

td_teamstring nullable

Team scoring TD

tempinteger nullable

Temperature

third_down_convertedboolean required

Third down conversion

third_down_failedboolean required

Third down failure

timestring nullable

Game clock at play start (mm:ss)

time_of_daystring nullable

Play time in UTC

timeoutboolean required

Timeout called

timeout_teamstring nullable

Team calling timeout

totalinteger nullable

Home score + Away score

total_away_comp_air_epanumber double nullable

Cumulative away completion air EPA

total_away_comp_air_wpanumber double nullable

Cumulative away completion air WPA

total_away_comp_yac_epanumber double nullable

Cumulative away completion YAC EPA

total_away_comp_yac_wpanumber double nullable

Cumulative away completion YAC WPA

total_away_epanumber double nullable

Cumulative away EPA

total_away_pass_epanumber double nullable

Cumulative away passing EPA

total_away_pass_wpanumber double nullable

Cumulative away passing WPA

total_away_raw_air_epanumber double nullable

Cumulative away raw air EPA

total_away_raw_air_wpanumber double nullable

Cumulative away raw air WPA

total_away_raw_yac_epanumber double nullable

Cumulative away raw YAC EPA

total_away_raw_yac_wpanumber double nullable

Cumulative away raw YAC WPA

total_away_rush_epanumber double nullable

Cumulative away rushing EPA

total_away_rush_wpanumber double nullable

Cumulative away rushing WPA

total_away_scoreinteger nullable

Away score at play start

total_home_comp_air_epanumber double nullable

Cumulative home completion air EPA

total_home_comp_air_wpanumber double nullable

Cumulative home completion air WPA

total_home_comp_yac_epanumber double nullable

Cumulative home completion YAC EPA

total_home_comp_yac_wpanumber double nullable

Cumulative home completion YAC WPA

total_home_epanumber double nullable

Cumulative home EPA

total_home_pass_epanumber double nullable

Cumulative home passing EPA

total_home_pass_wpanumber double nullable

Cumulative home passing WPA

total_home_raw_air_epanumber double nullable

Cumulative home raw air EPA

total_home_raw_air_wpanumber double nullable

Cumulative home raw air WPA

total_home_raw_yac_epanumber double nullable

Cumulative home raw YAC EPA

total_home_raw_yac_wpanumber double nullable

Cumulative home raw YAC WPA

total_home_rush_epanumber double nullable

Cumulative home rushing EPA

total_home_rush_wpanumber double nullable

Cumulative home rushing WPA

total_home_scoreinteger nullable

Home score at play start

total_linenumber double nullable

Vegas total line

touchbackboolean required

Touchback

touchdownboolean required

Touchdown scored

two_point_attemptboolean required

Two-point conversion attempt

two_point_conv_resultstring nullable

success, failure, safety, return

two_point_conversion_probnumber double nullable

Two-point conversion probability

vegas_home_wpnumber double nullable

Vegas home win probability

vegas_home_wpanumber double nullable

Vegas home WPA

vegas_wpnumber double nullable

Vegas win probability

vegas_wpanumber double nullable

Vegas-adjusted WPA

weatherstring nullable

Weather conditions description

windinteger nullable

Wind speed (mph)

wpnumber double nullable

Win probability for possession team

wpanumber double nullable

Win probability added

xpassnumber double nullable

Dropback probability

xyac_epanumber double nullable

Expected EPA after catch

xyac_fdnumber double nullable

First down probability (xYAC)

xyac_mean_yardagenumber double nullable

Average expected YAC

xyac_median_yardagenumber double nullable

Median expected YAC

xyac_successnumber double nullable

Positive EPA probability

yac_epanumber double nullable

EPA from yards after catch

yac_wpanumber double nullable

WPA from yards after catch

yard_lineinteger nullable

Yard line number (0-50)

yardline_100integer nullable

Yards from opponent endzone (0-100)

yds_after_catchinteger nullable

YAC yards

yds_gainedinteger nullable

Yards gained on play

ydsnetinteger nullable

Total net yards on drive

ydstogointeger nullable

Yards to first down/goal

yrdlnstring nullable

Yard line string (e.g., "KC 25")

Changes

No recorded changes to this operation across all 3 revisions of this API.