march-madness-predictions/bracket-39

25 rows where team_alive = 1

View and edit SQL

Suggested facets: team_seed, team_region, playin_flag, rd3_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.0 0.741884420261 0.502234429266 0.30289286352899997 0.162660051202 5.147791007
7 2617 Stephen F. Austin 12 South 0 1 1 1 0.121750636067 0.015209480896 0.0045983310440000005 0.001285738849 0.000319310556 3130.747387
8 26 UCLA 4 South 0 1 1 1 0.878249363933 0.242906098844 0.118404233681 0.053458295710000006 0.021263654062999997 46.02860558
11 2168 Dayton 11 South 0 1 1 1 1.0 0.274438376314 0.060921819737 0.016536100813 0.003957335913 251.695253
15 24 Stanford 10 South 0 1 1 1 0.21272335903499998 0.10853982953500001 0.023955035989999998 0.007475847689 0.002058957796 484.6826119
16 2305 Kansas 2 South 0 1 1 1 0.7872766409649999 0.61702179415 0.289886150281 0.163522722743 0.081825145392 11.22118207
18 258 Virginia 1 East 0 1 1 1 0.7099496068950001 0.33634447569 0.190784147703 0.096018802256 0.047052749216 20.25274329
20 235 Memphis 8 East 0 1 1 1 0.29005039310499997 0.08421791641000001 0.032910470404 0.011259390415 0.003827209559 260.2869728
24 127 Michigan State 4 East 0 1 1 1 1.0 0.579437607901 0.340033706121 0.167132368884 0.080021894855 11.49657986
26 153 North Carolina 6 East 0 1 1 1 0.44276071517 0.17577909299699998 0.065001880706 0.022974961012 0.008013017808 123.7969272
28 66 Iowa State 3 East 0 1 1 1 0.5572392848300001 0.24244281992400002 0.09860114377399999 0.040509290764 0.01640951839 59.94024067
30 41 Connecticut 7 East 0 1 1 1 0.35102758297799996 0.17669446005699999 0.06884497191599999 0.023701110447 0.008080275396 122.7581581
32 222 Villanova 2 East 0 1 1 1 0.648972417022 0.405083627022 0.20382367937600002 0.09323250689 0.041734959182 22.96072788
34 2724 Wichita State 1 Midwest 0 1 1 1 0.578640202491 0.208491164886 0.12471876894600001 0.077192002641 0.0457435692 20.86099636
37 96 Kentucky 8 Midwest 0 1 1 1 0.421359797509 0.142820309728 0.082372375562 0.041349894761000004 0.019798749347000003 49.50824082
42 97 Louisville 4 Midwest 0 1 1 1 1.0 0.648688525386 0.46065003544600003 0.288525268986 0.17214664518599998 4.809000802
46 2633 Tennessee 11b Midwest 1 1 1 1 0.810641139226 0.367189135106 0.118260948167 0.054258349535 0.023926878002999998 40.79400254
48 2382 Mercer 14 Midwest 0 1 1 1 0.189358860774 0.032158381128 0.0034749529930000003 0.000776868928 0.00017178133300000003 5820.354283
51 130 Michigan 2 Midwest 0 1 1 1 1.0 0.600652483766 0.210522918886 0.096584399254 0.042138885267 22.73105016
53 12 Arizona 1 West 0 1 1 1 0.7265928707170001 0.508313441414 0.335611112646 0.17281085741799998 0.094783873034 9.550317981
55 2250 Gonzaga 8 West 0 1 1 1 0.273407129283 0.139360898643 0.06701249326 0.023825254982 0.009527813518 103.9558745
59 21 San Diego State 4 West 0 1 1 1 1.0 0.352325659942 0.16859488516100002 0.047227370349 0.015252143365 64.56455549
61 239 Baylor 6 West 0 1 1 1 0.45595090335 0.161103668662 0.053110094666 0.02219656224 0.010236810498 96.68667694
63 156 Creighton 3 West 0 1 1 1 0.54404909665 0.24652563260899998 0.102969743689 0.044865808095 0.021340049023 45.86024849
67 275 Wisconsin 2 West 0 1 1 1 1.0 0.592370698728 0.272701670578 0.130387362811 0.067708722899 13.76914579

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "march-madness-predictions/bracket-39" (
"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" REAL,
  "rd4_win" REAL,
  "rd5_win" REAL,
  "rd6_win" REAL,
  "rd7_win" REAL,
  "win_odds" TEXT
);
Powered by Datasette · Query took 29.899ms