womens-world-cup-predictions/wwc-forecast-20150617-210614

8 rows where win = "0.0"

View and edit SQL

Suggested facets: group, group_third_no_advance, group_fourth

win

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
17 New Zealand A 82.78756556 1.47428696 1.19945697 0 0 0 0 1 0 0.0 0.0 0.0 0.0
18 Thailand B 68.35111448 0.89736657 2.70349166 0 0 0 1 0 0 0.0 0.0 0.0 0.0
19 Spain E 83.46439344 1.46549686 1.07421634 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.83719724 1.38377277 2.76430911 0 0 0 0 1 0 0.0 0.0 0.0 0.0
21 Costa Rica E 74.76881634 0.93763309 1.86021923 0 0 0 1 0 0 0.0 0.0 0.0 0.0
22 Mexico F 80.41636803 1.486867 1.60229443 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Nigeria D 85.86600561 1.7161016 0.91082785 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 58.03406445 0.48170908 3.55755304 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-20150617-210614" (
"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 27.287ms