playoff_prediction_snapshots

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: snapshot_date (date), computed_at (date)

snapshot_id ▼ playoff_season_id snapshot_date snapshot_type bracket_json champion_probs_json n_simulations computed_at
3 999 2026-04-14 pre [{"series_id": 1006, "round": 1, "label": "Atlantic Division R1-A", "higher_id": 384, "lower_id": 411, "higher_pct": 60.4, "lower_pct": 39.6, "expected_games": 2.6, "games_dist": "{\"2\": 44.5, \"3\": 55.50000000000001}"}, {"series_id": 1007, "round": 1, "label": "Atlantic Division R1-B", "higher_id": 317, "lower_id": 319, "higher_pct": 58.8, "lower_pct": 41.2, "expected_games": 2.6, "games_dist": "{\"2\": 42.9, \"3\": 57.099999999999994}"}, {"series_id": 1011, "round": 1, "label": "Central Division R1", "higher_id": 321, "lower_id": 327, "higher_pct": 32.8, "lower_pct": 67.2, "expected_games": 2.6, "games_dist": "{\"2\": 35.699999999999996, \"3\": 64.3}"}, {"series_id": 1015, "round": 1, "label": "North Division R1", "higher_id": 335, "lower_id": 323, "higher_pct": 62.0, "lower_pct": 38.0, "expected_games": 2.6, "games_dist": "{\"2\": 43.7, \"3\": 56.3}"}, {"series_id": 1019, "round": 1, "label": "Pacific Division R1-A", "higher_id": 419, "lower_id": 404, "higher_pct": 53.3, "lower_pct": 46.7, "expected_games": 2.5, "games_dist": "{\"2\": 45.800000000000004, \"3\": 54.2}"}, {"series_id": 1020, "round": 1, "label": "Pacific Division R1-B", "higher_id": 437, "lower_id": 402, "higher_pct": 83.7, "lower_pct": 16.3, "expected_games": 2.8, "games_dist": "{\"2\": 16.2, \"3\": 83.8}"}, {"series_id": 1021, "round": 1, "label": "Pacific Division R1-C", "higher_id": 445, "lower_id": 405, "higher_pct": 55.5, "lower_pct": 44.5, "expected_games": 2.5, "games_dist": "{\"2\": 46.2, \"3\": 53.800000000000004}"}, {"series_id": 1008, "round": 2, "label": "Atlantic Division R2-A", "higher_id": 309, "lower_id": 317, "higher_pct": 61.1, "lower_pct": 38.9, "expected_games": 4.2, "games_dist": "{\"3\": 21.0, \"4\": 37.7, \"5\": 41.3}"}, {"series_id": 1009, "round": 2, "label": "Atlantic Division R2-B", "higher_id": 316, "lower_id": 384, "higher_pct": 51.1, "lower_pct": 48.9, "expected_games": 4.1, "games_dist": "{\"3\": 24.4, \"4\": 38.6, \"5\": 37.0}"}, {"series_id": 1012, "round": 2, "label": "Central Division R2-A", "higher_id": 328… {"309": 0.090453314952, "316": 0.247324, "317": 0.228732, "319": 0.41200000000000003, "321": 0.32799999999999996, "323": 0.38, "324": 0.391, "327": 0.303744, "328": 0.140012904, "330": 0.22864600000000002, "335": 0.25606, "373": 0.146795796, "380": 0.45299999999999996, "384": 0.295356, "402": 0.163, "403": 0.322, "404": 0.467, "405": 0.445, "411": 0.396, "415": 0.21366800000000002, "419": 0.21213399999999996, "437": 0.076039121466, "445": 0.19758000000000003} 1000 2026-04-15T02:33:53.646686+00:00

Advanced export

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

CSV options: 

CREATE TABLE playoff_prediction_snapshots (
            snapshot_id          INTEGER PRIMARY KEY AUTOINCREMENT,
            playoff_season_id    INTEGER NOT NULL,
            snapshot_date        TEXT NOT NULL,
            snapshot_type        TEXT NOT NULL,
            bracket_json         TEXT NOT NULL,
            champion_probs_json  TEXT NOT NULL,
            n_simulations        INTEGER NOT NULL,
            computed_at          TEXT NOT NULL,
            UNIQUE(playoff_season_id, snapshot_date)
        );