At a glance
Tables
Table details
Dimensions
DIM_SEASON — Maps season IDs to labels (e.g. 2026 is “2025-26”).
DIM_TEAM — 368 D1 teams with canonical names, conference, and ESPN ID. About 15-20% of games are against non-D1 opponents who don’t appear here.
Games and team stats
FACT_SCHEDULE — One row per game with scores, winner, date, pace, T-Rank predicted scores, point-in-time rankings, and neutral-site flag.
FACT_TEAM_GAME_STATS — Two rows per game (one per team). Full box score plus Barttorvik ratings at game time — useful for tracking how a team was rated at any point in the season.
FACT_GAME_PREDICTIONS — T-Rank pre-game predicted scores alongside actuals. These are statistical model outputs, not betting lines.
Team season analytics
FACT_TEAM_SEASON_RATINGS — The richest team table. One row per team per season with adjusted efficiency, power rating (Barthag), all four factors (offense + defense with ranks), shooting splits, strength of schedule, and Wins Above Bubble.
Player stats
FACT_PLAYER_GAME_LOG — One row per player per game (22,000+ players, 57,000+ games). Traditional box score plus advanced metrics like offensive rating, usage rate, and game-level BPM.
FACT_PLAYER_SEASON_STATS — Season-level aggregates with BPM, PORPAG, true shooting percentage, shot-zone breakdowns, and player bio (height, hometown, recruit rating).
Tournament and play-by-play
FACT_TOURNAMENT_SEEDS — 68 teams per year: seed (1-16), region, and play-in flag. Covers 2016-2019 and 2021-2025 (2020 cancelled; 2026 not yet available).
FACT_PBP — 20M+ play-by-play events from ESPN. Every shot, foul, turnover, sub, and timeout with scoring flags, running score, game clock, and shot coordinates.
Polymarket prediction markets
POLYMARKET_EVENTS — One row per betting event (e.g. “2026 NCAA Tournament Winner”, “NCAAB Conference Winner: ACC”). Includes total trading volume and liquidity.
POLYMARKET_MARKETS — One row per outcome within an event. For team-based events, each row is one team; for player awards, each row is one player. The current price represents the implied probability (0-1) — a price of 0.16 means the market implies a 16% chance.
POLYMARKET_PRICE_HISTORY — Hourly price observations per market. Useful for tracking how odds shift over time. History goes back to when each market was created (typically early February 2026).
262 of 368 teams have a Polymarket name mapping, so you can ask about how betting odds compare to statistical ratings.
Key metrics
Box scores tell you what happened. Advanced analytics tell you how good a team or player actually is — adjusting for pace and opponent quality. Scoring 80 against a weak team at a fast pace is very different from 80 against an elite defense in a slow game.Team metrics (in FACT_TEAM_SEASON_RATINGS)
The Four Factors
Dean Oliver’s framework for why teams win. All tracked on offense and defense, each with a national rank.Player metrics (in FACT_PLAYER_SEASON_STATS)
Shot-zone breakdowns (rim, mid-range, three, dunk, layup) are also available for profiling a player’s shot selection.
Try asking
Team strength
- “Who are the top 10 teams by Barthag this season?”
- “How does Duke’s offensive efficiency compare to North Carolina’s over the last 5 years?”
- “Which conferences are strongest by AdjO and AdjD?”
Predictions and upsets
- “How accurate are T-Rank predictions this season?”
- “What were the biggest upsets by rank difference?”
- “Which team has outperformed predictions the most?”
Player performance
- “Who leads the nation in scoring (min 10 games)?”
- “Show Cooper Flagg’s game-by-game stats.”
- “Top 5 players by BPM in the ACC?”
Play-by-play
- “Three-point shooting in clutch situations (last 2 min, margin within 5)?”
- “Shot distribution: top-10 vs bottom-10 offenses?”
- “Which teams score the most in overtime?”
March Madness
- “Which teams have been #1 seeds the most since 2016?”
- “What seed produces the most upsets historically?”
- “Show me bubble teams by WAB.”
Prediction markets (Polymarket)
- “Who does Polymarket favor to win the tournament?”
- “How have Duke’s tournament odds changed over the last month?”
- “Compare Polymarket odds to Barthag rankings — where does the market disagree with the stats?”
- “Which conference champion markets have the most liquidity?”