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

24 rows

View and edit SQL

Suggested facets: group, 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.43553495 3.70135193 0.43740388 0.816 0.1453 0.03245 0.00065 0.0056 0.99375 0.8764 0.74855 0.44315 0.30765
2 Germany B 95.7449075 3.79496979 0.39818237 0.95935 0.0371 0.0035 5e-05 0.0 0.99995 0.8318 0.62035 0.38405 0.2713
3 Japan C 92.56705553 2.83757134 0.53783767 0.85905 0.1215 0.0194 5e-05 0.0 0.99995 0.80355 0.40575 0.23635 0.09135
4 Canada A 90.08096875 2.34216677 0.67999469 0.80485 0.1084 0.06485 0.00055 0.02135 0.9781 0.7548 0.4305 0.2073 0.075
5 Brazil E 92.30759668 2.80171226 0.57745992 0.89885 0.09135 0.00775 0.0 0.00205 0.99795 0.55125 0.3096 0.1823 0.06985
6 France F 92.4555158 2.84955029 0.58505632 0.89845 0.08315 0.01355 0.0002 0.00465 0.99515 0.758 0.29285 0.13245 0.06735
7 Sweden D 91.67348096 2.76744143 0.72376205 0.1221 0.3956 0.16265 0.1428 0.17685 0.68035 0.35225 0.21295 0.1067 0.0404
8 Norway B 89.12614556 2.22824436 0.78327694 0.04 0.95985 0.0001 5e-05 0.0 0.99995 0.546 0.26395 0.0958 0.02535
9 England F 89.30985161 2.21099574 0.72149619 0.0597 0.62085 0.18625 0.02755 0.10565 0.8668 0.41225 0.1959 0.07395 0.02045
10 Australia D 88.8398554 2.37917261 1.01409992 0.02085 0.25065 0.2753 0.0445 0.4087 0.5468 0.1769 0.0833 0.0347 0.0098
11 Netherlands A 86.00417257 1.83147621 1.01015106 0.0788 0.18205 0.58365 0.0367 0.1188 0.8445 0.2881 0.07725 0.0221 0.0055
12 China A 85.31348551 1.45016913 0.72417529 0.0841 0.5609 0.2033 0.00755 0.14415 0.8483 0.398 0.08455 0.01875 0.00425
13 Nigeria D 86.59948862 1.85738374 0.92102236 0.04105 0.20845 0.19125 0.1504 0.40885 0.44075 0.1267 0.0531 0.01795 0.00415
14 Switzerland C 83.55131315 1.80766708 1.43446437 0.0089 0.42535 0.4908 0.05515 0.0198 0.92505 0.30855 0.0665 0.01255 0.00185
15 Spain E 84.11582971 1.56324581 1.06774018 0.07305 0.36495 0.1211 0.2465 0.1944 0.5591 0.1263 0.0284 0.008 0.0016
16 South Korea E 83.87341084 1.67962234 1.23800543 0.01895 0.4152 0.2833 0.057 0.22555 0.71745 0.1332 0.03085 0.00595 0.0016
17 Cameroon C 80.56638539 1.24364448 1.3134771 0.1319 0.4526 0.41295 0.0025 5e-05 0.99745 0.3055 0.0468 0.00905 0.00145
18 New Zealand A 82.22749787 1.40863384 1.22225932 0.03225 0.14865 0.0991 0.0043 0.7157 0.28 0.10795 0.0194 0.0037 0.00055
19 Mexico F 80.99994761 1.5146118 1.54018059 0.0277 0.1749 0.1022 0.31695 0.37825 0.3048 0.07365 0.01835 0.00325 0.00045
20 Colombia F 78.10928289 0.86600613 1.28456043 0.01415 0.1211 0.0819 0.2714 0.51145 0.21715 0.0384 0.00875 0.00165 0.0001
21 Costa Rica E 73.71466064 0.87078433 1.94151844 0.00915 0.1285 0.0959 0.18845 0.578 0.23355 0.01295 0.0014 0.00015 0.0
22 Thailand B 68.10284288 0.92246135 2.7674463 0.00055 0.00305 0.5568 0.43725 0.00235 0.5604 0.01735 0.00095 0.00015 0.0
23 Ecuador C 59.00654616 0.43526126 3.38892721 0.0001 0.00055 0.01075 0.00845 0.98015 0.0114 0.0001 0.0 0.0 0.0
24 Ivory Coast B 71.31412391 1.32912908 2.77958007 0.0 0.0 0.0012 0.00115 0.99765 0.0012 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-210229" (
"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 41.772ms