Reference Data Dictionary
Main
main.operators7 fieldsendpoints →
The operators referenced by every operator_id filter across the public API — DFS sites (1 DraftKings, 2 FanDuel, 3 Yahoo), sportsbooks (1683 Pinnacle, 1684 BetMGM, 1685 Caesars, 1686 BetRivers, 1687 ESPN BET), and data providers (6 Consensus, 13 sportsdata.io). A small read-only lookup table.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| code | string | — | draftkings | Stable machine code (e.g. draftkings, fanduel, consensus, pinnacle). |
| description | stringnullable | — | — | — |
| is_active | boolean | — | true | False for operators no longer ingested. Values truefalse |
| name | string | — | DraftKings | Display name (e.g. DraftKings, FanDuel, Pinnacle). |
| operator_type | string | — | data_provider | Operator class — DFS, betting, media, or data provider (mixed-case legacy values exist). Values data_providerSPORTSBOOKDFSDATA_PROVIDERMEDIA |
| website_url | stringnullable | — | — | — |