march-madness-predictions/bracket-07

19 rows where team_region = "Midwest" sorted by team_region

View and edit SQL

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

team_region

  • Midwest · 19
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
34 2724 Wichita State 1 Midwest 0 1 1 0.9754539205689999 0.591415204901 0.24399510350900003 0.135567504661 0.076996573574 0.043960697391999995 21.74759181 3/20/2014 3:33 PM
35 13 Cal Poly 16a Midwest 1 1 1 0.024546079430999998 0.001766218646 8.2320812e-05 6.7722329999999996e-06 7.094370000000001e-07 8.816300000000001e-08 11342576.87 3/20/2014 3:33 PM
36 2640 Texas Southern 16b Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 3:33 PM
37 96 Kentucky 8 Midwest 0 1 1 0.7393162993019999 0.340260219827 0.142251946886 0.080003446948 0.038257663284 0.01859929282 52.76548505 3/20/2014 3:33 PM
38 2306 Kansas State 9 Midwest 0 1 1 0.260683700698 0.066558356626 0.013983112422 0.0044854668839999995 0.001495593305 0.000524022348 1907.31556 3/20/2014 3:33 PM
39 139 Saint Louis 5 Midwest 0 1 1 0.5804650593540001 0.120455730503 0.041538407325 0.016290497164 0.005773543199999999 0.002131015466 468.2598511 3/20/2014 3:33 PM
40 152 North Carolina State 12a Midwest 1 1 1 0.419534940646 0.069633049968 0.016972267703 0.004991897941 0.001328955804 0.00038210423499999995 2616.086935 3/20/2014 3:33 PM
41 2752 Xavier 12b Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 3:33 PM
42 97 Louisville 4 Midwest 0 1 1 0.9307029912379999 0.7842369919159999 0.5365325087039999 0.380555562235 0.234950042298 0.144975764532 5.897704614 3/20/2014 3:33 PM
43 2363 Manhattan 13 Midwest 0 1 1 0.069297008762 0.025674227612 0.004644332639000001 0.001050245642 0.000212058544 4.7033855e-05 21260.28067 3/20/2014 3:33 PM
44 113 Massachusetts 6 Midwest 0 1 1 0.294573469275 0.056982985793000006 0.019293553806 0.003793495077 0.001003788646 0.000284110671 3518.755156 3/20/2014 3:33 PM
45 2294 Iowa 11a Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 3:33 PM
46 2633 Tennessee 11b Midwest 1 1 1 0.7054265307250001 0.241660203984 0.127464151068 0.04442927594 0.018887339872 0.008276564598 119.8230768 3/20/2014 3:33 PM
47 150 Duke 3 Midwest 0 1 1 0.929166050148 0.683485418794 0.41546659370399996 0.174612580298 0.086660791752 0.043500656624999995 21.98815875 3/20/2014 3:33 PM
48 2382 Mercer 14 Midwest 0 1 1 0.070833949852 0.017871391429999998 0.0040786482520000005 0.0004977809820000001 9.4962651e-05 2.0029548e-05 49925.23913 3/20/2014 3:33 PM
49 251 Texas 7 Midwest 0 1 1 0.5011866119089999 0.12598117968800002 0.032428092314 0.006045779364999999 0.002144409947 0.0007946450879999999 1257.423433 3/20/2014 3:33 PM
50 9 Arizona State 10 Midwest 0 1 1 0.498813388091 0.124986380124 0.031258370301 0.0056519579480000005 0.001756841606 0.000576269825 1734.298216 3/20/2014 3:33 PM
51 130 Michigan 2 Midwest 0 1 1 0.953947339272 0.7389414435320001 0.36911610144699997 0.141961792951 0.061537476098999996 0.027200582209000002 35.76391896 3/20/2014 3:33 PM
52 2747 Wofford 15 Midwest 0 1 1 0.046052660728 0.010090996657000001 0.0008944891079999999 5.5943729000000004e-05 5.699304e-06 6.81477e-07 1467400.743 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.638ms