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

# Get a single team_player_roster by id

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

## Request

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

## Path parameters

- `id` integer, required: Primary Key

## Query parameters

- `mode` 'pre' | 'full'

## Response `200`

Single team_player_rosters row.

- NFLTeamPlayerRosters: Each NFL club's roster today — the players on the club's current game roster (its next game not yet kicked off, else its latest game), one row per player, with the game's status and injury report. Between seasons, until 21 days before a club's next game, it shows the club's last game roster as it stood at that kickoff. For past weeks, use the game rosters (game_team_rosters).
  - `day` integer, required: The first game day of the current game's week (YYYYMMDD, Eastern), usually its Thursday; the same value for every club that week.
  - `depth_order` integer, nullable: Depth-chart order at this position for the current game (1 = starter); empty when not on the chart or not active.
  - `game_id` integer, required: The club's current game — its next game not yet kicked off, else its latest game.
  - `game_time` string, date-time, nullable: Kickoff time of the current game.
  - `id` integer, required: Primary Key
  - `injury_status` string, nullable: Injury designation on the current game roster (e.g. Questionable, Doubtful, Out; empty when healthy).
  - `player_id` integer, required
  - `position` string, nullable: The player's position on the club (a position from the filter list when the game roster has one, else his primary position).
  - `position_group` string, nullable: Position group (`Offense`, `Defense`, `Special Teams`).
  - `practice_status` string, nullable: The injury report's practice participation for the current game, as the report words it (`DNP`, `LP`, `FP`, or the long form such as `Did Not Participate In Practice`); empty when the player is not on the practice report.
  - `report_primary_injury` string, nullable: The injury report's primary injury for the current game.
  - `report_status` string, nullable: The official injury report's game status for the current game, as the report words it (e.g. `Out`, `Doubtful`, `Questionable`, `Active`, `Injured Reserve`), from the injury report of that same game only; empty when the player is not on it.
  - `season_id` integer, required
  - `season_type` string, nullable: Season type of the current game (regular_season, postseason, preseason).
  - `status` string, nullable: Roster status for the current game (`Active`, `Inactive`, `PracticeSquad`, `Reserve`, `Exempt`, `PhysicallyUnableToPerform`, `NonFootballInjury`, `Suspended`, ...); only players on the club appear.
  - `team_id` integer, required
  - `week` integer, nullable: Week of the current game within its season type.

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