womens-world-cup-predictions/wwc-forecast-20150613-175552

4 rows where group = "A" sorted by wspi_offense

View and edit SQL

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
17 New Zealand A 82.43301795 1.37195381 1.14900751 0.0 0.2715 0.03605 0.0 0.69245 0.30755 0.1361 0.0205 0.00305 0.0006
12 China A 85.31386994 1.45200013 0.7273178 0.157 0.49945 0.1278 0.01395 0.2018 0.78425 0.3971 0.08815 0.02145 0.00525
11 Netherlands A 86.03342262 1.83639022 1.01052005 0.153 0.1033 0.5413 0.09665 0.10575 0.7976 0.27635 0.0885 0.02695 0.0055
4 Canada A 89.71430982 2.24326631 0.66172441 0.69 0.12575 0.1841 0.00015 0.0 0.99985 0.72835 0.39595 0.1889 0.06835

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150613-175552" (
"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 28.837ms