march-madness-predictions/bracket-12

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

60 rows where playin_flag = 0 sorted by rd7_win

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: team_seed, team_region, team_alive

playin_flag ✖

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
4 4 38 Colorado 8 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 7:00 PM
10 10 194 Ohio State 6 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 7:00 PM
13 13 2711 Western Michigan 14 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 7:00 PM
22 22 2132 Cincinnati 5 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 7:00 PM
66 66 252 Brigham Young 10 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 7:00 PM
68 68 44 American University 15 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 7:00 PM
19 19 324 Coastal Carolina 16 East 0 1 1 0.03610835929 0.005669669617 0.000428540662 4.297152200000001e-05 3.454001e-06 2.6881e-07 3720095.946 3/20/2014 7:00 PM
52 52 2747 Wofford 15 Midwest 0 1 1 0.046052660728 0.010090996657000001 0.0008944891079999999 5.5943729000000004e-05 5.711262e-06 7.113800000000001e-07 1405717.182 3/20/2014 7:00 PM
54 54 2692 Weber State 16 West 0 1 1 0.022304760296999997 0.002656332371 0.000568048682 7.831172499999999e-05 7.042114e-06 9.08272e-07 1100990.276 3/20/2014 7:00 PM
33 33 270 Milwaukee 15 East 0 1 1 0.052804631734999996 0.008735608167 0.0015150822020000001 0.00017773032299999998 2.1747217e-05 2.521731e-06 396552.0364 3/20/2014 7:00 PM
64 64 309 Louisiana-Lafayette 14 West 0 1 1 0.116949438934 0.026411969021 0.002995612634 0.000335425896 5.1448269e-05 1.0467272e-05 95534.87819 3/20/2014 7:00 PM
17 17 2198 Eastern Kentucky 15 South 0 1 1 0.075971064449 0.018818220196 0.0036827719439999997 0.0005010655279999999 8.1600733e-05 1.0718536e-05 93295.32366 3/20/2014 7:00 PM
48 48 2382 Mercer 14 Midwest 0 1 1 0.070833949852 0.017871391429999998 0.0040786482520000005 0.0004977809820000001 9.5178303e-05 2.0811164e-05 48050.13164 3/20/2014 7:00 PM
25 25 48 Delaware 13 East 0 1 1 0.088214555352 0.027646368714999998 0.005436159288 0.001258555788 0.000217585275 3.500748e-05 28564.32354 3/20/2014 7:00 PM
43 43 2363 Manhattan 13 Midwest 0 1 1 0.069297008762 0.025674227612 0.004644332639000001 0.001050245642 0.000212539364 4.8843944e-05 20472.36698 3/20/2014 7:00 PM
29 29 2428 North Carolina Central 14 East 0 1 1 0.187640554883 0.051296096158 0.010147441687999999 0.001896667672 0.000351704622 6.0490359e-05 16530.56003 3/20/2014 7:00 PM
60 60 166 New Mexico State 13 West 0 1 1 0.254511190995 0.088841564707 0.011369866993 0.002697792751 0.000490247162 0.000114668412 8719.797521 3/20/2014 7:00 PM
7 7 2617 Stephen F. Austin 12 South 0 1 1 0.235867786593 0.041831022382000004 0.006659851151 0.001754848014 0.0005186746379999999 0.000125544992 7964.271911 3/20/2014 7:00 PM
9 9 202 Tulsa 13 South 0 1 1 0.129240592976 0.044584178278 0.007713857086999999 0.0021652101 0.0006571100229999999 0.00016345950300000002 6116.723244 3/20/2014 7:00 PM
58 58 2449 North Dakota State 12 West 0 1 1 0.36209107554799996 0.145878994274 0.019494647020000002 0.004773691637 0.0009470582090000001 0.000238319935 4195.040089 3/20/2014 7:00 PM
44 44 113 Massachusetts 6 Midwest 0 1 1 0.294573469275 0.056982985793000006 0.019293553806 0.003793495077 0.001005998457 0.000294216238 3397.860673 3/20/2014 7:00 PM
62 62 158 Nebraska 11 West 0 1 1 0.29676324344099997 0.091637776657 0.022963742045999998 0.005237890193 0.001353033559 0.00042720902399999997 2339.774524 3/20/2014 7:00 PM
31 31 2603 Saint Joseph's 10 East 0 1 1 0.326989903654 0.083539258184 0.032306717406 0.009020180692 0.002251036977 0.000514725973 1941.781309 3/20/2014 7:00 PM
38 38 2306 Kansas State 9 Midwest 0 1 1 0.260683700698 0.066558356626 0.013983112422 0.0044854668839999995 0.001498696402 0.000541067429 1847.198479 3/20/2014 7:00 PM
50 50 9 Arizona State 10 Midwest 0 1 1 0.498813388091 0.124986380124 0.031258370301 0.0056519579480000005 0.001760567205 0.000595587919 1678.013237 3/20/2014 7:00 PM
15 15 24 Stanford 10 South 0 1 1 0.36246216417300003 0.08918457713 0.03132900433 0.00801249425 0.002656565803 0.000721978375 1384.083036 3/20/2014 7:00 PM
27 27 2507 Providence 11 East 0 1 1 0.320362632229 0.121140229004 0.038846850512 0.011589652047999999 0.003030486899 0.000724964054 1378.378736 3/20/2014 7:00 PM
49 49 251 Texas 7 Midwest 0 1 1 0.5011866119089999 0.12598117968800002 0.032428092314 0.006045779364999999 0.002148760637 0.0008197858960000001 1218.830695 3/20/2014 7:00 PM
21 21 45 George Washington 9 East 0 1 1 0.449958798798 0.11990715134299999 0.036518391621 0.012892921529999999 0.0035435254590000004 0.0008899204610000001 1122.69593 3/20/2014 7:00 PM
11 11 2168 Dayton 11 South 0 1 1 1.0 0.22661213245200001 0.065837250065 0.017119891069000002 0.005022348239000001 0.001198612792 833.2977873 3/20/2014 7:00 PM
39 39 139 Saint Louis 5 Midwest 0 1 1 0.5804650593540001 0.120455730503 0.041538407325 0.016290497164 0.005785260499 0.002198570646 453.8409676 3/20/2014 7:00 PM
23 23 108 Harvard 12 East 0 1 1 1.0 0.268198919318 0.095317821149 0.037557219408 0.010838410078 0.0028474803539999998 350.1876732 3/20/2014 7:00 PM
20 20 235 Memphis 8 East 0 1 1 0.550041201202 0.166598236998 0.059943419934 0.024549631377 0.008862398713 0.002914017087 342.1688869 3/20/2014 7:00 PM
57 57 201 Oklahoma 5 West 0 1 1 0.6379089244520001 0.334150742066 0.076682364608 0.028281765898 0.01021449605 0.004276340415 232.8448072 3/20/2014 7:00 PM
55 55 2250 Gonzaga 8 West 0 1 1 0.47987006853200004 0.126191039747 0.07716192817800001 0.037001852886000004 0.012991858592000001 0.00530685917 187.4353754 3/20/2014 7:00 PM
14 14 167 New Mexico 7 South 0 1 1 0.637537835827 0.221612021956 0.10307220074100001 0.036167934175 0.015871917455 0.005796354449 171.5222308 3/20/2014 7:00 PM
65 65 2483 Oregon 7 West 0 1 1 1.0 0.228002589012 0.124164077818 0.048135196634999995 0.016122513119999998 0.006348353785 156.5211518 3/20/2014 7:00 PM
59 59 21 San Diego State 4 West 0 1 1 0.745488809005 0.431128698952 0.142917343287 0.069172499546 0.019507247609 0.006578573242000001 151.0086443 3/20/2014 7:00 PM
61 61 239 Baylor 6 West 0 1 1 0.703236756559 0.338102692122 0.118113693891 0.036622601335 0.014850721277999999 0.006861390228 144.7430589 3/20/2014 7:00 PM
30 30 41 Connecticut 7 East 0 1 1 0.673010096346 0.263145195971 0.141404339929 0.057755863090000005 0.020894390673 0.006861847852000001 144.7333391 3/20/2014 7:00 PM
6 6 2670 Virginia Commonwealth 5 South 0 1 1 0.764132213407 0.28666324896699996 0.101845195748 0.048791133944 0.022177076375 0.008405849277 117.9647788 3/20/2014 7:00 PM
26 26 153 North Carolina 6 East 0 1 1 0.6796373677709999 0.36376216082199997 0.158570533817 0.063939586008 0.024658911851 0.008634448993000001 114.8151494 3/20/2014 7:00 PM
56 56 197 Oklahoma State 9 West 0 1 1 0.520129931468 0.144276088395 0.08969566114399999 0.043936023543 0.020386654325 0.010576173023 93.55215964 3/20/2014 7:00 PM
5 5 221 Pittsburgh 9 South 0 1 1 1.0 0.237970197346 0.135384785788 0.066973343895 0.031390345085 0.012404632885000001 79.61504192 3/20/2014 7:00 PM
28 28 66 Iowa State 3 East 0 1 1 0.8123594451170001 0.463801514016 0.203333849998 0.08237287833700001 0.033732887509 0.012536887011 78.76461774 3/20/2014 7:00 PM
8 8 26 UCLA 4 South 0 1 1 0.870759407024 0.6269215503719999 0.20024830227899998 0.088378236672 0.040617122386 0.01554058219 63.34765363 3/20/2014 7:00 PM
37 37 96 Kentucky 8 Midwest 0 1 1 0.7393162993019999 0.340260219827 0.142251946886 0.080003446948 0.038323647347 0.019095129326 51.36937561 3/20/2014 7:00 PM
63 63 156 Creighton 3 West 0 1 1 0.883050561066 0.5438475622 0.255248600208 0.10535505823100001 0.04677474491999999 0.023285239264 41.94566136 3/20/2014 7:00 PM
12 12 183 Syracuse 3 South 0 1 1 1.0 0.773387867548 0.36180411936800005 0.153657734938 0.071326777595 0.027661158409000002 35.1517759 3/20/2014 7:00 PM
51 51 130 Michigan 2 Midwest 0 1 1 0.953947339272 0.7389414435320001 0.36911610144699997 0.141961792951 0.061650745494 0.027976995167 34.74365274 3/20/2014 7:00 PM
32 32 222 Villanova 2 East 0 1 1 0.947195368265 0.6445799376770001 0.413875184448 0.21012805417199998 0.097670158457 0.041173087147 23.28770999 3/20/2014 7:00 PM
47 47 150 Duke 3 Midwest 0 1 1 0.929166050148 0.683485418794 0.41546659370399996 0.174612580298 0.086806067293 0.044631080132999996 21.40591079 3/20/2014 7:00 PM
34 34 2724 Wichita State 1 Midwest 0 1 1 0.9754539205689999 0.591415204901 0.24399510350900003 0.135567504661 0.077110388618 0.044973755956 21.23518981 3/20/2014 7:00 PM
67 67 275 Wisconsin 2 West 0 1 1 1.0 0.771997410988 0.476514273403 0.216724024945 0.105609320263 0.057272303568000005 16.46044663 3/20/2014 7:00 PM
18 18 258 Virginia 1 East 0 1 1 0.96389164071 0.707824942042 0.39147526623 0.234126633858 0.126181077461 0.062030605028 15.12107442 3/20/2014 7:00 PM
24 24 127 Michigan State 4 East 0 1 1 0.911785444648 0.7041547119670001 0.410880401116 0.252691454175 0.132630605546 0.06341049801 14.77025936 3/20/2014 7:00 PM
16 16 2305 Kansas 2 South 0 1 1 0.924028935551 0.670385180717 0.434274653551 0.226445849974 0.132531237258 0.066298284635 14.08334651 3/20/2014 7:00 PM
1 1 57 Florida 1 South 0 1 1 1.0 0.7620298026540001 0.5481480079469999 0.35003225744099997 0.212260843673 0.110125981778 8.080509284 3/20/2014 7:00 PM
53 53 12 Arizona 1 West 0 1 1 0.977695239703 0.7268765394869999 0.582110140089 0.40164786478 0.218771062447 0.129477700899 6.723337633 3/20/2014 7:00 PM
42 42 97 Louisville 4 Midwest 0 1 1 0.9307029912379999 0.7842369919159999 0.5365325087039999 0.380555562235 0.235263899223 0.148029129163 5.755427163 3/20/2014 7:00 PM

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "march-madness-predictions/bracket-12" (
"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 33.972ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub