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

24 rows

View and edit SQL

Suggested facets: group, group_third_no_advance, group_fourth, sixteen, 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.94240515 3.88020014 0.38930763 0.8922 0.1073 0.00045 5e-05 0.0 0.99995 0.8542 0.65495 0.4215 0.30545
2 USA D 95.41134423 3.69872773 0.43769705 0.8165 0.14605 0.03005 0.0013 0.0061 0.9926 0.86215 0.71625 0.42115 0.28805
3 Japan C 92.55419836 2.83961915 0.53694739 0.859 0.12045 0.0205 5e-05 0.0 0.99995 0.7932 0.414 0.2404 0.09075
4 Canada A 90.04710025 2.33920354 0.67958126 0.69435 0.22465 0.06525 0.00345 0.0123 0.98425 0.7528 0.4069 0.19545 0.0712
5 France F 92.42914308 2.84828867 0.58464365 0.87405 0.0969 0.02485 0.00055 0.00365 0.9958 0.71145 0.2754 0.1306 0.06565
6 Brazil E 92.21039127 2.80664717 0.60480284 0.69155 0.2204 0.0692 0.0073 0.01155 0.98115 0.518 0.2771 0.15665 0.06075
7 Sweden D 91.65275728 2.76727126 0.72321512 0.12315 0.3924 0.15015 0.15565 0.17865 0.6657 0.35985 0.21245 0.1018 0.03945
8 Norway B 88.90930206 2.20525116 0.80284453 0.1075 0.84225 0.0455 0.00475 0.0 0.99525 0.53365 0.2533 0.0979 0.02395
9 England F 89.28841889 2.21074029 0.72094636 0.05155 0.59385 0.21015 0.05695 0.0875 0.85555 0.39875 0.18745 0.0722 0.01825
10 Australia D 88.81760353 2.3782567 1.01301213 0.02025 0.25165 0.2336 0.08735 0.40715 0.5055 0.1845 0.08735 0.03775 0.0114
11 Netherlands A 86.36880928 1.8980689 1.00702784 0.2459 0.41225 0.2463 0.04095 0.0546 0.90445 0.4561 0.1364 0.03755 0.008
12 Nigeria D 86.6105674 1.86284038 0.92026141 0.0401 0.2099 0.18025 0.16165 0.4081 0.43025 0.13675 0.058 0.0189 0.00415
13 Spain E 84.72551619 1.62091341 1.01611169 0.15545 0.36295 0.2616 0.08475 0.13525 0.78 0.17785 0.0486 0.01415 0.00345
14 China A 85.09506547 1.44500408 0.75512409 0.0398 0.2745 0.26035 0.10745 0.3179 0.57465 0.22485 0.05245 0.0119 0.0027
15 South Korea E 84.27678298 1.75443658 1.24416555 0.14045 0.3463 0.2749 0.09325 0.1451 0.76165 0.17325 0.04685 0.01155 0.0024
16 Switzerland C 83.52637196 1.80663399 1.43389098 0.0097 0.423 0.47595 0.0714 0.01995 0.90865 0.28945 0.0622 0.0113 0.0024
17 Cameroon C 80.57377141 1.24722206 1.31289424 0.1313 0.4558 0.4037 0.009 0.0002 0.9908 0.2778 0.0492 0.0083 0.00095
18 New Zealand A 82.21449094 1.40767371 1.21983316 0.01995 0.0886 0.1964 0.07985 0.6152 0.30495 0.0831 0.0165 0.00345 0.0006
19 Mexico F 81.12292611 1.52626714 1.5295299 0.0501 0.1923 0.2689 0.1338 0.3549 0.5113 0.115 0.02735 0.0051 0.0003
20 Colombia F 77.90512281 0.8540531 1.30002664 0.0243 0.11695 0.1869 0.1179 0.55395 0.32815 0.05845 0.0128 0.00185 0.0001
21 Ivory Coast B 73.06091869 1.34694783 2.55348262 0.0002 0.04955 0.17465 0.32105 0.45455 0.2244 0.02495 0.0032 0.00055 5e-05
22 Costa Rica E 72.8563404 0.82461438 2.01039193 0.01255 0.07035 0.1226 0.0864 0.7081 0.2055 0.0106 0.0011 0.0 0.0
23 Thailand B 67.47659992 0.87225619 2.79303283 5e-05 0.0009 0.0888 0.3648 0.54545 0.08975 0.00315 0.00015 0.0 0.0
24 Ecuador C 58.9689362 0.43368042 3.39070014 0.0 0.00075 0.009 0.0104 0.97985 0.00975 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-20150609-145605" (
"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.953ms