womens-world-cup-predictions/wwc-forecast-20150612-185329

24 rows

View and edit SQL

Suggested facets: group, group_first, group_third_no_advance, group_fourth, sixteen, semi, final, win

Link rowid team group wspi wspi_offense wspi_defense group_first group_second group_third_advance group_third_no_advance group_fourth sixteen quarter semi final win
1 USA D 95.45608839 3.70742599 0.43697703 0.8321 0.1418 0.0156 0.00015 0.01035 0.9895 0.87975 0.7527 0.4477 0.3127
2 Germany B 95.75138588 3.79367026 0.39591616 0.96105 0.0355 0.0034 5e-05 0.0 0.99995 0.82255 0.6129 0.3765 0.27305
3 Japan C 92.590292 2.84149007 0.536861 0.86105 0.12035 0.01855 5e-05 0.0 0.99995 0.78605 0.39665 0.23765 0.0903
4 Canada A 89.7171089 2.24318168 0.6614961 0.6916 0.1237 0.18465 5e-05 0.0 0.99995 0.71815 0.3932 0.18655 0.06675
5 France F 92.46907058 2.85220813 0.58569694 0.8955 0.0872 0.0126 0.0001 0.0046 0.9953 0.7586 0.2974 0.12925 0.06595
6 Brazil E 92.32312116 2.80494843 0.57819044 0.9048 0.08565 0.0077 0.00025 0.0016 0.99815 0.53565 0.29885 0.1769 0.0645
7 Sweden D 91.63560595 2.75991775 0.72782965 0.125 0.3919 0.14655 0.22595 0.1106 0.66345 0.34855 0.2077 0.1037 0.0415
8 Norway B 89.13667545 2.22924418 0.78336151 0.0382 0.9615 0.00025 5e-05 0.0 0.99995 0.55005 0.2761 0.10145 0.0239
9 England F 89.317232 2.21097305 0.72118917 0.06085 0.6165 0.19035 0.0248 0.1075 0.8677 0.4087 0.203 0.0802 0.023
10 Australia D 89.24977714 2.41945389 0.96526406 0.04195 0.44625 0.4394 0.03885 0.03355 0.9276 0.3065 0.14575 0.0647 0.01975
11 Netherlands A 86.03929637 1.83715016 1.01071309 0.1528 0.10325 0.60095 0.04085 0.10215 0.857 0.29265 0.0862 0.0275 0.00545
12 China A 85.31959651 1.45245349 0.7266549 0.1556 0.50315 0.1343 0.006 0.20095 0.79305 0.39605 0.09185 0.02025 0.00415
13 Switzerland C 83.54265243 1.80711532 1.43636899 0.00815 0.42435 0.4918 0.05355 0.02215 0.9243 0.33215 0.073 0.01465 0.0026
14 Spain E 84.12232148 1.56334453 1.06773788 0.06665 0.3726 0.11715 0.25005 0.19355 0.5564 0.122 0.02585 0.0069 0.00165
15 South Korea E 83.88292466 1.67884476 1.23650927 0.018 0.4158 0.2822 0.0581 0.2259 0.716 0.13465 0.0299 0.00615 0.00125
16 Cameroon C 80.5517054 1.24315897 1.31617023 0.1308 0.45465 0.413 0.0014 0.00015 0.99845 0.31195 0.05075 0.0087 0.00115
17 Nigeria D 86.01570075 1.77087198 0.94273515 0.00095 0.02005 0.064 0.0695 0.8455 0.085 0.0173 0.00695 0.0024 0.00085
18 New Zealand A 82.441305 1.37145807 1.14684109 0.0 0.2699 0.0332 0.0 0.6969 0.3031 0.1349 0.0196 0.0032 0.00075
19 Mexico F 80.99383081 1.51483741 1.54230059 0.0274 0.1718 0.10565 0.3178 0.37735 0.30485 0.0718 0.0186 0.00375 0.0005
20 Colombia F 78.1131956 0.8658731 1.28457719 0.01625 0.1245 0.08235 0.26635 0.51055 0.2231 0.0417 0.01105 0.00175 0.00025
21 Thailand B 68.1784483 0.92106097 2.75634397 0.00065 0.003 0.5407 0.45345 0.0022 0.54435 0.01675 0.0009 0.0001 0.0
22 Costa Rica E 73.71440075 0.8717509 1.94321825 0.01055 0.12595 0.10265 0.1819 0.57895 0.23915 0.01315 0.0011 5e-05 0.0
23 Ecuador C 59.00676402 0.43516686 3.38901251 0.0 0.00065 0.0116 0.01005 0.9777 0.01225 0.0003 0.0 0.0 0.0
24 Ivory Coast B 71.2534081 1.32768352 2.78687566 0.0 0.0 0.0014 0.0008 0.9978 0.0014 0.0001 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150612-185329" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" REAL,
  "group_second" REAL,
  "group_third_advance" REAL,
  "group_third_no_advance" REAL,
  "group_fourth" REAL,
  "sixteen" REAL,
  "quarter" REAL,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 33.274ms