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

# Get a single game by id

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

## Request

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

## Path parameters

- `id` integer, required: Primary Key

## Response `200`

Single games row.

- NFLGames: Every scheduled and played NFL game — preseason exhibitions, the 18-week regular season, the playoffs from Wild Card weekend through the Super Bowl.
  - `attendance` integer, nullable: Reported attendance count; null when not published.
  - `away_rotation_number` integer, nullable: Sportsbook rotation number for the away team (3-4 digit cross-book reference).
  - `away_team` string, required: Denormalized team abbreviation for the away side at game time (snapshot copy of `teams.abbreviation`).
  - `away_team_id` integer, required
  - `away_team_score` integer, required: Final away-team score; 0 (not null) until the game completes.
  - `channel` string, nullable: Primary broadcast network/channel (e.g., `CBS`, `FOX`, `Prime Video`).
  - `day` integer, required: Calendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern.
  - `end_time` string, date-time, nullable: Actual game end timestamp; null until the game completes.
  - `game_label` string, nullable: Display label for special games (e.g., `Thanksgiving Day`, `Monday Night Football`).
  - `game_sub_label` string, nullable: Secondary label or sub-category for the game.
  - `game_time` string, date-time, nullable: Scheduled kickoff time (timezone-aware); null when the league published no time.
  - `home_rotation_number` integer, nullable: Sportsbook rotation number for the home team (3-4 digit cross-book reference).
  - `home_team` string, required: Denormalized team abbreviation for the home side at game time (snapshot copy of `teams.abbreviation`).
  - `home_team_id` integer, required
  - `home_team_score` integer, required: Final home-team score; 0 (not null) until the game completes.
  - `id` integer, required: Primary Key
  - `league_game_id` string, required: Official NFL game ID from league source
  - `neutral_venue` boolean, required: True if the game is played at a neutral site (Super Bowl, international games, etc.).
  - `overtime` boolean, required: True if the game went to overtime.
  - `overtime_periods` integer, nullable: Number of overtime periods played (1+ when `overtime` is true).
  - `playoff_round` string, nullable: Postseason round (`WildCard`, `Divisional`, `Conference Championship`, `Super Bowl`); null outside the postseason.
  - `playoff_seed_away` integer, nullable: Away-team playoff seed (1-7); null outside the postseason.
  - `playoff_seed_home` integer, nullable: Home-team playoff seed (1-7); null outside the postseason.
  - `postponed_status` string, nullable: Reason for postponement (e.g., `Weather`, `COVID`); null for games played as scheduled.
  - `season_id` integer, required
  - `season_type` string, required: Canonical season phase. Postseason round detail (Wild Card / Divisional / Conference Championship / Super Bowl) lives in `playoff_round`.
  - `stadium_id` integer, required: Stadium hosting the game (FK to `stadiums`).
  - `status` string, required: Game status. Currently always `Scheduled` (status reconciliation is pending) — detect completed games via populated scores, not this field.
  - `time_tbd` boolean, required: True when the league has not set the kickoff time yet; `game_time` then holds a provisional Sunday 1:00 PM ET of the game's week, not a real kickoff.
  - `type` string, required: Game classification (`Regular`, `Playoff`, `Super Bowl`, `Preseason`).
  - `week` integer, required: Week number within the season stage — 1-18 for regular season, restarting at 1 in the postseason (1 Wild Card, 2 Divisional, 3 Conference Championship, 4 Super Bowl). Note nfl.injuries.week uses the continuous 19-22 convention instead.

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