---
title: "Get a single game_player_advanced_stat by id"
method: GET
path: "/api/v1/nfl/game_player_advanced_stats/{id}"
tags: ["NFL"]
---

# Get a single game_player_advanced_stat by id

`GET /api/v1/nfl/game_player_advanced_stats/{id}`

## Request

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

## Path parameters

- `id` integer, required: Primary Key

## Response `200`

Single game_player_advanced_stats row.

- NFLGamePlayerAdvancedStats: Per-game advanced player stats — drop rates, time under pressure, yards before and after contact, broken tackles, passer rating allowed in coverage.
  - `carries` integer, nullable: Rushing attempts.
  - `def_adot` number, double, nullable: Average depth of target (yards) when this defender was in coverage.
  - `def_air_yds_completed` integer, nullable: Air yards completed on receptions allowed.
  - `def_completion_pct` number, double, nullable: Completion percentage allowed (0.0-100.0).
  - `def_completions_allowed` integer, nullable: Receptions allowed in coverage.
  - `def_ints` integer, nullable: Interceptions made by this defender in coverage.
  - `def_missed_tackle_pct` number, double, nullable: Missed-tackle rate on tackle opportunities (0.0-100.0).
  - `def_missed_tackles` integer, nullable: Tackle attempts missed by this defender.
  - `def_passer_rating_allowed` number, double, nullable: Passer rating allowed when targeted (0-158.3).
  - `def_pressures` integer, nullable: Total pressures generated (hurries + hits + sacks).
  - `def_receiving_td_allowed` integer, nullable: Receiving touchdowns allowed in coverage.
  - `def_sacks` number, double, nullable: Sacks recorded (half-sacks supported as decimals).
  - `def_tackles_combined` integer, nullable: Combined tackles (solo + assisted).
  - `def_targets` integer, nullable: Pass targets thrown at this defender's coverage assignment.
  - `def_times_blitzed` integer, nullable: Pass-rushing snaps as a blitzer.
  - `def_times_hitqb` integer, nullable: QB hits generated as a pass rusher.
  - `def_times_hurried` integer, nullable: Hurries generated as a pass rusher.
  - `def_yds_after_catch` integer, nullable: Yards-after-catch allowed in coverage.
  - `def_yds_allowed` integer, nullable: Receiving yards allowed in coverage.
  - `def_yds_allowed_per_cmp` number, double, nullable: Yards allowed per reception.
  - `def_yds_allowed_per_tgt` number, double, nullable: Yards allowed per target.
  - `game_id` integer, required
  - `id` integer, required: Primary Key
  - `opponent_team_id` integer, required: Opposing team in this matchup (FK to `teams`).
  - `passing_bad_throw_pct` number, double, nullable: Bad-throw rate on pass attempts (0.0-100.0).
  - `passing_bad_throws` integer, nullable: Pass attempts charged as bad throws.
  - `passing_drop_pct` number, double, nullable: Drop rate on catchable passes (0.0-100.0).
  - `passing_drops` integer, nullable: Pass attempts dropped by the receiver (charged to the QB's catchable-target count).
  - `player_id` integer, required
  - `receiving_broken_tackles` integer, nullable: Tackles the receiver broke on receiving plays.
  - `receiving_drop` integer, nullable: Drops charged to this receiver.
  - `receiving_drop_pct` number, double, nullable: Receiver drop rate on catchable targets (0.0-100.0).
  - `receiving_int` integer, nullable: Interceptions thrown when this player was the target.
  - `receiving_rat` number, double, nullable: Passer rating generated when targeted (0-158.3).
  - `rushing_broken_tackles` integer, nullable: Tackles the runner broke on rushing plays.
  - `rushing_yds_after_contact` integer, nullable: Total rushing yards gained after first contact.
  - `rushing_yds_after_contact_avg` number, double, nullable: Yards after contact averaged per rush.
  - `rushing_yds_before_contact` integer, nullable: Total rushing yards gained before first contact.
  - `rushing_yds_before_contact_avg` number, double, nullable: Yards before contact averaged per rush.
  - `team_id` integer, required
  - `times_blitzed` integer, nullable: Dropbacks the QB faced a blitz.
  - `times_hit` integer, nullable: QB hits (defender contacted the QB on the throw).
  - `times_hurried` integer, nullable: Dropbacks the QB was hurried but not pressured.
  - `times_pressured` integer, nullable: Total pressures faced (sum of hurries/hits/sacks-allowed indicators).
  - `times_pressured_pct` number, double, nullable: Pressure rate per dropback (0.0-100.0).
  - `times_sacked` integer, nullable: Sacks taken by this QB.

## 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)