womens-world-cup-predictions/wwc-forecast-20150608-212619

24 rows

View and edit SQL

Suggested facets: group, 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.93585179 3.88092076 0.38854707 0.89155 0.1076 0.0008 5e-05 0.0 0.99995 0.85 0.6584 0.4309 0.3097
2 USA D 95.39731841 3.69686235 0.43737016 0.80915 0.15145 0.0305 0.00195 0.00695 0.9911 0.86315 0.7098 0.418 0.2837
3 Japan C 92.68681364 2.90237902 0.56128432 0.73305 0.20675 0.05685 0.00265 0.0007 0.99665 0.76745 0.39855 0.2227 0.0885
4 Canada A 90.03614385 2.33859123 0.67875281 0.6944 0.2264 0.06505 0.0031 0.01105 0.98585 0.74245 0.387 0.1892 0.06965
5 France F 92.41422833 2.87325434 0.61302906 0.6064 0.29075 0.07195 0.013 0.0179 0.9691 0.6618 0.302 0.1467 0.0668
6 Brazil E 92.1959762 2.80555417 0.6044705 0.69725 0.21615 0.066 0.00735 0.01325 0.9794 0.52895 0.28845 0.1569 0.059
7 Sweden D 91.6431383 2.7668839 0.72224365 0.12515 0.3889 0.1532 0.1562 0.17655 0.66725 0.36405 0.2196 0.10585 0.0393
8 England F 89.56943624 2.28504869 0.73299403 0.3173 0.43415 0.1469 0.0403 0.06135 0.89835 0.47265 0.19395 0.0757 0.02255
9 Norway B 88.92064509 2.21075886 0.80368445 0.10805 0.8418 0.04475 0.0054 0.0 0.9946 0.50885 0.2357 0.08705 0.02165
10 Australia D 88.80045835 2.37596607 1.01178279 0.02205 0.24815 0.23425 0.08335 0.4122 0.50445 0.1803 0.0887 0.0378 0.0119
11 Netherlands A 86.35648023 1.89735099 1.00649664 0.2433 0.41165 0.25215 0.0383 0.0546 0.9071 0.44355 0.1301 0.0367 0.0085
12 Nigeria D 86.60111454 1.86296661 0.9200688 0.04365 0.2115 0.17695 0.1636 0.4043 0.4321 0.13535 0.0595 0.0187 0.00515
13 Spain E 84.71436989 1.62047826 1.01572791 0.15265 0.36265 0.26155 0.08435 0.1388 0.77685 0.19115 0.05115 0.01405 0.00345
14 China A 85.08595067 1.4442457 0.7539916 0.0407 0.27585 0.2624 0.10705 0.314 0.57895 0.2276 0.0522 0.0123 0.00295
15 Switzerland C 83.68882982 1.881828 1.48610976 0.1313 0.38595 0.3966 0.07 0.01615 0.91385 0.3246 0.07375 0.0172 0.0027
16 South Korea E 84.26578546 1.75421106 1.24400538 0.13695 0.34745 0.2684 0.0967 0.1505 0.7528 0.1688 0.04285 0.01015 0.00235
17 New Zealand A 82.20170061 1.40665332 1.21919402 0.0216 0.0861 0.19495 0.077 0.62035 0.30265 0.08705 0.01865 0.0039 0.00115
18 Cameroon C 80.56441953 1.24722875 1.31289395 0.13565 0.4068 0.44775 0.00945 0.00035 0.9902 0.26995 0.0471 0.009 0.0006
19 Mexico F 81.11326048 1.52630726 1.52958821 0.05245 0.1672 0.27845 0.13805 0.36385 0.4981 0.11435 0.02685 0.005 0.00035
20 Colombia F 77.89676335 0.85404569 1.30000181 0.02385 0.1079 0.19335 0.118 0.5569 0.3251 0.05465 0.01095 0.00155 5e-05
21 Ivory Coast B 73.05593861 1.34705766 2.55334903 0.00035 0.04915 0.17145 0.32345 0.4556 0.22095 0.0245 0.00295 0.00045 0.0
22 Costa Rica E 72.84929402 0.82462768 2.01045381 0.01315 0.07375 0.1285 0.08715 0.69745 0.2154 0.01295 0.00145 0.0002 0.0
23 Thailand B 67.47696357 0.87246479 2.79265328 5e-05 0.00145 0.08945 0.36465 0.5444 0.09095 0.0057 0.0003 0.0 0.0
24 Ecuador C 58.96704705 0.4336687 3.39073466 0.0 0.0005 0.0078 0.0089 0.9828 0.0083 0.00015 5e-05 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150608-212619" (
"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.565ms