womens-world-cup-predictions/wwc-forecast-20150617-210614

4 rows where group = "C" sorted by wspi_offense

View and edit SQL

Suggested facets: group_second, group_third_advance, group_fourth, sixteen

group_first

group

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 58.03406445 0.48170908 3.55755304 0 0 0 0 1 0 0.0 0.0 0.0 0.0
14 Cameroon C 81.48187359 1.3478804 1.27763597 0 1 0 0 0 1 0.3827 0.03825 0.00415 0.0014
13 Switzerland C 83.78797092 1.94132612 1.53894582 0 0 1 0 0 1 0.24945 0.0837 0.0217 0.0039
3 Japan C 92.25542615 2.75302043 0.54581278 1 0 0 0 0 1 0.7292 0.40055 0.24175 0.0861

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150617-210614" (
"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 23.993ms