playoff_series_predictions
1 row where series_id = 1175
This data as json, CSV (advanced)
Suggested facets: snapshot_date (date), computed_at (date)
| prediction_id ▼ | series_id | snapshot_date | home_team_id | away_team_id | home_series_win_pct | away_series_win_pct | expected_games | games_dist_json | n_simulations | computed_at |
|---|---|---|---|---|---|---|---|---|---|---|
| 653 | 1175 1175 | 2026-04-23 | 445 | 402 | 56.3 | 43.7 | 2.5 | {"2": 48.3, "3": 51.7} | 1000 | 2026-04-23T12:58:35.150219+00:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE playoff_series_predictions (
prediction_id INTEGER PRIMARY KEY AUTOINCREMENT,
series_id INTEGER NOT NULL REFERENCES playoff_brackets(series_id),
snapshot_date TEXT NOT NULL,
home_team_id INTEGER NOT NULL,
away_team_id INTEGER NOT NULL,
home_series_win_pct REAL NOT NULL,
away_series_win_pct REAL NOT NULL,
expected_games REAL NOT NULL,
games_dist_json TEXT NOT NULL,
n_simulations INTEGER NOT NULL,
computed_at TEXT NOT NULL,
UNIQUE(series_id, snapshot_date)
);