home / my_database

Menu
  • Playoff Bracket
  • Game Predictor
  • Season Predictor

playoff_series_predictions

1 row where series_id = 1158

✎ View and edit SQL

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
642 1158 1158 2026-04-19 373 384 39.6 60.4 6.0 {"4": 5.800000000000001, "5": 22.900000000000002, "6": 36.1, "7": 35.199999999999996} 1000 2026-04-19T14:14:58.428017+00:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Queries took 12.108ms