womens-world-cup-predictions/wwc-forecast-20150626-184421

4 rows where group = "A" sorted by win

View and edit SQL

Suggested facets: group_first, group_second, group_third_advance, group_fourth, sixteen, quarter, semi, final, win

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 ▼
10 Netherlands A 86.35205314 1.87835095 0.9957436 0 0 1 0 0 1 0 0.0 0.0 0.0
19 New Zealand A 82.8177714 1.48014893 1.20273585 0 0 0 0 1 0 0 0.0 0.0 0.0
7 China A 85.39312901 1.48348768 0.74778628 0 1 0 0 0 1 1 0.11915 0.0123 0.0037
4 Canada A 89.37313338 2.15570625 0.6499464 1 0 0 0 0 1 1 0.5659 0.28065 0.07575

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150626-184421" (
"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" INTEGER,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 81.351ms