womens-world-cup-predictions/wwc-forecast-20150622-215702

8 rows where sixteen = 0 sorted by group_first

View and edit SQL

Suggested facets: group, group_third_no_advance, group_fourth

sixteen

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
17 Spain E 83.45481192 1.46409277 1.07614329 0 0 0 0 1 0 0.0 0.0 0.0 0.0
18 Thailand B 68.3620899 0.89757892 2.70408301 0 0 0 1 0 0 0.0 0.0 0.0 0.0
19 New Zealand A 82.82440642 1.48157353 1.20303066 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.89372246 1.38069797 2.75499949 0 0 0 0 1 0 0.0 0.0 0.0 0.0
21 Costa Rica E 74.73527574 0.93515599 1.86444569 0 0 0 1 0 0 0.0 0.0 0.0 0.0
22 Mexico F 80.42628412 1.48580321 1.60140696 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Nigeria D 85.84723606 1.71213207 0.91184131 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 57.6762919 0.48658135 3.60826012 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-20150622-215702" (
"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 25.671ms