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

6 rows where group_first = 1 sorted by group_second

View and edit SQL

Suggested facets: quarter

group_third_advance

  • 0 6

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.99134383 3.88003086 0.39057046 1 0 0 0 0 1 1.0 0.719 0.44735 0.3497
2 USA D 95.20588303 3.5665402 0.40443394 1 0 0 0 0 1 0.95405 0.8391 0.4152 0.30005
3 Japan C 92.27317461 2.75937386 0.54834334 1 0 0 0 0 1 0.73185 0.46145 0.26835 0.09075
4 Canada A 89.39774464 2.16171268 0.65032637 1 0 0 0 0 1 1.0 0.5774 0.298 0.0845
5 France F 92.46472353 2.87059197 0.61258886 1 0 0 0 0 1 1.0 0.281 0.11585 0.0685
14 Brazil E 91.68650667 2.59287632 0.53489354 1 0 0 0 0 1 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 24.519ms