Get a single slate by id
Request
- Base URL: https://api.stat-api.com
- URL: https://api.stat-api.com/api/v1/dfs/slates/{id}
- Auth: HTTP bearer
Path parameters
Primary Key
Primary key (id) of the slates row.
Response
Single slates row.
Number of contests on this slate (rows in dfs.contests). Counts lobby-only contests too, which never have lineups.
Calendar day of the slate in US Eastern time (DB-generated from start_time — read-only).
Operator-side slate identifier (e.g., DraftKings contest group ID).
Number of games in the slate pool (distinct games in dfs.slate_games). 0 when the slate has no linked games.
Roster format of the slate, from its slate setting: classic (full roster), showdown (DraftKings Showdown Captain Mode — CPT at 1.5x salary and points), single_game (FanDuel Single Game — MVP at 1.5x points, no salary change), or tiers. Null when the setting states another format.
Primary Key
FK to the league this slate belongs to.
Number of contests on this slate with their lineups loaded (dfs.contests.lineups_status = available). 0 when no contest of the slate has a lineup file.
Whether this is the featured ("main") slate for this operator/league/day — at most one per (operator, league, date). Daily for NBA/MLB/NHL, Sundays for NFL, never for golf. Backfilled 2016-2026 on 2026-08-24 (docs/migrations/scripts/2026-08-24-dfs-slates-main-backfill.sql). Rows loaded after that date are not yet auto-flagged.
Human-readable slate label (e.g., "Sunday Main", "Showdown: TB vs KC").
FK to the DFS operator (DraftKings, FanDuel, Yahoo, etc.).
The operator's own id for the lineup setting this slate is played under — FanDuel states it as slateFormatId, DraftKings as lineupConfigurationId. Matches dfs.slate_settings.operator_setting_id. Text, because some stored values are not numbers (deprecated-5399). Never a key on its own: the operators reuse these ids across sports and versions, so resolution is (operator, league, this id) then the newest valid_from not after the slate date.
The part of each game that the slate scores, from the scoring rule of its slate setting (dfs.slate_settings.scoring): full, or second_half and fourth_quarter for an in-game slate. Null when the setting holds no scoring rule.
Number of priced players in the slate pool (rows in dfs.slate_players).
FK to slate_settings — the scoring format and roster constraints for this slate.
Lock time — first scheduled tip/kickoff of any game in the pool.
Lifecycle state of the slate in the Prelock / Started / Completed vocabulary, derived by the API on every read (browse.rs derive_dfs_lifecycle_state) from status: Upcoming → Prelock, Live → Started, Completed → Completed. status is the authoritative field; this one repeats it in the older vocabulary.
Authoritative slate lifecycle status: Upcoming (pre-lock), Live (in progress), Completed (all games final).
Changes
No recorded changes to this operation across all 3 revisions of this API.