womens-world-cup-predictions/wwc-forecast-20150621-175918

24 rows sorted by group

View and edit SQL

Suggested facets: group, group_third_advance, group_third_no_advance, sixteen, quarter, semi, final, win

group_second

  • 0 18
  • 1 6

group_fourth

  • 0 18
  • 1 6

group_first

  • 0 18
  • 1 6
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
4 Canada A 89.5109479 2.20922425 0.67481575 0 1 0 0 0 1 0.75945 0.4416 0.2324 0.07055
9 Netherlands A 86.26855756 1.85744459 0.98829936 0 0 1 0 0 1 0.2715 0.11125 0.04355 0.0073
10 China A 85.3880755 1.48298285 0.74719524 1 0 0 0 0 1 1.0 0.1436 0.01825 0.0051
19 New Zealand A 82.81637141 1.48061027 1.20261383 0 0 0 0 1 0 0.0 0.0 0.0 0.0
1 Germany B 95.98858345 3.87986661 0.39052221 1 0 0 0 0 1 1.0 0.71525 0.44325 0.34775
8 Norway B 89.02838895 2.21382891 0.79255032 0 1 0 0 0 1 0.48975 0.234 0.104 0.0218
17 Thailand B 68.3687825 0.89820002 2.70336013 0 0 0 1 0 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.92101504 1.38407212 2.75436424 0 0 0 0 1 0 0.0 0.0 0.0 0.0
3 Japan C 92.26414906 2.75755768 0.54807204 1 0 0 0 0 1 0.7285 0.45905 0.2761 0.0919
11 Switzerland C 83.80700518 1.93623276 1.53110109 0 0 1 0 0 1 0.24055 0.07735 0.0233 0.00265
13 Cameroon C 81.15073192 1.28820488 1.26752494 0 1 0 0 0 1 0.0 0.0 0.0 0.0
24 Ecuador C 57.84518108 0.4823598 3.58237771 0 0 0 0 1 0 0.0 0.0 0.0 0.0
2 USA D 95.2015181 3.56574448 0.40425937 1 0 0 0 0 1 0.94855 0.83835 0.41965 0.309
6 Australia D 89.47502224 2.40500589 0.89766517 0 1 0 0 0 1 1.0 0.4297 0.2085 0.05095
16 Sweden D 91.31747939 2.67575705 0.72694534 0 0 1 0 0 1 0.0 0.0 0.0 0.0
21 Nigeria D 85.83838678 1.71069681 0.91117429 0 0 0 0 1 0 0.0 0.0 0.0 0.0
14 Brazil E 91.68270929 2.59262382 0.53476497 1 0 0 0 0 1 0.0 0.0 0.0 0.0
15 South Korea E 83.17624518 1.67940032 1.35913104 0 1 0 0 0 1 0.0 0.0 0.0 0.0
18 Costa Rica E 74.72846877 0.93453226 1.86417588 0 0 0 1 0 0 0.0 0.0 0.0 0.0
23 Spain E 83.4229355 1.4640016 1.08081709 0 0 0 0 1 0 0.0 0.0 0.0 0.0
5 France F 92.46177095 2.87063862 0.61256589 1 0 0 0 0 1 1.0 0.28475 0.1171 0.06775
7 England F 89.21274468 2.22302813 0.75997928 0 1 0 0 0 1 0.51025 0.24705 0.11215 0.02495
12 Colombia F 80.32349361 1.10940758 1.20507423 0 0 1 0 0 1 0.05145 0.01805 0.00175 0.0003
22 Mexico F 80.413657 1.48362444 1.60035654 0 0 0 0 1 0 0.0 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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