womens-world-cup-predictions/wwc-forecast-20150621-175918

4 rows where group = "A" sorted by group_third_advance

View and edit SQL

Suggested facets: group_first, group_second, group_third_advance, group_fourth, 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
4 Canada A 89.5109479 2.20922425 0.67481575 0 1 0 0 0 1 0.75945 0.4416 0.2324 0.07055
10 China A 85.3880755 1.48298285 0.74719524 1 0 0 0 0 1 1.0 0.1436 0.01825 0.0051
19 New Zealand A 82.81637141 1.48061027 1.20261383 0 0 0 0 1 0 0.0 0.0 0.0 0.0
9 Netherlands A 86.26855756 1.85744459 0.98829936 0 0 1 0 0 1 0.2715 0.11125 0.04355 0.0073

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150621-175918" (
"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 28.355ms