march-madness-predictions/bracket-53

16 rows where team_region = "West"

View and edit SQL

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

rd4_win

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
53 12 Arizona 1 West 0 1 1 1 1 1.0 0.631873514707 0.348968626623 0.19659236111 4.086667632
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 --
59 21 San Diego State 4 West 0 0 1 1 1 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 --
67 275 Wisconsin 2 West 0 1 1 1 1 1.0 0.36812648529299996 0.19211502040800002 0.10387449847100001 8.627001956
68 44 American University 15 West 0 0 1 0 0 0.0 0.0 0.0 0.0 --

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "march-madness-predictions/bracket-53" (
"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 33.132ms