Odds API · Docs

Resources.

Expand any resource to see every field.

/sportsSport catalog

key: text, PK — e.g. basketball_nba
group_name: text — e.g. Basketball
title: text — display name
description: text
active: bool — default true
has_outrights: bool — default false
created_at: timestamptz
updated_at: timestamptz

/bookmakersSportsbook registry

key: text, PK — e.g. draftkings, fanduel, caesars
title: text — display name
active: bool — default true
created_at: timestamptz
updated_at: timestamptz

/bookmaker_regionsWhich regions each bookmaker serves

bookmaker_key: text, FK → bookmakers.key
region: text — e.g. us, us2, uk, eu

/eventsGames / matchups

id: uuid, PK (with sport_key)
sport_key: text, PK (with id), FK → sports.key
sport_title: text
commence_time: timestamptz — kickoff/tipoff
home_team: text
away_team: text
status: text — pregame, live, final
completed: bool
home_rotation_number: text
away_rotation_number: text
home_key: text — stable team key from matcher alias map
away_key: text — stable team key from matcher alias map
created_at: timestamptz
updated_at: timestamptz

/market_catalogKnown markets per sport/book/region

sport_key: text
bookmaker_key: text, FK → bookmakers.key
region: text
market_key: text — normalized, e.g. h2h, spreads, totals, player_points
market_name: text — human name
market_type: text — game | player_prop | team_total | future
market_period: text — full_game | 1h | 1q | 1p | ...
last_seen_at: timestamptz
created_at: timestamptz
updated_at: timestamptz

/current_oddsThe hot resource — one row per priced outcome, latest

id: uuid, PK
sport_key: text
event_id: uuid, FK → events.id
bookmaker_key: text, FK → bookmakers.key
bookmaker_title: text
region: text
market_key: text
market_name: text
market_type: text — game | player_prop | team_total | future
market_period: text
outcome_name: text — Over, Under, home team, Yes, ...
outcome_description: text — player name for props, else ''
point: float — spread/total/prop line; nullable
price_american: int — American odds; nullable
price_decimal: float — decimal odds; nullable
link: text — deep link to the specific bet at the book
sid: text — book-specific selection id
bet_limit: float — nullable
multiplier: float — nullable
last_update: timestamptz — when the book last repriced
fetched_at: timestamptz — when we pulled it
created_at: timestamptz
updated_at: timestamptz

/odds_snapshotsAppend-only line-movement history

id: bigint, PK autoincrement
sport_key: text
event_id: uuid
bookmaker_key: text, FK → bookmakers.key
market_key: text
market_type: text
market_period: text — default full_game
outcome_name: text
outcome_desc: text — note: not outcome_description
price_american: int — nullable
price_decimal: float — nullable
point: float — nullable
fetched_at: timestamptz

/futures_marketsSeason/tournament-long markets

id: uuid, PK
sport_key: text, FK → sports.key
season: text — e.g. 2025-26
market_key: text — e.g. championship_winner, mvp
market_name: text
market_type: text — default 'future'
created_at: timestamptz
updated_at: timestamptz

/futures_outcomesPriced selections on a future

id: uuid, PK
futures_market_id: uuid, FK → futures_markets.id (cascade)
bookmaker_key: text, FK → bookmakers.key
bookmaker_title: text
region: text
outcome_name: text — team or player
outcome_key: text — normalized key for dedup
point: float — nullable
price_american: int — nullable
price_decimal: float — nullable
link: text
sid: text
last_update: timestamptz
fetched_at: timestamptz
created_at: timestamptz
updated_at: timestamptz