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

6 rows where sixteen = "1.0"

View and edit SQL

Suggested facets: group, group_first

group_second

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
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
3 Japan C 92.49655981 2.83066067 0.55509327 0.99725 0.00275 0.0 0.0 0.0 1.0 0.79315 0.39835 0.23585 0.088
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
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
8 Norway B 89.03152686 2.2188491 0.79456345 0.0 1.0 0.0 0.0 0.0 1.0 0.52585 0.24475 0.08945 0.0242
12 China A 85.26258762 1.49017684 0.77733582 0.0 1.0 0.0 0.0 0.0 1.0 0.5522 0.0975 0.0176 0.0046

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 30.124ms