Reference

1 table

Cross-league reference data — the operators (DFS sites, sportsbooks, data providers) that every operator_id filter on the public API points at. Exactly one table from schema `main` is exposed; everything else in that schema is private.

Machine-readable spec: /api/openapi/public.json (OpenAPI 3.1)

Main· 1 table

operatorsmain.operators
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.
Fields7
FieldTypeReferencesDescription
idkeybigintPrimary Key
codestringStable machine code (e.g. draftkings, fanduel, consensus, pinnacle).
e.g. draftkings
descriptionstringnullable
e.g. — (all-null in sample)
is_activebooleanFalse for operators no longer ingested.
Values:truefalse
namestringDisplay name (e.g. DraftKings, FanDuel, Pinnacle).
e.g. DraftKings
operator_typestringOperator class — DFS, betting, media, or data provider (mixed-case legacy values exist).
Values:data_providerSPORTSBOOKDFSDATA_PROVIDERMEDIA
website_urlstringnullable
e.g. — (all-null in sample)
GET/api/v1/reference/operators
Parameters
limitqueryintegeroptionaldefault 50
Page size. Defaults to 50; max 200.
from_idquerybigintoptional
Return rows with id strictly greater than this value; page using the previous response's `next_from_id`. Omit on the first page.
Restores the documented defaults (trial keys only accept the unchanged defaults).
Request
curl -sS \
  -H 'Authorization: Bearer YOUR_API_KEY' \
  'https://api.stat-api.com/api/v1/reference/operators?limit=3'
Responses
200operators rows matching the declared filter set, wrapped in { operators, limit, next_from_id }. next_from_id is the last row's id on a full page — pass it back via ?from_id= to walk the full result; null marks the terminal page.application/jsonshow example ▸
400No declared filter set was satisfied — response body matches MissingRequiredFiltersError; pick one combo from the accepted-sets hint and resend.application/json
GET/api/v1/reference/operators/{id}
Parameters
idpathbigintrequired
Primary key (id) of the operator row.
Restores the documented defaults (trial keys only accept the unchanged defaults).
Request
curl -sS \
  -H 'Authorization: Bearer YOUR_API_KEY' \
  'https://api.stat-api.com/api/v1/reference/operators/{pk_value}'
Responses
200Single operator row.application/jsonshow example ▸
404Row not found.