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

4 rows where group = "B" sorted by group_fourth

View and edit SQL

Suggested facets: group_third_no_advance, group_fourth, sixteen

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
2 Germany B 95.78021737 3.81206702 0.39797638 0.9593 0.03955 0.0011 5e-05 0.0 0.99995 0.8315 0.6251 0.3901 0.28105
8 Norway B 89.11478895 2.22789229 0.78212022 0.0389 0.9228 0.03825 5e-05 0.0 0.99995 0.54525 0.2696 0.1016 0.02485
20 Ivory Coast B 72.98859289 1.34597674 2.5625203 0.0016 0.0366 0.31 0.19265 0.45915 0.3482 0.0279 0.00385 0.00055 0.0001
23 Thailand B 67.55780405 0.871978 2.78188416 0.0001 0.00105 0.1723 0.2857 0.54085 0.17345 0.00585 0.0003 5e-05 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 25.686ms