womens-world-cup-predictions/wwc-forecast-20150602-093000

24 rows

View and edit SQL

Suggested facets: group, 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.36678795 3.66911394 0.43303633 0.64725 0.23885 0.0758 0.0122 0.0259 0.9619 0.80235 0.654 0.41755 0.28235
2 Germany B 95.6357677 3.7543806 0.40466678 0.83385 0.15915 0.0062 0.0005 0.0003 0.9992 0.81475 0.6098 0.3954 0.2708
3 Japan C 92.66789611 2.89624622 0.56546943 0.7931 0.16925 0.03355 0.00255 0.00155 0.9959 0.78615 0.4078 0.2314 0.09735
4 France F 92.43907292 2.87534091 0.61259155 0.6017 0.291 0.07555 0.01285 0.0189 0.96825 0.66995 0.3252 0.16 0.07605
5 Canada A 90.08179817 2.36681052 0.70047616 0.5921 0.2424 0.0974 0.01775 0.05035 0.9319 0.68535 0.3633 0.16995 0.0684
6 Brazil E 92.24099451 2.81307458 0.6039692 0.69965 0.21655 0.06335 0.00875 0.0117 0.97955 0.5148 0.2808 0.15365 0.0641
7 Sweden D 91.60986902 2.6929255 0.65406955 0.2116 0.37265 0.20325 0.0638 0.1487 0.7875 0.44755 0.27195 0.1302 0.05045
8 England F 89.56590615 2.28437512 0.73479186 0.3156 0.43675 0.1423 0.04045 0.0649 0.89465 0.4838 0.20725 0.0793 0.0249
9 Norway B 88.73202893 2.19294923 0.82685924 0.15945 0.69035 0.09555 0.0372 0.01745 0.94535 0.46515 0.2171 0.08 0.0209
10 Australia D 88.73815005 2.34993253 0.99736582 0.097 0.237 0.2453 0.11095 0.30975 0.5793 0.25525 0.1284 0.0494 0.01645
11 Netherlands A 86.23081073 1.91988962 1.05255054 0.1807 0.2947 0.215 0.0785 0.2311 0.6904 0.3313 0.10335 0.03065 0.00725
12 China A 85.23997096 1.48275845 0.76340501 0.14475 0.2692 0.22345 0.0834 0.2792 0.6374 0.27985 0.0742 0.0197 0.00425
13 Spain E 84.68690692 1.61991388 1.01583 0.15015 0.3679 0.25485 0.09335 0.13375 0.7729 0.1958 0.05735 0.0162 0.00415
14 Nigeria D 85.71736556 1.65947657 0.86689401 0.04415 0.1515 0.18735 0.10135 0.51565 0.383 0.12615 0.0527 0.0174 0.0039
15 Switzerland C 83.65948044 1.8827799 1.48754182 0.1449 0.4949 0.2344 0.075 0.0508 0.8742 0.338 0.07295 0.01545 0.00315
16 South Korea E 84.25064793 1.75323644 1.24113202 0.13845 0.3447 0.2699 0.10355 0.1434 0.75305 0.1834 0.04805 0.01245 0.0025
17 New Zealand A 82.47609711 1.474422 1.24236393 0.08245 0.1937 0.1972 0.0873 0.43935 0.47335 0.1768 0.0411 0.0085 0.00145
18 Mexico F 81.08391267 1.52609208 1.52838383 0.0547 0.1687 0.2578 0.14715 0.37165 0.4812 0.1148 0.0295 0.0049 0.00065
19 Cameroon C 79.25999041 1.11611097 1.36968019 0.06095 0.3062 0.3478 0.1566 0.12845 0.71495 0.1802 0.02995 0.00425 0.00055
20 Ivory Coast B 75.5815458 1.4564638 2.30092904 0.0061 0.1204 0.28765 0.27985 0.306 0.41415 0.0622 0.0113 0.00205 0.0002
21 Colombia F 78.03186314 0.87095665 1.29087236 0.028 0.10355 0.19245 0.13145 0.54455 0.324 0.0575 0.0119 0.00145 0.0002
22 Costa Rica E 72.78919173 0.82485258 2.01126014 0.01175 0.07085 0.11545 0.0908 0.71115 0.19805 0.01405 0.0013 0.00015 0.0
23 Thailand B 68.00217065 0.91451355 2.76162628 0.0006 0.0301 0.1132 0.17985 0.67625 0.1439 0.0089 0.0004 0.0 0.0
24 Ecuador C 63.34079702 0.48703789 2.89261013 0.00105 0.02965 0.06525 0.08485 0.8192 0.09595 0.00595 0.00035 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150602-093000" (
"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 24.847ms