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

2 rows where group_third_no_advance = 1

View and edit SQL

sixteen

  • 0 2

semi

  • 0 2

group_third_no_advance

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
18 Thailand B 68.33961893 0.89820883 2.70802025 0 0 0 1 0 0 0 0 0.0 0.0
21 Costa Rica E 74.73388958 0.93516523 1.86503702 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-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 25.68ms