march-madness-predictions/bracket-07

16 rows where team_region = "East" sorted by team_region

View and edit SQL

team_region

  • East · 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 timestamp
18 258 Virginia 1 East 0 1 1 0.96389164071 0.707824942042 0.389376290563 0.232918784859 0.121536251432 0.059789937300000005 15.72522242 3/20/2014 3:33 PM
19 324 Coastal Carolina 16 East 0 1 1 0.03610835929 0.005669669617 0.000410315764 4.1302314e-05 3.1752820000000003e-06 2.47709e-07 4036993.577 3/20/2014 3:33 PM
20 235 Memphis 8 East 0 1 1 0.550041201202 0.166598236998 0.059218027263 0.024272860588000003 0.008421478331000001 0.002772746006 359.653301 3/20/2014 3:33 PM
21 45 George Washington 9 East 0 1 1 0.449958798798 0.11990715134299999 0.03597020788 0.012713812311 0.003348056428 0.00084208021 1186.53533 3/20/2014 3:33 PM
22 2132 Cincinnati 5 East 0 1 1 0.5801557954559999 0.19540511022399998 0.07880430883299999 0.034817028329 0.012487900678000001 0.004243315002 234.6648044 3/20/2014 3:33 PM
23 108 Harvard 12 East 0 1 1 0.419844204544 0.11647577913000001 0.042654481591 0.017296342611 0.004949836529 0.001349260759 740.1465824 3/20/2014 3:33 PM
24 127 Michigan State 4 East 0 1 1 0.911785444648 0.664471097064 0.38887784627599997 0.23983599596900002 0.122196372184 0.058670899666 16.04422475 3/20/2014 3:33 PM
25 48 Delaware 13 East 0 1 1 0.088214555352 0.023648013582000003 0.004688521829 0.001094169426 0.00018202577 2.9543164e-05 33847.77816 3/20/2014 3:33 PM
26 153 North Carolina 6 East 0 1 1 0.6796373677709999 0.36376216082199997 0.158570533817 0.063948749501 0.023702281714 0.008301616875 119.4584619 3/20/2014 3:33 PM
27 2507 Providence 11 East 0 1 1 0.320362632229 0.121140229004 0.038846850512 0.011582202483000001 0.002896405591 0.000692899532 1442.210673 3/20/2014 3:33 PM
28 66 Iowa State 3 East 0 1 1 0.8123594451170001 0.463801514016 0.203333849998 0.082385521083 0.032458237344999995 0.012066646185000002 81.87306885 3/20/2014 3:33 PM
29 2428 North Carolina Central 14 East 0 1 1 0.187640554883 0.051296096158 0.010147441687999999 0.001892327223 0.000334814121 5.7573262e-05 17368.17386 3/20/2014 3:33 PM
30 41 Connecticut 7 East 0 1 1 0.673010096346 0.263145195971 0.141404339929 0.057765749073 0.020063796166 0.006590441210000001 150.7349094 3/20/2014 3:33 PM
31 2603 Saint Joseph's 10 East 0 1 1 0.326989903654 0.083539258184 0.032306717406 0.009012539759 0.002150128689 0.000491647092 2032.979282 3/20/2014 3:33 PM
32 222 Villanova 2 East 0 1 1 0.947195368265 0.6445799376770001 0.413875184448 0.21024565459300001 0.094246628057 0.039740492806000005 24.16325112 3/20/2014 3:33 PM
33 270 Milwaukee 15 East 0 1 1 0.052804631734999996 0.008735608167 0.0015150822020000001 0.00017695988 2.0637095e-05 2.39166e-06 418118.6139 3/20/2014 3:33 PM

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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