operator_player_lookupsnfl.operator_player_lookups

How each sportsbook and fantasy operator names every NFL player — the mapping from each operator's own player identifier to a unified player record.

Full field reference (9 columns) → Data Dictionary Query in GraphQL →

GET/api/v1/nfl/operator_player_lookupsList operator_player_lookups for NFL

Requires one of: operator_id — requests satisfying none of these return 400.

Parameters

operator_idquerybigintoptional

Filter by sportsbook / operator.

player_idquerybigintoptional

Filter to a single player.

positionquerystringoptional

Filter by player position. Values: C, CB, D, DB, DE, DEF, DL, DST, DT, FB, G, ILB, K, LB, LS, NT, OL, OLB, OT, P, QB, RB, S, TE, WR.

limitqueryintegeroptionaldefault 100

Page size. Defaults to 100; max 5000.

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 --compressed \
  -H 'Authorization: Bearer YOUR_API_KEY' \
  'https://api.stat-api.com/api/v1/nfl/operator_player_lookups?operator_id=1'

Responses

200operator_player_lookups rows matching the declared filter set, wrapped in { operator_player_lookups, 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

Response Schema(9 fields)show schema ▸

Field	Type	References	Description
idkey	bigint	—	Primary Key
operator_id	bigint		Reference to main.operator entity e.g. 5
operator_player_id	string	—	External player ID from operator e.g. 6012
player_id	bigintnullable		Internal nfl.players.id reference e.g. 2
decided_at	timestamptznullable	—	When the pin or block was decided. e.g. — (all-null in sample)
decided_reason	stringnullable	—	Evidence behind a pinned or blocked decision. e.g. — (all-null in sample)
decision	stringnullable	—	How this mapping was decided: 'derived' (finder answer, overwritable), 'pinned' (decided on evidence, trigger-protected), 'blocked' (no player we hold is this id; player_id NULL, never retried). DB default 'derived'; a BEFORE UPDATE trigger preserves non-derived rows. e.g. derived
player_name	stringnullable	—	Player name as provided by operator e.g. Lamar Jackson
position	stringnullable	—	Position as provided by operator Values:DBDLLBWRRBTEQBOLPKLS

GET/api/v1/nfl/operator_player_lookups/{id}Get a single operator_player_lookup by id

Parameters

idpathbigintrequired

Primary key (id) of the operator_player_lookup row.

Restores the documented defaults (trial keys only accept the unchanged defaults).

Request

curl -sS --compressed \
  -H 'Authorization: Bearer YOUR_API_KEY' \
  'https://api.stat-api.com/api/v1/nfl/operator_player_lookups/{pk_value}'

Responses

200Single operator_player_lookup row.application/jsonshow example ▸

404Row not found.

Response Schema(9 fields)show schema ▸

Field	Type	References	Description
idkey	bigint	—	Primary Key
operator_id	bigint		Reference to main.operator entity e.g. 5
operator_player_id	string	—	External player ID from operator e.g. 6012
player_id	bigintnullable		Internal nfl.players.id reference e.g. 2
decided_at	timestamptznullable	—	When the pin or block was decided. e.g. — (all-null in sample)
decided_reason	stringnullable	—	Evidence behind a pinned or blocked decision. e.g. — (all-null in sample)
decision	stringnullable	—	How this mapping was decided: 'derived' (finder answer, overwritable), 'pinned' (decided on evidence, trigger-protected), 'blocked' (no player we hold is this id; player_id NULL, never retried). DB default 'derived'; a BEFORE UPDATE trigger preserves non-derived rows. e.g. derived
player_name	stringnullable	—	Player name as provided by operator e.g. Lamar Jackson
position	stringnullable	—	Position as provided by operator Values:DBDLLBWRRBTEQBOLPKLS