womens-world-cup-predictions/wwc-forecast-20150612-215533

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

24 rows

View and edit SQL

Suggested facets: group, group_first, group_second, 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 USA D 95.27302179 3.61287949 0.4171328 0.8458 0.1353 0.01885 5e-05 0.0 0.99995 0.8874 0.7505 0.4365 0.30395
2 Germany B 95.76188146 3.79581815 0.39651422 0.95895 0.0366 0.0044 5e-05 0.0 0.99995 0.8043 0.60235 0.37925 0.27535
3 Japan C 92.59581327 2.84026828 0.53555199 0.8621 0.1045 0.03335 5e-05 0.0 0.99995 0.75765 0.38695 0.226 0.08765
4 France F 92.47834084 2.85354858 0.58603739 0.90085 0.0816 0.01195 0.0003 0.0053 0.9944 0.75965 0.296 0.13375 0.06985
5 Brazil E 92.31260168 2.8000243 0.57760652 0.9009 0.08905 0.00735 0.0002 0.0025 0.9973 0.53755 0.2968 0.1785 0.0682
6 Canada A 89.72459939 2.24399194 0.66172617 0.68825 0.12375 0.18795 5e-05 0.0 0.99995 0.72605 0.40245 0.1947 0.0675
7 Sweden D 91.48792334 2.68962761 0.69351197 0.0762 0.3891 0.2694 0.2039 0.0614 0.7347 0.33275 0.19005 0.0954 0.0369
8 Norway B 89.14654453 2.22922881 0.78212187 0.04 0.95975 0.0002 5e-05 0.0 0.99995 0.5544 0.2786 0.10895 0.0257
9 England F 89.32523338 2.21187073 0.72138276 0.05795 0.62005 0.1875 0.03235 0.10215 0.8655 0.4053 0.20285 0.081 0.0214
10 Australia D 89.25860966 2.42214091 0.96722569 0.07385 0.4599 0.3823 0.04515 0.0388 0.91605 0.3156 0.153 0.0639 0.02125
11 Netherlands A 86.05010112 1.8367891 1.01017734 0.1518 0.10745 0.58505 0.0481 0.1076 0.8443 0.30955 0.09655 0.02975 0.0066
12 China A 85.33390204 1.45306779 0.72727863 0.1599 0.49515 0.1358 0.00905 0.2001 0.79085 0.3974 0.0913 0.01985 0.0049
13 Switzerland C 84.21804979 1.96220593 1.49061864 0.04015 0.60765 0.35175 0.00045 0.0 0.99955 0.39495 0.0846 0.0179 0.00355
14 South Korea E 83.90191889 1.67880494 1.23645127 0.019 0.42025 0.27365 0.0652 0.2219 0.7129 0.1355 0.0313 0.00695 0.00215
15 Spain E 84.14112185 1.56328505 1.06763792 0.071 0.36375 0.106 0.2615 0.19775 0.54075 0.1206 0.02695 0.00685 0.00185
16 Cameroon C 80.4107908 1.21593104 1.31270323 0.0977 0.28785 0.6117 0.00275 0.0 0.99725 0.2703 0.0513 0.0096 0.00115
17 Nigeria D 86.05651653 1.77885242 0.94549058 0.0041 0.0157 0.06855 0.01185 0.8998 0.08835 0.0183 0.0068 0.00275 0.0008
18 Mexico F 81.00229305 1.51459814 1.54431438 0.0258 0.1736 0.0884 0.3278 0.3844 0.2878 0.07025 0.02 0.00445 0.0006
19 New Zealand A 82.46655892 1.37178926 1.14644658 0.0 0.27365 0.03405 0.0 0.6923 0.3077 0.1373 0.0203 0.00265 0.00055
20 Colombia F 78.09525569 0.85173069 1.27581195 0.0154 0.12475 0.0709 0.2808 0.50815 0.21105 0.03915 0.00905 0.00115 5e-05
21 Costa Rica E 73.73542538 0.87255227 1.94527079 0.0091 0.12695 0.0901 0.196 0.57785 0.22615 0.01465 0.0015 0.00015 5e-05
22 Thailand B 68.21300508 0.92111356 2.75633839 0.00095 0.00365 0.47985 0.51365 0.0019 0.48445 0.0113 0.00075 0.0 0.0
23 Ivory Coast B 71.28910814 1.32737338 2.78598255 0.0 0.0 0.00095 0.00095 0.9981 0.00095 0.0001 5e-05 0.0 0.0
24 Ecuador C 55.10033772 0.49280896 3.94007485 0.0 0.0 5e-05 0.0 0.99995 5e-05 0.0 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150612-215533" (
"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 28.661ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub