womens-world-cup-predictions/wwc-forecast-20150611-182114

4 rows where group = "E" sorted by wspi_defense

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
5 Brazil E 92.29068457 2.80078657 0.57738888 0.89885 0.0893 0.0094 0.00015 0.0023 0.99755 0.55105 0.3092 0.1824 0.07165
15 Spain E 84.0992522 1.56327333 1.0677469 0.0707 0.3673 0.14595 0.22155 0.1945 0.58395 0.13595 0.03145 0.00865 0.00195
16 South Korea E 83.83366214 1.67671527 1.23885692 0.01975 0.4174 0.2736 0.0605 0.22875 0.71075 0.1398 0.0296 0.00585 0.00165
22 Costa Rica E 73.69808949 0.8707819 1.94154129 0.0107 0.126 0.11905 0.1698 0.57445 0.25575 0.015 0.00145 0.0002 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150611-182114" (
"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 24.973ms