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

16 rows where sixteen = 1 sorted by wspi

View and edit SQL

Suggested facets: group, group_first, group_second, group_third_advance, quarter, semi, final, win

sixteen

group_fourth

  • 0 16
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
11 Colombia F 80.32665865 1.10895025 1.20466353 0 0 1 0 0 1 0.04595 0.01675 0.00105 0.0002
13 Cameroon C 81.15984435 1.2903529 1.2690039 0 1 0 0 0 1 0.0 0.0 0.0 0.0
15 South Korea E 83.18060181 1.67997341 1.35966118 0 1 0 0 0 1 0.0 0.0 0.0 0.0
16 Switzerland C 83.69523188 1.87705432 1.48650619 0 0 1 0 0 1 0.0 0.0 0.0 0.0
10 China A 85.39302408 1.48378622 0.74785799 0 1 0 0 0 1 1.0 0.14415 0.02055 0.00675
9 Netherlands A 86.28242957 1.86003809 0.98914607 0 0 1 0 0 1 0.26815 0.108 0.04025 0.00715
8 Norway B 89.03188343 2.21406976 0.79279041 0 1 0 0 0 1 0.4912 0.20445 0.09035 0.0203
7 England F 89.21829442 2.22353465 0.76003132 0 1 0 0 0 1 0.5088 0.21815 0.1044 0.0244
4 Canada A 89.39774464 2.16171268 0.65032637 1 0 0 0 0 1 1.0 0.5774 0.298 0.0845
6 Australia D 89.47812011 2.40487837 0.89759282 0 1 0 0 0 1 1.0 0.43055 0.19865 0.0477
12 Sweden D 91.32029906 2.67609931 0.72745095 0 0 1 0 0 1 0.0 0.0 0.0 0.0
14 Brazil E 91.68650667 2.59287632 0.53489354 1 0 0 0 0 1 0.0 0.0 0.0 0.0
3 Japan C 92.27317461 2.75937386 0.54834334 1 0 0 0 0 1 0.73185 0.46145 0.26835 0.09075
5 France F 92.46472353 2.87059197 0.61258886 1 0 0 0 0 1 1.0 0.281 0.11585 0.0685
2 USA D 95.20588303 3.5665402 0.40443394 1 0 0 0 0 1 0.95405 0.8391 0.4152 0.30005
1 Germany B 95.99134383 3.88003086 0.39057046 1 0 0 0 0 1 1.0 0.719 0.44735 0.3497

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150621-213134" (
"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 30.406ms