# Sports Data Map

Generated: 2026-08-04T03:26:36.203865+00:00

Scope: sports-only: NBA, MLB package, odds, Pikkit, Kalshi, kyleskom, Kaggle, live sports captures, and sports model artifacts

## Inventory

- Files mapped: 562
- Bytes mapped: 3,313,273,603

### Largest Files

| File | Size MB | Category | Backup |
|---|---:|---|---|
| `/root/.openclaw/workspace/ladder-framework/data/backtest.db` | 796.05 | sports_model | False |
| `/root/.openclaw/workspace/ladder-framework/data/backtest.db.bak-20260804-020719` | 697.27 | sports_model | False |
| `/root/.openclaw/workspace/kalshi-data/kalshi_nba.db` | 426.00 | kalshi | False |
| `/root/.openclaw/workspace/ladder-framework/data/NBA_AI_dev.zip` | 191.30 | nba | False |
| `/root/.openclaw/workspace-clawopen-backup/ladder-framework/data/NBA_AI_dev.zip` | 191.30 | nba | True |
| `/root/.openclaw/workspace/ladder-framework/data/kyleskom-nba/Data/TeamData.sqlite` | 87.62 | kyleskom | False |
| `/root/.openclaw/workspace-clawopen-backup/ladder-framework/data/kyleskom-nba/Data/TeamData.sqlite` | 87.62 | kyleskom | True |
| `/root/.openclaw/workspace/kalshi-data/candles.parquet` | 48.87 | kalshi | False |
| `/root/.openclaw/workspace/ladder-framework/data/kyleskom-nba/Data/dataset.sqlite` | 35.62 | kyleskom | False |
| `/root/.openclaw/workspace-clawopen-backup/ladder-framework/data/kyleskom-nba/Data/dataset.sqlite` | 35.62 | kyleskom | True |
| `/root/.openclaw/workspace/kalshi-data/nba_kxnbapts_raw.json` | 28.04 | kalshi | False |
| `/root/.openclaw/workspace-clawopen-backup/kalshi-data/nba_kxnbapts_raw.json` | 28.04 | kalshi | True |
| `/root/.openclaw/workspace/kalshi-data/nba_kxnbareb_raw.json` | 27.27 | kalshi | False |
| `/root/.openclaw/workspace-clawopen-backup/kalshi-data/nba_kxnbareb_raw.json` | 27.27 | kalshi | True |
| `/root/.openclaw/workspace/kalshi-data/nba_kxnba3pt_raw.json` | 22.49 | kalshi | False |
| `/root/.openclaw/workspace-clawopen-backup/kalshi-data/nba_kxnba3pt_raw.json` | 22.49 | kalshi | True |
| `/root/.openclaw/workspace/kalshi-data/nba_spread_markets_raw.json` | 22.28 | kalshi | False |
| `/root/.openclaw/workspace-clawopen-backup/kalshi-data/nba_spread_markets_raw.json` | 22.28 | kalshi | True |
| `/root/.openclaw/workspace/kalshi-data/nba_kxnbaast_raw.json` | 20.82 | kalshi | False |
| `/root/.openclaw/workspace-clawopen-backup/kalshi-data/nba_kxnbaast_raw.json` | 20.82 | kalshi | True |

## Relationships

### backtest_integrity

```json
{
  "box_scores": {
    "distinct_ids": 6385,
    "games_missing_table_id": 1893,
    "ids_not_in_games": 1237,
    "sample_ids_not_in_games": [
      "0021900001",
      "0021900002",
      "0021900003",
      "0021900004",
      "0021900005",
      "0021900006",
      "0021900007",
      "0021900008",
      "0021900009",
      "0021900010",
      "0021900011",
      "0021900012",
      "0021900013",
      "0021900014",
      "0021900015",
      "0021900016",
      "0021900017",
      "0021900018",
      "0021900019",
      "0021900020"
    ]
  },
  "games": 7041,
  "historical_odds": {
    "distinct_ids": 846,
    "games_missing_table_id": 6195,
    "ids_not_in_games": 0,
    "sample_ids_not_in_games": []
  },
  "historical_odds_events": {
    "distinct_ids": 846,
    "games_missing_table_id": 6195,
    "ids_not_in_games": 0,
    "sample_ids_not_in_games": []
  },
  "pbp_actions": {
    "distinct_ids": 8192,
    "games_missing_table_id": 88,
    "ids_not_in_games": 1239,
    "sample_ids_not_in_games": [
      "0021900001",
      "0021900002",
      "0021900003",
      "0021900004",
      "0021900005",
      "0021900006",
      "0021900007",
      "0021900008",
      "0021900009",
      "0021900010",
      "0021900011",
      "0021900012",
      "0021900013",
      "0021900014",
      "0021900015",
      "0021900016",
      "0021900017",
      "0021900018",
      "0021900019",
      "0021900020"
    ]
  }
}
```

