NBA Desk Data Inventory
Updated: 2026-04-03
Status: All sources operational
EDGE DETECTION
| Source |
Table |
Rows |
Updated |
| Edge Scanner — Totals |
sports_edges (market_type='total') |
~2K/week |
Every scan cycle |
| Edge Scanner — Spreads |
sports_edges (market_type='spread') |
~1.5K/week |
Every scan cycle |
| Edge Scanner — Moneylines |
sports_edges (market_type='ml') |
~100/week |
Every scan cycle |
| Edge Scanner — Team Totals |
sports_edges (market_type='teamTotal') |
~1.5K/week |
Every scan cycle |
| Custom Calculations |
Computed during scan |
N/A |
With scanner |
Columns tracked per edge: sport, game_id, market_type, ticker, threshold, model_prob, kalshi_mid/bid/ask, execution_price, raw_edge, net_edge, executable, tail_confidence, pinnacle_anchor, de_vig_method, detected_at, side, steam_detected/magnitude/direction, yes/no model_prob, yes/no exec_price, yes/no net_edge, best_side, scan_type, spread_cents, team_code, team_sigma, pace_factor, closing_price, clv, actual_outcome, settled_at
ODDS & PRICES
| Source |
Table |
Rows |
Schedule |
| Kalshi game lines |
sports_odds_snapshots (source='kalshi') |
7M+ |
Every 30min |
| Pinnacle NBA odds |
sports_odds_snapshots (source='pinnacle') |
860+ |
Adaptive |
| Pinnacle Team Totals |
sports_odds_snapshots (source='pinnacle-teamtotal') |
Varies |
Adaptive |
| SBR Multi-Book — Spreads |
sbr_book_odds (sport='nba') |
19K+ |
4x daily |
| SBR Multi-Book — Totals |
sbr_book_odds (sport='nba') |
Included above |
4x daily |
| SBR Multi-Book — Moneylines |
sbr_book_odds (sport='nba') |
Included above |
4x daily |
| Pregame.com sharp money |
pregame_consensus, pregame_sharp_data |
1.5K |
3x daily |
| Live Game Scores |
live_game_scores (sport='nba') |
85K+ |
Every 60s |
RATINGS & PREDICTIONS
| Source |
Table |
Rows |
Schedule |
| DRatings |
dratings_predictions |
28 |
11 AM daily |
| Sagarin |
sagarin_predictions |
20 |
11 AM daily |
| Dimers |
dimers_predictions |
120 |
11 AM daily |
| GameSim |
gamesim_predictions |
210 |
12 PM daily |
| ESPN BPI |
espn_bpi_predictions |
36 |
11 AM daily |
TEAM STATS (NBA.com)
| Source |
Table |
Rows |
Schedule |
| Advanced Stats |
nba_advanced_stats |
30 |
11 AM daily |
| Four Factors |
nba_four_factors |
30 |
11 AM daily |
| Shooting Stats |
nba_shooting_stats |
30 |
11 AM daily |
| Shot Profile by Zone |
nba_shot_locations |
120 |
11 AM daily |
| Opponent Stats |
nba_opponent_stats |
60 |
11 AM daily |
| Home/Away Splits |
nba_home_away_splits |
60 |
11 AM daily |
| Last 5/10 Games |
nba_last_n_stats |
60 |
11 AM daily |
| Clutch Stats |
nba_clutch_stats |
30 |
11 AM daily |
| Hustle Stats |
nba_hustle_stats |
30 |
11 AM daily |
TEAM STATS (Other)
| Source |
Table |
Rows |
Schedule |
| NBAStuffer (pace, ORtg, DRtg) |
nbastuffer_stats |
30 |
11 AM daily |
| BBRef Team Stats |
nba_bbref_team_stats |
60 |
11 AM daily |
| BBRef Opponent Stats |
nba_opponent_stats |
60 |
11 AM daily |
COMPUTED ANALYTICS
| Metric |
Table |
Rows |
Schedule |
| Team Variance & Fat Tails |
nba_team_variance |
30 |
11 AM daily |
| Quarter Scoring Patterns |
nba_quarter_scoring |
24 |
11 AM daily |
| Fatigue & Travel Metrics |
nba_fatigue_metrics |
80 |
11 AM daily |
| Rest Stats |
nba_rest_stats |
30 |
11 AM daily |
| Implied Probability Curves |
market_implied_curves |
56K+ |
With edge scanner |
GAME CONTEXT
| Source |
Table |
Rows |
Schedule |
| ESPN Schedule |
nba_schedule |
15 |
Continuous |
| Injury Report |
nba_injuries |
117 |
11 AM + 5 PM |
| Injury Change Alerts |
nba_injury_changes |
Growing |
Every 30min 2-8PM ET |
| Referee Assignments |
ref_assignments |
414 |
Game day |
KEY PARAMETERS
| Parameter |
Value |
| Game-level sigma |
14 (NBA council ruling) |
| Team total sigma |
Per-team (10.1-12.5 from nba_team_variance) |
| Min net edge |
4 cents |
| Kalshi fee rate |
7% on profit |
| Kelly fraction |
0.25 (quarter) |
| Max spread filter |
20 cents |
| Implied prob range |
10%-90% (mid) |
| Steam threshold |
0.5 pts/hour |
| Star player threshold |
25+ avg minutes |
DATABASE: research-pipeline.db
All data stored in SQLite WAL mode at /home/ubuntu/edgeclaw/data/db/research-pipeline.db.
Source: ~/.claude/projects/-home-ubuntu-edgeclaw/memory/nba-desk-data-inventory.md