mc_predictions

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: game_id, n_simulations, decay_rate, lookback_games, computed_at (date)

prediction_id ▼ game_id n_simulations decay_rate lookback_games home_win_pct away_win_pct ot_pct so_pct avg_home_goals avg_away_goals score_dist_json computed_at
3 1027774 100 0.1 20 40.0 60.0 9.0 7.0 2.62 3.5 {"3-3": 7.000000000000001, "2-3": 7.000000000000001, "1-3": 6.0, "4-3": 5.0, "3-4": 5.0, "1-5": 3.0, "2-2": 3.0, "3-2": 3.0, "1-2": 3.0, "4-5": 3.0} 2026-04-10T13:21:05.299494Z
4 1028858 1000 0.1 20 76.5 23.5 7.6 5.3 3.54 1.97 {"3-2": 7.000000000000001, "3-1": 6.7, "4-1": 5.1, "2-2": 5.1, "2-1": 4.9, "4-2": 4.8, "4-3": 4.3999999999999995, "5-1": 4.0, "5-2": 3.5999999999999996, "2-3": 3.3000000000000003} 2026-04-11T00:59:33.901892Z
5 1028858 1000 0.25 5 73.9 26.1 10.0 6.7 3.42 1.98 {"2-2": 5.800000000000001, "3-2": 5.7, "2-1": 5.4, "3-1": 4.8, "3-3": 4.7, "4-2": 4.7, "1-2": 4.2, "4-1": 4.2, "4-3": 3.9, "5-1": 3.6999999999999997} 2026-04-11T01:01:03.519931Z

Advanced export

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

CSV options: 

CREATE TABLE mc_predictions (
            prediction_id    INTEGER PRIMARY KEY AUTOINCREMENT,
            game_id          INTEGER NOT NULL,
            n_simulations    INTEGER NOT NULL,
            decay_rate       REAL NOT NULL,
            lookback_games   INTEGER NOT NULL,
            home_win_pct     REAL NOT NULL,
            away_win_pct     REAL NOT NULL,
            ot_pct           REAL NOT NULL,
            so_pct           REAL NOT NULL,
            avg_home_goals   REAL NOT NULL,
            avg_away_goals   REAL NOT NULL,
            score_dist_json  TEXT NOT NULL,
            computed_at      TEXT NOT NULL,
            UNIQUE(game_id, n_simulations, decay_rate, lookback_games)
        );