march-madness-predictions/bracket-50

13 rows where team_alive = 1

View and edit SQL

Suggested facets: team_seed, team_region, rd4_win

playin_flag

  • 0 12
  • 1 1

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.253427661914 2.945899167
11 2168 Dayton 11 South 0 1 1 1 1 1.0 0.16938858686299998 0.045440604498 0.010129931949 97.71734628
18 258 Virginia 1 East 0 1 1 1 1 0.492752765159 0.31019475478999997 0.162066379903 0.079371512889 11.5989787
24 127 Michigan State 4 East 0 1 1 1 1 0.507247234841 0.321887006348 0.15992059423399999 0.07416909864900001 12.48270396
28 66 Iowa State 3 East 0 1 1 1 1 0.48405153122199995 0.17410558672899998 0.068885667504 0.025301497193 38.5233528
30 41 Connecticut 7 East 0 1 1 1 1 0.515948468778 0.193812652133 0.07012359014000001 0.02355214432 41.45897895
37 96 Kentucky 8 Midwest 0 1 1 1 1 0.322972445958 0.17486151419799997 0.075255189025 0.034542991832 27.9494322
42 97 Louisville 4 Midwest 0 1 1 1 1 0.677027554042 0.470580707961 0.269684339648 0.1598089351 5.257472396
46 2633 Tennessee 11b Midwest 1 1 1 1 1 0.474597663977 0.165214547829 0.070252758177 0.032290813422 29.96856022
51 130 Michigan 2 Midwest 0 1 1 1 1 0.525402336023 0.189343230012 0.077233008137 0.033769067719 28.61289925
53 12 Arizona 1 West 0 1 1 1 1 0.726268899569 0.46834445792499996 0.261915503953 0.150243725364 5.655852
59 21 San Diego State 4 West 0 1 1 1 1 0.273731100431 0.11920606058800001 0.035366110213 0.011498411998999999 85.96853097
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 30.73ms