womens-world-cup-predictions/wwc-forecast-20150609-175933

24 rows

View and edit SQL

Suggested facets: group, group_first, group_fourth, 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 Germany B 95.94823014 3.88019225 0.3893084 0.89165 0.1075 0.0008 5e-05 0.0 0.99995 0.8448 0.64145 0.4103 0.2943
2 USA D 95.42062794 3.69993951 0.43737814 0.8126 0.14675 0.03345 0.00105 0.00615 0.9928 0.8691 0.72315 0.42765 0.2906
3 Japan C 92.55730281 2.83961314 0.53695025 0.85965 0.12105 0.0192 5e-05 5e-05 0.9999 0.7988 0.41665 0.2408 0.0911
4 Canada A 90.04895536 2.33913547 0.67963835 0.6993 0.22425 0.0615 0.0021 0.01285 0.98505 0.7588 0.4062 0.19285 0.0708
5 Brazil E 92.21446599 2.80678967 0.60465394 0.74425 0.1877 0.047 0.0051 0.01595 0.97895 0.5233 0.2812 0.1613 0.0639
6 France F 92.43162871 2.84814158 0.5846703 0.89325 0.0864 0.01435 0.00025 0.00575 0.994 0.7218 0.2838 0.1256 0.06365
7 Sweden D 91.65562729 2.76726911 0.72321732 0.12595 0.3941 0.1826 0.1224 0.17495 0.70265 0.37295 0.2217 0.11055 0.04325
8 Norway B 88.90728476 2.20458922 0.80303237 0.108 0.842 0.04695 0.003 5e-05 0.99695 0.5336 0.2564 0.0949 0.02295
9 England F 89.28819539 2.21047162 0.72120782 0.06015 0.62155 0.186 0.0272 0.1051 0.8677 0.40815 0.1966 0.0778 0.0217
10 Australia D 88.81987934 2.37829853 1.01299087 0.0201 0.25035 0.27035 0.0492 0.41 0.5408 0.1885 0.08515 0.0368 0.0115
11 Netherlands A 86.36976321 1.89806029 1.00703188 0.24095 0.4198 0.2649 0.02 0.05435 0.92565 0.46925 0.1363 0.03665 0.0089
12 Nigeria D 86.61167128 1.86283981 0.92026151 0.04135 0.2088 0.21485 0.1261 0.4089 0.465 0.13815 0.0572 0.01855 0.0042
13 China A 85.09496106 1.44493518 0.7551753 0.0387 0.27225 0.2944 0.07835 0.3163 0.60535 0.24125 0.05535 0.0138 0.0033
14 Switzerland C 83.5263457 1.80662801 1.43389636 0.00845 0.4267 0.4923 0.0544 0.01815 0.92745 0.29085 0.06445 0.0129 0.0026
15 South Korea E 84.27612258 1.75434056 1.24423364 0.1576 0.39995 0.22485 0.0454 0.1722 0.7824 0.17275 0.04335 0.0124 0.0022
16 Spain E 84.09061386 1.56291667 1.06800892 0.0844 0.30695 0.17865 0.22055 0.20945 0.57 0.1246 0.03145 0.0079 0.00185
17 New Zealand A 82.2117294 1.40741829 1.21994905 0.02105 0.0837 0.22465 0.0541 0.6165 0.3294 0.0919 0.0191 0.005 0.0012
18 Cameroon C 80.57286896 1.24722204 1.31289424 0.13185 0.4516 0.4119 0.0043 0.00035 0.99535 0.2827 0.0455 0.00815 0.00115
19 Mexico F 80.9747863 1.51372779 1.53979833 0.0296 0.17015 0.1254 0.2898 0.38505 0.32515 0.0758 0.01915 0.00395 0.0006
20 Ivory Coast B 73.05803487 1.34694774 2.55348364 0.00025 0.04925 0.2993 0.1945 0.4567 0.3488 0.02945 0.0054 0.0007 0.00015
21 Colombia F 78.08324639 0.86521312 1.2846177 0.017 0.1219 0.1033 0.2537 0.5041 0.2422 0.0428 0.00875 0.00135 0.0001
22 Costa Rica E 73.69517645 0.87077135 1.94161309 0.01375 0.1054 0.12475 0.1537 0.6024 0.2439 0.01505 0.0015 0.0001 0.0
23 Thailand B 67.47230408 0.87224945 2.79308378 5e-05 0.00125 0.16595 0.2895 0.54325 0.16725 0.00545 0.0002 0.0 0.0
24 Ecuador C 59.00028266 0.43473841 3.38741809 5e-05 0.00065 0.0126 0.00525 0.98145 0.0133 0.0002 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150609-175933" (
"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 31.803ms