womens-world-cup-predictions/wwc-forecast-20150613-175552

24 rows sorted by final

View and edit SQL

Suggested facets: group, group_first, group_second, group_third_advance, group_third_no_advance, sixteen, semi, final

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
22 Thailand B 68.18234521 0.92128397 2.75660255 0.0008 0.0037 0.2074 0.78615 0.00195 0.2119 0.00365 5e-05 0.0 0.0
23 Ivory Coast B 71.29837001 1.32775537 2.78149283 0.0 0.0 0.00045 0.0015 0.99805 0.00045 0.0 0.0 0.0 0.0
24 Ecuador C 55.75343506 0.49991471 3.86424921 0.0 0.0 5e-05 0.0 0.99995 5e-05 0.0 0.0 0.0 0.0
21 Costa Rica E 73.71261864 0.87643566 1.94910559 0.0064 0.13465 0.077 0.21085 0.5711 0.21805 0.0249 0.00175 0.0003 5e-05
20 Mexico F 81.28047897 1.54372644 1.52748592 0.0 0.0829 0.03195 0.0 0.88515 0.11485 0.02545 0.008 0.00165 5e-05
18 Nigeria D 86.04752124 1.77916714 0.94511582 0.0039 0.0178 0.0648 0.0146 0.8989 0.0865 0.01765 0.0076 0.00285 0.0006
17 New Zealand A 82.43301795 1.37195381 1.14900751 0.0 0.2715 0.03605 0.0 0.69245 0.30755 0.1361 0.0205 0.00305 0.0006
16 Spain E 83.86502873 1.48568653 1.02840841 0.0 0.3944 0.02495 0.3736 0.20705 0.41935 0.1471 0.0219 0.00425 0.0012
19 Colombia F 80.02814071 1.04370789 1.18163869 0.218 0.26605 0.5159 5e-05 0.0 0.99995 0.1974 0.03485 0.0055 0.00055
14 South Korea E 83.88350506 1.6798036 1.23769505 0.003 0.46155 0.18025 0.13335 0.22185 0.6448 0.1919 0.03375 0.00725 0.00195
15 Cameroon C 80.91988285 1.28452629 1.30237999 0.00135 0.2938 0.7018 0.00305 0.0 0.99695 0.25905 0.05185 0.00935 0.0012
13 Switzerland C 84.19115186 1.96188397 1.49201498 0.00195 0.7029 0.2931 0.00205 0.0 0.99795 0.40835 0.0849 0.0173 0.00305
12 China A 85.31386994 1.45200013 0.7273178 0.157 0.49945 0.1278 0.01395 0.2018 0.78425 0.3971 0.08815 0.02145 0.00525
11 Netherlands A 86.03342262 1.83639022 1.01052005 0.153 0.1033 0.5413 0.09665 0.10575 0.7976 0.27635 0.0885 0.02695 0.0055
10 Australia D 89.23149626 2.41850379 0.96774469 0.07335 0.4499 0.35095 0.0842 0.0416 0.8742 0.2872 0.14425 0.05705 0.01875
9 England F 89.24783789 2.20987408 0.73551821 0.51205 0.16925 0.30045 0.0162 0.00205 0.98175 0.5163 0.1745 0.0606 0.02005
7 Sweden D 91.47351815 2.68701277 0.69364792 0.07955 0.3965 0.2014 0.26305 0.0595 0.67745 0.3035 0.1764 0.0841 0.0318
8 Norway B 89.12227886 2.22534161 0.78164177 0.04145 0.95815 0.00035 5e-05 0.0 0.99995 0.53 0.27415 0.1034 0.02605
6 France F 91.87000347 2.76208456 0.66463449 0.26995 0.4818 0.13485 0.0006 0.1128 0.8866 0.55025 0.2866 0.1378 0.05705
5 Brazil E 92.23099686 2.75425694 0.55112544 0.9906 0.0094 0.0 0.0 0.0 1.0 0.5428 0.28715 0.17075 0.06485
4 Canada A 89.71430982 2.24326631 0.66172441 0.69 0.12575 0.1841 0.00015 0.0 0.99985 0.72835 0.39595 0.1889 0.06835
3 Japan C 92.47736082 2.82824029 0.55817337 0.9967 0.0033 0.0 0.0 0.0 1.0 0.77805 0.40185 0.23605 0.0888
2 USA D 95.27276268 3.61136608 0.41772521 0.84315 0.1358 0.021 5e-05 0.0 0.99995 0.85725 0.7329 0.43015 0.2948
1 Germany B 95.76768045 3.79610826 0.39699025 0.95765 0.03815 0.00415 5e-05 0.0 0.99995 0.8213 0.68445 0.4313 0.3095

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150613-175552" (
"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 36.677ms