womens-world-cup-predictions/wwc-forecast-20150615-175745

4 rows where group = "D" sorted by wspi_offense

View and edit SQL

sixteen

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
17 Nigeria D 86.03518886 1.7752372 0.94266118 0.0039 0.01505 0.06085 0.01455 0.90565 0.0798 0.01515 0.00675 0.0027 0.00085
10 Australia D 89.2305021 2.4175798 0.96687642 0.0704 0.45895 0.4056 0.0273 0.03775 0.93495 0.28795 0.14275 0.05695 0.01825
7 Sweden D 91.46821825 2.68688554 0.69540583 0.07375 0.3958 0.2094 0.26445 0.0566 0.67895 0.2972 0.1761 0.0867 0.0326
2 USA D 95.27805283 3.60990734 0.4174047 0.8519 0.1302 0.01785 5e-05 0.0 0.99995 0.84825 0.73055 0.4217 0.28915

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150615-175745" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" REAL,
  "group_second" REAL,
  "group_third_advance" REAL,
  "group_third_no_advance" REAL,
  "group_fourth" REAL,
  "sixteen" REAL,
  "quarter" REAL,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 24.28ms