### pikkit_to_backtest

```json
[
  {
    "action_number_out_of_bounds_vs_backtest_pbp": 0,
    "distinct_game_ids": 133,
    "game_ids_missing_from_backtest": 0,
    "rows": 203,
    "sample_missing_game_ids": [],
    "source": "pikkit_full_pbp_enriched.json"
  },
  {
    "distinct_game_ids": 135,
    "game_ids_missing_from_backtest": 0,
    "rows": 197,
    "sample_missing_game_ids": [],
    "source": "pikkit_matched_v6.json"
  },
  {
    "distinct_game_ids": 130,
    "game_ids_missing_from_backtest": 0,
    "rows": 203,
    "sample_missing_game_ids": [],
    "source": "pikkit_enriched.json"
  },
  {
    "distinct_game_ids": 0,
    "game_ids_missing_from_backtest": 0,
    "rows": 122,
    "sample_missing_game_ids": [],
    "source": "pikkit_historical_ev.json"
  }
]
```

### live_to_backtest

```json
[
  {
    "distinct_game_ids": 13,
    "game_ids_missing_from_backtest": 0,
    "rows": 873,
    "sample_missing_game_ids": [],
    "source": "live_spreads.db/spread_snapshots"
  },
  {
    "distinct_game_ids": 16,
    "game_ids_missing_from_backtest": 0,
    "rows": 4343,
    "sample_missing_game_ids": [],
    "source": "arb_log.db/pbp_snapshots"
  },
  {
    "distinct_game_ids": 8,
    "game_ids_missing_from_backtest": 0,
    "rows": 36,
    "sample_missing_game_ids": [],
    "source": "arb_log.db/run_events"
  }
]
```

### kalshi_to_backtest

