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

24 rows sorted by group_third_advance

View and edit SQL

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

sixteen

  • 1 16
  • 0 8
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.99134383 3.88003086 0.39057046 1 0 0 0 0 1 1.0 0.719 0.44735 0.3497
2 USA D 95.20588303 3.5665402 0.40443394 1 0 0 0 0 1 0.95405 0.8391 0.4152 0.30005
3 Japan C 92.27317461 2.75937386 0.54834334 1 0 0 0 0 1 0.73185 0.46145 0.26835 0.09075
4 Canada A 89.39774464 2.16171268 0.65032637 1 0 0 0 0 1 1.0 0.5774 0.298 0.0845
5 France F 92.46472353 2.87059197 0.61258886 1 0 0 0 0 1 1.0 0.281 0.11585 0.0685
6 Australia D 89.47812011 2.40487837 0.89759282 0 1 0 0 0 1 1.0 0.43055 0.19865 0.0477
7 England F 89.21829442 2.22353465 0.76003132 0 1 0 0 0 1 0.5088 0.21815 0.1044 0.0244
8 Norway B 89.03188343 2.21406976 0.79279041 0 1 0 0 0 1 0.4912 0.20445 0.09035 0.0203
10 China A 85.39302408 1.48378622 0.74785799 0 1 0 0 0 1 1.0 0.14415 0.02055 0.00675
13 Cameroon C 81.15984435 1.2903529 1.2690039 0 1 0 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
15 South Korea E 83.18060181 1.67997341 1.35966118 0 1 0 0 0 1 0.0 0.0 0.0 0.0
17 Spain E 83.4267504 1.46396321 1.08077115 0 0 0 0 1 0 0.0 0.0 0.0 0.0
18 Thailand B 68.37245736 0.89817463 2.70324769 0 0 0 1 0 0 0.0 0.0 0.0 0.0
19 New Zealand A 82.825185 1.48165077 1.20290356 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.92524202 1.38402719 2.7541836 0 0 0 0 1 0 0.0 0.0 0.0 0.0
21 Costa Rica E 74.73189246 0.93446957 1.86411389 0 0 0 1 0 0 0.0 0.0 0.0 0.0
22 Mexico F 80.41834561 1.48390168 1.60050664 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Nigeria D 85.84140827 1.71052963 0.91113746 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 57.71958936 0.48521569 3.60126165 0 0 0 0 1 0 0.0 0.0 0.0 0.0
9 Netherlands A 86.28242957 1.86003809 0.98914607 0 0 1 0 0 1 0.26815 0.108 0.04025 0.00715
11 Colombia F 80.32665865 1.10895025 1.20466353 0 0 1 0 0 1 0.04595 0.01675 0.00105 0.0002
12 Sweden D 91.32029906 2.67609931 0.72745095 0 0 1 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

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 39.092ms