--- title: "Get a single game_player_stat by id" method: GET path: "/api/v1/nfl/game_player_stats/{id}" tags: ["NFL"] --- # Get a single game_player_stat by id `GET /api/v1/nfl/game_player_stats/{id}` ## Request - Base URL: `https://api.stat-api.com` - URL: `https://api.stat-api.com/api/v1/nfl/game_player_stats/{id}` - Auth: HTTP bearer ## Path parameters - `id` integer, required: Primary Key ## Response `200` Single game_player_stats row. - NFLGamePlayerStats: Each NFL player's stat line for each game — every passing, rushing, receiving, defensive, special-teams, and scoring statistic recorded that day. - `air_yds_share` number, double, required: Percentage of team air yards - `assisted_tackles` integer, nullable: Assisted tackles - `blocked_kick_return_tds` integer, nullable: Blocked kick return touchdowns - `blocked_kick_return_yds` integer, nullable: Blocked kick return yards - `blocked_kicks` integer, nullable: Blocked kicks (FG, XP, punts) - `completions` integer, required - `dakota` number, double, nullable: DAKOTA: adjusted completion % + EPA metric - `defensive_interceptions` integer, nullable: Defensive interceptions - `defensive_sack_yds` integer, nullable: Yards lost on defensive sacks - `defensive_sacks` number, double, nullable: Defensive sacks (can be half sacks) - `defensive_snaps` integer, nullable: Defensive snaps played - `defensive_tds` integer, nullable: Total defensive touchdowns (INT + fumble return TDs) - `defensive_team_snaps` integer, nullable: Total team defensive snaps (for calculating snap %) - `depth_order` integer, nullable: Depth order within position (1=starter, 2=backup, etc.) - joined from depth charts - `depth_position` string, nullable: Depth chart position (QB1, RB2, etc.) - joined from depth charts - `extra_pts_attempted` integer, nullable: Extra points attempted - `extra_pts_had_blocked` integer, nullable: Extra points blocked by opponent - `extra_pts_made` integer, nullable: Extra points made - `fantasy_pts` number, double, required: Standard-scoring fantasy points - `fantasy_pts_ppr` number, double, required: PPR fantasy points - `field_goal_percentage` number, double, nullable: Field goal percentage - `field_goal_return_tds` integer, nullable: Field goal return touchdowns - `field_goal_return_yds` integer, nullable: Field goal return yards (missed FG returns) - `field_goals_attempted` integer, nullable: Field goals attempted - `field_goals_had_blocked` integer, nullable: Field goals blocked by opponent - `field_goals_longest` integer, nullable: Longest field goal made (yards) - `field_goals_made` integer, nullable: Field goals made - `field_goals_made_0_19` integer, nullable: Field goals made 0-19 yards - `field_goals_made_20_29` integer, nullable: Field goals made 20-29 yards - `field_goals_made_30_39` integer, nullable: Field goals made 30-39 yards - `field_goals_made_40_49` integer, nullable: Field goals made 40-49 yards - `field_goals_made_50_plus` integer, nullable: Field goals made 50+ yards - `forced_fumbles` integer, nullable: Forced fumbles - `fumble_return_tds` integer, nullable: Fumble return touchdowns - `fumble_return_yds` integer, nullable: Fumble return yards - `fumbles_out_of_bounds` integer, nullable: Fumbles out of bounds - `fumbles_own_recoveries` integer, nullable: Own fumbles recovered - `fumbles_recovered` integer, nullable: Fumbles recovered - `game_id` integer, required - `humidity` integer, nullable: Humidity percentage - `id` integer, required: Primary Key - `interception_return_tds` integer, nullable: Interception return touchdowns - `interception_return_yds` integer, nullable: Interception return yards - `interceptions_thrown` integer, required - `is_home` boolean, required: True if player's team is the home team - `kick_return_avg` number, float, nullable: Kick return average (yards per return) - `kick_return_fair_catches` integer, nullable: Fair catches on kick returns - `kick_return_fumbles` integer, nullable: Fumbles on kick returns - `kick_return_fumbles_lost` integer, nullable: Fumbles lost on kick returns - `kick_return_long` integer, nullable: Longest kick return (yards) - `kick_return_tds` integer, nullable: Kick return touchdowns - `kick_return_yds` integer, nullable: Total kick return yards - `kick_returns` integer, nullable: Number of kick returns - `misc_assisted_tackles` integer, nullable: Miscellaneous assisted tackles - `misc_fumbles_forced` integer, nullable: Miscellaneous fumbles forced - `misc_fumbles_recovered` integer, nullable: Miscellaneous fumbles recovered - `misc_solo_tackles` integer, nullable: Miscellaneous solo tackles - `offensive_snaps` integer, nullable: Offensive snaps played - `offensive_team_snaps` integer, nullable: Total team offensive snaps (for calculating snap %) - `opponent_team_id` integer, required - `pacr` number, double, nullable: Passer air conversion ratio - `pass_attempts` integer, required - `passes_defended` integer, nullable: Passes defended - `passing_2pt_conversions` integer, required - `passing_air_yds` integer, required - `passing_completion_percentage` number, double, nullable: Completion percentage - `passing_epa` number, double, required: Expected points added from passing - `passing_first_downs` integer, required - `passing_long` integer, nullable: Longest pass completion (yards) - `passing_rating` number, double, nullable: Passer rating - `passing_tds` integer, required - `passing_yds` integer, required - `passing_yds_after_catch` integer, required - `player_id` integer, required - `playing_surface` string, nullable: Playing surface type (grass, turf, etc.) - `position` string, required: Player position at time of game - `position_group` string, required: Position group (QB, RB, WR, TE, etc.) - `punt_average` number, double, nullable: Punt average (yards) - `punt_inside_20` integer, nullable: Punts inside 20 yard line - `punt_long` integer, nullable: Longest punt (yards) - `punt_net_average` number, float, nullable: Net punt average (gross - return yards) - `punt_net_yds` integer, nullable: Net punt yards (gross - return yards) - `punt_return_avg` number, float, nullable: Punt return average (yards per return) - `punt_return_fair_catches` integer, nullable: Fair catches on punt returns - `punt_return_fumbles` integer, nullable: Fumbles on punt returns (includes muffs) - `punt_return_fumbles_lost` integer, nullable: Fumbles lost on punt returns - `punt_return_long` integer, nullable: Longest punt return (yards) - `punt_return_tds` integer, nullable: Punt return touchdowns - `punt_return_yds` integer, nullable: Total punt return yards - `punt_returns` integer, nullable: Number of punt returns - `punt_touchbacks` integer, nullable: Punt touchbacks - `punt_yds` integer, nullable: Total punt yards - `punts` integer, nullable: Number of punts - `punts_had_blocked` integer, nullable: Punts blocked by opponent - `quarterback_hits` integer, nullable: Quarterback hits - `racr` number, double, nullable: Receiver air conversion ratio - `receiving_2pt_conversions` integer, required - `receiving_air_yds` integer, required - `receiving_epa` number, double, required: Expected points added from receiving - `receiving_first_downs` integer, required - `receiving_fumbles` integer, required - `receiving_fumbles_lost` integer, required - `receiving_long` integer, nullable: Longest reception (yards) - `receiving_tds` integer, required - `receiving_yds` integer, required - `receiving_yds_after_catch` integer, required - `receiving_yds_per_reception` number, double, nullable: Yards per reception - `reception_percentage` number, double, nullable: Reception percentage (receptions/targets) - `receptions` integer, required - `rushing_2pt_conversions` integer, required - `rushing_attempts` integer, required - `rushing_epa` number, double, required: Expected points added from rushing - `rushing_first_downs` integer, required - `rushing_fumbles` integer, required - `rushing_fumbles_lost` integer, required - `rushing_long` integer, nullable: Longest rush (yards) - `rushing_tds` integer, required - `rushing_yds` integer, required - `rushing_yds_per_attempt` number, double, nullable: Rushing yards per attempt - `sack_fumbles` integer, required - `sack_fumbles_lost` integer, required - `sack_yds` integer, required - `sacks_allowed` integer, required - `safeties` integer, nullable: Safeties - `solo_tackles` integer, nullable: Solo tackles - `special_teams_assisted_tackles` integer, nullable: Assisted tackles on special teams - `special_teams_fumbles_forced` integer, nullable: Fumbles forced on special teams - `special_teams_fumbles_recovered` integer, nullable: Fumbles recovered on special teams - `special_teams_snaps` integer, nullable: Special teams snaps played - `special_teams_solo_tackles` integer, nullable: Solo tackles on special teams - `special_teams_tds` integer, required - `special_teams_team_snaps` integer, nullable: Total team special teams snaps (for calculating snap %) - `stadium` string, nullable: Stadium name - `tackles_for_loss` integer, nullable: Tackles for loss - `target_share` number, double, required: Percentage of team targets - `targets` integer, required - `team_id` integer, required - `temperature` integer, nullable: Game temperature (Fahrenheit) - `two_pt_returns` integer, nullable: Two-point conversion returns (defensive) - `wind_speed` integer, nullable: Wind speed (mph) - `wopr` number, double, nullable: Weighted opportunity rating ## Other responses - `404`: Row not found. --- [API](https://skmtc.dev/stat-api/apis/sports-db-public-api.md) · [All operations](https://skmtc.dev/stat-api/apis/sports-db-public-api/llms.txt) · [OpenAPI document](https://skmtc.dev/stat-api/apis/sports-db-public-api/revisions/23b66b957723?raw)