```json
{
  "matched_to_backtest": 905,
  "missing_because_date_absent": 134,
  "missing_because_game_absent_on_date": 22,
  "missing_from_backtest": 156,
  "parse_failures": 0,
  "rows": 1061,
  "sample_missing": [
    {
      "away": "DAL",
      "date": "2026-01-25",
      "home": "MIL",
      "kalshi_game_id": "2026-01-25_DALM@IL"
    },
    {
      "away": "DEN",
      "date": "2026-01-25",
      "home": "MEM",
      "kalshi_game_id": "2026-01-25_DENM@EM"
    },
    {
      "away": "GSW",
      "date": "2026-01-24",
      "home": "MIN",
      "kalshi_game_id": "2026-01-24_GSWM@IN"
    },
    {
      "away": "MIA",
      "date": "2026-01-08",
      "home": "CHI",
      "kalshi_game_id": "2026-01-08_MIAC@HI"
    },
    {
      "away": "MEM",
      "date": "2025-12-15",
      "home": "LAC",
      "kalshi_game_id": "2025-12-15_MEML@AC"
    },
    {
      "away": "HOU",
      "date": "2025-12-15",
      "home": "DEN",
      "kalshi_game_id": "2025-12-15_HOUD@EN"
    },
    {
      "away": "DAL",
      "date": "2025-12-15",
      "home": "UTA",
      "kalshi_game_id": "2025-12-15_DALU@TA"
    },
    {
      "away": "DET",
      "date": "2025-12-15",
      "home": "BOS",
      "kalshi_game_id": "2025-12-15_DETB@OS"
    },
    {
      "away": "TOR",
      "date": "2025-12-15",
      "home": "MIA",
      "kalshi_game_id": "2025-12-15_TORM@IA"
    },
    {
      "away": "GSW",
      "date": "2025-12-14",
      "home": "POR",
      "kalshi_game_id": "2025-12-14_GSWP@OR"
    },
    {
      "away": "NOP",
      "date": "2025-12-14",
      "home": "CHI",
      "kalshi_game_id": "2025-12-14_NOPC@HI"
    },
    {
      "away": "MIL",
      "date": "2025-12-14",
      "home": "BKN",
      "kalshi_game_id": "2025-12-14_MILB@KN"
    },
    {
      "away": "LAL",
      "date": "2025-12-14",
      "home": "PHX",
      "kalshi_game_id": "2025-12-14_LALP@HX"
    },
    {
      "away": "SAC",
      "date": "2025-12-14",
      "home": "MIN",
      "kalshi_game_id": "2025-12-14_SACM@IN"
    },
    {
      "away": "PHI",
      "date": "2025-12-14",
      "home": "ATL",
      "kalshi_game_id": "2025-12-14_PHIA@TL"
    },
    {
      "away": "WAS",
      "date": "2025-12-14",
      "home": "IND",
      "kalshi_game_id": "2025-12-14_WASI@ND"
    },
    {
      "away": "CHA",
      "date": "2025-12-14",
      "home": "CLE",
      "kalshi_game_id": "2025-12-14_CHAC@LE"
    },
    {
      "away": "SAS",
      "date": "2025-12-13",
      "home": "OKC",
      "kalshi_game_id": "2025-12-13_SASO@KC"
    },
    {
      "away": "NYK",
      "date": "2025-12-13",
      "home": "ORL",
      "kalshi_game_id": "2025-12-13_NYKO@RL"
    },
    {
      "away": "MIN",
      "date": "2025-12-12",
      "home": "GSW",
      "kalshi_game_id": "2025-12-12_MING@SW"
    },
    {
      "away": "BKN",
      "date": "2025-12-12",
      "home": "DAL",
      "kalshi_game_id": "2025-12-12_BKND@AL"
    },
    {
      "away": "IND",
      "date": "2025-12-12",
      "home": "PHI",
      "kalshi_game_id": "2025-12-12_INDP@HI"
    },
    {
      "away": "CHI",
      "date": "2025-12-12",
      "home": "CHA",
      "kalshi_game_id": "2025-12-12_CHIC@HA"
    },
    {
      "away": "UTA",
      "date": "2025-12-12",
      "home": "MEM",
      "kalshi_game_id": "2025-12-12_UTAM@EM"
    },
    {
      "away": "CLE",
      "date": "2025-12-12",
      "home": "WAS",
      "kalshi_game_id": "2025-12-12_CLEW@AS"
    },
    {
      "away": "ATL",
      "date": "2025-12-12",
      "home": "DET",
      "kalshi_game_id": "2025-12-12_ATLD@ET"
    },
    {
      "away": "DEN",
      "date": "2025-12-11",
      "home": "SAC",
      "kalshi_game_id": "2025-12-11_DENS@AC"
    },
    {
      "away": "LAC",
      "date": "2025-12-11",
      "home": "HOU",
      "kalshi_game_id": "2025-12-11_LACH@OU"
    },
    {
      "away": "POR",
      "date": "2025-12-11",
      "home": "NOP",
      "kalshi_game_id": "2025-12-11_PORN@OP"
    },
    {
      "away": "BOS",
      "date": "2025-12-11",
      "home": "MIL",
      "kalshi_game_id": "2025-12-11_BOSM@IL"
    }
  ]
}
```

### kaggle_to_backtest

```json
{
  "canonical_date_max": "2026-03-31",
  "canonical_date_min": "2018-10-16",
  "exact_score_matches": 3275,
  "rows": 23118,
  "rows_inside_canonical_date_range": 8909,
  "rows_on_canonical_dates": 6345,
  "team_date_only_matches": 17,
  "team_parse_failures": 0
}
```

### kyleskom_to_backtest

```json
{
  "exact_score_matches": 4138,
  "rows_checked": 45284,
  "source_tables_scanned": 36,
  "table_details": [
    {
      "exact_score_matches": 355,
      "rows": 1255,
      "table": "2023-24",
      "team_date_only_matches": 1
    },
    {
      "exact_score_matches": 685,
      "rows": 1326,
      "table": "2024-25",
      "team_date_only_matches": 5
    },
    {
      "exact_score_matches": 124,
      "rows": 1312,
      "table": "odds_2018-19_new",
      "team_date_only_matches": 0
    },
    {
      "exact_score_matches": 236,
      "rows": 1143,
      "table": "odds_2019-20_new",
      "team_date_only_matches": 0
    },
    {
      "exact_score_matches": 610,
      "rows": 1171,
      "table": "odds_2020-21_new",
      "team_date_only_matches": 9
    },
    {
      "exact_score_matches": 627,
      "rows": 1323,
      "table": "odds_2021-22_new",
      "team_date_only_matches": 2
    },
    {
      "exact_score_matches": 629,
      "rows": 1319,
      "table": "odds_2022-23_new",
      "team_date_only_matches": 1
    },
    {
      "exact_score_matches": 350,
      "rows": 1195,
      "table": "odds_2023-24_new",
      "team_date_only_matches": 1
    },
    {
      "exact_score_matches": 522,
      "rows": 554,
      "table": "odds_2025-26",
      "team_date_only_matches": 1
    }
  ],
  "tables_with_matches_or_priority": 9,
  "team_date_only_matches": 20
}
```

