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

6 rows where group_fourth = 1 sorted by team

View and edit SQL

group_fourth

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
24 Ecuador C 57.6982561 0.48768945 3.60683902 0 0 0 0 1 0 0 0 0.0 0.0
20 Ivory Coast B 71.86541926 1.38012965 2.75860767 0 0 0 0 1 0 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
19 New Zealand A 82.81893278 1.48216959 1.20557594 0 0 0 0 1 0 0 0 0.0 0.0
23 Nigeria D 85.8629464 1.71701819 0.91543867 0 0 0 0 1 0 0 0 0.0 0.0
17 Spain E 83.45514212 1.46247771 1.07533874 0 0 0 0 1 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-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 28.287ms