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

4 rows where group = "F" sorted by group_third_no_advance

View and edit SQL

sixteen

group_fourth

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
20 Mexico F 81.28958001 1.54454892 1.52594317 0.0 0.08225 0.0307 0.0 0.88705 0.11295 0.0283 0.0101 0.0016 0.0001
18 Colombia F 80.02198821 1.04381691 1.18170181 0.2203 0.26175 0.51785 0.0001 0.0 0.9999 0.1951 0.0355 0.00515 0.00055
6 France F 91.86410328 2.76000286 0.66457899 0.27275 0.48335 0.13285 0.00035 0.1107 0.88895 0.55785 0.28705 0.1343 0.05585
9 England F 89.23346354 2.20776772 0.73647349 0.50695 0.17265 0.31295 0.0052 0.00225 0.99255 0.51755 0.17965 0.0607 0.0219

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