womens-world-cup-predictions/wwc-forecast-20150607-180420

4 rows where group = "F"

View and edit SQL

final

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
5 France F 92.44115291 2.87430844 0.6131556 0.60295 0.291 0.075 0.01085 0.0202 0.96895 0.6647 0.29765 0.14815 0.06805
8 England F 89.59574852 2.28511686 0.73286285 0.3179 0.43345 0.1472 0.0383 0.06315 0.89855 0.4779 0.1945 0.07435 0.02155
17 Mexico F 81.11906488 1.52751824 1.52976527 0.0535 0.16915 0.28275 0.1276 0.367 0.5054 0.11305 0.02795 0.0059 0.001
20 Colombia F 78.06807848 0.87093206 1.29111548 0.02565 0.1064 0.20265 0.11565 0.54965 0.3347 0.06005 0.0122 0.0023 0.0003

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150607-180420" (
"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 44.879ms