womens-world-cup-predictions/wwc-forecast-20150615-213540

3 rows where group_first = "1.0"

View and edit SQL

group_second

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
1 Germany B 95.70278239 3.75700988 0.38744414 1.0 0.0 0.0 0.0 0.0 1.0 0.8273 0.6929 0.43975 0.31675
4 Canada A 89.48663963 2.20450402 0.67258603 1.0 0.0 0.0 0.0 0.0 1.0 0.807 0.46265 0.2162 0.07175
5 Brazil E 92.20151735 2.74667404 0.55153209 1.0 0.0 0.0 0.0 0.0 1.0 0.5448 0.298 0.17155 0.06185

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150615-213540" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" REAL,
  "group_second" REAL,
  "group_third_advance" REAL,
  "group_third_no_advance" REAL,
  "group_fourth" REAL,
  "sixteen" REAL,
  "quarter" REAL,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 26.708ms