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

6 rows where group_fourth = 1

View and edit SQL

group_fourth

group_first

  • 0 6
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
19 New Zealand A 82.81637141 1.48061027 1.20261383 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.92101504 1.38407212 2.75436424 0 0 0 0 1 0 0.0 0.0 0.0 0.0
21 Nigeria D 85.83838678 1.71069681 0.91117429 0 0 0 0 1 0 0.0 0.0 0.0 0.0
22 Mexico F 80.413657 1.48362444 1.60035654 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Spain E 83.4229355 1.4640016 1.08081709 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 57.84518108 0.4823598 3.58237771 0 0 0 0 1 0 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-175918" (
"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 28.271ms