playoff_brackets

46 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: playoff_season_id, reg_season_id, round_number, division_name, conference_name, series_label, higher_seed_team_id, lower_seed_team_id, updated_at (date)

series_id ▼ playoff_season_id reg_season_id round_number division_name conference_name series_label higher_seed_team_id lower_seed_team_id higher_seed_wins lower_seed_wins series_winner_team_id series_complete source_series_a_id source_series_b_id updated_at
97 88 86 1 Atlantic Division Eastern Conference Atlantic Division R1-A 309 411 0 0   0     2026-04-14T13:49:31.515423+00:00
98 88 86 1 Atlantic Division Eastern Conference Atlantic Division R1-B 316 313 0 0   0     2026-04-14T13:49:31.515431+00:00
99 88 86 2 Atlantic Division Eastern Conference Atlantic Division R2-A 319   0 0   0 1   2026-04-14T13:49:31.515436+00:00
100 88 86 2 Atlantic Division Eastern Conference Atlantic Division R2-B 384   0 0   0 0   2026-04-14T13:49:31.515440+00:00
101 88 86 3 Atlantic Division Eastern Conference Atlantic Division Final     0 0   0 2 3 2026-04-14T13:49:31.515443+00:00
102 88 86 1 Central Division Western Conference Central Division R1-A 330 372 0 0   0     2026-04-14T13:49:31.515448+00:00
103 88 86 1 Central Division Western Conference Central Division R1-B 380 328 0 0   0     2026-04-14T13:49:31.515451+00:00
104 88 86 2 Central Division Western Conference Central Division R2-A 327   0 0   0 5   2026-04-14T13:49:31.515454+00:00
105 88 86 2 Central Division Western Conference Central Division R2-B     0 0   0 6   2026-04-14T13:49:31.515456+00:00
106 88 86 3 Central Division Western Conference Central Division Final     0 0   0 7 8 2026-04-14T13:49:31.515459+00:00
107 88 86 1 North Division Eastern Conference North Division R1-A 335 373 0 0   0     2026-04-14T13:49:31.515462+00:00
108 88 86 1 North Division Eastern Conference North Division R1-B 323 324 0 0   0     2026-04-14T13:49:31.515466+00:00
109 88 86 2 North Division Eastern Conference North Division R2-A 415   0 0   0 10   2026-04-14T13:49:31.515471+00:00
110 88 86 2 North Division Eastern Conference North Division R2-B     0 0   0 11   2026-04-14T13:49:31.515474+00:00
111 88 86 3 North Division Eastern Conference North Division Final     0 0   0 12 13 2026-04-14T13:49:31.515476+00:00
112 88 86 1 Pacific Division Western Conference Pacific Division R1-A 440 412 0 0   0     2026-04-14T13:49:31.515479+00:00
113 88 86 1 Pacific Division Western Conference Pacific Division R1-B 403 405 0 0   0     2026-04-14T13:49:31.515481+00:00
114 88 86 1 Pacific Division Western Conference Pacific Division R1-C 445 444 0 0   0     2026-04-14T13:49:31.515483+00:00
115 88 86 2 Pacific Division Western Conference Pacific Division R2-A 419   0 0   0 17   2026-04-14T13:49:31.515486+00:00
116 88 86 2 Pacific Division Western Conference Pacific Division R2-B     0 0   0 15 16 2026-04-14T13:49:31.515488+00:00
117 88 86 3 Pacific Division Western Conference Pacific Division Final     0 0   0 18 19 2026-04-14T13:49:31.515490+00:00
118 88 86 4   West Western Conference Final     0 0   0 9 20 2026-04-14T13:49:31.515494+00:00
119 88 86 4   East Eastern Conference Final     0 0   0 14 4 2026-04-14T13:49:31.515497+00:00
120 88 86 5     Calder Cup Final     0 0   0 21 22 2026-04-14T13:49:31.515499+00:00
1006 999 90 1 Atlantic Division Eastern Conference Atlantic Division R1-A 384 411 0 0   0     2026-04-15T02:33:53.611167+00:00
1007 999 90 1 Atlantic Division Eastern Conference Atlantic Division R1-B 317 319 0 0   0     2026-04-15T02:33:53.611176+00:00
1008 999 90 2 Atlantic Division Eastern Conference Atlantic Division R2-A 309 317 0 0   0   1007 2026-04-15T02:33:53.628610+00:00
1009 999 90 2 Atlantic Division Eastern Conference Atlantic Division R2-B 316 384 0 0   0   1006 2026-04-15T02:33:53.628633+00:00
1010 999 90 3 Atlantic Division Eastern Conference Atlantic Division Final 309 316 0 0   0 1008 1009 2026-04-15T02:33:53.636017+00:00
1011 999 90 1 Central Division Western Conference Central Division R1 321 327 0 0   0     2026-04-15T02:33:53.611189+00:00
1012 999 90 2 Central Division Western Conference Central Division R2-A 328 327 0 0   0   1011 2026-04-15T02:33:53.628644+00:00
1013 999 90 2 Central Division Western Conference Central Division R2-B 330 380 0 0   0     2026-04-15T02:33:53.611195+00:00
1014 999 90 3 Central Division Western Conference Central Division Final 328 330 0 0   0 1012 1013 2026-04-15T02:33:53.636029+00:00
1015 999 90 1 North Division Eastern Conference North Division R1 335 323 0 0   0     2026-04-15T02:33:53.611201+00:00
1016 999 90 2 North Division Eastern Conference North Division R2-A 415 335 0 0   0   1015 2026-04-15T02:33:53.628653+00:00
1017 999 90 2 North Division Eastern Conference North Division R2-B 324 373 0 0   0     2026-04-15T02:33:53.611206+00:00
1018 999 90 3 North Division Eastern Conference North Division Final 415 373 0 0   0 1016 1017 2026-04-15T02:33:53.636047+00:00
1019 999 90 1 Pacific Division Western Conference Pacific Division R1-A 419 404 0 0   0     2026-04-15T02:33:53.611212+00:00
1020 999 90 1 Pacific Division Western Conference Pacific Division R1-B 437 402 0 0   0     2026-04-15T02:33:53.611215+00:00
1021 999 90 1 Pacific Division Western Conference Pacific Division R1-C 445 405 0 0   0     2026-04-15T02:33:53.611218+00:00
1022 999 90 2 Pacific Division Western Conference Pacific Division R2-A 403 445 0 0   0   1021 2026-04-15T02:33:53.628657+00:00
1023 999 90 2 Pacific Division Western Conference Pacific Division R2-B 419 437 0 0   0 1019 1020 2026-04-15T02:33:53.628660+00:00
1024 999 90 3 Pacific Division Western Conference Pacific Division Final 403 437 0 0   0 1022 1023 2026-04-15T02:33:53.636053+00:00
1025 999 90 4   West Western Conference Final 328 437 0 0   0 1014 1024 2026-04-15T02:33:53.641181+00:00
1026 999 90 4   East Eastern Conference Final 373 309 0 0   0 1018 1010 2026-04-15T02:33:53.641167+00:00
1027 999 90 5     Calder Cup Final 437 309 0 0   0 1025 1026 2026-04-15T02:33:53.644146+00:00

Advanced export

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

CSV options: 

CREATE TABLE playoff_brackets (
            series_id             INTEGER PRIMARY KEY AUTOINCREMENT,
            playoff_season_id     INTEGER NOT NULL,
            reg_season_id         INTEGER NOT NULL,
            round_number          INTEGER NOT NULL,
            division_name         TEXT,
            conference_name       TEXT,
            series_label          TEXT NOT NULL,
            higher_seed_team_id   INTEGER,
            lower_seed_team_id    INTEGER,
            higher_seed_wins      INTEGER NOT NULL DEFAULT 0,
            lower_seed_wins       INTEGER NOT NULL DEFAULT 0,
            series_winner_team_id INTEGER,
            series_complete       INTEGER NOT NULL DEFAULT 0,
            source_series_a_id    INTEGER,
            source_series_b_id    INTEGER,
            updated_at            TEXT NOT NULL,
            UNIQUE(playoff_season_id, series_label)
        );