womens-world-cup-predictions/wwc-forecast-20150607-180420

24 rows sorted by rowid

View and edit SQL

Suggested facets: group

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.96244315 3.8858248 0.38917037 0.88795 0.1113 0.0007 5e-05 0.0 0.99995 0.84555 0.65845 0.44425 0.32155
2 USA D 95.36187927 3.67179536 0.43360639 0.64565 0.2366 0.0793 0.01145 0.027 0.96155 0.79955 0.64795 0.3915 0.2585
3 Japan C 92.71516942 2.90422452 0.56170946 0.7946 0.16965 0.03345 0.0015 0.0008 0.9977 0.77935 0.4001 0.22215 0.08765
4 Canada A 90.07159814 2.34061146 0.67849899 0.69715 0.22285 0.0642 0.003 0.0128 0.9842 0.73565 0.38965 0.1829 0.0684
5 France F 92.44115291 2.87430844 0.6131556 0.60295 0.291 0.075 0.01085 0.0202 0.96895 0.6647 0.29765 0.14815 0.06805
6 Brazil E 92.25388021 2.81418985 0.60381919 0.6953 0.2204 0.06505 0.0075 0.01175 0.98075 0.50695 0.2731 0.1531 0.06175
7 Sweden D 91.63978686 2.69767184 0.65427273 0.2176 0.38165 0.20255 0.0555 0.1427 0.8018 0.4576 0.27715 0.1288 0.0504
8 England F 89.59574852 2.28511686 0.73286285 0.3179 0.43345 0.1472 0.0383 0.06315 0.89855 0.4779 0.1945 0.07435 0.02155
9 Norway B 88.94452306 2.21127408 0.80374862 0.11165 0.83775 0.0461 0.00445 5e-05 0.9955 0.50485 0.2313 0.08335 0.0211
10 Australia D 88.80556149 2.35813644 0.99582273 0.0947 0.2385 0.2602 0.1002 0.3064 0.5934 0.2435 0.12215 0.04795 0.0154
11 Netherlands A 86.36597944 1.89759546 1.00657464 0.23895 0.41315 0.25585 0.0351 0.05695 0.90795 0.44445 0.1382 0.03675 0.00865
12 Spain E 84.71973835 1.62047309 1.01574338 0.1551 0.3611 0.2721 0.0809 0.1308 0.7883 0.19345 0.0512 0.0137 0.00345
13 Nigeria D 85.70672075 1.65565061 0.86991926 0.04205 0.14325 0.19875 0.09205 0.5239 0.38405 0.1166 0.0471 0.01385 0.0029
14 China A 85.09301478 1.44478943 0.75442295 0.04065 0.27785 0.2658 0.10005 0.31565 0.5843 0.2327 0.05895 0.01335 0.00285
15 Switzerland C 83.71138727 1.88511389 1.48638627 0.14535 0.4927 0.24825 0.06435 0.04935 0.8863 0.33405 0.07445 0.01695 0.00275
16 South Korea E 84.24516078 1.75169575 1.24582607 0.1385 0.3461 0.27755 0.08985 0.148 0.76215 0.1784 0.0474 0.01225 0.00265
17 Mexico F 81.11906488 1.52751824 1.52976527 0.0535 0.16915 0.28275 0.1276 0.367 0.5054 0.11305 0.02795 0.0059 0.001
18 New Zealand A 82.20322954 1.40702925 1.21948134 0.02325 0.08615 0.203 0.073 0.6146 0.3124 0.08595 0.01745 0.00345 0.0006
19 Cameroon C 79.2248517 1.11216401 1.37645252 0.0584 0.3074 0.37385 0.132 0.12835 0.73965 0.1773 0.02825 0.00455 0.00045
20 Colombia F 78.06807848 0.87093206 1.29111548 0.02565 0.1064 0.20265 0.11565 0.54965 0.3347 0.06005 0.0122 0.0023 0.0003
21 Costa Rica E 72.83054607 0.82479051 2.01103831 0.0111 0.0724 0.12425 0.0828 0.70945 0.20775 0.01435 0.0019 0.00015 5e-05
22 Ivory Coast B 72.83575461 1.35032858 2.58569462 0.0003 0.04965 0.1569 0.33625 0.4569 0.20685 0.0241 0.0026 0.0003 0.0
23 Ecuador C 63.37774164 0.48714627 2.89253619 0.00165 0.03025 0.0742 0.0724 0.8215 0.1061 0.0057 0.00025 0.0 0.0
24 Thailand B 67.46867771 0.87308845 2.79142932 5e-05 0.0013 0.09035 0.36525 0.54305 0.0917 0.00425 0.0001 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150607-180420" (
"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 28.742ms