home / fivethirtyeight

fivethirtyeight

Custom SQL query returning 24 rows (hide)

rowidteamgroupwspiwspi_offensewspi_defensegroup_firstgroup_secondgroup_third_advancegroup_third_no_advancegroup_fourthsixteenquartersemifinalwin
1 Germany B 95.98277462 3.87907395 0.39047121 1 0 0 0 0 1 1.0 0.763 0.4664 0.35665
2 USA D 95.18160659 3.55967206 0.40397923 1 0 0 0 0 1 0.95155 0.85355 0.42245 0.2977
3 Japan C 92.24884456 2.75363438 0.54616622 1 0 0 0 0 1 0.7259 0.39775 0.24 0.08275
4 Brazil E 92.01984651 2.68083985 0.53347523 1 0 0 0 0 1 0.62 0.3451 0.20445 0.0674
5 Canada A 89.49703079 2.20767956 0.67440029 1 0 0 0 0 1 0.756 0.43525 0.2157 0.0635
6 France F 92.27381631 2.8423125 0.6358772 1 0 0 0 0 1 0.7991 0.2205 0.09055 0.0516
7 England F 89.18730785 2.22026551 0.76086033 0 1 0 0 0 1 0.5087 0.25125 0.1065 0.02315
8 Norway B 89.01934357 2.21326936 0.79202033 0 1 0 0 0 1 0.4913 0.2333 0.096 0.0222
9 Australia D 89.25324873 2.40307569 0.94567596 0 1 0 0 0 1 0.38 0.1655 0.08125 0.02075
10 Netherlands A 86.25263155 1.85620247 0.98812305 0 0 1 0 0 1 0.2741 0.09165 0.03485 0.00535
11 China A 85.28614036 1.49060661 0.77268921 0 1 0 0 0 1 0.60895 0.08855 0.01195 0.00345
12 Switzerland C 83.76201604 1.93736935 1.53839946 0 0 1 0 0 1 0.244 0.0802 0.02125 0.00315
13 Cameroon C 81.47760261 1.34802094 1.27790157 0 1 0 0 0 1 0.39105 0.0393 0.0041 0.00095
14 South Korea E 83.74050015 1.74703436 1.33377106 0 1 0 0 0 1 0.2009 0.0165 0.00305 0.0008
15 Colombia F 80.28145186 1.10479891 1.20504948 0 0 1 0 0 1 0.04845 0.0186 0.0015 0.0006
16 Sweden D 91.2910534 2.6722951 0.72826591 0 0 1 0 0 1 0.0 0.0 0.0 0.0
17 New Zealand A 82.77932173 1.47558532 1.2015975 0 0 0 0 1 0 0.0 0.0 0.0 0.0
18 Thailand B 68.3779799 0.89783944 2.70035578 0 0 0 1 0 0 0.0 0.0 0.0 0.0
19 Ivory Coast B 71.93304198 1.38388497 2.75108685 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Costa Rica E 74.78376713 0.93749476 1.85784044 0 0 0 1 0 0 0.0 0.0 0.0 0.0
21 Spain E 83.46047501 1.4656197 1.07430194 0 0 0 0 1 0 0.0 0.0 0.0 0.0
22 Mexico F 80.38973002 1.4827642 1.60154303 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Nigeria D 85.82096781 1.70911311 0.91086045 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 58.02110024 0.48176173 3.55908929 0 0 0 0 1 0 0.0 0.0 0.0 0.0
Powered by Datasette · Query took 0.8ms