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

4 rows where group = "A"

View and edit SQL

sixteen

semi

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
5 Canada A 89.7058039 2.24199953 0.6623747 0.68935 0.12235 0.18825 5e-05 0.0 0.99995 0.72525 0.3954 0.1863 0.06615
11 Netherlands A 86.02741298 1.83711664 1.01192734 0.1542 0.10545 0.60505 0.03095 0.10435 0.8647 0.2935 0.0951 0.03075 0.00755
12 China A 85.29283885 1.44790154 0.72614198 0.1564 0.4999 0.13555 0.0062 0.20195 0.79185 0.40305 0.09205 0.0223 0.00495
19 New Zealand A 82.41742402 1.37154141 1.15029009 0.0 0.2723 0.034 0.0 0.6937 0.3063 0.13695 0.0206 0.0029 0.00035

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.861ms