fivethirtyeight

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

Custom SQL query returning 24 rows (hide)

rowidteamgroupwspiwspi_offensewspi_defensegroup_firstgroup_secondgroup_third_advancegroup_third_no_advancegroup_fourthsixteenquartersemifinalwin
1 Germany B 95.77228656 3.79610714 0.39700041 0.9603 0.0361 0.00355 5e-05 0.0 0.99995 0.81015 0.67165 0.43025 0.3054
2 USA D 95.27792303 3.61074728 0.41695791 0.8469 0.1324 0.02065 5e-05 0.0 0.99995 0.84975 0.72865 0.4255 0.291
3 Japan C 92.4788419 2.82807919 0.55821233 0.99735 0.00265 0.0 0.0 0.0 1.0 0.7983 0.4133 0.24645 0.094
4 Brazil E 92.20725671 2.74731707 0.5511554 1.0 0.0 0.0 0.0 0.0 1.0 0.542 0.2846 0.1712 0.0662
5 Canada A 89.70643793 2.24124018 0.66172869 0.6879 0.1231 0.18895 5e-05 0.0 0.99995 0.7271 0.3927 0.1814 0.0644
6 France F 91.87220926 2.76214211 0.66465358 0.2765 0.48285 0.13245 0.0001 0.1081 0.8918 0.55255 0.2902 0.13885 0.0572
7 Sweden D 91.47551801 2.68704173 0.69366367 0.079 0.3863 0.21205 0.26365 0.059 0.67735 0.30135 0.17875 0.0879 0.03405
8 Norway B 89.12310223 2.22525697 0.7816499 0.03865 0.961 0.0003 5e-05 0.0 0.99995 0.526 0.26945 0.1031 0.02595
9 England F 89.24995369 2.21008703 0.7355602 0.50935 0.17215 0.30915 0.00745 0.0019 0.99065 0.51555 0.17925 0.059 0.02085
10 Australia D 89.22034186 2.41588671 0.96777624 0.06965 0.46435 0.3821 0.0432 0.0407 0.9161 0.3029 0.14775 0.06055 0.02025
11 Netherlands A 86.03313814 1.83638818 1.01064258 0.15475 0.10605 0.5893 0.04815 0.10175 0.8501 0.2874 0.09385 0.0274 0.0054
12 China A 85.29275334 1.44839128 0.72735845 0.15735 0.5003 0.13295 0.00715 0.20225 0.7906 0.40555 0.09615 0.02175 0.00475
13 Switzerland C 84.18884602 1.96153604 1.49201996 0.0015 0.6954 0.30225 0.00085 0.0 0.99915 0.39965 0.07815 0.01455 0.00315
14 Spain E 83.91841216 1.48555798 1.01885236 0.0 0.5455 0.0141 0.07655 0.36385 0.5596 0.1946 0.0308 0.0065 0.0021
15 New Zealand A 82.4316119 1.37185237 1.14903014 0.0 0.27055 0.03345 0.0 0.696 0.304 0.1396 0.02025 0.00365 0.00135
16 Cameroon C 80.91884043 1.28452064 1.30238465 0.00115 0.30195 0.6956 0.0013 0.0 0.9987 0.26255 0.0525 0.00895 0.00115
17 Colombia F 80.02779959 1.04388861 1.18170335 0.21415 0.2679 0.5179 5e-05 0.0 0.99995 0.19185 0.0389 0.0059 0.0011
18 South Korea E 83.33284253 1.68223209 1.33610864 0.0 0.3511 0.0127 0.1264 0.5098 0.3638 0.12495 0.0171 0.0031 0.00075
19 Nigeria D 86.04743612 1.7791624 0.94519729 0.0044 0.01695 0.06535 0.013 0.9003 0.0867 0.0159 0.00695 0.00235 0.00055
20 Mexico F 81.29798421 1.54318843 1.52389108 0.0 0.0771 0.0329 0.0 0.89 0.11 0.0263 0.0077 0.00145 0.00035
21 Costa Rica E 74.48002721 0.98054072 1.95263815 0.0 0.1034 0.0751 0.69515 0.12635 0.1785 0.0212 0.0012 0.0002 5e-05
22 Thailand B 68.17085735 0.92048679 2.75682063 0.00095 0.0029 0.27855 0.71545 0.00215 0.2824 0.00475 0.00015 0.0 0.0
23 Ivory Coast B 71.29559208 1.32775438 2.78149296 0.0 0.0 0.00065 0.0015 0.99785 0.00065 5e-05 0.0 0.0 0.0
24 Ecuador C 55.74903536 0.49994042 3.86438563 0.0 0.0 5e-05 0.0 0.99995 5e-05 0.0 0.0 0.0 0.0
Powered by Datasette · Query took 1.023ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub