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

11 rows where group_first = "0.0"

View and edit SQL

Suggested facets: group, group_third_advance, group_third_no_advance, group_fourth, sixteen, quarter, semi, final, win

group_second

group_first

  • 0.0 · 11
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
8 Norway B 89.03152686 2.2188491 0.79456345 0.0 1.0 0.0 0.0 0.0 1.0 0.52585 0.24475 0.08945 0.0242
11 Netherlands A 86.25827639 1.85865642 0.98939868 0.0 0.0 0.99995 5e-05 0.0 0.99995 0.2197 0.07085 0.02495 0.005
12 China A 85.26258762 1.49017684 0.77733582 0.0 1.0 0.0 0.0 0.0 1.0 0.5522 0.0975 0.0176 0.0046
14 Spain E 83.91743339 1.48399124 1.01584968 0.0 0.5484 0.01285 0.0785 0.36025 0.56125 0.19525 0.02735 0.00695 0.00215
16 South Korea E 83.30212814 1.67748517 1.33473725 0.0 0.3473 0.01295 0.12775 0.512 0.36025 0.1198 0.01605 0.00345 0.0009
19 Mexico F 81.2808519 1.543547 1.52556614 0.0 0.0797 0.03185 0.0 0.88845 0.11155 0.02605 0.0077 0.0012 0.0001
20 Costa Rica E 74.46848601 0.98090239 1.95309483 0.0 0.1043 0.0704 0.69755 0.12775 0.1747 0.0199 0.0015 5e-05 0.0
21 Thailand B 68.33349734 0.89889336 2.71014832 0.0 0.0 0.2397 0.7603 0.0 0.2397 0.00365 0.0001 0.0 0.0
22 Ecuador C 55.74307688 0.5000465 3.86426127 0.0 0.0 5e-05 0.0 0.99995 5e-05 0.0 0.0 0.0 0.0
23 Ivory Coast B 71.8384438 1.37944188 2.76162647 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
24 New Zealand A 82.7981143 1.47447794 1.19842544 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-213540" (
"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.606ms