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

24 rows

View and edit SQL

Suggested facets: group, group_third_no_advance, group_fourth, sixteen, 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.4322931 3.70131963 0.43740045 0.8182 0.1405 0.03365 0.00055 0.0071 0.99235 0.8733 0.74285 0.4372 0.3009
2 Germany B 95.78351283 3.81262172 0.39799119 0.9606 0.0382 0.00115 5e-05 0.0 0.99995 0.83005 0.6218 0.39085 0.28005
3 Japan C 92.55632773 2.83754998 0.53780244 0.85415 0.12485 0.02095 0.0 5e-05 0.99995 0.78135 0.39795 0.23255 0.09035
4 Canada A 90.06968716 2.34215567 0.67999669 0.8004 0.1041 0.0736 0.0006 0.0213 0.9781 0.7504 0.43285 0.21035 0.07285
5 Brazil E 92.29672254 2.80168163 0.5773637 0.9013 0.0882 0.00815 0.0001 0.00225 0.99765 0.55365 0.311 0.1812 0.07095
6 France F 92.44466841 2.84955967 0.58504945 0.8976 0.084 0.01315 0.0001 0.00515 0.99475 0.7531 0.28875 0.12735 0.0652
7 Sweden D 91.66473032 2.7675102 0.7234729 0.1188 0.3964 0.17975 0.12265 0.1824 0.69495 0.3538 0.21085 0.10125 0.0389
8 Norway B 89.10931144 2.22777829 0.78393265 0.0376 0.9246 0.03775 5e-05 0.0 0.99995 0.5443 0.25525 0.09695 0.0254
9 England F 89.29824217 2.21098641 0.72146333 0.0603 0.6216 0.1853 0.02855 0.10425 0.8672 0.41515 0.19975 0.0782 0.0223
10 Australia D 88.82772117 2.37914531 1.01410579 0.01985 0.25445 0.2675 0.0489 0.4093 0.5418 0.174 0.08255 0.0337 0.01035
11 Netherlands A 85.98939467 1.83137281 1.01032202 0.0833 0.1844 0.5614 0.04665 0.12425 0.8291 0.29165 0.08535 0.0256 0.00565
12 Nigeria D 86.61740038 1.8625092 0.92041257 0.04315 0.20865 0.21695 0.13005 0.4012 0.46875 0.126 0.05435 0.0195 0.00445
13 China A 85.29454998 1.44993025 0.72491974 0.08295 0.56015 0.20465 0.0096 0.14265 0.84775 0.399 0.08415 0.0185 0.0039
14 Spain E 84.10182972 1.56323472 1.06774429 0.0697 0.36515 0.1362 0.2402 0.18875 0.57105 0.12575 0.0297 0.0091 0.0026
15 Switzerland C 83.53711649 1.80764779 1.43446895 0.00945 0.4249 0.4914 0.055 0.01925 0.92575 0.3155 0.0675 0.0132 0.0018
16 South Korea E 83.85353091 1.67922724 1.23861017 0.0194 0.41975 0.276 0.0627 0.22215 0.71515 0.13915 0.02995 0.00535 0.00145
17 Cameroon C 80.57860685 1.24706908 1.31292096 0.1364 0.4498 0.4098 0.00385 0.00015 0.996 0.29665 0.0489 0.00815 0.0012
18 New Zealand A 82.21307114 1.40862028 1.22226246 0.03335 0.15135 0.09695 0.00655 0.7118 0.28165 0.1112 0.02165 0.00495 0.001
19 Mexico F 80.9853863 1.51460398 1.54018146 0.02655 0.1714 0.1199 0.3022 0.37995 0.31785 0.07575 0.0193 0.0039 0.0005
20 Colombia F 78.09492953 0.86605325 1.28455787 0.01555 0.123 0.09445 0.25635 0.51065 0.233 0.04325 0.00965 0.0015 0.00015
21 Ivory Coast B 72.99119181 1.34597855 2.56244608 0.00155 0.0361 0.2907 0.21265 0.459 0.32835 0.0272 0.0042 0.00055 5e-05
22 Costa Rica E 73.70037787 0.87078416 1.94151969 0.0096 0.1269 0.11275 0.1639 0.58685 0.24925 0.01515 0.00125 0.0001 0.0
23 Thailand B 67.56214244 0.87282324 2.78245234 0.00015 0.0011 0.1555 0.30225 0.541 0.15675 0.00415 0.00045 0.0 0.0
24 Ecuador C 59.00849209 0.43527766 3.38737714 0.0 0.00045 0.0124 0.0066 0.98055 0.01285 0.0005 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150611-200059" (
"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 26.138ms