### missing_games_queue

```json
{
  "already_present_in_backtest": 4416,
  "blank_date_or_team": 1969,
  "by_season": {
    "2018-19": 206,
    "2019-20": 718,
    "2020-21": 620,
    "2021-22": 770,
    "2022-23": 771,
    "2023-24": 842,
    "2024-25": 733,
    "2025-26": 995
  },
  "remaining_candidate_rows": 1239,
  "rows": 5655
}
```

## Top Correlations

| Source | X | Y | N | r |
|---|---|---|---:|---:|
| `kaggle_nba_betting/nba_2008-2025.csv` | total | actual_points | 23,118 | 0.654 |
| `kaggle_nba_betting/nba_2008-2025.csv` | h2_total | actual_points | 19,817 | 0.622 |
| `live_line_correlation_data.json` | q3_margin | dog_covered | 5,498 | -0.611 |
| `signals.db/backtest_games` | q3_margin | dog_covered | 5,829 | 0.593 |
| `universal_game_state.json` | chase_gap | dog_covered | 22,104 | -0.565 |
| `pregame_features.json` | fg_pct_diff | home_covered | 3,844 | 0.553 |
| `universal_game_state.json` | margin | dog_covered | 22,104 | -0.553 |
| `live_line_correlation_data.json` | half_margin | dog_covered | 5,498 | -0.472 |
| `pregame_features.json` | 3pt_pct_diff | home_covered | 3,844 | 0.469 |
| `kyleskom/OddsData.sqlite` | OU | Points | 24,807 | 0.466 |
| `signals.db/backtest_games` | half_margin | dog_covered | 5,829 | 0.463 |
| `universal_game_state.json` | fg_pct_diff | dog_covered | 22,104 | -0.380 |
| `pregame_features.json` | reb_diff | home_covered | 3,844 | 0.323 |
| `signals.db/backtest_games` | final_margin | dog_covered | 5,829 | -0.292 |
| `kyleskom/OddsData.sqlite` | Spread | Win_Margin | 24,806 | 0.281 |
| `universal_game_state.json` | reb_diff | dog_covered | 22,104 | -0.253 |
| `kaggle_nba_betting/nba_2008-2025.csv` | spread | home_margin | 23,115 | 0.216 |
| `live_line_correlation_data.json` | q3_to_diff | dog_covered | 5,498 | 0.175 |
| `pikkit_full_pbp_enriched.json` | amount | profit | 203 | -0.170 |
| `live_line_correlation_data.json` | half_to_diff | dog_covered | 5,498 | 0.168 |
| `signals.db/backtest_games` | to_diff | dog_covered | 4,056 | 0.166 |
| `pikkit_matched_v6.json` | amount | profit | 197 | -0.165 |
| `pregame_features.json` | to_diff | home_covered | 3,844 | -0.165 |
| `universal_game_state.json` | fg3_pct_diff | dog_covered | 22,104 | -0.163 |
| `signals.db/backtest_games` | q3_max_lead | dog_covered | 2,158 | 0.156 |
| `universal_game_state.json` | to_diff | dog_covered | 22,104 | 0.139 |
| `signals.db/backtest_games` | dog_tov | dog_covered | 4,056 | -0.108 |
| `live_line_correlation_data.json` | final_to_diff | dog_covered | 5,725 | 0.108 |
| `signals.db/backtest_games` | q3_lead_pct | dog_covered | 2,158 | 0.107 |
| `signals.db/backtest_games` | q3_erosion | dog_covered | 2,158 | -0.098 |
| `signals.db/backtest_games` | q3_stability | dog_covered | 2,158 | 0.077 |
| `signals.db/backtest_games` | fav_tov | dog_covered | 4,056 | 0.067 |
| `pikkit_full_pbp_enriched.json` | to_diff | won | 203 | -0.062 |
| `pikkit_matched_v6.json` | margin | won | 197 | 0.053 |
| `pikkit_matched_v6.json` | edge | won | 116 | 0.053 |
| `pregame_features.json` | spread | home_covered | 3,844 | 0.046 |
| `pikkit_full_pbp_enriched.json` | bt_fg_pct | won | 195 | 0.043 |
| `kaggle_nba_betting/nba_2008-2025.csv` | h2_spread | home_margin | 19,822 | -0.043 |
| `pikkit_full_pbp_enriched.json` | reb_diff | won | 203 | 0.042 |
| `pikkit_matched_v6.json` | edge | profit | 116 | 0.042 |