march-madness-predictions/bracket-51

12 rows where team_alive = 1

View and edit SQL

Suggested facets: team_seed, team_region, playin_flag, rd4_win

team_alive

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
1 57 Florida 1 South 0 1 1 1 1 1.0 0.830611413137 0.493563163721 0.24904648302299998 3.015314683
11 2168 Dayton 11 South 0 1 1 1 1 1.0 0.16938858686299998 0.045440604498 0.009755546644 101.5057884
18 258 Virginia 1 East 0 1 1 1 1 0.492752765159 0.31019475478999997 0.162066379903 0.07790860709400001 11.83555229
24 127 Michigan State 4 East 0 1 1 1 1 0.507247234841 0.321887006348 0.15992059423399999 0.072704878451 12.75423522
28 66 Iowa State 3 East 0 1 1 1 1 0.48405153122199995 0.17410558672899998 0.068885667504 0.024661547680000003 39.54895552
30 41 Connecticut 7 East 0 1 1 1 1 0.515948468778 0.193812652133 0.07012359014000001 0.022906794967999997 42.65516876
37 96 Kentucky 8 Midwest 0 1 1 1 1 0.322972445958 0.17486151419799997 0.070325422508 0.032510284523 29.75949702
42 97 Louisville 4 Midwest 0 1 1 1 1 0.677027554042 0.470580707961 0.25769662157900003 0.15334658001499998 5.521175757
46 2633 Tennessee 11b Midwest 1 1 1 1 1 0.474597663977 0.165214547829 0.06558939816499999 0.030375332603000002 31.92145021
51 130 Michigan 2 Midwest 0 1 1 1 1 0.525402336023 0.189343230012 0.071873981814 0.03166580314 30.57980853
53 12 Arizona 1 West 0 1 1 1 1 1.0 0.631873514707 0.344870050039 0.19320758179699998 4.175780322
67 275 Wisconsin 2 West 0 1 1 1 1 1.0 0.36812648529299996 0.189644525896 0.101910560063 8.812525801

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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