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

18 rows where group_first = 0 sorted by wspi

View and edit SQL

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

sixteen

  • 1 10
  • 0 8

group_first

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
24 Ecuador C 57.71958936 0.48521569 3.60126165 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
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
11 Colombia F 80.32665865 1.10895025 1.20466353 0 0 1 0 0 1 0.04595 0.01675 0.00105 0.0002
22 Mexico F 80.41834561 1.48390168 1.60050664 0 0 0 0 1 0 0.0 0.0 0.0 0.0
13 Cameroon C 81.15984435 1.2903529 1.2690039 0 1 0 0 0 1 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
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
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
23 Nigeria D 85.84140827 1.71052963 0.91113746 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
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
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

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