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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
codestringdraftkingsStable machine code (e.g. draftkings, fanduel, consensus, pinnacle).
descriptionstringnullable
is_activebooleantrueFalse for operators no longer ingested.
Valuestruefalse
namestringDraftKingsDisplay name (e.g. DraftKings, FanDuel, Pinnacle).
operator_typestringdata_providerOperator class — DFS, betting, media, or data provider (mixed-case legacy values exist).
Valuesdata_providerSPORTSBOOKDFSDATA_PROVIDERMEDIA
website_urlstringnullable