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

10 rows where group_fourth = "0.0" sorted by wspi

View and edit SQL

Suggested facets: group, group_first, group_second, group_third_advance, group_third_no_advance, sixteen

group_fourth

  • 0.0 · 10
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
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
18 Colombia F 80.02198821 1.04381691 1.18170181 0.2203 0.26175 0.51785 0.0001 0.0 0.9999 0.1951 0.0355 0.00515 0.00055
15 Cameroon C 80.92597624 1.2852254 1.30118231 0.0008 0.3008 0.69795 0.00045 0.0 0.99955 0.2635 0.0495 0.0084 0.0013
13 Switzerland C 84.18821549 1.96139031 1.49125943 0.0019 0.6965 0.3013 0.0003 0.0 0.9997 0.40845 0.0844 0.01685 0.00355
8 Norway B 89.02880437 2.21857626 0.79569614 0.0 1.0 0.0 0.0 0.0 1.0 0.52855 0.2724 0.10025 0.0235
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
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
3 Japan C 92.50588778 2.83311783 0.55572662 0.9973 0.0027 0.0 0.0 0.0 1.0 0.7814 0.39825 0.23755 0.089
2 USA D 95.27805283 3.60990734 0.4174047 0.8519 0.1302 0.01785 5e-05 0.0 0.99995 0.84825 0.73055 0.4217 0.28915
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

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