fivethirtyeight

Custom SQL query returning 68 rows (hide)

This data as json, CSV

rowidteam_idteam_nameteam_seedteam_regionplayin_flagteam_aliverd1_winrd2_winrd3_winrd4_winrd5_winrd6_winrd7_winwin_odds
1 57 Florida 1 South 0 1 1.0 0.988190851712 0.839462623313 0.62444073374 0.410978179192 0.26092852205 0.144572206116 5.916958846
2 399 Albany 16a South 1 1 0.523123750696 0.006667110139 0.0011345594229999999 0.000159823308 1.8409608e-05 2.2825020000000002e-06 2.39125e-07 4181911.466
3 116 Mount St. Mary's 16b South 1 1 0.47687624930399997 0.005142038149 0.000801382175 0.000103198835 1.0888019e-05 1.224242e-06 1.1664400000000001e-07 8573095.723
4 38 Colorado 8 South 0 1 1.0 0.275715272033 0.022416391403000002 0.007759465004 0.002202951214 0.000698753811 0.000185843753 5379.864219
5 221 Pittsburgh 9 South 0 1 1.0 0.724284727967 0.136185043685 0.070576973526 0.03073065988 0.012877665119 0.004548961741 218.83038259999998
6 2670 Virginia Commonwealth 5 South 0 1 1.0 0.764132213407 0.28666324896699996 0.095683188813 0.044995878712 0.020483954735 0.007898738436 125.60249579999999
7 2617 Stephen F. Austin 12 South 0 1 1.0 0.235867786593 0.041831022382000004 0.006237463449 0.0015887111910000001 0.000469211128 0.000116038196 8616.851988
8 26 UCLA 4 South 0 1 1.0 0.870759407024 0.6269215503719999 0.187818722511 0.081204410382 0.037373099152 0.014542836154 67.76237822
9 202 Tulsa 13 South 0 1 1.0 0.129240592976 0.044584178278 0.007220430814 0.001962353389 0.000595274875 0.000151280416 6609.240941
10 194 Ohio State 6 South 0 1 1.0 0.753055786951 0.40077493166 0.199897912862 0.08581507868899999 0.041491999892 0.017045129439999997 57.66778563
11 2168 Dayton 11 South 0 1 1.0 0.24694421304900002 0.076264790353 0.022848595022999997 0.005736489237 0.0017353493169999998 0.00043811449800000004 2281.508352
12 183 Syracuse 3 South 0 1 1.0 0.886092464154 0.501449763387 0.225549382025 0.086459002941 0.038538705988 0.014486038054 68.03198765
13 2711 Western Michigan 14 South 0 1 1.0 0.113907535846 0.0215105146 0.0036629987420000003 0.000515751757 9.6160658e-05 1.4929994999999999e-05 66978.25854
14 167 New Mexico 7 South 0 1 1.0 0.637537835827 0.221612021956 0.097308000294 0.032255299524 0.014227577533 0.005310375617 187.3105965
15 24 Stanford 10 South 0 1 1.0 0.36246216417300003 0.08918457713 0.029151457762000003 0.007007829532 0.002336488767 0.000652180907 1532.316891
16 2305 Kansas 2 South 0 1 1.0 0.924028935551 0.670385180717 0.418241229491 0.20809321810400003 0.12225487691199999 0.062121880281 15.09738784
17 2198 Eastern Kentucky 15 South 0 1 1.0 0.075971064449 0.018818220196 0.003340423802 0.00042488863 6.9522438e-05 9.473384e-06 105557.8966
18 258 Virginia 1 East 0 1 1.0 0.96389164071 0.707824942042 0.38903700643100003 0.23272831499000002 0.12074784713600001 0.060120333651 15.63330756
19 324 Coastal Carolina 16 East 0 1 1.0 0.03610835929 0.005669669617 0.000409048003 4.1185075e-05 3.0667809999999997e-06 2.48445e-07 4025032.865
20 235 Memphis 8 East 0 1 1.0 0.550041201202 0.166598236998 0.059135920332000005 0.02424165927 0.008323000988 0.002790259585 357.3895941
21 45 George Washington 9 East 0 1 1.0 0.449958798798 0.11990715134299999 0.035913469027999995 0.012695265109 0.003296652472 0.000847544577 1178.878944
22 2132 Cincinnati 5 East 0 1 1.0 0.5801557954559999 0.194839106492 0.078596406322 0.034733779641 0.01233548422 0.004266692214 233.37359669999998
23 108 Harvard 12 East 0 1 1.0 0.419844204544 0.11606958434499999 0.042519017342 0.017246572845999997 0.004873386216 0.0013566575299999999 736.1057015
24 127 Michigan State 4 East 0 1 1.0 0.9136820566159999 0.665932496917 0.389793425352 0.24043238009399998 0.121783085526 0.059205244082 15.8903957
25 48 Delaware 13 East 0 1 1.0 0.086317943384 0.023158812247 0.00459570719 0.001073451977 0.000175129233 2.9256988999999998e-05 34178.86725
26 153 North Carolina 6 East 0 1 1.0 0.6796373677709999 0.36376216082199997 0.158570533817 0.063916335579 0.023460936804 0.008358534639 118.63819540000001
27 2507 Providence 11 East 0 1 1.0 0.320362632229 0.121140229004 0.038846850512 0.011574816958 0.002852073325 0.00069786364 1431.944694
28 66 Iowa State 3 East 0 1 1.0 0.8123594451170001 0.463801514016 0.203333849998 0.08234393428299999 0.032151734587 0.012147762824 81.31968425
29 2428 North Carolina Central 14 East 0 1 1.0 0.187640554883 0.051296096158 0.010147441687999999 0.0018907587309999999 0.000328056096 5.7964655e-05 17250.89246
30 41 Connecticut 7 East 0 1 1.0 0.673010096346 0.263145195971 0.141404339929 0.057736802224 0.019843621793 0.006636521546999999 149.68134609999998
31 2603 Saint Joseph's 10 East 0 1 1.0 0.326989903654 0.083539258184 0.032306717406 0.009006541758 0.002115820244 0.000495158323 2018.556076
32 222 Villanova 2 East 0 1 1.0 0.947195368265 0.6445799376770001 0.413875184448 0.21016142034899998 0.093509341577 0.039997493237 24.00156682
33 270 Milwaukee 15 East 0 1 1.0 0.052804631734999996 0.008735608167 0.0015150822020000001 0.000176781117 2.009388e-05 2.405526e-06 415708.4549
34 2724 Wichita State 1 Midwest 0 1 1.0 0.978998826242 0.593564472099 0.24297345335499998 0.135356515847 0.079054415882 0.045123904745 21.16120271
35 13 Cal Poly 16a Midwest 1 1 0.556026277314 0.013065156743999998 0.0009085286980000001 3.8934418999999996e-05 3.1405669999999998e-06 3.4634599999999997e-07 4.1694e-08 23984320.92
36 2640 Texas Southern 16b Midwest 1 1 0.443973722686 0.007936017015 0.00045151296900000003 1.5695114e-05 1.04493e-06 1.14885e-07 1.3845000000000001e-08 72229245.3
37 96 Kentucky 8 Midwest 0 1 1.0 0.7393162993019999 0.33902398697999997 0.14071306803300002 0.079370373228 0.039298843476999995 0.019100746533 51.35397466
38 2306 Kansas State 9 Midwest 0 1 1.0 0.260683700698 0.066051499254 0.013637933661 0.004405502162999999 0.0015424214300000002 0.000540769508 1848.2166899999997
39 139 Saint Louis 5 Midwest 0 1 1.0 0.576932201751 0.120300922669 0.041602009109 0.016422235057000002 0.006102291001000001 0.002255247354 442.4103418
40 152 North Carolina State 12a Midwest 1 1 0.363083282455 0.145666494439 0.022644239490999998 0.005182101168 0.001447051279 0.000383475156 0.00010376165 9636.472025
41 2752 Xavier 12b Midwest 1 1 0.636916717545 0.27740130381 0.048221060702 0.015320460501000001 0.005647173884000001 0.001729591562 0.0005340937279999999 1871.3305440000001
42 97 Louisville 4 Midwest 0 1 1.0 0.9307029912379999 0.78326545461 0.535887829637 0.38067708292499997 0.24083452263 0.14856633704299999 5.730999901000001
43 2363 Manhattan 13 Midwest 0 1 1.0 0.069297008762 0.025568322529 0.004628515003 0.001054064705 0.00022657299200000002 5.0154309999999996e-05 19937.46595
44 113 Massachusetts 6 Midwest 0 1 1.0 0.323742006064 0.062344817951 0.021060004974000002 0.004107938534 0.001140965097 0.000320494379 3119.179525
45 2294 Iowa 11a Midwest 1 1 0.48278065333 0.316287499496 0.093957567939 0.049025218662 0.016781280385 0.007467456452999999 0.003289774255 302.972225
46 2633 Tennessee 11b Midwest 1 1 0.51721934667 0.35997049443999996 0.119936818979 0.062067205914 0.020994236891999998 0.009044499598 0.0038586089880000003 258.1607502
47 150 Duke 3 Midwest 0 1 1.0 0.929166050148 0.7044148837019999 0.428036238078 0.179358346449 0.09178919437899999 0.045936222462 20.7693129
48 2382 Mercer 14 Midwest 0 1 1.0 0.070833949852 0.019345911428 0.00440974565 0.000533754592 0.00010801295000000001 2.26164e-05 44214.7017
49 251 Texas 7 Midwest 0 1 1.0 0.5011866119089999 0.126193997951 0.032760844302 0.006085899782 0.002254733001 0.000833414207 1198.883554
50 9 Arizona State 10 Midwest 0 1 1.0 0.498813388091 0.125197836448 0.03158517476 0.005689933461 0.001854972952 0.000606640743 1647.422087
51 130 Michigan 2 Midwest 0 1 1.0 0.9538258826450001 0.738491521328 0.37014459796800003 0.142007923028 0.06381637739 0.028130649257999997 34.54841521
52 2747 Wofford 15 Midwest 0 1 1.0 0.046174117355 0.010116644273 0.000910969693 5.650229e-05 6.218794e-06 7.38493e-07 1354108.091
53 12 Arizona 1 West 0 1 1.0 0.977695239703 0.7268765394869999 0.582411997103 0.42412175432800003 0.230825752208 0.133549746409 6.487846491
54 2692 Weber State 16 West 0 1 1.0 0.022304760296999997 0.002656332371 0.000568461552 9.3021487e-05 8.340969e-06 1.023039e-06 977478.9735
55 2250 Gonzaga 8 West 0 1 1.0 0.47987006853200004 0.126191039747 0.077224202977 0.040451180180000004 0.014181218607000001 0.00561193758 177.1915757
56 197 Oklahoma State 9 West 0 1 1.0 0.520129931468 0.144276088395 0.08976697554400001 0.047944924321 0.022217258188 0.0112255306 88.0826488
57 201 Oklahoma 5 West 0 1 1.0 0.6379089244520001 0.333590025743 0.076573283322 0.031502789051 0.011361434436000002 0.004610733992 215.88520780000002
58 2449 North Dakota State 12 West 0 1 1.0 0.36209107554799996 0.14546857204299998 0.019449384465 0.005465534098999999 0.0010823094590000002 0.000261583924 3821.864901
59 21 San Diego State 4 West 0 1 1.0 0.734775656057 0.42532318977899997 0.141197305461 0.07467315494099999 0.021060906332 0.006866943347 144.6252003
60 166 New Mexico State 13 West 0 1 1.0 0.265224343943 0.095618212435 0.012808389576000001 0.0036100417219999997 0.0006785848200000001 0.000157008372 6368.087131
61 239 Baylor 6 West 0 1 1.0 0.703236756559 0.33812182966700005 0.14349000744100002 0.044286024681 0.017880727266 0.008002963436 123.9537135
62 158 Nebraska 11 West 0 1 1.0 0.29676324344099997 0.09164480282 0.029181695233 0.006612233582 0.001696542071 0.000514024938 1944.4309059999998
63 156 Creighton 3 West 0 1 1.0 0.8829045859810001 0.543764419623 0.296920210803 0.12219162545 0.054078980875 0.026150582684 37.2400657
64 309 Louisiana-Lafayette 14 West 0 1 1.0 0.117095414019 0.02646894789 0.004215018662 0.000466907512 7.086876199999999e-05 1.3694655999999999e-05 73020.18402999999
65 2483 Oregon 7 West 0 1 1.0 0.6473165134759999 0.191415757568 0.098730522699 0.035653377651999996 0.011007541824000001 0.0038960415539999998 255.67077369999998
66 252 Brigham Young 10 West 0 1 1.0 0.352683486524 0.069537751924 0.02666660515 0.006775909139000001 0.00152799288 0.00041334098 2418.310082
67 275 Wisconsin 2 West 0 1 1.0 0.9284052215299999 0.718357824028 0.39723606041599996 0.155778562628 0.065619792625 0.030338653860999997 31.961251500000003
68 44 American University 15 West 0 1 1.0 0.07159477847 0.020688666479 0.003559879596 0.00037295922800000003 4.6722705999999995e-05 7.636814000000001e-06 130943.6616
Powered by Datasette · Query took 1.716ms