march-madness-predictions/bracket-23

17 rows where team_region = "South" sorted by team_alive

View and edit SQL

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

playin_flag

  • 0 15
  • 1 2

team_region

  • South · 17
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
2 399 Albany 16a South 1 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
3 116 Mount St. Mary's 16b South 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 --
4 38 Colorado 8 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
10 194 Ohio State 6 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
13 2711 Western Michigan 14 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
1 57 Florida 1 South 0 1 1 1.0 0.7620298026540001 0.549531138344 0.349041039339 0.209463647801 0.11094875349099999 8.013170212
5 221 Pittsburgh 9 South 0 1 1 1.0 0.237970197346 0.135883297969 0.066753108644 0.030828010256 0.012517885804999998 78.88569441
6 2670 Virginia Commonwealth 5 South 0 1 1 0.7576910688099999 0.279566709382 0.098169078738 0.04630268906499999 0.020646113266 0.008016552608 123.7418995
7 2617 Stephen F. Austin 12 South 0 1 1 0.24230893119 0.04290331303 0.0068181205649999995 0.001777431679 0.000513327335 0.000128858446 7759.453655
8 26 UCLA 4 South 0 1 1 0.870759407024 0.63214366119 0.20175497554900002 0.08833779284 0.039973366017 0.015718583629999998 62.61896361
9 202 Tulsa 13 South 0 1 1 0.129240592976 0.045386316398 0.007843388836 0.002179700279 0.0006469463990000001 0.000166893304 5990.852146
11 2168 Dayton 11 South 0 1 1 1.0 0.22661213245200001 0.06508665409 0.016956190955000002 0.004866246165 0.0012064305370000001 827.8914854
12 183 Syracuse 3 South 0 1 1 1.0 0.773387867548 0.358470884505 0.152443356089 0.069726506392 0.027801407832 34.96940148
14 167 New Mexico 7 South 0 1 1 0.637537835827 0.221612021956 0.10307220074100001 0.036211756144 0.01563904931 0.005877760076999999 169.1328375
15 24 Stanford 10 South 0 1 1 0.36246216417300003 0.08918457713 0.03132900433 0.008025125326 0.002607021415 0.00073380338 1361.76287
16 2305 Kansas 2 South 0 1 1 0.924028935551 0.670385180717 0.43835848439 0.23146959343100001 0.136063433044 0.070739200822 13.13643338
17 2198 Eastern Kentucky 15 South 0 1 1 0.075971064449 0.018818220196 0.0036827719439999997 0.000502216209 7.9299443e-05 1.0946004000000001e-05 91356.54429

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "march-madness-predictions/bracket-23" (
"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
);
Powered by Datasette · Query took 29.144ms