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

8 rows where group_second = "0.0" sorted by wspi_defense

View and edit SQL

Suggested facets: group, group_first, group_third_advance, group_third_no_advance, group_fourth, sixteen, quarter, semi, final

group_second

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
1 Germany B 95.70278239 3.75700988 0.38744414 1.0 0.0 0.0 0.0 0.0 1.0 0.8273 0.6929 0.43975 0.31675
5 Brazil E 92.20151735 2.74667404 0.55153209 1.0 0.0 0.0 0.0 0.0 1.0 0.5448 0.298 0.17155 0.06185
4 Canada A 89.48663963 2.20450402 0.67258603 1.0 0.0 0.0 0.0 0.0 1.0 0.807 0.46265 0.2162 0.07175
11 Netherlands A 86.25827639 1.85865642 0.98939868 0.0 0.0 0.99995 5e-05 0.0 0.99995 0.2197 0.07085 0.02495 0.005
24 New Zealand A 82.7981143 1.47447794 1.19842544 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
21 Thailand B 68.33349734 0.89889336 2.71014832 0.0 0.0 0.2397 0.7603 0.0 0.2397 0.00365 0.0001 0.0 0.0
23 Ivory Coast B 71.8384438 1.37944188 2.76162647 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
22 Ecuador C 55.74307688 0.5000465 3.86426127 0.0 0.0 5e-05 0.0 0.99995 5e-05 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-20150615-213540" (
"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 26.187ms