womens-world-cup-predictions/wwc-forecast-20150612-235650

24 rows

View and edit SQL

Suggested facets: group, group_first, group_second, 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.27163518 3.61275027 0.41716912 0.84655 0.1331 0.0203 5e-05 0.0 0.99995 0.88765 0.7597 0.4394 0.30085
2 Germany B 95.75920062 3.79498355 0.39653698 0.9582 0.03775 0.004 5e-05 0.0 0.99995 0.8083 0.60265 0.3842 0.27455
3 Japan C 92.48142588 2.82936941 0.55783513 0.99735 0.00265 0.0 0.0 0.0 1.0 0.7683 0.39375 0.2416 0.0909
4 Canada A 89.71791779 2.24343349 0.6618187 0.69425 0.11875 0.18695 5e-05 0.0 0.99995 0.73015 0.40945 0.1986 0.07305
5 France F 92.47316 2.85284866 0.58606049 0.8992 0.0823 0.01265 0.00015 0.0057 0.99415 0.7513 0.2953 0.13345 0.069
6 Brazil E 92.31085858 2.80028511 0.57761471 0.90305 0.0874 0.0073 0.0003 0.00195 0.99775 0.5514 0.29235 0.1742 0.06735
7 Sweden D 91.48454935 2.68954934 0.69351727 0.0737 0.39255 0.2678 0.2044 0.06155 0.73405 0.3239 0.18395 0.09025 0.0351
8 Norway B 89.14209161 2.22913725 0.78214121 0.04085 0.95895 0.00015 5e-05 0.0 0.99995 0.5474 0.2744 0.10255 0.0279
9 England F 89.32090127 2.2117951 0.72140675 0.05905 0.6242 0.1842 0.0301 0.10245 0.86745 0.40775 0.2051 0.07765 0.02185
10 Australia D 89.2470411 2.42062719 0.96735781 0.07465 0.45825 0.38555 0.0423 0.03925 0.91845 0.3125 0.143 0.05815 0.01805
11 Netherlands A 86.04501433 1.83677977 1.01022478 0.1501 0.1058 0.5884 0.0515 0.1042 0.8443 0.29105 0.09365 0.0279 0.00585
12 China A 85.32350058 1.45222435 0.72738112 0.1556 0.5033 0.13255 0.00795 0.2006 0.79145 0.39635 0.0908 0.02095 0.0044
13 Switzerland C 84.21491022 1.96276862 1.49073822 0.00165 0.6947 0.30305 0.0006 0.0 0.9994 0.40745 0.0844 0.0163 0.00395
14 Spain E 84.13516439 1.56328388 1.0676424 0.0696 0.3657 0.1037 0.26455 0.19645 0.539 0.12595 0.0286 0.00865 0.0024
15 South Korea E 83.89431564 1.67859637 1.23650762 0.0179 0.4212 0.27085 0.06655 0.2235 0.70995 0.13425 0.0315 0.00575 0.0017
16 Cameroon C 80.93479893 1.28458574 1.30235085 0.001 0.30265 0.6952 0.00115 0.0 0.99885 0.26835 0.055 0.0091 0.0009
17 New Zealand A 82.45693596 1.37133488 1.14650482 0.0 0.27215 0.0326 5e-05 0.6952 0.30475 0.13985 0.0183 0.00265 0.0007
18 Nigeria D 86.05685678 1.77922134 0.94489128 0.00505 0.0161 0.0678 0.01185 0.8992 0.08895 0.0195 0.00745 0.0026 0.0007
19 Mexico F 80.99654181 1.51467333 1.54426328 0.02685 0.1704 0.0906 0.32975 0.3824 0.28785 0.06825 0.0191 0.0042 0.0006
20 Colombia F 78.09324213 0.85238486 1.27576695 0.0149 0.1231 0.0739 0.27865 0.50945 0.2119 0.03925 0.00915 0.00155 0.0002
21 Costa Rica E 73.72813599 0.87255166 1.94527283 0.00945 0.1257 0.0914 0.19535 0.5781 0.22655 0.01425 0.0018 0.00025 0.0
22 Thailand B 68.20634433 0.92126795 2.75636709 0.00085 0.0033 0.4801 0.5132 0.00255 0.48425 0.0068 0.00055 5e-05 0.0
23 Ivory Coast B 71.31719322 1.32783092 2.78160937 0.0 0.0 0.00095 0.0016 0.99745 0.00095 5e-05 5e-05 0.0 0.0
24 Ecuador C 55.32642992 0.49307992 3.91179446 0.0 0.0 5e-05 0.0 0.99995 5e-05 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-20150612-235650" (
"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.696ms