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

# Get a single coaching_staff_tenure by id

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

## Request

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

## Path parameters

- `id` integer, required: Primary Key

## Response `200`

Single coaching_staff_tenures row.

- NFLCoachingStaffTenures: Every coaching change across NFL history with dates — when each head coach, offensive coordinator, and defensive coordinator started, when they left, and why (fired, resigned, promoted, retired).
  - `effective_date` string, date, required: Date this coach started in this role
  - `end_date` string, date, nullable: Date this coach ended (null if current)
  - `first_name` string, nullable
  - `full_name` string, required: Coach full name
  - `id` integer, required: Primary Key
  - `is_interim` boolean, required
  - `last_name` string, nullable
  - `position` string, required: Coaching position (HC, OC, DC)
  - `reason` string, nullable: Reason for change (fired, resigned, hired, promoted)
  - `season_id` integer, required: Reference to the season
  - `team_id` integer, required: Reference to the team

## 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/601ff9eaca3f?raw)