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

8 rows where sixteen = 0 sorted by group_fourth

View and edit SQL

Suggested facets: group, group_third_no_advance, group_fourth

sixteen

group_first

  • 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
18 Thailand B 68.37245736 0.89817463 2.70324769 0 0 0 1 0 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
17 Spain E 83.4267504 1.46396321 1.08077115 0 0 0 0 1 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
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

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