march-madness-predictions/bracket-20

68 rows sorted by playin_flag

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_seed, team_region, playin_flag, team_alive, rd1_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 timestamp
1 1 57 Florida 1 South 0 1 1 1.0 0.7620298026540001 0.5481480079469999 0.35003225744099997 0.210037322117 0.110198141355 8.074563216 3/21/2014 1:37 AM
4 4 38 Colorado 8 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
5 5 221 Pittsburgh 9 South 0 1 1 1.0 0.237970197346 0.135384785788 0.066973343895 0.030926760384999998 0.012391966347 79.69744317 3/21/2014 1:37 AM
6 6 2670 Virginia Commonwealth 5 South 0 1 1 0.764132213407 0.28666324896699996 0.101845195748 0.048791133944 0.021838665480999997 0.00839567115 118.1090006 3/21/2014 1:37 AM
7 7 2617 Stephen F. Austin 12 South 0 1 1 0.235867786593 0.041831022382000004 0.006659851151 0.001754848014 0.000507348658 0.00012497793 8000.412711 3/21/2014 1:37 AM
8 8 26 UCLA 4 South 0 1 1 0.870759407024 0.6269215503719999 0.20024830227899998 0.088378236672 0.040004491808 0.015523072082 63.42023813 3/21/2014 1:37 AM
9 9 202 Tulsa 13 South 0 1 1 0.129240592976 0.044584178278 0.007713857086999999 0.0021652101 0.000643017773 0.000162756106 6143.162719 3/21/2014 1:37 AM
10 10 194 Ohio State 6 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
11 11 2168 Dayton 11 South 0 1 1 1.0 0.22661213245200001 0.065837250065 0.017119891069000002 0.004912124442 0.0011931521529999999 837.1160754 3/21/2014 1:37 AM
12 12 183 Syracuse 3 South 0 1 1 1.0 0.773387867548 0.36180411936800005 0.153657734938 0.070262342482 0.027631749883 35.19025231 3/21/2014 1:37 AM
13 13 2711 Western Michigan 14 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
14 14 167 New Mexico 7 South 0 1 1 0.637537835827 0.221612021956 0.10307220074100001 0.036167934175 0.01562086775 0.005787873555 171.7750253 3/21/2014 1:37 AM
15 15 24 Stanford 10 South 0 1 1 0.36246216417300003 0.08918457713 0.03132900433 0.00801249425 0.002603094219 0.000719388839 1389.068829 3/21/2014 1:37 AM
16 16 2305 Kansas 2 South 0 1 1 0.924028935551 0.670385180717 0.434274653551 0.226445849974 0.13106170303099998 0.066327844887 14.07662433 3/21/2014 1:37 AM
17 17 2198 Eastern Kentucky 15 South 0 1 1 0.075971064449 0.018818220196 0.0036827719439999997 0.0005010655279999999 7.9125482e-05 1.0616015e-05 94196.30139 3/21/2014 1:37 AM
18 18 258 Virginia 1 East 0 1 1 0.96389164071 0.707824942042 0.376597739537 0.22173708004599998 0.11991850556 0.059844543197 15.70996129 3/21/2014 1:37 AM
19 19 324 Coastal Carolina 16 East 0 1 1 0.03610835929 0.005669669617 0.00036628264499999997 3.5226399e-05 2.885827e-06 2.33786e-07 4277415.373 3/21/2014 1:37 AM
20 20 235 Memphis 8 East 0 1 1 0.550041201202 0.166598236998 0.05619861265599999 0.022506967159000003 0.008180962311 0.0027484924099999996 362.8358238 3/21/2014 1:37 AM
21 21 45 George Washington 9 East 0 1 1 0.449958798798 0.11990715134299999 0.033900359054000004 0.011676599897 0.003237281738 0.000833565273 1198.6661 3/21/2014 1:37 AM
22 22 2132 Cincinnati 5 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
23 23 108 Harvard 12 East 0 1 1 1.0 0.22767624055 0.082238382702 0.032004875329 0.009427705693 0.002570594588 388.015057 3/21/2014 1:37 AM
24 24 127 Michigan State 4 East 0 1 1 1.0 0.77232375945 0.450698623406 0.27244373368 0.14312091888599998 0.069280604077 13.43405428 3/21/2014 1:37 AM
25 25 48 Delaware 13 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
26 26 153 North Carolina 6 East 0 1 1 0.6796373677709999 0.36376216082199997 0.15056791656 0.059716345908000006 0.023155177809 0.008268457819 119.9415373 3/21/2014 1:37 AM
27 27 2507 Providence 11 East 0 1 1 0.320362632229 0.121140229004 0.036247772694 0.010595726746000001 0.002794094312 0.0006852978710000001 1458.219475 3/21/2014 1:37 AM
28 28 66 Iowa State 3 East 0 1 1 0.8123594451170001 0.463801514016 0.193134672236 0.076959538371 0.031677883397 0.011997895086 82.34795336 3/21/2014 1:37 AM
29 29 2428 North Carolina Central 14 East 0 1 1 0.187640554883 0.051296096158 0.009207806773 0.001676943669 0.000314803126 5.5815917e-05 17915.03649 3/21/2014 1:37 AM
30 30 41 Connecticut 7 East 0 1 1 1.0 0.35102758297799996 0.18766148122 0.074628106444 0.026849011886999997 0.008891698527000001 111.4644518 3/21/2014 1:37 AM
31 31 2603 Saint Joseph's 10 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
32 32 222 Villanova 2 East 0 1 1 1.0 0.648972417022 0.42318035051700004 0.21601885635200002 0.102823905824 0.045034470162000004 21.20521295 3/21/2014 1:37 AM
33 33 270 Milwaukee 15 East 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
34 34 2724 Wichita State 1 Midwest 0 1 1 0.9754539205689999 0.591415204901 0.24083336197 0.133934722343 0.076759023504 0.044847543010999996 21.29776556 3/21/2014 1:37 AM
37 37 96 Kentucky 8 Midwest 0 1 1 0.7393162993019999 0.340260219827 0.140502803137 0.079097020936 0.038256516408 0.019098396381000003 51.36041708 3/21/2014 1:37 AM
38 38 2306 Kansas State 9 Midwest 0 1 1 0.260683700698 0.066558356626 0.013198070188 0.004259027783 0.001451763358 0.0005282647159999999 1891.99033 3/21/2014 1:37 AM
39 39 139 Saint Louis 5 Midwest 0 1 1 1.0 0.17773511846599999 0.059424655698 0.022491194612 0.0077949629639999995 0.002860597576 348.5773081 3/21/2014 1:37 AM
42 42 97 Louisville 4 Midwest 0 1 1 1.0 0.822264881534 0.545973999181 0.375575557412 0.224648222256 0.13611582043 6.346684587 3/21/2014 1:37 AM
43 43 2363 Manhattan 13 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
44 44 113 Massachusetts 6 Midwest 0 1 1 0.294573469275 0.056982985793000006 0.018616959578 0.00371728402 0.0010008716620000001 0.00029282296500000003 3414.032699 3/21/2014 1:37 AM
47 47 150 Duke 3 Midwest 0 1 1 0.929166050148 0.683485418794 0.408355794106 0.174490016321 0.087262569767 0.044807223026 21.31783031 3/21/2014 1:37 AM
48 48 2382 Mercer 14 Midwest 0 1 1 0.070833949852 0.017871391429999998 0.0038875639659999997 0.000479971919 9.3707075e-05 2.0525063e-05 48719.92287 3/21/2014 1:37 AM
49 49 251 Texas 7 Midwest 0 1 1 1.0 0.21311401249 0.052565547054 0.0094234499 0.00325755716 0.001196261579 834.9375723 3/21/2014 1:37 AM
50 50 9 Arizona State 10 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
51 51 130 Michigan 2 Midwest 0 1 1 1.0 0.78688598751 0.391858549886 0.15230291327099998 0.066252093831 0.029853628484 32.49676575 3/21/2014 1:37 AM
52 52 2747 Wofford 15 Midwest 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
53 53 12 Arizona 1 West 0 1 1 0.977695239703 0.7268765394869999 0.596402058274 0.410912763622 0.226613377877 0.133406116417 6.495908185 3/21/2014 1:37 AM
54 54 2692 Weber State 16 West 0 1 1 0.022304760296999997 0.002656332371 0.0006593845789999999 8.9674411e-05 8.108343e-06 1.021748e-06 978713.8763 3/21/2014 1:37 AM
55 55 2250 Gonzaga 8 West 0 1 1 0.47987006853200004 0.126191039747 0.081325619972 0.038822578483000005 0.013802469325999999 0.005580111218 178.2078977 3/21/2014 1:37 AM
56 56 197 Oklahoma State 9 West 0 1 1 0.520129931468 0.144276088395 0.09437588771500001 0.046028686162 0.021606799571000004 0.011117858901 88.94537607 3/21/2014 1:37 AM
57 57 201 Oklahoma 5 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
58 58 2449 North Dakota State 12 West 0 1 1 1.0 0.395126072258 0.051118676743000004 0.012188159223 0.002397690864 0.000583492584 1712.817839 3/21/2014 1:37 AM
59 59 21 San Diego State 4 West 0 1 1 0.745488809005 0.494767314476 0.162271374613 0.077893560251 0.022130759337 0.007338885890000001 135.2604645 3/21/2014 1:37 AM
60 60 166 New Mexico State 13 West 0 1 1 0.254511190995 0.110106613266 0.013846998104 0.003238587826 0.000591277598 0.000135313575 7389.241493 3/21/2014 1:37 AM
61 61 239 Baylor 6 West 0 1 1 0.703236756559 0.338102692122 0.118113693891 0.036510001703 0.015059098776 0.006924784101 143.4088343 3/21/2014 1:37 AM
62 62 158 Nebraska 11 West 0 1 1 0.29676324344099997 0.091637776657 0.022963742045999998 0.005231511938 0.001377108586 0.00043185498899999997 2314.592096 3/21/2014 1:37 AM
63 63 156 Creighton 3 West 0 1 1 0.883050561066 0.5438475622 0.255248600208 0.10494123251599999 0.047370954873 0.023484763068 41.58080003 3/21/2014 1:37 AM
64 64 309 Louisiana-Lafayette 14 West 0 1 1 0.116949438934 0.026411969021 0.002995612634 0.000337610902 5.2735004e-05 1.0621487999999999e-05 94147.76551 3/21/2014 1:37 AM
65 65 2483 Oregon 7 West 0 1 1 1.0 0.228002589012 0.124164077818 0.047951491235 0.016360612962 0.006408763957 155.0363288 3/21/2014 1:37 AM
66 66 252 Brigham Young 10 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
67 67 275 Wisconsin 2 West 0 1 1 1.0 0.771997410988 0.476514273403 0.215854141729 0.106859942647 0.057737836933000004 16.31966511 3/21/2014 1:37 AM
68 68 44 American University 15 West 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
2 2 399 Albany 16a South 1 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
3 3 116 Mount St. Mary's 16b South 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
35 35 13 Cal Poly 16a Midwest 1 1 1 0.024546079430999998 0.001766218646 6.7109826e-05 5.6199429999999995e-06 6.20462e-07 8.211800000000001e-08 12177592.73 3/21/2014 1:37 AM
36 36 2640 Texas Southern 16b Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
40 40 152 North Carolina State 12a Midwest 1 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
41 41 2752 Xavier 12b Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
45 45 2294 Iowa 11a Midwest 1 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/21/2014 1:37 AM
46 46 2633 Tennessee 11b Midwest 1 1 1 0.7054265307250001 0.241660203984 0.12471558541 0.044223221541 0.018991155788 0.008538530769 116.1161675 3/21/2014 1:37 AM

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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