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

24 rows sorted by final

View and edit SQL

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

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
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
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
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
18 Nigeria D 86.03082982 1.7752345 0.9427305 0.004 0.0172 0.06585 0.0145 0.89845 0.08705 0.0177 0.00715 0.0023 0.00065
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
17 Colombia F 80.01802084 1.04392551 1.18176089 0.21315 0.2676 0.5192 5e-05 0.0 0.99995 0.1946 0.0363 0.00545 0.00085
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
15 Cameroon C 80.92182581 1.28530933 1.30124503 0.0013 0.3029 0.6947 0.0011 0.0 0.9989 0.2371 0.0457 0.0076 0.00105
13 Switzerland C 84.18604549 1.96127015 1.4907697 0.00145 0.69435 0.30375 0.00045 0.0 0.99955 0.40225 0.0811 0.01535 0.0029
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
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
9 England F 89.22663883 2.20680924 0.73620412 0.5123 0.1697 0.30795 0.0085 0.00155 0.98995 0.5174 0.17185 0.0594 0.0226
10 Australia D 89.22646948 2.41648156 0.96580428 0.0746 0.4603 0.38205 0.0429 0.04015 0.91695 0.29245 0.146 0.0604 0.01745
7 Sweden D 91.46095872 2.68585304 0.69547583 0.07825 0.3857 0.20645 0.2682 0.0614 0.6704 0.2911 0.17615 0.08635 0.0327
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
6 France F 91.86229527 2.75994623 0.66423541 0.27455 0.483 0.13235 0.0001 0.11 0.8899 0.56705 0.2811 0.12995 0.0518
5 Brazil E 92.20151735 2.74667404 0.55153209 1.0 0.0 0.0 0.0 0.0 1.0 0.5448 0.298 0.17155 0.06185
4 Canada A 89.48663963 2.20450402 0.67258603 1.0 0.0 0.0 0.0 0.0 1.0 0.807 0.46265 0.2162 0.07175
3 Japan C 92.49655981 2.83066067 0.55509327 0.99725 0.00275 0.0 0.0 0.0 1.0 0.79315 0.39835 0.23585 0.088
2 USA D 95.2719922 3.60761198 0.41685075 0.84315 0.1368 0.02 5e-05 0.0 0.99995 0.8457 0.73695 0.4262 0.2947
1 Germany B 95.70278239 3.75700988 0.38744414 1.0 0.0 0.0 0.0 0.0 1.0 0.8273 0.6929 0.43975 0.31675

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