march-madness-predictions/bracket-50

16 rows where team_region = "West" sorted by rd4_win

View and edit SQL

Suggested facets: team_alive, rd2_win, rd3_win, rd4_win, rd5_win, rd6_win, rd7_win

win_odds

team_region

  • West · 16
Link rowid team_id team_name team_seed team_region playin_flag team_alive rd1_win rd2_win rd3_win rd4_win ▼ rd5_win rd6_win rd7_win win_odds
54 2692 Weber State 16 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
55 2250 Gonzaga 8 West 0 0 1 1 0 0.0 0.0 0.0 0.0 --
56 197 Oklahoma State 9 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
57 201 Oklahoma 5 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
58 2449 North Dakota State 12 West 0 0 1 1 0 0.0 0.0 0.0 0.0 --
60 166 New Mexico State 13 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
61 239 Baylor 6 West 0 0 1 1 1 0.0 0.0 0.0 0.0 --
62 158 Nebraska 11 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
63 156 Creighton 3 West 0 0 1 1 0 0.0 0.0 0.0 0.0 --
64 309 Louisiana-Lafayette 14 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
65 2483 Oregon 7 West 0 0 1 1 0 0.0 0.0 0.0 0.0 --
66 252 Brigham Young 10 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
68 44 American University 15 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --
59 21 San Diego State 4 West 0 1 1 1 1 0.273731100431 0.11920606058800001 0.035366110213 0.011498411998999999 85.96853097
53 12 Arizona 1 West 0 1 1 1 1 0.726268899569 0.46834445792499996 0.261915503953 0.150243725364 5.655852
67 275 Wisconsin 2 West 0 1 1 1 1 1.0 0.412449481487 0.21029309084699999 0.11189420765000001 7.937013104

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "march-madness-predictions/bracket-50" (
"team_id" INTEGER,
  "team_name" TEXT,
  "team_seed" TEXT,
  "team_region" TEXT,
  "playin_flag" INTEGER,
  "team_alive" INTEGER,
  "rd1_win" INTEGER,
  "rd2_win" INTEGER,
  "rd3_win" INTEGER,
  "rd4_win" REAL,
  "rd5_win" REAL,
  "rd6_win" REAL,
  "rd7_win" REAL,
  "win_odds" TEXT
);
Powered by Datasette · Query took 24.64ms