march-madness-predictions/bracket-31

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

68 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: team_seed, team_region, playin_flag, team_alive, rd1_win, rd2_win

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
1 1 57 Florida 1 South 0 1 1 1.0 0.7620298026540001 0.5780376625460001 0.36598187870399995 0.218972827682 0.11755503553999999 7.506653887
2 2 399 Albany 16a South 1 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
3 3 116 Mount St. Mary's 16b South 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 --
4 4 38 Colorado 8 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
5 5 221 Pittsburgh 9 South 0 1 1 1.0 0.237970197346 0.146992877949 0.071731394957 0.032923168512 0.013569274046 72.69591008
6 6 2670 Virginia Commonwealth 5 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
7 7 2617 Stephen F. Austin 12 South 0 1 1 1.0 0.168424807998 0.025308720649000003 0.006285860134 0.001734361628 0.000427007778 2340.877714
8 8 26 UCLA 4 South 0 1 1 0.870759407024 0.760536067201 0.23781994360599998 0.102251308599 0.045496588507 0.017955015557999998 54.69474428
9 9 202 Tulsa 13 South 0 1 1 0.129240592976 0.0710391248 0.01184079525 0.003186510884 0.0009174089139999999 0.00023578156 4240.21378
10 10 194 Ohio State 6 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
11 11 2168 Dayton 11 South 0 1 1 1.0 0.22661213245200001 0.064812919839 0.017263725452 0.004940645494 0.001257263059 794.3784954
12 12 183 Syracuse 3 South 0 1 1 1.0 0.773387867548 0.357373985814 0.15388352871400002 0.070331231317 0.028639454539999998 33.91686612
13 13 2711 Western Michigan 14 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
14 14 167 New Mexico 7 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
15 15 24 Stanford 10 South 0 1 1 1.0 0.21272335903499998 0.074372405563 0.019333699034 0.006220463198000001 0.001780887751 560.5177033
16 16 2305 Kansas 2 South 0 1 1 1.0 0.7872766409649999 0.5034406887830001 0.260082093521 0.148691503334 0.076206953018 12.12216222
17 17 2198 Eastern Kentucky 15 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
18 18 258 Virginia 1 East 0 1 1 0.96389164071 0.7011712231880001 0.37369456255500005 0.22015936356600002 0.11874934958000001 0.061039016065 15.38296395
19 19 324 Coastal Carolina 16 East 0 1 1 0.03610835929 0.005468352806 0.00035566819300000005 3.4166628e-05 2.8043630000000002e-06 2.45814e-07 4068117.747
20 20 235 Memphis 8 East 0 1 1 1.0 0.293360424006 0.09597411349400001 0.037301058894000004 0.013091326658999999 0.004437019987 224.3764921
21 21 45 George Washington 9 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
22 22 2132 Cincinnati 5 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
23 23 108 Harvard 12 East 0 1 1 1.0 0.22767624055 0.08141826583 0.031670659863 0.009294547517999999 0.0026556118060000002 375.5610613
24 24 127 Michigan State 4 East 0 1 1 1.0 0.77232375945 0.448557389928 0.271080559768 0.141870481732 0.070727593487 13.13875336
25 25 48 Delaware 13 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
26 26 153 North Carolina 6 East 0 1 1 1.0 0.5141898272659999 0.20191710079300002 0.07579826162600001 0.027656227743 0.009682208687 102.2822192
27 27 2507 Providence 11 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
28 28 66 Iowa State 3 East 0 1 1 0.8123594451170001 0.439951100469 0.184656694179 0.07409420210199999 0.030567662162000003 0.012093852890000001 81.68663502
29 29 2428 North Carolina Central 14 East 0 1 1 0.187640554883 0.045859072265 0.008371041951999999 0.001545665667 0.00029298000199999997 5.5755685999999994e-05 17934.39044
30 30 41 Connecticut 7 East 0 1 1 1.0 0.35102758297799996 0.18539072238499998 0.073847890487 0.026488080046 0.009149547367 108.2950241
31 31 2603 Saint Joseph's 10 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
32 32 222 Villanova 2 East 0 1 1 1.0 0.648972417022 0.41966444069 0.21446817140000002 0.10175834161 0.046080470467 20.70116732
33 33 270 Milwaukee 15 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
34 34 2724 Wichita State 1 Midwest 0 1 1 1.0 0.621127661485 0.262100569785 0.161123863961 0.097932383506 0.05820324933899999 16.18117135
35 35 13 Cal Poly 16a Midwest 1 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
36 36 2640 Texas Southern 16b Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 --
37 37 96 Kentucky 8 Midwest 0 1 1 0.7393162993019999 0.31947815905099997 0.132334006217 0.080401919907 0.040581859297 0.020087215961 48.7829068
38 38 2306 Kansas State 9 Midwest 0 1 1 0.260683700698 0.059394179463 0.011900715885000001 0.004378327636 0.001580666379 0.00057041142 1752.120579
39 39 139 Saint Louis 5 Midwest 0 1 1 1.0 0.17773511846599999 0.057282457178 0.024218046741999996 0.008825163225 0.003190007899 312.4788476
40 40 152 North Carolina State 12a Midwest 1 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
41 41 2752 Xavier 12b Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 --
42 42 97 Louisville 4 Midwest 0 1 1 1.0 0.822264881534 0.536382250935 0.389218498343 0.240622946782 0.144705450356 5.910589736
43 43 2363 Manhattan 13 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
44 44 113 Massachusetts 6 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
45 45 2294 Iowa 11a Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 --
46 46 2633 Tennessee 11b Midwest 1 1 1 1.0 0.810641139226 0.417738967448 0.146235010965 0.065995472476 0.029471811108 32.93072778
47 47 150 Duke 3 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
48 48 2382 Mercer 14 Midwest 0 1 1 1.0 0.189358860774 0.04217991225599999 0.005257364954 0.001136428012 0.000253379755 3945.645227
49 49 251 Texas 7 Midwest 0 1 1 1.0 0.21311401249 0.071766563406 0.012222097331999998 0.004376982889 0.001559331469 640.3004674
50 50 9 Arizona State 10 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
51 51 130 Michigan 2 Midwest 0 1 1 1.0 0.78688598751 0.46831455689 0.176944870161 0.079693015272 0.035142503988 27.45557051
52 52 2747 Wofford 15 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
53 53 12 Arizona 1 West 0 1 1 1.0 0.7265928707170001 0.567101376647 0.374812638128 0.19817820529 0.11021411248400001 8.073248221
54 54 2692 Weber State 16 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
55 55 2250 Gonzaga 8 West 0 1 1 1.0 0.273407129283 0.168567420019 0.080794097392 0.02962620791 0.01198817263 82.41554888
56 56 197 Oklahoma State 9 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
57 57 201 Oklahoma 5 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
58 58 2449 North Dakota State 12 West 0 1 1 1.0 0.354155672889 0.050463366114 0.01216111057 0.002530547485 0.000621805181 1607.220759
59 59 21 San Diego State 4 West 0 1 1 1.0 0.6458443271109999 0.21386783722 0.09836402426799999 0.027177068877 0.008481041528 116.9100464
60 60 166 New Mexico State 13 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
61 61 239 Baylor 6 West 0 1 1 1.0 0.45595090335 0.165011411743 0.056040768591999995 0.024318560650999996 0.011449525811999999 86.33986162
62 62 158 Nebraska 11 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
63 63 156 Creighton 3 West 0 1 1 1.0 0.54404909665 0.25129874541200004 0.107183431424 0.048474847735 0.023550675419 41.4616272
64 64 309 Louisiana-Lafayette 14 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
65 65 2483 Oregon 7 West 0 1 1 1.0 0.228002589012 0.119929606057 0.049099739869 0.017235264352 0.006734079263000001 147.4984006
66 66 252 Brigham Young 10 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --
67 67 275 Wisconsin 2 West 0 1 1 1.0 0.771997410988 0.463760236787 0.221544189757 0.11171437985999999 0.060229231281 15.60323366
68 68 44 American University 15 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 --

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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