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

24 rows

View and edit SQL

Suggested facets: group, group_first, group_second, group_third_no_advance, group_fourth, sixteen, semi, 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.44290425 3.70292578 0.4376543 0.812 0.1485 0.033 0.00045 0.00605 0.9935 0.87235 0.74485 0.44335 0.3062
2 Germany B 95.74916985 3.79516532 0.39829414 0.95905 0.03685 0.00405 5e-05 0.0 0.99995 0.82595 0.61995 0.385 0.27385
3 Japan C 92.57391454 2.83868174 0.5382307 0.8588 0.1228 0.01835 5e-05 0.0 0.99995 0.79255 0.4034 0.2403 0.0933
4 Brazil E 92.3123019 2.80203912 0.57765478 0.90055 0.089 0.00765 0.0003 0.0025 0.9972 0.55025 0.30065 0.1797 0.0712
5 France F 92.46080036 2.85000659 0.58521663 0.89785 0.08395 0.01265 0.0002 0.00535 0.99445 0.75285 0.29035 0.1292 0.06425
6 Canada A 89.72874009 2.24493613 0.66008169 0.6911 0.1234 0.18525 0.00025 0.0 0.99975 0.7188 0.38975 0.18515 0.0634
7 Sweden D 91.67714223 2.76758143 0.72404047 0.1262 0.3813 0.1658 0.14505 0.18165 0.6733 0.3469 0.20775 0.10325 0.04015
8 Norway B 89.13292628 2.22897734 0.78338611 0.0401 0.9596 0.00025 5e-05 0.0 0.99995 0.55645 0.2813 0.10445 0.0288
9 England F 89.31576378 2.21156092 0.72162317 0.05875 0.6188 0.1931 0.02755 0.1018 0.87065 0.40485 0.2035 0.0797 0.02375
10 Australia D 88.84832573 2.38040512 1.01438424 0.0213 0.2576 0.2727 0.04565 0.40275 0.5516 0.1755 0.08395 0.03565 0.01055
11 Netherlands A 86.02364985 1.83471689 1.01055558 0.15005 0.10495 0.60195 0.03895 0.1041 0.85695 0.2902 0.0898 0.02685 0.0058
12 China A 85.31285809 1.45106603 0.72587017 0.15885 0.5042 0.13435 0.0062 0.1964 0.7974 0.3987 0.09455 0.02265 0.00525
13 Nigeria D 86.6025572 1.85731594 0.92101473 0.0405 0.2126 0.1898 0.14755 0.40955 0.4429 0.13035 0.05595 0.0187 0.0049
14 Switzerland C 83.55623793 1.80814958 1.43463898 0.008 0.42455 0.49075 0.0559 0.0208 0.9233 0.32565 0.07315 0.01545 0.00255
15 Spain E 84.11896394 1.56340061 1.06788262 0.0688 0.36575 0.12085 0.2536 0.191 0.5554 0.129 0.02925 0.00885 0.0025
16 South Korea E 83.87823357 1.68085308 1.23902249 0.01995 0.4188 0.27765 0.0545 0.2291 0.7164 0.1413 0.03095 0.0056 0.0014
17 Cameroon C 80.56875655 1.24364469 1.31347923 0.13315 0.4522 0.41165 0.00275 0.00025 0.997 0.31275 0.05075 0.0086 0.001
18 New Zealand A 82.42583767 1.37005922 1.14739949 0.0 0.26745 0.03305 0.0 0.6995 0.3005 0.13395 0.0196 0.0024 0.0006
19 Mexico F 81.00398925 1.51529673 1.54067366 0.02615 0.1708 0.09845 0.31555 0.38905 0.2954 0.07045 0.0184 0.0034 0.00045
20 Colombia F 78.11131519 0.86597349 1.28451636 0.01725 0.12645 0.08015 0.27235 0.5038 0.22385 0.04015 0.0094 0.0016 0.0001
21 Costa Rica E 73.71606262 0.87074895 1.94146794 0.0107 0.12645 0.10025 0.1852 0.5774 0.2374 0.0134 0.00165 0.0001 0.0
22 Thailand B 68.10445527 0.92240284 2.76724965 0.00075 0.00355 0.55655 0.437 0.00215 0.56085 0.0175 0.0011 5e-05 0.0
23 Ecuador C 59.00567672 0.4352535 3.38889635 0.0 0.00045 0.0109 0.0097 0.97895 0.01135 0.0001 0.0 0.0 0.0
24 Ivory Coast B 71.31510445 1.32912566 2.77957678 0.0 0.0 0.00085 0.0013 0.99785 0.00085 5e-05 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-232844" (
"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.504ms