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

5 rows where group_second = "0.0"

View and edit SQL

Suggested facets: group_first, group_third_advance, group_third_no_advance, group_fourth, quarter, semi, final

sixteen

win

group

group_second

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
1 Germany B 95.70604569 3.75786164 0.3874431 1.0 0.0 0.0 0.0 0.0 1.0 0.8199 0.6844 0.4341 0.312
4 Brazil E 92.20765171 2.74815648 0.5521339 1.0 0.0 0.0 0.0 0.0 1.0 0.54835 0.2943 0.18195 0.06985
22 Thailand B 68.33002325 0.90011005 2.71244876 0.0 0.0 0.24625 0.75375 0.0 0.24625 0.00375 0.0001 0.0 0.0
23 Ecuador C 55.74511094 0.49999971 3.86419264 0.0 0.0 5e-05 0.0 0.99995 5e-05 0.0 0.0 0.0 0.0
24 Ivory Coast B 71.84368999 1.37917421 2.76116937 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0

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 33.952ms