womens-world-cup-predictions/wwc-forecast-20150608-175420

24 rows

View and edit SQL

Suggested facets: group, group_third_advance, group_third_no_advance, 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 Germany B 95.94286698 3.88098341 0.38854947 0.89035 0.10895 0.00065 5e-05 0.0 0.99995 0.8506 0.6575 0.4424 0.32105
2 USA D 95.35087439 3.67166839 0.43355989 0.68385 0.1929 0.0778 0.0092 0.03625 0.95455 0.80335 0.6576 0.39215 0.26345
3 Japan C 92.69822286 2.90305431 0.56145585 0.7921 0.1713 0.03365 0.0016 0.00135 0.99705 0.79545 0.41365 0.2284 0.08925
4 Canada A 90.04692302 2.33864213 0.67878258 0.6942 0.22535 0.06575 0.0026 0.0121 0.9853 0.7323 0.3943 0.1846 0.06875
5 France F 92.42473639 2.87358173 0.61315302 0.6005 0.29305 0.07355 0.0114 0.0215 0.9671 0.6614 0.29845 0.1501 0.0665
6 Brazil E 92.23404478 2.81258039 0.60380833 0.69895 0.21635 0.06575 0.0079 0.01105 0.98105 0.5223 0.28395 0.1595 0.0651
7 Sweden D 91.65232913 2.7667187 0.72232845 0.1541 0.34985 0.1648 0.14685 0.1844 0.66875 0.37555 0.22495 0.10425 0.0409
8 England F 89.58118807 2.28535454 0.7330302 0.3169 0.43445 0.1515 0.03585 0.0613 0.90285 0.47575 0.1846 0.0739 0.0217
9 Norway B 88.92737025 2.21081781 0.80372155 0.10915 0.84115 0.0456 0.00405 5e-05 0.9959 0.50415 0.2336 0.08775 0.0214
10 Australia D 88.79078124 2.35819648 0.99581587 0.1098 0.2622 0.21395 0.0629 0.35115 0.58595 0.2489 0.1275 0.04695 0.01485
11 Netherlands A 86.35058386 1.89758514 1.00659421 0.24215 0.4182 0.25385 0.03255 0.05325 0.9142 0.44385 0.1361 0.0365 0.00925
12 Nigeria D 86.57289011 1.860365 0.92162687 0.05225 0.19505 0.1804 0.1441 0.4282 0.4277 0.1419 0.059 0.0187 0.0045
13 Switzerland C 83.67739797 1.88193419 1.48623021 0.14865 0.498 0.24775 0.0584 0.0472 0.8944 0.3425 0.07905 0.017 0.0029
14 Spain E 84.70474731 1.62047544 1.01572386 0.15325 0.36355 0.2684 0.0776 0.1372 0.7852 0.1986 0.0522 0.01505 0.0029
15 South Korea E 84.25651288 1.7546404 1.24426847 0.13725 0.3459 0.2856 0.0865 0.14475 0.76875 0.18635 0.049 0.01245 0.00285
16 China A 85.07744757 1.4444211 0.75409655 0.0417 0.27455 0.2729 0.09715 0.3137 0.58915 0.2252 0.0563 0.01295 0.00255
17 New Zealand A 82.18871249 1.407039 1.21946617 0.02195 0.0819 0.2092 0.066 0.62095 0.31305 0.0804 0.0165 0.0036 0.0008
18 Mexico F 81.11767893 1.52863766 1.52886866 0.0545 0.1685 0.28305 0.12025 0.3737 0.50605 0.11335 0.0273 0.0059 0.0006
19 Cameroon C 79.24971313 1.11143399 1.36960145 0.0582 0.30245 0.386 0.1236 0.12975 0.74665 0.18565 0.03095 0.00435 0.0004
20 Colombia F 78.05434435 0.87093554 1.2911445 0.0281 0.104 0.2174 0.107 0.5435 0.3495 0.0614 0.01225 0.0024 0.00025
21 Ivory Coast B 72.90306573 1.34430477 2.5680221 0.00045 0.0487 0.1852 0.30675 0.4589 0.23435 0.02575 0.0034 0.0008 5e-05
22 Costa Rica E 72.8194939 0.82481829 2.01100639 0.01055 0.0742 0.13065 0.0776 0.707 0.2154 0.01535 0.0015 0.00025 0.0
23 Ecuador C 63.37013996 0.48717143 2.89259398 0.00105 0.02825 0.0785 0.0705 0.8217 0.1078 0.00565 0.0002 5e-05 0.0
24 Thailand B 67.4452344 0.87245828 2.79261644 0.0 0.0012 0.1081 0.34965 0.54105 0.1093 0.0043 0.00015 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150608-175420" (
"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 28.141ms