march-madness-predictions/bracket-06

16 rows where team_region = "West" sorted by rd4_win

View and edit SQL

team_region

  • West · 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
54 2692 Weber State 16 West 0 1 1 0.022304760296999997 0.002656332371 0.000568048682 9.2944959e-05 8.324014e-06 1.0266859999999999e-06 974006.3867 3/20/2014 2:27 PM
68 44 American University 15 West 0 1 1 0.07159477847 0.020688666479 0.003559571688 0.000372634721 4.664791e-05 7.66077e-06 130534.1818 3/20/2014 2:27 PM
64 309 Louisiana-Lafayette 14 West 0 1 1 0.116949438934 0.026411969021 0.00420182853 0.000464628888 7.0418752e-05 1.3653765e-05 73238.86951 3/20/2014 2:27 PM
60 166 New Mexico State 13 West 0 1 1 0.254511190995 0.088841564707 0.011369866993 0.003100964257 0.000561858014 0.000126467282 7906.183443 3/20/2014 2:27 PM
58 2449 North Dakota State 12 West 0 1 1 0.36209107554799996 0.145878994274 0.019494647020000002 0.005476073203 0.001083356545 0.000262588529 3807.239462 3/20/2014 2:27 PM
66 252 Brigham Young 10 West 0 1 1 0.352683486524 0.069537751924 0.026665244552000002 0.00677265337 0.001526736612 0.000414237838 2413.072083 3/20/2014 2:27 PM
62 158 Nebraska 11 West 0 1 1 0.29676324344099997 0.091637776657 0.029179592248 0.0066086058849999995 0.001695170018 0.000514962434 1940.889221 3/20/2014 2:27 PM
57 201 Oklahoma 5 West 0 1 1 0.6379089244520001 0.334150742066 0.076682364608 0.031541288005 0.011371314913 0.004621682183 215.3714337 3/20/2014 2:27 PM
55 2250 Gonzaga 8 West 0 1 1 0.47987006853200004 0.126191039747 0.07716192817800001 0.040420617898 0.014169382796 0.005617579514 177.0126116 3/20/2014 2:27 PM
56 197 Oklahoma State 9 West 0 1 1 0.520129931468 0.144276088395 0.08969566114399999 0.047909273025000004 0.022201693349 0.011230859574 88.04037963 3/20/2014 2:27 PM
65 2483 Oregon 7 West 0 1 1 0.6473165134759999 0.191415757568 0.0987269227 0.035641679235 0.011002050675 0.0039024496970000004 255.2492992 3/20/2014 2:27 PM
59 21 San Diego State 4 West 0 1 1 0.745488809005 0.431128698952 0.142917343287 0.075504585611 0.021254957673 0.006935982879 143.1756731 3/20/2014 2:27 PM
61 239 Baylor 6 West 0 1 1 0.703236756559 0.338102692122 0.143482608394 0.044268181398 0.017872989089 0.008011351273000001 123.8228877 3/20/2014 2:27 PM
63 156 Creighton 3 West 0 1 1 0.883050561066 0.5438475622 0.296961249282 0.12217619800599999 0.054070888367999996 0.02617925468 37.19818449 3/20/2014 2:27 PM
67 275 Wisconsin 2 West 0 1 1 0.9284052215299999 0.718357824028 0.397222982607 0.15573283192 0.065599104093 0.030371132517 31.92600299 3/20/2014 2:27 PM
53 12 Arizona 1 West 0 1 1 0.977695239703 0.7268765394869999 0.582110140089 0.42391683962 0.230737199433 0.13361192499299998 6.484361894 3/20/2014 2:27 PM

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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