fivethirtyeight

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

Custom SQL query returning 24 rows (show)

rowidteamgroupwspiwspi_offensewspi_defensegroup_firstgroup_secondgroup_third_advancegroup_third_no_advancegroup_fourthsixteenquartersemifinalwin
1 Germany B 95.76021816 3.79446062 0.39688396 0.96075 0.036 0.0032 5e-05 0.0 0.99995 0.8218 0.6785 0.4314 0.30695
2 USA D 95.26726609 3.6108162 0.41777604 0.8444 0.1363 0.01925 5e-05 0.0 0.99995 0.859 0.7391 0.4332 0.29165
3 Japan C 92.47309045 2.82827471 0.55818392 0.99755 0.00245 0.0 0.0 0.0 1.0 0.77545 0.3992 0.24075 0.0942
4 Canada A 89.70970076 2.24329599 0.66181678 0.68985 0.1214 0.1886 0.00015 0.0 0.99985 0.7247 0.3968 0.1889 0.06865
5 Brazil E 92.31345033 2.80014491 0.57562609 0.9052 0.0835 0.0083 0.00015 0.00285 0.997 0.5505 0.28965 0.1728 0.0677
6 France F 91.86729387 2.76247785 0.66458846 0.3621 0.39735 0.14725 0.0039 0.0894 0.9067 0.57675 0.2801 0.1308 0.05595
7 Sweden D 91.4693677 2.68697042 0.69353539 0.07725 0.38425 0.20345 0.27385 0.0612 0.66495 0.3058 0.1769 0.0852 0.03175
8 Norway B 89.11706299 2.22494801 0.78141637 0.03845 0.9612 0.0003 5e-05 0.0 0.99995 0.567 0.28935 0.10655 0.02635
9 Australia D 89.22609092 2.41821152 0.96767388 0.0745 0.46325 0.32075 0.10275 0.03875 0.8585 0.29325 0.14235 0.0574 0.01755
10 England F 89.29457691 2.21036459 0.72411358 0.36405 0.157 0.2337 0.0302 0.21505 0.75475 0.3902 0.13805 0.04975 0.01675
11 Netherlands A 86.02994986 1.83648775 1.0105088 0.1545 0.1064 0.5199 0.1166 0.1026 0.7808 0.26695 0.0852 0.0249 0.0055
12 China A 85.30912632 1.45179638 0.72723413 0.15565 0.5092 0.1206 0.0194 0.19515 0.78545 0.4039 0.09535 0.02165 0.00535
13 Switzerland C 84.18619259 1.96144034 1.49172174 0.00135 0.701 0.295 0.00265 0.0 0.99735 0.40375 0.0788 0.0155 0.0039
14 Spain E 84.12624032 1.5658424 1.06933062 0.06715 0.36975 0.09385 0.2766 0.19265 0.53075 0.1695 0.0341 0.00935 0.0027
15 South Korea E 83.87979747 1.67876376 1.23653162 0.0183 0.41785 0.2046 0.13045 0.2288 0.64075 0.181 0.03605 0.0072 0.0016
16 Cameroon C 80.91638172 1.28452202 1.30237876 0.0011 0.29655 0.69845 0.0039 0.0 0.9961 0.25925 0.05465 0.0088 0.00115
17 Colombia F 80.012281 1.04297384 1.18281171 0.2173 0.36785 0.41475 0.0001 0.0 0.9999 0.20625 0.041 0.0066 0.0008
18 New Zealand A 82.42609354 1.37139952 1.1489438 0.0 0.263 0.0347 5e-05 0.70225 0.2977 0.13565 0.0193 0.00385 0.0006
19 Mexico F 81.11838861 1.52080195 1.52826689 0.05655 0.0778 0.1416 0.0285 0.69555 0.27595 0.0641 0.0157 0.00285 0.0005
20 Nigeria D 86.0435226 1.77919089 0.94512619 0.0038 0.0162 0.0648 0.01515 0.90005 0.0848 0.01635 0.0072 0.00225 0.0004
21 Costa Rica E 73.7102072 0.87277778 1.94508743 0.00935 0.1289 0.08325 0.2028 0.5757 0.2215 0.02545 0.00235 0.0003 0.0
22 Thailand B 68.18050129 0.92129428 2.75668557 0.0007 0.0028 0.2035 0.79145 0.00155 0.207 0.0034 0.0003 0.0 0.0
23 Ivory Coast B 71.2948343 1.32776579 2.78169327 0.0 0.0 0.0002 0.00135 0.99845 0.0002 0.0 0.0 0.0 0.0
24 Ecuador C 55.75637703 0.49949739 3.86338039 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 18.814ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub