womens-world-cup-predictions/wwc-forecast-20150627-213532

4 rows where group = "F" sorted by semi

View and edit SQL

Suggested facets: group_first, group_second, group_fourth, sixteen, semi, final, win

quarter

group_third_advance

group

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
6 France F 92.46354832 2.86166617 0.60567606 0 1 0 0 0 1 1 0 0.0 0.0
12 Colombia F 80.27718112 1.08058037 1.18239688 0 0 1 0 0 1 0 0 0.0 0.0
22 Mexico F 80.41864939 1.48574836 1.60338125 0 0 0 0 1 0 0 0 0.0 0.0
4 England F 89.82047907 2.34203662 0.74917098 1 0 0 0 0 1 1 1 0.39555 0.08755

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150627-213532" (
"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" INTEGER,
  "semi" INTEGER,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 29.211ms