womens-world-cup-predictions/wwc-forecast-20150617-175941

24 rows

View and edit SQL

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

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 USA D 95.18432294 3.55777213 0.40283754 1 0.0 0.0 0.0 0.0 1.0 0.95035 0.85305 0.47415 0.3339
2 Germany B 95.69772691 3.75182433 0.38770741 1 0.0 0.0 0.0 0.0 1.0 0.7533 0.56175 0.33535 0.2536
3 Japan C 92.25298531 2.75295748 0.54592025 1 0.0 0.0 0.0 0.0 1.0 0.7366 0.39665 0.2408 0.08855
4 Brazil E 92.2284253 2.75054288 0.55052098 1 0.0 0.0 0.0 0.0 1.0 0.6258 0.3492 0.2149 0.0774
5 Canada A 89.48855243 2.20467347 0.6744485 1 0.0 0.0 0.0 0.0 1.0 0.75185 0.4334 0.2044 0.0671
6 France F 92.26328835 2.83879649 0.63685927 1 0.0 0.0 0.0 0.0 1.0 0.8015 0.2824 0.11385 0.0634
7 England F 89.20023328 2.22134654 0.76034442 0 1.0 0.0 0.0 0.0 1.0 0.50365 0.24505 0.1001 0.02655
8 Norway B 89.03956367 2.21752377 0.79332126 0 1.0 0.0 0.0 0.0 1.0 0.49635 0.23725 0.0957 0.0242
9 Sweden D 91.38029205 2.66298179 0.69518464 0 0.0 0.9449 0.0551 0.0 0.9449 0.23965 0.1271 0.04605 0.02325
10 Australia D 89.27165832 2.4085638 0.94870502 0 1.0 0.0 0.0 0.0 1.0 0.3742 0.1685 0.08565 0.02275
11 Netherlands A 86.24590432 1.85542934 0.98962701 0 0.0 1.0 0.0 0.0 1.0 0.2626 0.08635 0.0355 0.00715
12 China A 85.26407956 1.48981393 0.77688218 0 1.0 0.0 0.0 0.0 1.0 0.61 0.0905 0.0176 0.00555
13 Switzerland C 83.78851968 1.94102122 1.53862424 0 0.0 1.0 0.0 0.0 1.0 0.24815 0.0843 0.0227 0.003
14 Cameroon C 81.48295839 1.34788615 1.27764638 0 1.0 0.0 0.0 0.0 1.0 0.39 0.03515 0.00465 0.00115
15 Spain E 83.89071904 1.477821 1.01359021 0 0.54645 0.0134 0.0781 0.36205 0.55985 0.1211 0.0169 0.0036 0.0011
16 South Korea E 83.28586461 1.6790032 1.33888908 0 0.34975 0.0123 0.12485 0.5131 0.36205 0.0733 0.0104 0.0021 0.00085
17 Colombia F 80.28728516 1.10479078 1.20484123 0 0.0 1.0 0.0 0.0 1.0 0.0544 0.02165 0.00285 0.0005
18 Costa Rica E 74.44425438 0.9812938 1.9553374 0 0.1038 0.0294 0.74195 0.12485 0.1332 0.0072 0.0004 5e-05 0.0
19 New Zealand A 82.78500052 1.47407676 1.19980172 0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.83890169 1.38378658 2.7644246 0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
21 Thailand B 68.3323134 0.89724383 2.7063306 0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0 0.0
22 Mexico F 80.42032904 1.48626795 1.60121484 0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
23 Nigeria D 85.86611918 1.71614219 0.91087197 0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
24 Ecuador C 58.05365874 0.4815121 3.55526255 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-20150617-175941" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" INTEGER,
  "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 34.99ms